Application data model

This page documents the cross-library database table inventory for Claims Legal, grouped by business domain.

Legal case and scheduling

Table	Schema	Owning library	CRUD	Notes
LEGAL_CASE	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	Master legal case record linked to a claim (SQL-046–SQL-050, SQL-051).
CASE_STATUS_HISTORY	[unqualified]**	SAIF.Business.Claim.Legal	CR	Case status change history (SQL-007).
LEGAL_SCHEDULE / SCHEDULE	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	Hearing, mediation, deposition, and calendar events (SQL-040–SQL-044, SQL-045).
LEGAL_FILE_LOCATION	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	File location history and current file tracking (SQL-036–SQL-039).
LEGAL_CASE_EVALUATION	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	LCE due-date, filed-date, excusal, and transfer state (SQL-033–SQL-035).
CONSOLIDATED_CASE	[unqualified]**	SAIF.Business.Claim.Legal	CRU	Primary-to-secondary legal-case linkage used for propagation workflows (SQL-056, SQL-057); see BR-APP-003.

Appeals and outcomes

Table	Schema	Owning library	CRUD	Notes
APPEAL	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	Appeal header and level-specific data (SQL-009–SQL-012, SQL-013).
APPEAL_EXTENSION	[unqualified]**	SAIF.Business.Claim.Legal	CR	Approved extension tracking for appeals (SQL-014, SQL-015).
CASE_OUTCOME	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	Outcome or order header for a case (SQL-020–SQL-023).
OUTCOME_ISSUE	[unqualified]**	SAIF.Business.Claim.Legal	CR	Outcome-level issue, grounds, body-part, and fee detail (SQL-024, SQL-025).
OUTCOME_STAFF	[unqualified]**	SAIF.Business.Claim.Legal	CR	ALJ, board-member, or staff linkage to an outcome (SQL-026, SQL-027).

Requests, acknowledgements, costs, and other parties

Table	Schema	Owning library	CRUD	Notes
REQUEST_ISSUE	[unqualified]**	SAIF.Business.Claim.Legal	CR	Requested issue rows for a legal case (SQL-028, SQL-029).
CASE_COST	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	Legal cost, billing, authorization, and cancellation tracking (SQL-001–SQL-004, SQL-006).
ACKNOWLEDGE workflow procedure set	[unqualified]**	SAIF.Business.Claim.Legal	CRU	WCB or DCBS acknowledgement updates (SQL-008).
LEGAL_CASE_EMPLOYER	[unqualified]**	SAIF.Business.Claim.Legal	CR	Employer, insurer, and attorney-party linkage for a case.
LEGAL.vw_cases	LEGAL	SAIF.Business.Claim.Legal	R	Case-number lookup used by letter generation support.

Assignment and reference data

Table	Schema	Owning library	CRUD	Notes
ATTORNEY_CONFLICT	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	Attorney conflict maintenance (SQL-065-104).
ATTORNEY_POLICY_ASSIGNMENT	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	Policy-to-attorney assignment maintenance.
ATTORNEY_SCHEDULE	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	Attorney schedule and time-off maintenance.
ATTORNEY_WORKER_ASSIGNMENT	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	Worker-to-attorney assignment rules.
OUT_OF_TOWN_ROTATION_ASSGN	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	Rotation assignment maintenance.
HEARING_LOCATION	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	Hearing location lookup and maintenance (SQL-062, SQL-063).
LEGAL_PERSON and LEGAL_PERSON_TYPE	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	Legal person master data and role classification (SQL-061).
OTHER_FIRM	[unqualified]**	SAIF.Business.Claim.Legal	CRUD	Outside firm and employer reference data (SQL-064); note the SQL-injection tech debt finding on clsOtherFirm.ValidateState in Tech debt.

Policy context and access

Table	Schema	Owning library	CRUD	Notes
POLICY	[unqualified]**	SAIF.Business.View.Policy	R	Policy header and policy-list lookup data.
POLICY_PERIOD and POLICY_PERIOD_NON_WCIS	[unqualified]**	SAIF.Business.View.Policy, SAIF.Business.Policy	R	Policy-period and ownership-period context.
TRADING_AS	[unqualified]**	SAIF.Business.View.Policy	R	Trading-name records for policy display.
NON_EMPR_ACCT	[unqualified]**	SAIF.Business.View.Policy	R	Non-employer account lookup.
BUSINESS_AFFILIATE and AFFILIATE	[unqualified]**	SAIF.Business.View.Policy	R	Officer-of-notice and affiliation lookups.
ASSOCIATION_TYPE_CODE	[unqualified]**	SAIF.Business.View.Policy	R	Association-type metadata that drives policy-header association retrieval.
PA_AUDIT, PA_AUDITOR, and PA_POLICY_PERIOD	[unqualified]**	SAIF.Business.View.Policy	R	Auditor-access and last-audit lookups.

Shared policy reference and rating support

Table	Schema	Owning library	CRUD	Notes
HAZARD_GROUP	[unqualified]**	SAIF.Business.Policy	R	Hazard-group reference data.
BENEFIT_JURISDICTION_CODE	[unqualified]**	SAIF.Business.Policy	R	Benefit-jurisdiction code map.
MANUAL_CLASS_TYPE_CODE	[unqualified]**	SAIF.Business.Policy	R	Manual-class-type code map.
ENDORSEMENT	[unqualified]**	SAIF.Business.Policy	R	Information-page and endorsement status lookup support.
PREM_HIST_SUMMARY	[unqualified]**	SAIF.Business.Policy	R	Premium-history set resolution for rating support.

Batch and document support

Table	Schema	Owning library	CRUD	Notes
submit_appworx_job	[unqualified]**	SAIF.Services.Appworx	C	Batch letter and print-job submission procedure.
xprint_control_seq	[unqualified]**	SAIF.Business.Claim.Legal	RU	Sequence used by create-file document numbering support (SQL-052, SQL-053).

Related documentation

• Application 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

• SAIF.Business.Claim.Legal/clsLegalCase.vb
• SAIF.Business.Claim.Legal/clsCaseCost.vb
• SAIF.Business.Claim.Legal/clsAppeal.vb
• SAIF.Business.Claim.Legal/clsCaseOutcome.vb
• SAIF.Business.Claim.Legal/clsAssignmentProcess.vb
• SAIF.Business.View.Policy/clsPolicyData.vb
• SAIF.Business.Policy/PolicyInformation.vb
• SAIF.Services.Appworx/AppworxServices.vb