DB-CLL-051 — Retrieve the full legal case list
Classification
| Field |
Value |
| SQL ID |
DB-CLL-051 |
| Operation type |
R |
| Execution method |
Text |
| Database |
Oracle (Case Management) |
| Schema |
[unqualified]** |
| Command type |
Inline text SQL |
| Business object |
clsLegalCaseCollection |
| Criteria property |
RetrieveSQL |
| Lifecycle method |
BeforeRetrieve |
Parameters
No bound parameters were identified for this statement.
Tables
| Table |
Access |
Columns/Notes |
| LEGAL_CASE |
SELECT |
all rows, no filter (inferred*) |
Sample SQL
Select
LEGAL_CASE.LEGAL_CASE_SEQ_NUM as LegalCaseID,
LEGAL_CASE.CLAIM_ID as ClaimID,
LEGAL_CASE.CASE_STATUS_CODE as CaseStatusCode
From
LEGAL_CASE
Operations and processes
Business rules
Sources
SAIF.Business.Claim.Legal\clsLegalCaseCollection.vb