SAIF.Business.Claim.Legal database tables¶

This page catalogs the 51 database tables and views accessed by this library. Schema is recorded as [unqualified]** wherever the source references the object without a schema prefix (the overwhelming majority — the BOF data portal resolves the schema through the connecting Oracle user at runtime). Only two references are explicitly qualified (LEGAL.ATTORNEY_PROFILE, LEGAL.VW_CASES).

Table catalog¶

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
ADP_EMPLOYEE	Oracle	`[unqualified]**`	R	Attorney / staff lookup joins	`Attorney / staff lookup joins`
ALL_STATES	Oracle	`[unqualified]**`	R	State code list	`State code list`
APPEAL_EXTENSION	Oracle	`[unqualified]**`	CRU	clsAppealExtension	`clsAppealExtension`
ATTORNEY_CONFLICT	Oracle	`[unqualified]**`	CRUD	clsAttorneyConflict, clsAttorneyConflictCollection	`clsAttorneyConflict`
ATTORNEY_POLICY_ASSIGNMENT	Oracle	`[unqualified]**`	CRUD	clsAttorneyPolicyAssignment (+collection)	`clsAttorneyPolicyAssignment`
ATTORNEY_PROFILE	Oracle	`[unqualified]**`	CRU	clsAttorneyProfile	`clsAttorneyProfile`
LEGAL.ATTORNEY_PROFILE	Oracle	`LEGAL`	R	clsAttorneyProfile (explicitly qualified read)	`clsAttorneyProfile`
ATTORNEY_SCHEDULE	Oracle	`[unqualified]**`	CRUD	clsAttorneySchedule (+collection)	`clsAttorneySchedule`
ATTORNEY_SCHEDULE_TYPE_CODE	Oracle	`[unqualified]**`	R	clsAttorneyScheduleTypeCodes	`clsAttorneyScheduleTypeCodes`
ATTORNEY_TYPE_CODE	Oracle	`[unqualified]**`	R	clsAttorneyTypeCodes	`clsAttorneyTypeCodes`
ATTORNEY_WORKER_ASSIGNMENT	Oracle	`[unqualified]**`	CRUD	clsAttorneyWorkerAssignment (+collection)	`clsAttorneyWorkerAssignment`
CANCELLED_BY_CODE	Oracle	`[unqualified]**`	R	clsCancelledByCodes	`clsCancelledByCodes`
CASE_COST	Oracle	`[unqualified]**`	CRUD	clsCaseCost (+collection)	`clsCaseCost`
CASE_STATUS_CODE	Oracle	`[unqualified]**`	R	clsCaseStatusCodes	`clsCaseStatusCodes`
CASE_STATUS_HISTORY	Oracle	`[unqualified]**`	CRUD	clsCaseStatusHistory (+collection)	`clsCaseStatusHistory`
DUAL	Oracle	`[unqualified]**`	R	Sequence NEXTVAL pseudo-table	`Sequence NEXTVAL pseudo-table`
DURATION_CODE	Oracle	`[unqualified]**`	R	clsDurationCodes	`clsDurationCodes`
HEARING_LOCATION	Oracle	`[unqualified]**`	CRUD	clsHearingLocation (+collection), clsHearingLocationInfo	`clsHearingLocation`
HEARING_LOCATION_CODE	Oracle	`[unqualified]**`	R	clsHearingLocationCodes, clsHearingLocationList	`clsHearingLocationCodes`
LEGAL_BODY_PART_CODE	Oracle	`[unqualified]**`	R	clsBodyPartCodes	`clsBodyPartCodes`
LEGAL_CASE_EMPLOYER	Oracle	`[unqualified]**`	CRUD	clsLegalCaseEmployer (+collection)	`clsLegalCaseEmployer`
LEGAL_CASE_EVALUATION	Oracle	`[unqualified]**`	CRU	clsLegalCaseEvaluation (+collection)	`clsLegalCaseEvaluation`
LEGAL_FILE_LOCATION	Oracle	`[unqualified]**`	CRUD	clsLegalFileLocation (+collection)	`clsLegalFileLocation`
LEGAL_FILE_LOCATION_CODE	Oracle	`[unqualified]**`	R	clsFileLocationCodes	`clsFileLocationCodes`
LEGAL_PERSON	Oracle	`[unqualified]**`	CRUD	clsLegalPerson, clsLegalPersonList	`clsLegalPerson`
LEGAL_PERSON_TYPE	Oracle	`[unqualified]**`	CRUD	clsLegalPersonType (+collection)	`clsLegalPersonType`
LEGAL_PERSON_TYPE_CODE	Oracle	`[unqualified]**`	R	clsLegalPersonType, person-type lookups	`clsLegalPersonType`
LEGAL.VW_CASES	Oracle	`LEGAL`	R	clsLetterRequest case lookup (view)	`clsLetterRequest case lookup`
NATURE_CODE	Oracle	`[unqualified]**`	R	clsNatureCodes	`clsNatureCodes`
NOTE_CATEGORY_CODE	Oracle	`[unqualified]**`	R	clsNoteCategoryCodes	`clsNoteCategoryCodes`
ORDER_TYPE_CODE	Oracle	`[unqualified]**`	R	clsOrderTypeCodes	`clsOrderTypeCodes`
OTHER_FIRM	Oracle	`[unqualified]**`	CRUD	clsOtherFirm (+collection)	`clsOtherFirm`
OTHER_FIRM_TYPE_CODE	Oracle	`[unqualified]**`	R	clsOtherFirmTypeCodes	`clsOtherFirmTypeCodes`
OUTCOME_GROUNDS_CODE	Oracle	`[unqualified]**`	R	clsOutcomeGroundsCodes	`clsOutcomeGroundsCodes`
OUTCOME_ISSUE	Oracle	`[unqualified]**`	CRUD	clsOutcomeIssue (+collection)	`clsOutcomeIssue`
OUTCOME_ISSUE_CODE	Oracle	`[unqualified]**`	R	clsOutcomeIssueCodes	`clsOutcomeIssueCodes`
OUTCOME_STAFF	Oracle	`[unqualified]**`	CRUD	clsOutcomeStaff (+collection)	`clsOutcomeStaff`
OUT_OF_TOWN_ROTATION_ASSGN	Oracle	`[unqualified]**`	CRUD	clsOutOFTownRotationAssgn (+collection)	`clsOutOFTownRotationAssgn`
PETITIONER_RESPONDENT_CODE	Oracle	`[unqualified]**`	R	clsPetitionerRespondentCodes	`clsPetitionerRespondentCodes`
POLICY	Oracle	`[unqualified]**`	R	Policy join for conflicts / policy assignment	`Policy join for conflicts / policy assignment`
PROVIDER_LOCATION	Oracle	`[unqualified]**`	R	Outside-counsel firm location join	`Outside-counsel firm location join`
REQUESTED_BY_CODE	Oracle	`[unqualified]**`	R	clsRequestedByCodes	`clsRequestedByCodes`
REQUEST_ISSUE	Oracle	`[unqualified]**`	CRUD	clsRequestIssue (+collection)	`clsRequestIssue`
REQUEST_ISSUE_CODE	Oracle	`[unqualified]**`	R	clsRequestIssueCodes	`clsRequestIssueCodes`
REQUEST_TYPE_CODE	Oracle	`[unqualified]**`	R	clsRequestTypeCodes	`clsRequestTypeCodes`
REVIEW_LEVEL_CODE	Oracle	`[unqualified]**`	R	clsReviewLevelCodes	`clsReviewLevelCodes`
SCHEDULE	Oracle	`[unqualified]**`	R	clsLegalSchedule, clsHearingLocation.CanDeleteLocation	`clsLegalSchedule`
SCHEDULE_STATUS_CODE	Oracle	`[unqualified]**`	R	clsScheduleStatusCodes	`clsScheduleStatusCodes`
SCHEDULE_TYPE_CODE	Oracle	`[unqualified]**`	R	clsScheduleTypeCodes	`clsScheduleTypeCodes`
SERVICE_CODE	Oracle	`[unqualified]**`	R	clsServiceCodes	`clsServiceCodes`
SUBPOENA_RECIPIENT	Oracle	`[unqualified]**`	R	clsLegalPerson delete-guard (NOT EXISTS)	`clsLegalPerson delete-guard`

ADP_EMPLOYEE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by Attorney / staff lookup joins
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`Attorney / staff lookup joins`

Sources for ADP_EMPLOYEE¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb
SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb
SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb
SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb
SAIF.Business.Claim.Legal\TableMaint\clsOutOFTownRotationAssgn.vb
SAIF.Business.Claim.Legal\mdlCodeTables.vb

ALL_STATES¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by State code list
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`State code list`

Sources for ALL_STATES¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

APPEAL_EXTENSION¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsAppealExtension
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update
Key columns used	See SQL catalog entries referencing this table
Sequence	APPEAL_EXTENSION_SEQ
Related tables	See Table relationship diagram below
Business objects	`clsAppealExtension`

Sources for APPEAL_EXTENSION¶

SAIF.Business.Claim.Legal\LegalNet\clsAppealExtension.vb

ATTORNEY_CONFLICT¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsAttorneyConflict, clsAttorneyConflictCollection
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	ATTORNEY_CONFLICT_SEQ_NUM
Related tables	See Table relationship diagram below
Business objects	`clsAttorneyConflict, clsAttorneyConflictCollection`

Sources for ATTORNEY_CONFLICT¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb

ATTORNEY_POLICY_ASSIGNMENT¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsAttorneyPolicyAssignment (+collection)
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	ATTY_POLICY_ASSGN_SEQ_NUM
Related tables	See Table relationship diagram below
Business objects	`clsAttorneyPolicyAssignment (+collection)`

Sources for ATTORNEY_POLICY_ASSIGNMENT¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb

ATTORNEY_PROFILE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsAttorneyProfile
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update
Key columns used	See SQL catalog entries referencing this table
Sequence	— (proc-managed)
Related tables	See Table relationship diagram below
Business objects	`clsAttorneyProfile`

Sources for ATTORNEY_PROFILE¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyProfile.vb
SAIF.Business.Claim.Legal\mdlCodeTables.vb

LEGAL.ATTORNEY_PROFILE¶

Field	Value
Database	Oracle
Schema/Link	`LEGAL`
Purpose	Used by clsAttorneyProfile (explicitly qualified read)
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsAttorneyProfile (explicitly qualified read)`

Sources for LEGAL.ATTORNEY_PROFILE¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyProfile.vb:587

ATTORNEY_SCHEDULE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsAttorneySchedule (+collection)
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	ATTORNEY_SCHEDULE_SEQ_NUM
Related tables	See Table relationship diagram below
Business objects	`clsAttorneySchedule (+collection)`

Sources for ATTORNEY_SCHEDULE¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb

ATTORNEY_SCHEDULE_TYPE_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsAttorneyScheduleTypeCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsAttorneyScheduleTypeCodes`

Sources for ATTORNEY_SCHEDULE_TYPE_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

ATTORNEY_TYPE_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsAttorneyTypeCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsAttorneyTypeCodes`

Sources for ATTORNEY_TYPE_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

ATTORNEY_WORKER_ASSIGNMENT¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsAttorneyWorkerAssignment (+collection)
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	ATTORNEY_WORKER_ASSIGNMENT_SEQ
Related tables	See Table relationship diagram below
Business objects	`clsAttorneyWorkerAssignment (+collection)`

Sources for ATTORNEY_WORKER_ASSIGNMENT¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb

CANCELLED_BY_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsCancelledByCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsCancelledByCodes`

Sources for CANCELLED_BY_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

CASE_COST¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsCaseCost (+collection)
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	CASE_COST_SEQ
Related tables	See Table relationship diagram below
Business objects	`clsCaseCost (+collection)`

Sources for CASE_COST¶

SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb

CASE_STATUS_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsCaseStatusCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsCaseStatusCodes`

Sources for CASE_STATUS_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

CASE_STATUS_HISTORY¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsCaseStatusHistory (+collection)
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	CASE_STATUS_HISTORY_SEQ
Related tables	See Table relationship diagram below
Business objects	`clsCaseStatusHistory (+collection)`

Sources for CASE_STATUS_HISTORY¶

SAIF.Business.Claim.Legal\LegalNet\clsCaseStatusHistory.vb

DUAL¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by Sequence NEXTVAL pseudo-table
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`Sequence NEXTVAL pseudo-table`

Sources for DUAL¶

SAIF.Business.Claim.Legal\13 CreateSQL properties (see SQL-001 through SQL-013)

DURATION_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsDurationCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsDurationCodes`

Sources for DURATION_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

HEARING_LOCATION¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsHearingLocation (+collection), clsHearingLocationInfo
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	HEARING_LOCATION_SEQ_NUM
Related tables	See Table relationship diagram below
Business objects	`clsHearingLocation (+collection), clsHearingLocationInfo`

Sources for HEARING_LOCATION¶

SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb
SAIF.Business.Claim.Legal\LegalNet\clsHearingLocationInfo.vb

HEARING_LOCATION_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsHearingLocationCodes, clsHearingLocationList
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsHearingLocationCodes, clsHearingLocationList`

Sources for HEARING_LOCATION_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb
SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb

LEGAL_BODY_PART_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsBodyPartCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsBodyPartCodes`

Sources for LEGAL_BODY_PART_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

LEGAL_CASE_EMPLOYER¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsLegalCaseEmployer (+collection)
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	LEGAL_CASE_EMPLOYER_SEQ
Related tables	See Table relationship diagram below
Business objects	`clsLegalCaseEmployer (+collection)`

Sources for LEGAL_CASE_EMPLOYER¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEmployer.vb

LEGAL_CASE_EVALUATION¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsLegalCaseEvaluation (+collection)
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update
Key columns used	See SQL catalog entries referencing this table
Sequence	LEGAL_CASE_EVALUATION_SEQ
Related tables	See Table relationship diagram below
Business objects	`clsLegalCaseEvaluation (+collection)`

Sources for LEGAL_CASE_EVALUATION¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEvaluation.vb

LEGAL_FILE_LOCATION¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsLegalFileLocation (+collection)
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	LEGAL_FILE_LOCATION_SEQ
Related tables	See Table relationship diagram below
Business objects	`clsLegalFileLocation (+collection)`

Sources for LEGAL_FILE_LOCATION¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalFileLocation.vb

LEGAL_FILE_LOCATION_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsFileLocationCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsFileLocationCodes`

Sources for LEGAL_FILE_LOCATION_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

LEGAL_PERSON¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsLegalPerson, clsLegalPersonList
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	LEGAL_PERSON_SEQ_NUM
Related tables	See Table relationship diagram below
Business objects	`clsLegalPerson, clsLegalPersonList`

Sources for LEGAL_PERSON¶

SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb
SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonList.vb

LEGAL_PERSON_TYPE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsLegalPersonType (+collection)
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	LEGAL_PERSON_SEQ_NUM
Related tables	See Table relationship diagram below
Business objects	`clsLegalPersonType (+collection)`

Sources for LEGAL_PERSON_TYPE¶

SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonType.vb

LEGAL_PERSON_TYPE_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsLegalPersonType, person-type lookups
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsLegalPersonType, person-type lookups`

Sources for LEGAL_PERSON_TYPE_CODE¶

SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonType.vb
SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonList.vb

LEGAL.VW_CASES¶

Field	Value
Database	Oracle
Schema/Link	`LEGAL`
Purpose	Used by clsLetterRequest case lookup (view)
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsLetterRequest case lookup (view)`

Sources for LEGAL.VW_CASES¶

SAIF.Business.Claim.Legal\Print\clsLetterRequest.vb:730

NATURE_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsNatureCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsNatureCodes`

Sources for NATURE_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

NOTE_CATEGORY_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsNoteCategoryCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsNoteCategoryCodes`

Sources for NOTE_CATEGORY_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

ORDER_TYPE_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsOrderTypeCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsOrderTypeCodes`

Sources for ORDER_TYPE_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

OTHER_FIRM¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsOtherFirm (+collection)
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	OTHER_FIRM_SEQ_NUM
Related tables	See Table relationship diagram below
Business objects	`clsOtherFirm (+collection)`

Sources for OTHER_FIRM¶

SAIF.Business.Claim.Legal\TableMaint\clsOtherFirm.vb
SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEmployer.vb

OTHER_FIRM_TYPE_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsOtherFirmTypeCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsOtherFirmTypeCodes`

Sources for OTHER_FIRM_TYPE_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

OUTCOME_GROUNDS_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsOutcomeGroundsCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsOutcomeGroundsCodes`

Sources for OUTCOME_GROUNDS_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

OUTCOME_ISSUE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsOutcomeIssue (+collection)
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	OUTCOME_ISSUE_SEQ
Related tables	See Table relationship diagram below
Business objects	`clsOutcomeIssue (+collection)`

Sources for OUTCOME_ISSUE¶

SAIF.Business.Claim.Legal\LegalNet\clsOutcomeIssue.vb

OUTCOME_ISSUE_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsOutcomeIssueCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsOutcomeIssueCodes`

Sources for OUTCOME_ISSUE_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

OUTCOME_STAFF¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsOutcomeStaff (+collection)
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	OUTCOME_STAFF_SEQ_NUM
Related tables	See Table relationship diagram below
Business objects	`clsOutcomeStaff (+collection)`

Sources for OUTCOME_STAFF¶

SAIF.Business.Claim.Legal\LegalNet\clsOutcomeStaff.vb

OUT_OF_TOWN_ROTATION_ASSGN¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsOutOFTownRotationAssgn (+collection)
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	OUT_OF_TOWN_ROTATION_SEQ_NUM
Related tables	See Table relationship diagram below
Business objects	`clsOutOFTownRotationAssgn (+collection)`

Sources for OUT_OF_TOWN_ROTATION_ASSGN¶

SAIF.Business.Claim.Legal\TableMaint\clsOutOFTownRotationAssgn.vb

PETITIONER_RESPONDENT_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsPetitionerRespondentCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsPetitionerRespondentCodes`

Sources for PETITIONER_RESPONDENT_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

POLICY¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by Policy join for conflicts / policy assignment
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`Policy join for conflicts / policy assignment`

Sources for POLICY¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb
SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb

PROVIDER_LOCATION¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by Outside-counsel firm location join
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`Outside-counsel firm location join`

Sources for PROVIDER_LOCATION¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb
SAIF.Business.Claim.Legal\mdlCodeTables.vb

REQUESTED_BY_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsRequestedByCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsRequestedByCodes`

Sources for REQUESTED_BY_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

REQUEST_ISSUE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsRequestIssue (+collection)
Access pattern	direct SQL / stored procedure
CRUD operations	Create, Read, Update, Delete
Key columns used	See SQL catalog entries referencing this table
Sequence	REQUEST_ISSUE_SEQ
Related tables	See Table relationship diagram below
Business objects	`clsRequestIssue (+collection)`

Sources for REQUEST_ISSUE¶

SAIF.Business.Claim.Legal\LegalNet\clsRequestIssue.vb

REQUEST_ISSUE_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsRequestIssueCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsRequestIssueCodes`

Sources for REQUEST_ISSUE_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

REQUEST_TYPE_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsRequestTypeCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsRequestTypeCodes`

Sources for REQUEST_TYPE_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

REVIEW_LEVEL_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsReviewLevelCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsReviewLevelCodes`

Sources for REVIEW_LEVEL_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

SCHEDULE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsLegalSchedule, clsHearingLocation.CanDeleteLocation
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	SCHEDULE_SEQ (create via proc)
Related tables	See Table relationship diagram below
Business objects	`clsLegalSchedule, clsHearingLocation.CanDeleteLocation`

Sources for SCHEDULE¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalSchedule.vb
SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb

SCHEDULE_STATUS_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsScheduleStatusCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsScheduleStatusCodes`

Sources for SCHEDULE_STATUS_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

SCHEDULE_TYPE_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsScheduleTypeCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsScheduleTypeCodes`

Sources for SCHEDULE_TYPE_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

SERVICE_CODE¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsServiceCodes
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsServiceCodes`

Sources for SERVICE_CODE¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb

SUBPOENA_RECIPIENT¶

Field	Value
Database	Oracle
Schema/Link	`[unqualified]**`
Purpose	Used by clsLegalPerson delete-guard (NOT EXISTS)
Access pattern	direct SQL / stored procedure
CRUD operations	Read
Key columns used	See SQL catalog entries referencing this table
Sequence	—
Related tables	See Table relationship diagram below
Business objects	`clsLegalPerson delete-guard (NOT EXISTS)`

Sources for SUBPOENA_RECIPIENT¶

SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb

Table relationship diagram¶

The following diagram shows verified relationships between tables used by this library (explicit JOIN or correlated predicate in repository SQL).

erDiagram
    ADP_EMPLOYEE ||--o{ ATTORNEY_CONFLICT : "ADJUSTER_EMPLID"
    PROVIDER_LOCATION ||--o{ ATTORNEY_CONFLICT : "PROVIDER_LOCATION_SEQ_NUM"
    POLICY ||--o{ ATTORNEY_CONFLICT : "POLICY_NUM"
    LEGAL_PERSON ||--o{ ATTORNEY_CONFLICT : "CONFLICT_LEGAL_PERSON_SEQ_NUM"
    ATTORNEY_PROFILE ||--o{ ATTORNEY_CONFLICT : "ATTORNEY_EMPLID"
    ADP_EMPLOYEE ||--o{ ATTORNEY_POLICY_ASSIGNMENT : "PRIMARY_SECONDARY_TERTIARY_EMPLID"
    POLICY ||--o{ ATTORNEY_POLICY_ASSIGNMENT : "POLICY_NUM"
    ADP_EMPLOYEE ||--o{ ATTORNEY_SCHEDULE : "SCHEDULE_EMPLID"
    ADP_EMPLOYEE ||--o{ ATTORNEY_WORKER_ASSIGNMENT : "ATTORNEY_EMPLID"
    ADP_EMPLOYEE ||--o{ OUT_OF_TOWN_ROTATION_ASSGN : "ATTORNEY_EMPLID"
    ADP_EMPLOYEE ||--o{ ATTORNEY_PROFILE : "PROFILE_EMPLID"
    OTHER_FIRM ||--o{ LEGAL_CASE_EMPLOYER : "OTHER_FIRM_SEQ_NUM"
    LEGAL_PERSON ||--o{ LEGAL_CASE_EMPLOYER : "LEGAL_PERSON_SEQ_NUM"
    HEARING_LOCATION_CODE ||--o{ HEARING_LOCATION : "HEARING_LOCATION_CODE"
    LEGAL_PERSON ||--o{ LEGAL_PERSON_TYPE : "LEGAL_PERSON_SEQ_NUM"
    LEGAL_PERSON_TYPE_CODE ||--o{ LEGAL_PERSON_TYPE : "LEGAL_PERSON_TYPE_CODE"
    LEGAL_PERSON ||--o{ SUBPOENA_RECIPIENT : "LEGAL_PERSON_SEQ_NUM (delete guard)"
    HEARING_LOCATION ||--o{ SCHEDULE : "HEARING_LOCATION_SEQ_NUM (delete guard)"
    OTHER_FIRM_TYPE_CODE ||--o{ OTHER_FIRM : "OTHER_FIRM_TYPE_CODE"
    OUTCOME_ISSUE_CODE ||--o{ OUTCOME_ISSUE : "OUTCOME_ISSUE_CODE"
    REQUEST_ISSUE_CODE ||--o{ REQUEST_ISSUE : "REQUEST_ISSUE_CODE"

Additional relationships are inferred from *_SEQ_NUM naming conventions but have no explicit JOIN in repository SQL (e.g. LEGAL_CASE to CASE_COST, CASE_STATUS_HISTORY, LEGAL_CASE_EMPLOYER, LEGAL_CASE_EVALUATION, LEGAL_FILE_LOCATION, REQUEST_ISSUE, SCHEDULE via LEGAL_CASE_SEQ_NUM; CASE_OUTCOME to OUTCOME_ISSUE/OUTCOME_STAFF via CASE_OUTCOME_SEQ_NUM; APPEAL to APPEAL_EXTENSION via APPEAL_SEQ_NUM).* No FOREIGN KEY constraint DDL exists in this repository; all relationships are derived from query text or naming.**

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

SAIF.Business.Claim.Legal\mdlCodeTables.vb
SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb
SAIF.Business.Claim.Legal\LegalNet\clsLegalSchedule.vb
SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb
SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb
SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb
SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb
SAIF.Business.Claim.Legal\TableMaint\clsAttorneyProfile.vb
SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb
SAIF.Business.Claim.Legal\TableMaint\clsOtherFirm.vb
SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb
SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonType.vb
SAIF.Business.Claim.Legal\TableMaint\clsOutOFTownRotationAssgn.vb
SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb
SAIF.Business.Claim.Legal\LegalNet\clsCaseStatusHistory.vb
SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEmployer.vb
SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEvaluation.vb
SAIF.Business.Claim.Legal\LegalNet\clsLegalFileLocation.vb
SAIF.Business.Claim.Legal\LegalNet\clsOutcomeIssue.vb
SAIF.Business.Claim.Legal\LegalNet\clsOutcomeStaff.vb
SAIF.Business.Claim.Legal\LegalNet\clsRequestIssue.vb
SAIF.Business.Claim.Legal\LegalNet\clsAppealExtension.vb
SAIF.Business.Claim.Legal\Print\clsLetterRequest.vb