SQL-003 Manual class type code lookup¶

Unfiltered lookup of all rows in MANUAL_CLASS_TYPE_CODE, used to build the cached clsManualClassTypeCodeMap; only six codes are mapped to enum values (BR-POL-013).

Classification¶

Field	Value
SQL ID	SQL-003
Operation type	Read
Execution method	Inline SQL (`clsCodeTableBase.Fill`)
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	N/A (Application layer)
Criteria property	N/A
Lifecycle method	N/A
Application class	`clsManualClassTypeCodeMap` (constructor)

Tables¶

Table	Access	Columns used
MANUAL_CLASS_TYPE_CODE	SELECT	`CODE`, `CODE_DESCR`

Sample SQL¶

-- Unfiltered code-table lookup
SELECT
  code,
  code_descr
FROM MANUAL_CLASS_TYPE_CODE

Operations and processes¶

OP-13 Load and cache the manual class type code map (see Operations and processes)

Business rules¶

Sources¶

SAIF.Business.Policy/CodeMaps/clsManualClassTypeCodeMap.vb