SAIF.Business.Claim database tables

This page catalogs database tables accessed by this library. All tables are Oracle; schema qualification could not be resolved from any *.config file in the repository (see per-table Schema/Link notes).**

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
CL_1502_DCBS_TRANSFER	Oracle	[unqualified]** (UPDATE only: CLM_DBA)	C, R, U, D	DCBS 1502 transfer file lifecycle	cls1502Transfer
CL_AWARD	Oracle	[unqualified]**	R, U	Award status and pending processing	clsSetAwardPaymentPending
CL_BENEFIT_PAYMENT	Oracle	[unqualified]**	R, U, D	Benefit payment rows for schedules and awards	clsAwardBenefitPayment
CL_BENEFIT_SCHEDULE	Oracle	[unqualified]**	R, U, D	Active/federal benefit schedule rows	clsActiveBenefitSchedule
CL_CLAIM_EMPLOYEE_WORK_ADDRESS	Oracle	[unqualified]**	C, R, U, D	Employee work address for a claim	clsClaimEmployeeWorkAddress
CL_CLAIM_WORK_RELEASE_STATUS	Oracle	[unqualified]**	C, R, U, D	Work-release status history	clsClaimWorkReleaseStatus
CL_CLAIM_WORK_STATUS	Oracle	[unqualified]**	C, R, U, D	Return-to-work status history	clsClaimWorkStatus
CL_FEDERAL_AWARD	Oracle	[unqualified]**	R, U	Federal award status	clsFederalAwardStatus
CL_INJURY_CLAIM	Oracle	[unqualified]**	R (join), U	Claim-level injury record; primary body-part propagation target	clsWorkerInjuredBodyPart
CL_PPD_BODY_PART_CODE	Oracle	[unqualified]**	R	PPD body-part reference code table	clsPPDBodyParts
CL_PPD_SCHED_DEGREE_AWARD	Oracle	[unqualified]**	R	PPD scheduled degree-award amounts	clsPPDScheduledDegreeAwards
CL_PPD_UNSCHED_DEGREE_AWARD	Oracle	[unqualified]**	R	PPD unscheduled degree-award bands	clsPPDUnscheduledDegreeAwards
CL_RESERVE_MED_SERV_TYPE_CODE	Oracle	[unqualified]**	R	Medical reserve service-type reference codes	clsServiceTypeCollection
CL_RESERVE_MED_SERV_DESCR_CODE	Oracle	[unqualified]**	R	Medical reserve service description codes	clsServiceTypeCollection
CL_RESERVE_VOC_SERV_COST_CODE	Oracle	[unqualified]**	R	Vocational reserve service-cost reference codes	clsServiceTypeCollection
CL_RESERVE_VOC_SERV_DESCR_CODE	Oracle	[unqualified]**	R	Vocational reserve service description codes	clsServiceTypeCollection
CL_RESERVE_VOC_SERV_TYPE_CODE	Oracle	[unqualified]**	R	Vocational reserve service-type reference codes	clsVocationalServiceTypes
CL_WORKER_INJURED_BODY_PART	Oracle	[unqualified]**	C, R, U, D	Injured body-part rows for a claim	clsWorkerInjuredBodyPart

DUAL is excluded as an Oracle pseudo-table (used only by the three sequence reads, SQL-001/002/003).

CL_1502_DCBS_TRANSFER

Field	Value
Database	Oracle
Schema/Link	[unqualified]** on INSERT/DELETE/SELECT; CLM_DBA on UPDATE only — an inconsistency flagged for follow-up.*
Purpose	Stores DCBS 1502 transfer file records queued for transfer and their processed status.
Access pattern	Direct SQL (criteria pattern plus two literal SELECT helper functions)
CRUD operations	Create, Read, Update, Delete
Key columns used	FILE_ID, CLAIM_ID, PROCESSED_DATE, FILE_NAME
Sequence	CL_1502_DCBS_TRANSFER_SEQ
Related tables	CL_INJURY_CLAIM (inferred, by CLAIM_ID)
Business objects	cls1502Transfer, cls1502TransferList

Operations referencing this table

• DCBS 1502 transfer handling

Business rules referencing this table

• BR-001: 1502 transfer claim ID required
• BR-002: 1502 transfer filing reason required

SQL referencing this table

• SQL-001: Get next 1502 transfer sequence value
• SQL-004: Insert a new 1502 DCBS transfer record
• SQL-009: Retrieve unprocessed 1502 transfers for a claim
• SQL-010: Retrieve all unprocessed 1502 transfers
• SQL-037: Update a 1502 DCBS transfer as processed
• SQL-052: Delete a 1502 DCBS transfer record

---

CL_AWARD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores award records and their status, including the Pending lifecycle.
Access pattern	Direct SQL (criteria pattern)
CRUD operations	Read, Update
Key columns used	CLAIM_ID, SAIF_AWARD_NUM, AWARD_STATUS_CODE
Sequence	N/A
Related tables	CL_BENEFIT_PAYMENT (inferred, shared CLAIM_ID/SAIF_AWARD_NUM), CL_FEDERAL_AWARD
Business objects	clsSetAwardPaymentPending

Operations referencing this table

• Set award to Pending

Business rules referencing this table

• BR-011: Award must be successfully updated to pending

SQL referencing this table

• SQL-031: Retrieve an active award for pending processing
• SQL-048: Set an award status to Pending

---

CL_BENEFIT_PAYMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores individual benefit payment rows linked to benefit schedules and awards.
Access pattern	Direct SQL (criteria pattern and auxiliary criteria-class SQL properties)
CRUD operations	Read, Update, Delete
Key columns used	CLAIM_ID, BENEFIT_PAYMENT_SEQ_NUM, SAIF_AWARD_NUM, BENEFIT_STATUS_CODE, BENEFIT_TYPE_CODE
Sequence	N/A
Related tables	CL_BENEFIT_SCHEDULE (inferred, identical key pair), CL_AWARD, CL_FEDERAL_AWARD
Business objects	clsAwardBenefitPayment, clsAwardBenefitPaymentCollection, clsActiveBenefitSchedule, clsSetAwardPaymentPending

Operations referencing this table

• Benefit-payment stop processing
• Set award to Pending

Business rules referencing this table

• BR-009: Benefit schedule update must affect a row
• BR-010: Benefit payment delete must affect a row
• BR-011: Award must be successfully updated to pending
• BR-012: Optimistic concurrency contention check

SQL referencing this table

• SQL-012: Retrieve the benefit payment for an active schedule
• SQL-014: Retrieve an in-progress award benefit payment
• SQL-015: Retrieve award benefit payments by benefit type
• SQL-032: Retrieve benefit payments for an award
• SQL-039: Update remaining payment count on a benefit payment
• SQL-040: Update an award benefit payment issue date
• SQL-049: Move an award's benefit payment to In Progress
• SQL-054: Delete a benefit payment (stop processing)
• SQL-055: Delete an award benefit payment

---

CL_BENEFIT_SCHEDULE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores benefit-schedule rows tracking remaining payments and next issue dates.
Access pattern	Direct SQL (criteria pattern)
CRUD operations	Read, Update, Delete
Key columns used	CLAIM_ID, BENEFIT_PAYMENT_SEQ_NUM, NEXT_ISSUE_DATE, REMAINING_PAYMENT_COUNT
Sequence	N/A
Related tables	CL_BENEFIT_PAYMENT (inferred, identical key pair)
Business objects	clsActiveBenefitSchedule, clsFederalBenefitSchedule

Operations referencing this table

• Benefit-payment stop processing

Business rules referencing this table

• BR-012: Optimistic concurrency contention check

SQL referencing this table

• SQL-011: Retrieve an active benefit schedule row
• SQL-024: Retrieve a federal benefit schedule row
• SQL-038: Update an active benefit schedule
• SQL-047: Update a federal benefit schedule
• SQL-053: Delete an active benefit schedule
• SQL-061: Delete a federal benefit schedule

---

CL_CLAIM_EMPLOYEE_WORK_ADDRESS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores an injured employee's work address for a claim.
Access pattern	Direct SQL (criteria pattern)
CRUD operations	Create, Read, Update, Delete
Key columns used	CLAIM_ID, ADDRESS_LINE_1_TEXT, CITY_NAME, STATE_CODE, ZIP_CODE, COUNTY_CODE
Sequence	N/A
Related tables	CL_INJURY_CLAIM (inferred, one-to-one by CLAIM_ID)
Business objects	clsClaimEmployeeWorkAddress

Business rules referencing this table

• BR-012: Optimistic concurrency contention check

SQL referencing this table

• SQL-005: Insert a new claim employee work address
• SQL-018: Retrieve a claim employee work address
• SQL-043: Update a claim employee work address
• SQL-058: Delete a claim employee work address

---

CL_CLAIM_WORK_RELEASE_STATUS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores work-release status history for a claim.
Access pattern	Direct SQL (criteria pattern)
CRUD operations	Create, Read, Update, Delete
Key columns used	CLAIM_ID, CLAIM_WORK_REL_STATUS_SEQ_NUM, WORK_RELEASE_STATUS_CODE, EFFECTIVE_DATE
Sequence	CLAIM_WORK_REL_STATUS_SEQ_NUM
Related tables	CL_INJURY_CLAIM (inferred, by CLAIM_ID)
Business objects	clsClaimWorkReleaseStatus

Business rules referencing this table

• BR-004: Work release date must be valid at level two
• BR-005: Work release status data must be present

SQL referencing this table

• SQL-002: Get next claim work-release-status sequence value
• SQL-006: Insert a new claim work-release-status record
• SQL-020: Retrieve the latest claim work-release-status row
• SQL-044: Update a claim work-release-status row
• SQL-059: Delete a claim work-release-status row

---

CL_CLAIM_WORK_STATUS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores return-to-work status history for a claim.
Access pattern	Direct SQL (criteria pattern)
CRUD operations	Create, Read, Update, Delete
Key columns used	CLAIM_ID, CLAIM_WORK_STATUS_SEQ_NUM, WORK_STATUS_CODE, EFFECTIVE_DATE
Sequence	CLAIM_WORK_STATUS_SEQ
Related tables	CL_INJURY_CLAIM (inferred, by CLAIM_ID)
Business objects	clsClaimWorkStatus

Business rules referencing this table

• BR-003: Work status date cannot be in the future

SQL referencing this table

• SQL-003: Get next claim work-status sequence value
• SQL-007: Insert a new claim work-status record
• SQL-021: Retrieve the latest claim work-status row
• SQL-045: Update a claim work-status row
• SQL-060: Delete a claim work-status row

---

CL_FEDERAL_AWARD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores federal award records and their status.
Access pattern	Direct SQL (criteria pattern)
CRUD operations	Read, Update
Key columns used	CLAIM_ID, SAIF_AWARD_NUM, AWARD_STATUS_CODE
Sequence	N/A
Related tables	CL_INJURY_CLAIM (verified join), CL_BENEFIT_PAYMENT (inferred)
Business objects	clsFederalAwardStatus, clsFederalAwardStatusCollection

SQL referencing this table

• SQL-022: Retrieve federal awards by claim and status
• SQL-023: Retrieve federal awards by worker and status
• SQL-046: Update a federal award status

---

CL_INJURY_CLAIM

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Claim-level injury record; parent of most claim-scoped child tables in this library and the propagation target for the primary injured body part.
Access pattern	Direct SQL (legacy comma-join in one retrieve; criteria pattern for the update)
CRUD operations	Read (join), Update
Key columns used	CLAIM_ID, WORKER_ID, BODY_PART_CODE, BODY_PART_SIDE_CODE
Sequence	N/A
Related tables	CL_FEDERAL_AWARD (verified join), CL_WORKER_INJURED_BODY_PART, CL_CLAIM_WORK_STATUS, CL_CLAIM_WORK_RELEASE_STATUS, CL_CLAIM_EMPLOYEE_WORK_ADDRESS, CL_1502_DCBS_TRANSFER (all inferred, by CLAIM_ID)
Business objects	clsFederalAwardStatusCollection, clsWorkerInjuredBodyPart

Operations referencing this table

• Injured body-part maintenance

SQL referencing this table

• SQL-023: Retrieve federal awards by worker and status
• SQL-051: Propagate the primary body part to the injury claim

---

CL_PPD_BODY_PART_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Reference code table of PPD body parts, cached by mdlPPD.
Access pattern	Direct SQL (SqlHelper.ResultSetQuery, outside the criteria pattern)
CRUD operations	Read
Key columns used	* (full code table)
Sequence	N/A
Related tables	—
Business objects	clsPPDBodyParts

Operations referencing this table

• Code-table caching

SQL referencing this table

• SQL-026: Retrieve PPD body-part code table

---

CL_PPD_SCHED_DEGREE_AWARD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Effective-dated scheduled PPD degree-award amounts.
Access pattern	Direct SQL (SqlHelper.ResultSetQuery)
CRUD operations	Read
Key columns used	EFFECTIVE_DATE, AWARD_PER_DEGREE_AMT
Sequence	N/A
Related tables	—
Business objects	clsPPDScheduledDegreeAwards

Operations referencing this table

• PPD award calculation

SQL referencing this table

• SQL-027: Retrieve PPD scheduled degree-award table

---

CL_PPD_UNSCHED_DEGREE_AWARD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Effective-dated, banded PPD unscheduled degree-award amounts.
Access pattern	Direct SQL (SqlHelper.ResultSetQuery)
CRUD operations	Read
Key columns used	DEGREE_UPPER_RANGE_NUM, AWARD_PER_DEGREE_AMT, EFFECTIVE_DATE
Sequence	N/A
Related tables	—
Business objects	clsPPDUnscheduledDegreeAwards

Operations referencing this table

• PPD award calculation

SQL referencing this table

• SQL-028: Retrieve PPD unscheduled degree-award bands

---

CL_RESERVE_MED_SERV_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Medical reserve service-type reference codes.
Access pattern	Direct SQL (StringBuilder-assembled, criteria constructor)
CRUD operations	Read
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	CL_RESERVE_MED_SERV_DESCR_CODE (verified outer join)
Business objects	clsServiceTypeCollection

SQL referencing this table

• SQL-029: Retrieve medical reserve service types

---

CL_RESERVE_MED_SERV_DESCR_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Medical reserve service description codes joined to service types.
Access pattern	Direct SQL (StringBuilder-assembled, criteria constructor)
CRUD operations	Read
Key columns used	RESERVE_MED_SERV_TYPE_CODE, CODE, CODE_DESCR
Sequence	N/A
Related tables	CL_RESERVE_MED_SERV_TYPE_CODE (verified outer join)
Business objects	clsServiceTypeCollection

SQL referencing this table

• SQL-029: Retrieve medical reserve service types

---

CL_RESERVE_VOC_SERV_COST_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Vocational reserve service-cost reference codes.
Access pattern	Direct SQL (StringBuilder-assembled, criteria constructor)
CRUD operations	Read
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	CL_RESERVE_VOC_SERV_DESCR_CODE (verified outer join)
Business objects	clsServiceTypeCollection

SQL referencing this table

• SQL-030: Retrieve vocational reserve service types

---

CL_RESERVE_VOC_SERV_DESCR_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Vocational reserve service description codes joined to cost codes.
Access pattern	Direct SQL (StringBuilder-assembled, criteria constructor)
CRUD operations	Read
Key columns used	RESERVE_VOC_SERV_COST_CODE, CODE, CODE_DESCR
Sequence	N/A
Related tables	CL_RESERVE_VOC_SERV_COST_CODE (verified outer join)
Business objects	clsServiceTypeCollection

SQL referencing this table

• SQL-030: Retrieve vocational reserve service types

---

CL_RESERVE_VOC_SERV_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Vocational reserve service-type reference codes, cached by mdlReserveServices.
Access pattern	Direct SQL (SqlHelper.ResultSetQuery)
CRUD operations	Read
Key columns used	* (full code table)
Sequence	N/A
Related tables	—
Business objects	clsVocationalServiceTypes

Operations referencing this table

• Code-table caching

SQL referencing this table

• SQL-035: Retrieve vocational service type code table

---

CL_WORKER_INJURED_BODY_PART

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores injured body-part rows for a claim, including the primary-body-part indicator.
Access pattern	Direct SQL (criteria pattern; Create/Retrieve return empty string in clsWorkerInjuredBodyPart.Criteria*)
CRUD operations	Create, Read, Update, Delete
Key columns used	CLAIM_ID, BODY_PART_CODE, BODY_PART_SIDE_CODE, PRIMARY_BODY_PART_IND, INJURY_NATURE_CODE
Sequence	N/A
Related tables	CL_INJURY_CLAIM (inferred, by CLAIM_ID)
Business objects	clsWorkerInjuredBodyPart, clsWorkerInjuredBodyPartCollection

Operations referencing this table

• Injured body-part maintenance

Business rules referencing this table

• BR-006: Primary body part is required
• BR-007: Only one primary body part is allowed
• BR-012: Optimistic concurrency contention check

SQL referencing this table

• SQL-008: Insert a new injured body-part record
• SQL-036: Retrieve injured body parts for a claim
• SQL-050: Update an injured body-part record
• SQL-062: Delete an injured body-part record

---

Table relationship diagram

The following diagram shows relationships between tables used by this library.

erDiagram
    CL_AWARD ||--o{ CL_BENEFIT_PAYMENT : "CLAIM_ID, SAIF_AWARD_NUM (inferred)"
    CL_FEDERAL_AWARD ||--o{ CL_BENEFIT_PAYMENT : "CLAIM_ID, SAIF_AWARD_NUM (inferred)"
    CL_FEDERAL_AWARD ||--o{ CL_INJURY_CLAIM : "CLAIM_ID (verified join)"
    CL_BENEFIT_SCHEDULE ||--o{ CL_BENEFIT_PAYMENT : "CLAIM_ID, BENEFIT_PAYMENT_SEQ_NUM (inferred)"
    CL_INJURY_CLAIM ||--o{ CL_WORKER_INJURED_BODY_PART : "CLAIM_ID (inferred)"
    CL_INJURY_CLAIM ||--o{ CL_CLAIM_WORK_STATUS : "CLAIM_ID (inferred)"
    CL_INJURY_CLAIM ||--o{ CL_CLAIM_WORK_RELEASE_STATUS : "CLAIM_ID (inferred)"
    CL_INJURY_CLAIM ||--|| CL_CLAIM_EMPLOYEE_WORK_ADDRESS : "CLAIM_ID (inferred)"
    CL_INJURY_CLAIM ||--o{ CL_1502_DCBS_TRANSFER : "CLAIM_ID (inferred)"
    CL_RESERVE_MED_SERV_TYPE_CODE ||--o{ CL_RESERVE_MED_SERV_DESCR_CODE : "RESERVE_MED_SERV_TYPE_CODE = CODE (verified)"
    CL_RESERVE_VOC_SERV_COST_CODE ||--o{ CL_RESERVE_VOC_SERV_DESCR_CODE : "RESERVE_VOC_SERV_COST_CODE = CODE (verified)"

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

• SAIF.Business.Claim/cls1502Transfer.vb
• SAIF.Business.Claim/clsActiveBenefitSchedule.vb
• SAIF.Business.Claim/clsAwardBenefitPayment.vb
• SAIF.Business.Claim/clsAwardBenefitPaymentCollection.vb
• SAIF.Business.Claim/clsClaimEmployeeWorkAddress.vb
• SAIF.Business.Claim/clsClaimWorkReleaseStatus.vb
• SAIF.Business.Claim/clsClaimWorkStatus.vb
• SAIF.Business.Claim/clsFederalAwardStatus.vb
• SAIF.Business.Claim/clsFederalAwardStatusCollection.vb
• SAIF.Business.Claim/clsPPDBodyParts.vb
• SAIF.Business.Claim/clsPPDScheduledDegreeAwards.vb
• SAIF.Business.Claim/clsPPDUnscheduledDegreeAwards.vb
• SAIF.Business.Claim/clsServiceTypeCollection.vb
• SAIF.Business.Claim/clsSetAwardPaymentPending.vb
• SAIF.Business.Claim/clsVocationalServicesTypes.vb
• SAIF.Business.Claim/clsWorkerInjuredBodyPart.vb
• SAIF.Business.Claim/clsWorkerInjuredBodyPartCollection.vb