SAIF.Application.Claim.Legal database tables

This page catalogs database tables accessed by this library.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
ADP_EMPLOYEE	Oracle	[unqualified]**	R	Attorney conflicts, policy/worker assignments, schedules, time-off, out-of-town rotations; AJAX + XML reports	clsAttorneyTableManager
APPEAL	Oracle	[unqualified]**	R	Case outcomes and case closure	clsOutcomeManager
ATTORNEY_PROFILE	Oracle	[unqualified]**	R	Attorney conflicts, policy/worker assignments, schedules, time-off, out-of-town rotations; AJAX + XML reports	clsAttorneyTableManager, clsSummaryManager
CASE_STATUS_CODE	Oracle	[unqualified]**	R	Case updates	clsUpdateCaseManager
DUAL	Oracle	N/A — Oracle pseudo-table	R	Other parties on a case	clsOtherPartiesManager, clsOutcomeManager, clsScheduleManager
HEARING_LOCATION_CODE	Oracle	[unqualified]**	R	Attorney conflicts, policy/worker assignments, schedules, time-off, out-of-town rotations; AJAX + XML reports	clsAttorneyTableManager, clsHearingLocationManager
LEGAL_CODE_TABLE	Oracle	[unqualified]**	R	Attorney conflicts, policy/worker assignments, schedules, time-off, out-of-town rotations; AJAX + XML reports	clsAttorneyTableManager, clsLegalPersonManager
LEGAL_PERSON	Oracle	[unqualified]**	R	Attorney conflicts, policy/worker assignments, schedules, time-off, out-of-town rotations; AJAX + XML reports	clsAttorneyTableManager, clsOtherPartiesManager, clsUpdateCaseManager (dead)
LEGAL_PERSON_TYPE	Oracle	[unqualified]**	R	Attorney conflicts, policy/worker assignments, schedules, time-off, out-of-town rotations; AJAX + XML reports	clsAttorneyTableManager, clsOtherPartiesManager, clsUpdateCaseManager (dead)
LEGAL_PERSON_TYPE_CODE	Oracle	[unqualified]**	R	Legal person, legal person type, and other-firm maintenance	clsLegalPersonManager
OTHER_FIRM	Oracle	[unqualified]**	R	Other parties on a case	clsOtherPartiesManager, clsUpdateCaseManager (dead)
OTHER_FIRM_TYPE_CODE	Oracle	[unqualified]**	R	Legal person, legal person type, and other-firm maintenance	clsLegalPersonManager
POLICY	Oracle	[unqualified]**	R	Attorney conflicts, policy/worker assignments, schedules, time-off, out-of-town rotations; AJAX + XML reports	clsAttorneyTableManager
REVIEW_LEVEL_CODE	Oracle	[unqualified]**	R	Case outcomes and case closure	clsOutcomeManager

ADP_EMPLOYEE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Attorney conflicts, policy/worker assignments, schedules, time-off, out-of-town rotations; AJAX + XML reports
Access pattern	direct SQL
CRUD operations	R
Key columns used	EMPLID, LAST_NAME, FIRST_NAME, PREFERRED_NAME, EMPL_STATUS, DESCR
Sequence	N/A
Related tables	ATTORNEY_PROFILE
Business objects	clsAttorneyTableManager

SQL referencing this table

• SQL-002: Adjuster code list
• SQL-004: SAIF attorney code list

---

APPEAL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Case outcomes and case closure
Access pattern	direct SQL
CRUD operations	R
Key columns used	APPEAL_SEQ_NUM, APPEAL_NUM, REVIEW_LEVEL_CODE, LEGAL_CASE_SEQ_NUM
Sequence	N/A
Related tables	LEGAL_CASE (external to this library), REVIEW_LEVEL_CODE
Business objects	clsOutcomeManager

SQL referencing this table

• SQL-016: Appeal number / review level list for a case

---

ATTORNEY_PROFILE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Attorney conflicts, policy/worker assignments, schedules, time-off, out-of-town rotations; AJAX + XML reports
Access pattern	direct SQL
CRUD operations	R
Key columns used	PROFILE_EMPLID, SECRETARY_EMPLID
Sequence	N/A
Related tables	ADP_EMPLOYEE, ADP_EMPLOYEE (secretary)
Business objects	clsAttorneyTableManager, clsSummaryManager

SQL referencing this table

• SQL-004: SAIF attorney code list
• SQL-018: Legal secretary employee ID for an attorney

---

CASE_STATUS_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Case updates
Access pattern	direct SQL
CRUD operations	R
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	LEGAL_CASE (external)
Business objects	clsUpdateCaseManager

SQL referencing this table

• SQL-019: Allowed case status codes for the current case

---

DUAL

Field	Value
Database	Oracle
Schema/Link	N/A — Oracle pseudo-table
Purpose	Other parties on a case
Access pattern	direct SQL
CRUD operations	R
Key columns used	N/A
Sequence	N/A
Related tables	N/A
Business objects	clsOtherPartiesManager, clsOutcomeManager, clsScheduleManager

SQL referencing this table

• SQL-013: Opposing/outside attorney firm list
• SQL-014: Opposing/outside attorney person list
• SQL-015: Employer / insurer firm list
• SQL-016: Appeal number / review level list for a case
• SQL-017: Assigned attorney's manager email

---

HEARING_LOCATION_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Attorney conflicts, policy/worker assignments, schedules, time-off, out-of-town rotations; AJAX + XML reports
Access pattern	direct SQL
CRUD operations	R
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	N/A
Business objects	clsAttorneyTableManager, clsHearingLocationManager

SQL referencing this table

• SQL-005: Hearing location code list
• SQL-008: Hearing location code list

---

LEGAL_CODE_TABLE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Attorney conflicts, policy/worker assignments, schedules, time-off, out-of-town rotations; AJAX + XML reports
Access pattern	direct SQL
CRUD operations	R
Key columns used	TABLE_NAME, TABLE_MAINT_WIN_NAME
Sequence	N/A
Related tables	(maintenance-window registry)
Business objects	clsAttorneyTableManager, clsLegalPersonManager

SQL referencing this table

• SQL-007: Attorney-assignment maintenance table list
• SQL-011: Person-maintenance view code list

---

LEGAL_PERSON

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Attorney conflicts, policy/worker assignments, schedules, time-off, out-of-town rotations; AJAX + XML reports
Access pattern	direct SQL
CRUD operations	R
Key columns used	LEGAL_PERSON_SEQ_NUM, LAST_NAME, FIRST_NAME, PREFERRED_NAME
Sequence	N/A
Related tables	LEGAL_PERSON_TYPE
Business objects	clsAttorneyTableManager, clsOtherPartiesManager, clsUpdateCaseManager (dead)

SQL referencing this table

• SQL-003: ALJ / Board / FJ person list
• SQL-012: Legal person type code list
• SQL-014: Opposing/outside attorney person list

---

LEGAL_PERSON_TYPE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Attorney conflicts, policy/worker assignments, schedules, time-off, out-of-town rotations; AJAX + XML reports
Access pattern	direct SQL
CRUD operations	R
Key columns used	LEGAL_PERSON_SEQ_NUM, LEGAL_PERSON_TYPE_CODE, EXP_DATE
Sequence	N/A
Related tables	LEGAL_PERSON, LEGAL_PERSON_TYPE_CODE
Business objects	clsAttorneyTableManager, clsOtherPartiesManager, clsUpdateCaseManager (dead)

SQL referencing this table

• SQL-003: ALJ / Board / FJ person list
• SQL-012: Legal person type code list
• SQL-014: Opposing/outside attorney person list

---

LEGAL_PERSON_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Legal person, legal person type, and other-firm maintenance
Access pattern	direct SQL
CRUD operations	R
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	LEGAL_PERSON_TYPE
Business objects	clsLegalPersonManager

SQL referencing this table

• SQL-012: Legal person type code list

---

OTHER_FIRM

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Other parties on a case
Access pattern	direct SQL
CRUD operations	R
Key columns used	OTHER_FIRM_SEQ_NUM, FIRM_NAME, OTHER_FIRM_TYPE_CODE
Sequence	N/A
Related tables	OTHER_FIRM_TYPE_CODE
Business objects	clsOtherPartiesManager, clsUpdateCaseManager (dead)

SQL referencing this table

• SQL-010: Other-firm type code list
• SQL-013: Opposing/outside attorney firm list
• SQL-015: Employer / insurer firm list

---

OTHER_FIRM_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Legal person, legal person type, and other-firm maintenance
Access pattern	direct SQL
CRUD operations	R
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	OTHER_FIRM
Business objects	clsLegalPersonManager

SQL referencing this table

• SQL-010: Other-firm type code list

---

POLICY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Attorney conflicts, policy/worker assignments, schedules, time-off, out-of-town rotations; AJAX + XML reports
Access pattern	direct SQL
CRUD operations	R
Key columns used	POLICY_NUM, POLICY_NAME
Sequence	N/A
Related tables	N/A
Business objects	clsAttorneyTableManager

SQL referencing this table

• SQL-006: Policy name code list

---

REVIEW_LEVEL_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Case outcomes and case closure
Access pattern	direct SQL
CRUD operations	R
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	APPEAL
Business objects	clsOutcomeManager

SQL referencing this table

• SQL-016: Appeal number / review level list for a case

---

Table relationship diagram

The following diagram shows the table relationships identified from the library SQL.

erDiagram
    LEGAL_PERSON ||--o{ LEGAL_PERSON_TYPE : "LEGAL_PERSON.LEGAL_PERSON_SEQ_NUM = LEGAL_PERSON_TYPE.LEGAL_PERSON_SEQ_NUM"
    ADP_EMPLOYEE ||--o{ ATTORNEY_PROFILE : "ADP_EMPLOYEE.EMPLID = ATTORNEY_PROFILE.PROFILE_EMPLID"
    REVIEW_LEVEL_CODE ||--o{ APPEAL : "APPEAL.REVIEW_LEVEL_CODE = REVIEW_LEVEL_CODE.CODE (LEFT OUTER JOIN)"
    LEGAL_CASE (external to this library) ||--o{ APPEAL : "APPEAL.LEGAL_CASE_SEQ_NUM = <current case id>"
    ATTORNEY_PROFILE ||--o{ ADP_EMPLOYEE (secretary) : "ATTORNEY_PROFILE.SECRETARY_EMPLID → ADP_EMPLOYEE.EMPLID"
    OTHER_FIRM_TYPE_CODE ||--o{ OTHER_FIRM : "OTHER_FIRM.OTHER_FIRM_TYPE_CODE = OTHER_FIRM_TYPE_CODE.CODE"
    LEGAL_PERSON_TYPE_CODE ||--o{ LEGAL_PERSON_TYPE : "LEGAL_PERSON_TYPE.LEGAL_PERSON_TYPE_CODE = LEGAL_PERSON_TYPE_CODE.CODE"
    CASE_STATUS_CODE ||--o{ LEGAL_CASE (external) : "LEGAL_CASE.CASE_STATUS_CODE = CASE_STATUS_CODE.CODE"
    LEGAL_CODE_TABLE ||--o{ (maintenance-window registry) : "TABLE_MAINT_WIN_NAME → screen name literal ('AttorneyAssignment', 'PersonMaint')"

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Security and authorization
• Configuration
• SQL catalog
• Procedures
• API reference

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• SAIF.Application.Claim.Legal\LegalManagerBase.vb
• SAIF.Application.Claim.Legal\clsAttorneyTableManager.vb
• SAIF.Application.Claim.Legal\clsHearingLocationManager.vb
• SAIF.Application.Claim.Legal\clsLegalPersonManager.vb
• SAIF.Application.Claim.Legal\LegalNet\clsOtherPartiesManager.vb
• SAIF.Application.Claim.Legal\LegalNet\clsOutcomeManager.vb
• SAIF.Application.Claim.Legal\LegalNet\clsScheduleManager.vb
• SAIF.Application.Claim.Legal\LegalNet\clsSummaryManager.vb
• SAIF.Application.Claim.Legal\LegalNet\clsUpdateCaseManager.vb