SQL-003 ALJ Board FJ person list¶

Inline (const ALJLISTSQL → GetCodeCollection) for clsAttorneyTableManager.

Classification¶

Field	Value
SQL ID	SQL-003
Operation type	Read
Execution method	Inline (const ALJLISTSQL → GetCodeCollection)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsAttorneyTableManager`
Criteria property	N/A
Lifecycle method	ALJList property getter

Tables¶

Table	Access	Columns used
LEGAL_PERSON	SELECT	See database table section
LEGAL_PERSON_TYPE	SELECT	See database table section

Sample SQL¶

SELECT
  to_char(per.legal_person_seq_num) As code,
  LAST_NAME || ', ' || decode(nvl(preferred_name, ' '), ' ', FIRST_NAME, preferred_name) AS code_descr
FROM legal_person per,
  legal_person_type typ
WHERE typ.legal_person_seq_num = per.legal_person_seq_num
  AND typ.legal_person_type_code IN ('ALJ', 'BOARD', 'FJ')

Operations and processes¶

Attorney table maintenance — ALJ/Board picklist

Sources¶

clsAttorneyTableManager.vb