SAIF.Business.Claim database tables

This page catalogs the Oracle tables used by SAIF.Business.Claim.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
CLAIM_WORK_REL_STATUS_SEQ_NUM	Oracle	[unqualified]**	R	Supports Criteria data access.	Criteria
CLAIM_WORK_STATUS_SEQ	Oracle	[unqualified]**	R	Supports Criteria data access.	Criteria
CLM_DBA.CL_1502_DCBS_TRANSFER	Oracle	CLM_DBA	U	Supports Criteria data access.	Criteria
CL_1502_DCBS_TRANSFER	Oracle	[unqualified]**	C/D	Supports Criteria data access.	Criteria
CL_1502_DCBS_TRANSFER_SEQ	Oracle	[unqualified]**	R	Supports Criteria data access.	Criteria
CL_AWARD	Oracle	[unqualified]**	R/U	Supports Criteria data access.	Criteria
CL_BENEFIT_PAYMENT	Oracle	[unqualified]**	R/U/D	Supports Criteria data access.	Criteria
CL_BENEFIT_SCHEDULE	Oracle	[unqualified]**	R/U/D	Supports Criteria data access.	Criteria
CL_CLAIM_EMPLOYEE_WORK_ADDRESS	Oracle	[unqualified]**	C/R/U/D	Supports Criteria data access.	Criteria
CL_CLAIM_WORK_RELEASE_STATUS	Oracle	[unqualified]**	C/R/U/D	Supports Criteria data access.	Criteria
CL_CLAIM_WORK_STATUS	Oracle	[unqualified]**	C/R/U/D	Supports Criteria data access.	Criteria
CL_FEDERAL_AWARD	Oracle	[unqualified]**	R/U	Supports Criteria data access.	Criteria
CL_PPD_BODY_PART_CODE	Oracle	[unqualified]**	R	Supports clsPPDBodyParts data access.	clsPPDBodyParts
CL_PPD_SCHED_DEGREE_AWARD	Oracle	[unqualified]**	R	Supports clsPPDScheduledDegreeAwards data access.	clsPPDScheduledDegreeAwards
CL_PPD_UNSCHED_DEGREE_AWARD	Oracle	[unqualified]**	R	Supports clsPPDUnscheduledDegreeAwards data access.	clsPPDUnscheduledDegreeAwards
CL_RESERVE_VOC_SERV_TYPE_CODE	Oracle	[unqualified]**	R	Supports clsVocationalServiceTypes data access.	clsVocationalServiceTypes
CL_WORKER_INJURED_BODY_PART	Oracle	[unqualified]**	C/R/U/D	Supports Criteria data access.	Criteria

CLAIM_WORK_REL_STATUS_SEQ_NUM

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	R
Key columns used	N/A
Sequence	CLAIM_WORK_REL_STATUS_SEQ_NUM
Related tables	N/A
Business objects	Criteria

---

CLAIM_WORK_STATUS_SEQ

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	R
Key columns used	N/A
Sequence	CLAIM_WORK_STATUS_SEQ
Related tables	N/A
Business objects	Criteria

---

CLM_DBA.CL_1502_DCBS_TRANSFER

Field	Value
Database	Oracle
Schema/Link	CLM_DBA
Purpose	Supports Criteria data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	U
Key columns used	C, CLAIM_ID, CLM_DBA, CL_, CREATE_DATE, CREATE_USER, D, F, FILE_ID, FILE_NAME
Sequence	N/A
Related tables	CLM_DBA.CL_1502_DCBS_TRANSFER
Business objects	Criteria

SQL referencing this table

• SQL-028

---

CL_1502_DCBS_TRANSFER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	C/D
Key columns used	C, CLAIM_ID, CLM_DBA, CL_, CREATE_DATE, CREATE_USER, D, F, FILE_ID, FILE_NAME
Sequence	N/A
Related tables	CLM_DBA.CL_1502_DCBS_TRANSFER, CL_1502_DCBS_TRANSFER
Business objects	Criteria

SQL referencing this table

• SQL-004
• SQL-028
• SQL-039

---

CL_1502_DCBS_TRANSFER_SEQ

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	R
Key columns used	N/A
Sequence	CL_1502_DCBS_TRANSFER_SEQ
Related tables	N/A
Business objects	Criteria

---

CL_AWARD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	R/U
Key columns used	A, AND, AWARD_STATUS_CODE, C, CLAIM_ID, CL_AWARD, F, ID, N, P
Sequence	N/A
Related tables	CL_AWARD
Business objects	Criteria

SQL referencing this table

• SQL-025
• SQL-037

---

CL_BENEFIT_PAYMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	R/U/D
Key columns used	A, AND, APPROVER_USER, B, BENEFIT_PAYMENT_SEQ_NUM, BENEFIT_STATUS_CODE, BENEFIT_TYPE_CODE, C, CLAIM_ID, CL_BENEFIT_PAYMENT
Sequence	N/A
Related tables	CL_BENEFIT_PAYMENT
Business objects	Criteria

SQL referencing this table

• SQL-015
• SQL-016
• SQL-030
• SQL-041

---

CL_BENEFIT_SCHEDULE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	R/U/D
Key columns used	AND, B, BENEFIT_PAYMENT_SEQ_NUM, C, CLAIM_ID, CL_BENEFIT_SCHEDULE, D, F, I, ID
Sequence	N/A
Related tables	CL_BENEFIT_SCHEDULE
Business objects	Criteria

SQL referencing this table

• SQL-013
• SQL-017
• SQL-022
• SQL-029
• SQL-031
• SQL-036
• SQL-040
• SQL-042
• SQL-046

---

CL_CLAIM_EMPLOYEE_WORK_ADDRESS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	C/R/U/D
Key columns used	A, ADDRESS_LINE, C, CITY_NAME, CLAIM_ID, CL_CLAIM_EMPLOYEE_WORK_ADDRESS, COUNTY_CODE, D, E, F
Sequence	N/A
Related tables	CL_CLAIM_EMPLOYEE_WORK_ADDRESS
Business objects	Criteria

SQL referencing this table

• SQL-005
• SQL-018
• SQL-032
• SQL-043

---

CL_CLAIM_WORK_RELEASE_STATUS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	C/R/U/D
Key columns used	AND, C, CLAIM_ID, CLAIM_WORK_REL_STATUS_SEQ_NUM, CL_CLAIM_WORK_RELEASE_STATUS, D, F, FROM, I, ID
Sequence	N/A
Related tables	CL_CLAIM_WORK_RELEASE_STATUS
Business objects	Criteria

SQL referencing this table

• SQL-006
• SQL-019
• SQL-033
• SQL-044

---

CL_CLAIM_WORK_STATUS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	C/R/U/D
Key columns used	AND, C, CLAIM_ID, CLAIM_WORK_STATUS_SEQ_NUM, CL_CLAIM_WORK_STATUS, D, F, FROM, I, ID
Sequence	N/A
Related tables	CL_CLAIM_WORK_STATUS
Business objects	Criteria

SQL referencing this table

• SQL-007
• SQL-020
• SQL-034
• SQL-045

---

CL_FEDERAL_AWARD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	R/U
Key columns used	A, AND, ANNUAL_INCREASE_FLAG, AWARD_BALANCE_AMOUNT, AWARD_EFF_DATE, AWARD_STATUS_CODE, AWARD_TOTAL_AMOUNT, B, C, CLAIM_ID
Sequence	N/A
Related tables	CL_FEDERAL_AWARD
Business objects	Criteria

SQL referencing this table

• SQL-021
• SQL-035

---

CL_PPD_BODY_PART_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsPPDBodyParts data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	R
Key columns used	_
Sequence	N/A
Related tables	CL_PPD_BODY_PART_CODE
Business objects	clsPPDBodyParts

SQL referencing this table

• SQL-009

---

CL_PPD_SCHED_DEGREE_AWARD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsPPDScheduledDegreeAwards data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	R
Key columns used	E, _
Sequence	N/A
Related tables	CL_PPD_SCHED_DEGREE_AWARD
Business objects	clsPPDScheduledDegreeAwards

SQL referencing this table

• SQL-010

---

CL_PPD_UNSCHED_DEGREE_AWARD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsPPDUnscheduledDegreeAwards data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	R
Key columns used	_
Sequence	N/A
Related tables	CL_PPD_UNSCHED_DEGREE_AWARD
Business objects	clsPPDUnscheduledDegreeAwards

SQL referencing this table

• SQL-011

---

CL_RESERVE_VOC_SERV_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsVocationalServiceTypes data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	R
Key columns used	_
Sequence	N/A
Related tables	CL_RESERVE_VOC_SERV_TYPE_CODE
Business objects	clsVocationalServiceTypes

SQL referencing this table

• SQL-012

---

CL_WORKER_INJURED_BODY_PART

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.
Access pattern	direct SQL
CRUD operations	C/R/U/D
Key columns used	AND, B, BODY_PART_CODE, BODY_SIDE_CODE, C, CLAIM_ID, CL_WORKER_INJURED_BODY_PART, D, F, I
Sequence	N/A
Related tables	CL_WORKER_INJURED_BODY_PART
Business objects	Criteria

SQL referencing this table

• SQL-008
• SQL-027
• SQL-047
• SQL-038

---

Table relationship diagram

The following diagram shows the relationships identified in this library's SQL.

erDiagram

Related documentation

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

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

• Business\SAIF.Business.Claim\cls1502Transfer.vb
• Business\SAIF.Business.Claim\clsClaimWorkReleaseStatus.vb
• Business\SAIF.Business.Claim\clsClaimWorkStatus.vb
• Business\SAIF.Business.Claim\clsClaimEmployeeWorkAddress.vb
• Business\SAIF.Business.Claim\clsWorkerInjuredBodyPart.vb
• Business\SAIF.Business.Claim\clsPPDBodyParts.vb
• Business\SAIF.Business.Claim\clsPPDScheduledDegreeAwards.vb
• Business\SAIF.Business.Claim\clsPPDUnscheduledDegreeAwards.vb
• Business\SAIF.Business.Claim\clsVocationalServicesTypes.vb
• Business\SAIF.Business.Claim\clsActiveBenefitSchedule.vb
• Business\SAIF.Business.Claim\clsAggRightDates.vb
• Business\SAIF.Business.Claim\clsAwardBenefitPayment.vb
• Business\SAIF.Business.Claim\clsAwardBenefitPaymentCollection.vb
• Business\SAIF.Business.Claim\clsBenefitSchedule.vb
• Business\SAIF.Business.Claim\clsFederalAwardStatusCollection.vb
• Business\SAIF.Business.Claim\clsFederalBenefitSchedule.vb
• Business\SAIF.Business.Claim\clsITimelinessOfFirstPayment.vb
• Business\SAIF.Business.Claim\clsMedicallyStationaryDate.vb
• Business\SAIF.Business.Claim\clsSetAwardPaymentPending.vb
• Business\SAIF.Business.Claim\clsStatutoryWeeklyWageCalculation.vb
• Business\SAIF.Business.Claim\clsWorkerInjuredBodyPartCollection.vb
• Business\SAIF.Business.Claim\clsFederalAwardStatus.vb
• Business\SAIF.Business.Claim\SAIF.BOF.Business.Claim.vbproj