Skip to content

Resolve code-table lookups

Populate dropdown/code-table lookup lists (attorney types, case status, hearing locations, and related joined reference data) consumed across most domains in this library.

Field Value
Operation ID OP-CLL-020
Trigger Any screen or business object requests dropdown/code-table data
Inputs Business-object criteria properties set by the caller (see linked SQL parameter tables)
Outputs Persisted/retrieved mdlCodeTables state
Primary components mdlCodeTables
Entry point SAIF.Business.Claim.Legal\mdlCodeTables.vb

Steps

  1. Execute the underlying data access for mdlCodeTables against: DB-CLL-CT-001
  2. Tables affected: ADP_EMPLOYEE, ATTORNEY_PROFILE, LEGAL_PERSON, LEGAL_PERSON_TYPE, OTHER_FIRM, HEARING_LOCATION
  3. Return the resulting object graph (or success/failure status) to the caller.

Process flow

flowchart TD
    Start([Any screen or business object requests dropdown/code-table data]) --> Validate[Validate business rules]
    Validate --> Decision{Valid?}
    Decision -->|No| EndErr([Return validation errors])
    Decision -->|Yes| Exec[Execute data access for mdlCodeTables]
    Exec --> EndOk([Return result])

Failure and edge-case behavior

  • Validation failure: the operation returns collected errors without persisting any change.

Sources

  • SAIF.Business.Claim.Legal\ (mdlCodeTables)