SQL-001 Benefit jurisdiction code lookup¶

Retrieves the full BENEFIT_JURISDICTION_CODE reference table so clsBenefitJurisdictionCodeMap can build its cached, in-memory code-to-enum map (BenefitJurisdictions: State/Federal).

Classification¶

Field	Value
SQL ID	SQL-001
Operation type	Read
Execution method	Inline SQL (literal in constructor)
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsBenefitJurisdictionCodeMap`
Criteria property	N/A (no `Criteria`; built via the framework's `Fill(inDPI, sql)` helper)
Lifecycle method	`New(inDPI, includeNull)` (constructor)

Parameters¶

No bind parameters; the statement is a static literal.

Tables¶

Table	Access	Columns used
BENEFIT_JURISDICTION_CODE	SELECT	`code`, `code_descr`

Sample SQL¶

select code, code_descr
from BENEFIT_JURISDICTION_CODE

Operations and processes¶

Resolve or cache benefit-jurisdiction code table

Sources¶

SAIF.Business.Policy\CodeMaps\clsBenefitJurisdictionCodeMap.vb