SQL-004 SAIF attorney code list¶

Inline (const ATTORNEYLISTSQL → GetCodeCollection) for clsAttorneyTableManager.

Classification¶

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

Tables¶

Table	Access	Columns used
ADP_EMPLOYEE	SELECT	See database table section
ATTORNEY_PROFILE	SELECT	See database table section

Sample SQL¶

SELECT
  PROFILE_EMPLID As code,
  LAST_NAME || ', ' || decode(nvl(preferred_name, ' '), ' ', FIRST_NAME, preferred_name) AS code_descr
FROM ADP_EMPLOYEE A,
  ATTORNEY_PROFILE P
WHERE A.EMPLID = P.PROFILE_EMPLID

Operations and processes¶

Attorney table maintenance — SAIF attorney picklist

Sources¶

clsAttorneyTableManager.vb