SQL-003 Manual class type code lookup¶

Retrieves the full MANUAL_CLASS_TYPE_CODE reference table so clsManualClassTypeCodeMap can build its cached, in-memory code-to-enum map (ManualClassTypes).

Classification¶

Field	Value
SQL ID	SQL-003
Operation type	Read
Execution method	Inline SQL (literal in constructor)
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsManualClassTypeCodeMap`
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
MANUAL_CLASS_TYPE_CODE	SELECT	`code`, `code_descr`

Sample SQL¶

select code, code_descr
from MANUAL_CLASS_TYPE_CODE

Operations and processes¶

Resolve or cache manual-class-type code table

Sources¶

SAIF.Business.Policy\CodeMaps\clsManualClassTypeCodeMap.vb