SQL-006 Retrieve hearing duration code list¶

Retrieves the full DURATION_CODE list, ordered by description, for the DURATIONCODESQL code-table lookup used by the attorney-assignment maintenance UI.

Classification¶

Field	Value
SQL ID	SQL-006
Operation type	Read
Execution method	Inline SQL (`clsCodeCollection.GetCodeCollection`)
Database	Oracle
Command type	Text
Business object	N/A (Application layer)
Criteria property	N/A (Application layer)
Lifecycle method	N/A (Application layer)
Application class	`clsAttorneyTableManager`

Parameters¶

No runtime parameters — this is a static code-table lookup constant (DURATIONCODESQL), executed as-is via clsCodeCollection.GetCodeCollection(DPI, DURATIONCODESQL).

Tables¶

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

Sample SQL¶

SELECT code, code_descr
FROM DURATION_CODE
ORDER BY code_descr

Sources¶

SAIF.Application.Claim.Legal\clsAttorneyTableManager.vb