SQL-007 Attorney-assignment maintenance table list

Inline (const TABLELISTSQL → GetCodeCollection) for clsAttorneyTableManager.

Classification

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

Tables

Table	Access	Columns used
LEGAL_CODE_TABLE	SELECT	See database table section

Sample SQL

SELECT
  table_name As code,
  table_name As code_descr
FROM legal_code_table
WHERE table_maint_win_name = 'AttorneyAssignment'

Operations and processes

• Attorney assignment screen — maintenance table selector

Sources

• clsAttorneyTableManager.vb