Application data model¶
This page documents the cross-library database table inventory for LegalMaintenance, grouped by business domain.
Attorneystaff domain¶
| Table | Schema | Owning library | CRUD | Notes |
|---|---|---|---|---|
| ATTORNEY_PROFILE | [unqualified]** | SAIF.Business.Claim.Legal | C/R/U | Attorney bio/profile data, surfaced via frmAttorneyProfile |
| ATTORNEY_SCHEDULE | [unqualified]** | SAIF.Business.Claim.Legal | C/R/U | Attorney schedule/availability data |
| ATTORNEY_SCHEDULE_TYPE_CODE | [unqualified]** | SAIF.Business.Claim.Legal | R | Reference codes for schedule types |
| ATTORNEY_WORKER_ASSIGNMENT | [unqualified]** | SAIF.Business.Claim.Legal | C/R/U | Attorney-to-claim/worker assignment records |
| ATTORNEY_CONFLICT | [unqualified]** | SAIF.Business.Claim.Legal | C/R/U | Attorney conflict-of-interest tracking, tied to assignment |
| ATTORNEY_POLICY_ASSIGNMENT | [unqualified]** | SAIF.Business.Claim.Legal | C/R/U | Attorney-to-policy assignment records |
| ATTORNEY_TYPE_CODE | [unqualified]** | SAIF.Business.Claim.Legal | R | Reference codes for attorney type |
| ADP_EMPLOYEE | [unqualified]** | SAIF.Business.Claim.Legal | R | Employee/staff reference data used by attorney maintenance |
Hearing location domain¶
| Table | Schema | Owning library | CRUD | Notes |
|---|---|---|---|---|
| HEARING_LOCATION | [unqualified]** | SAIF.Business.Claim.Legal | C/R/U | Hearing location records, surfaced via frmHearingLocation |
| HEARING_LOCATION_CODE | [unqualified]** | SAIF.Business.Claim.Legal | R | Reference codes for hearing locations |
| DURATION_CODE | [unqualified]** | SAIF.Business.Claim.Legal | R | Reference codes for hearing durations |
Legal person other firm domain¶
| Table | Schema | Owning library | CRUD | Notes |
|---|---|---|---|---|
| LEGAL_PERSON | [unqualified]** | SAIF.Business.Claim.Legal | C/R/U | Legal person records, surfaced via frmLegalPerson |
| LEGAL_PERSON_TYPE | [unqualified]** | SAIF.Business.Claim.Legal | R | Legal person type reference data |
| LEGAL_PERSON_TYPE_CODE | [unqualified]** | SAIF.Business.Claim.Legal | R | Legal person type codes |
| OTHER_FIRM | [unqualified]** | SAIF.Business.Claim.Legal | C/R/U | Other-firm records, surfaced via frmOtherFirms |
| OTHER_FIRM_TYPE_CODE | [unqualified]** | SAIF.Business.Claim.Legal | R | Other-firm type reference codes |
Legal casehearing domain¶
| Table | Schema | Owning library | CRUD | Notes |
|---|---|---|---|---|
| CASE_COST | [unqualified]** | SAIF.Business.Claim.Legal | C/R/U | Legal case cost data, consumed transitively via LegalNet managers, not directly by LegalMaintenance screens |
| CASE_STATUS_HISTORY | [unqualified]** | SAIF.Business.Claim.Legal | C/R | Legal case status history |
| CASE_STATUS_CODE | [unqualified]** | SAIF.Business.Claim.Legal | R | Legal case status reference codes |
| OUTCOME_* | [unqualified]** | SAIF.Business.Claim.Legal | R | Legal case outcome reference tables |
| LEGAL_CASE_* | [unqualified]** | SAIF.Business.Claim.Legal | C/R/U | Legal case core tables |
| LEGAL_FILE_LOCATION* | [unqualified]** | SAIF.Business.Claim.Legal | C/R/U | Legal case file location tables |
| LEGAL.VW_CASES | LEGAL | SAIF.Business.Claim.Legal | R | View aggregating legal case data |
Claimbenefit domain¶
| Table | Schema | Owning library | CRUD | Notes |
|---|---|---|---|---|
| CL_1502_DCBS_TRANSFER | [unqualified]** | SAIF.Business.Claim | R | Reachable indirectly through claim context/security |
| CL_BENEFIT_PAYMENT | [unqualified]** | SAIF.Business.Claim | R | Claim benefit payment records |
| CL_BENEFIT_SCHEDULE | [unqualified]** | SAIF.Business.Claim | R | Claim benefit schedule records |
| CL_CLAIM_EMPLOYEE_WORK_ADDRESS | [unqualified]** | SAIF.Business.Claim | R | Claim employee work address records |
| CL_CLAIM_WORK_RELEASE_STATUS | [unqualified]** | SAIF.Business.Claim | R | Claim work release status records |
| CL_CLAIM_WORK_STATUS | [unqualified]** | SAIF.Business.Claim | R | Claim work status records |
| CL_FEDERAL_AWARD | [unqualified]** | SAIF.Business.Claim | R | Claim federal award records |
| CL_INJURY_CLAIM | [unqualified]** | SAIF.Business.Claim | R | Injury claim core records |
| CL_PPD_* | [unqualified]** | SAIF.Business.Claim | R | Permanent partial disability tables |
| CL_RESERVE_* | [unqualified]** | SAIF.Business.Claim | R | Claim reserve tables |
| CL_WORKER_INJURED_BODY_PART | [unqualified]** | SAIF.Business.Claim | R | Injured body part records |
Task domain¶
| Table | Schema | Owning library | CRUD | Notes |
|---|---|---|---|---|
| TASK | [unqualified]** | SAIF.Business.Tasks | C/R/U | Task records raised as a side effect of assignment workflows |
| TASK_ACTION_CODE | [unqualified]** | SAIF.Business.Tasks | R | Task action reference codes |
| TASK_CATEGORY_CODE | [unqualified]** | SAIF.Business.Tasks | R | Task category reference codes |
| TASK_PRIORITY_CODE | [unqualified]** | SAIF.Business.Tasks | R | Task priority reference codes |
| TASK_SOURCE_CODE | [unqualified]** | SAIF.Business.Tasks | R | Task source reference codes |
| LEGACY_TASK_CODE | [unqualified]** | SAIF.Business.Tasks | R | Legacy task code cross-reference |
Policy domain¶
| Table | Schema | Owning library | CRUD | Notes |
|---|---|---|---|---|
| POLICY | [unqualified]** | SAIF.Business.Policy | R | Policy core record, consumed for legal-context lookups |
| POLICY_PERIOD | [unqualified]** | SAIF.Business.Policy | R | Policy period records |
| POLICY_PERIOD_NON_WCIS | [unqualified]** | SAIF.Business.Policy | R | Policy period records for non-WCIS policies |
| ENDORSEMENT | [unqualified]** | SAIF.Business.Policy | R | Policy endorsement records |
| PREM_HIST_SUMMARY | [unqualified]** | SAIF.Business.Policy | R | Premium history summary |
| HAZARD_GROUP | [unqualified]** | SAIF.Business.Policy | R | Hazard group reference data |
| MANUAL_CLASS_TYPE_CODE | [unqualified]** | SAIF.Business.Policy | R | Manual class type reference codes |
| BENEFIT_JURISDICTION_CODE | [unqualified]** | SAIF.Business.Policy | R | Benefit jurisdiction reference codes |
| DUAL | [unqualified]** | SAIF.Business.Policy | R | Dual-coverage policy reference data |
Provider domain¶
| Table | Schema | Owning library | CRUD | Notes |
|---|---|---|---|---|
| PROVIDER | [unqualified]** | SAIF.Business.View.Provider | R | Provider core records, consumed for legal correspondence targets |
| PROVIDER_TAX_ID | [unqualified]** | SAIF.Business.View.Provider | R | Provider tax ID records |
| PROVIDER_LOCATION | [unqualified]** | SAIF.Business.View.Provider | R | Provider location records |
| PROVIDER_ADDRESS | [unqualified]** | SAIF.Business.View.Provider | R | Provider address records |
| PROVIDER_INELIG_PERIOD | [unqualified]** | SAIF.Business.View.Provider | R | Provider ineligibility period records |
| PROVIDER_RELATIONSHIP | [unqualified]** | SAIF.Business.View.Provider | R | Provider relationship records |
| PROVIDER_TYPE_CODE | [unqualified]** | SAIF.Business.View.Provider | R | Provider type reference codes |
| PROVIDER_DCBS_COST_CHARGE | [unqualified]** | SAIF.Business.View.Provider | R | Provider DCBS cost charge records |
| MCO_PROVIDER | [unqualified]** | SAIF.Business.View.Provider | R | MCO provider records |
| PROVIDER_SERVICE | [unqualified]** | SAIF.Business.View.Provider | R | Provider service records |
| PROVIDER_SERVICE_CODE | [unqualified]** | SAIF.Business.View.Provider | R | Provider service reference codes |
| PROVIDER_SERVICE_CONTRACT | [unqualified]** | SAIF.Business.View.Provider | R | Provider service contract records |
| PROVIDER_IDENTITY | [unqualified]** | SAIF.Business.View.Provider | R | Provider identity records |
Batchscheduling domain¶
| Table | Schema | Owning library | CRUD | Notes |
|---|---|---|---|---|
| JOB_QUEUE | [unqualified]** | SAIF.Services.Appworx | C | Accessed only via the submit_appworx_job stored procedure (proc-side only) |
[unqualified]**: The owning-library analyses did not capture explicit Oracle schema-owner qualifiers for these tables; treat the schema as unknown until verified against source SQL qualifiers.
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Configuration
- Operations and processes
- Business rules
- Security and authorization
- Tech debt
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
- LegalMaintenance web application (LegalMaintenance/*.aspx.vb)
- SAIF.Business.Claim.Legal
- SAIF.Business.Tasks
- SAIF.Business.View.Policy
- SAIF.Business.View.Provider
- SAIF.Services.Appworx