SQL-017: CALCULATION_TYPE_CODE code-table load¶

This SQL statement implements the CALCULATION_TYPE_CODE code-table load data-access path for CodeMappings.clsCalculationTypeMap in SAIF.Business.UnitStat. It participates in the read lifecycle handled by clsCalculationTypeMap.New.

Classification¶

Field	Value
SQL ID	SQL-017
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`CodeMappings.clsCalculationTypeMap`
Criteria property	`N/A (direct code-table SQL)`
Lifecycle method	`clsCalculationTypeMap.New`

Tables¶

Table	Access	Columns used
CALCULATION_TYPE_CODE	SELECT	See sample SQL

Sample SQL¶

select code, code_descr from calculation_type_code

Operations and processes¶

Code map loading

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business\SAIF.Business.UnitStat\mdlCodeMaps.vb