SQL-039: Load user-status code map

Loads all rows from EXT_USER_STATUS_CODE ordered by a defined display sequence (ACTIV, PENDA, PENDE, DIS) into an in-memory code map used by mdlCodeMaps.

Classification

Field	Value
SQL ID	SQL-039
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	mdlCodeMaps
Criteria property	dpi.GetResultSet(...)
Lifecycle method	GetStatusTypes

Parameters

This statement has no bind parameters.

Tables

Table	Access	Columns used
EXT_USER_STATUS_CODE	SELECT	CODE, CODE_DESCR

Sample SQL

SELECT code, code_descr
FROM ext_user_status_code
ORDER BY CASE code
    WHEN 'ACTIV' THEN 1
    WHEN 'PENDA' THEN 2
    WHEN 'PENDE' THEN 3
    WHEN 'DIS'   THEN 4
END

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