SQL-009 Retrieve attorney-assignment maintenance table list¶
Retrieves LEGAL_CODE_TABLE rows filtered to the AttorneyAssignment maintenance window, for the TABLELISTSQL code-table lookup used by the attorney-assignment maintenance UI.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-009 |
| 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 (TABLELISTSQL), executed as-is via clsCodeCollection.GetCodeCollection(DPI, TABLELISTSQL).
Tables¶
| Table | Access | Columns used |
|---|---|---|
| LEGAL_CODE_TABLE | SELECT | TABLE_NAME, TABLE_MAINT_WIN_NAME |
Sample SQL¶
SELECT
table_name As code,
table_name As code_descr
FROM legal_code_table
WHERE table_maint_win_name = 'AttorneyAssignment'
Sources¶
SAIF.Application.Claim.Legal\clsAttorneyTableManager.vb