SQL-007 Retrieve hearing location code list¶

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

Classification¶

Field	Value
SQL ID	SQL-007
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 (LOCATIONCODESQL), executed as-is via clsCodeCollection.GetCodeCollection(DPI, LOCATIONCODESQL).

Tables¶

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

Sample SQL¶

SELECT code, code_descr
FROM HEARING_LOCATION_CODE
ORDER BY code_descr

Sources¶

SAIF.Application.Claim.Legal\clsAttorneyTableManager.vb