DB-CLL-CT-001 — Retrieve a code-table lookup list for dropdowns

Classification

Field	Value
SQL ID	DB-CLL-CT-001
Operation type	R
Execution method	Text
Database	Oracle (Case Management)
Schema	[unqualified]**
Command type	Inline text SQL
Business object	mdlCodeTables
Criteria property	n/a (application-layer)
Lifecycle method	n/a

Parameters

No bound parameters were identified for this statement.

Tables

Table	Access	Columns/Notes
CODE_TABLES	SELECT	CODE, CODE_DESCR (generic pattern applied to ~21 code tables)
ADP_EMPLOYEE	SELECT	joined for employee-name lookups
ATTORNEY_PROFILE	SELECT	joined for attorney lookups
LEGAL_PERSON	SELECT	joined for legal-person lookups
OTHER_FIRM	SELECT	joined for firm lookups
HEARING_LOCATION	SELECT	joined for hearing-location lookups

Sample SQL

Select
  CODE,
  CODE_DESCR
From
  {CODE_TABLE_NAME}
Order by
  CODE

Operations and processes

• Resolve code-table lookups

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb