Skip to content

Manage attorney and legal-person reference data

Maintain attorney profiles, conflicts, policy assignments, schedules, legal persons, other firms, and rotation assignments, enforcing duplicate/referential-integrity checks.

Field Value
Operation ID OP-CLL-015
Trigger Reference-data maintenance user adds, edits, or deletes attorney/firm/person records
Inputs Business-object criteria properties set by the caller (see linked SQL parameter tables)
Outputs Persisted/retrieved clsAttorneyProfile state
Primary components clsAttorneyProfile, clsAttorneyConflict, clsAttorneyPolicyAssignment, clsAttorneySchedule, clsAttorneyWorkerAssignment, clsLegalPerson, clsLegalPersonType, clsOtherFirm, clsOutOFTownRotationAssgn
Entry point SAIF.Business.Claim.Legal\TableMaint\clsAttorneyProfile.vb, TableMaint\clsAttorneyConflict.vb, TableMaint\clsAttorneyPolicyAssignment.vb, TableMaint\clsAttorneySchedule.vb, TableMaint\clsAttorneyWorkerAssignment.vb, TableMaint\clsLegalPerson.vb, TableMaint\clsLegalPersonType.vb, TableMaint\clsOtherFirm.vb, TableMaint\clsOutOFTownRotationAssgn.vb

Steps

  1. Validate the request against applicable business rules: BR-CLM-LGL-006, BR-CLM-LGL-007, BR-CLM-LGL-008, BR-CLM-LGL-009, BR-CLM-LGL-010, BR-CLM-LGL-011, BR-CLM-LGL-014, BR-CLM-LGL-015, BR-CLM-LGL-016, BR-CLM-LGL-017, BR-CLM-LGL-018
  2. On failure: validation errors are collected and returned to the caller; the operation does not proceed.
  3. Execute the underlying data access for clsAttorneyProfile against: DB-CLL-061, DB-CLL-064, DB-CLL-065-104
  4. Tables affected: ATTORNEY_CONFLICT, ATTORNEY_POLICY_ASSIGNMENT, ATTORNEY_SCHEDULE, ATTORNEY_WORKER_ASSIGNMENT, LEGAL_PERSON, LEGAL_PERSON_TYPE, OTHER_FIRM, OUT_OF_TOWN_ROTATION_ASSGN
  5. Return the resulting object graph (or success/failure status) to the caller.

Process flow

flowchart TD
    Start([Reference-data maintenance user adds, edits, or deletes attorney/firm/person records]) --> Validate[Validate business rules]
    Validate --> Decision{Valid?}
    Decision -->|No| EndErr([Return validation errors])
    Decision -->|Yes| Exec[Execute data access for clsAttorneyProfile]
    Exec --> EndOk([Return result])

Failure and edge-case behavior

  • Validation failure: the operation returns collected errors without persisting any change.
  • ValidateState on this path is non-parameterized (raw string concatenation) — see business-rules.md for the flagged SQL-injection risk.

Sources

  • SAIF.Business.Claim.Legal\ (clsAttorneyProfile, clsAttorneyConflict, clsAttorneyPolicyAssignment, clsAttorneySchedule, clsAttorneyWorkerAssignment, clsLegalPerson, clsLegalPersonType, clsOtherFirm, clsOutOFTownRotationAssgn)