SQL-019: US_OFFSET_TYPE_CODE code-table load¶

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

Classification¶

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

Tables¶

Table	Access	Columns used
US_OFFSET_TYPE_CODE	SELECT	See sample SQL

Sample SQL¶

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