SQL-001 Benefit jurisdiction code lookup¶

Unfiltered lookup of all rows in BENEFIT_JURISDICTION_CODE, used to build the cached clsBenefitJurisdictionCodeMap; only codes S and F are mapped to enum values (BR-POL-012).

Classification¶

Field	Value
SQL ID	SQL-001
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	`clsBenefitJurisdictionCodeMap` (constructor)

Tables¶

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

Sample SQL¶

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

Operations and processes¶

OP-12 Load and cache the benefit jurisdiction code map (see Operations and processes)

Business rules¶

Sources¶

SAIF.Business.Policy/CodeMaps/clsBenefitJurisdictionCodeMap.vb