SQL-038: Load user-type code map¶
Loads all rows from EXT_USER_TYPE_CODE as a code/description map used by mdlCodeMaps to populate in-memory lookup structures.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-038 |
| Operation type | Read |
| Execution method | Inline SQL |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | mdlCodeMaps |
| Criteria property | dpi.GetResultSet(...) |
| Lifecycle method | GetUserTypes |
Parameters¶
This statement has no bind parameters.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| EXT_USER_TYPE_CODE | SELECT | CODE, CODE_DESCR |
Sample SQL¶
Note: Statements marked with
*were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with**could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business.External.Users\mdlCodeMaps.vb