SQL-023 Retrieve attorney person list for case update¶
Retrieves LEGAL_PERSON rows joined to LEGAL_PERSON_TYPE where the type is ATTY or OUTC and the type assignment has not expired (exp_date is null), for the ATTORNEYPERSONSQL code-table lookup used by the update-case status/attorney maintenance UI. The SQL text is identical to SQL-017, but is defined independently as a separate Private Const in clsUpdateCaseManager.vb.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-023 |
| 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 | clsUpdateCaseManager |
Parameters¶
No runtime parameters — this is a static code-table lookup constant (ATTORNEYPERSONSQL), executed as-is via clsCodeCollection.GetCodeCollection(DPI, ATTORNEYPERSONSQL).
Tables¶
| Table | Access | Columns used |
|---|---|---|
| LEGAL_PERSON | SELECT, JOIN | LEGAL_PERSON_SEQ_NUM, LAST_NAME, FIRST_NAME |
| LEGAL_PERSON_TYPE | SELECT, JOIN | LEGAL_PERSON_SEQ_NUM, LEGAL_PERSON_TYPE_CODE, EXP_DATE |
Sample SQL¶
SELECT
to_char(p.legal_person_seq_num) As code,
last_name || ', ' || first_name as code_descr
from legal_person p, legal_person_type t
where p.legal_person_seq_num = t.legal_person_seq_num
and (t.legal_person_type_code = 'ATTY' or t.legal_person_type_code = 'OUTC')
and t.exp_date is null
Business rules¶
- BR-LGL-009: Worker-attorney firm change creates a system audit case note*
- BR-LGL-010: Worker attorney change creates a system audit case note*
- BR-LGL-012: Secondary consolidated cases mirror the primary case state*
Note: Statements marked with
*were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with**could not be confirmed; treat as unknown until verified.
Sources¶
SAIF.Application.Claim.Legal\LegalNet\clsUpdateCaseManager.vb