SQL-018: US_COST_TYPE_CODE code-table load¶

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

Classification¶

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

Tables¶

Table	Access	Columns used
US_COST_TYPE_CODE	SELECT	See sample SQL

Sample SQL¶

select code, code_descr from us_cost_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