---
title: SAIF.Business.Claim database tables
summary: Database tables used by SAIF.Business.Claim.
status: draft
owner: Technical Writer
last_reviewed: 2026-07-28
library: SAIF.Business.Claim
reference_type: package
---

# 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](#claim_work_rel_status_seq_num) | Oracle | [unqualified]** | R | Supports Criteria data access. | `Criteria` |
| [CLAIM_WORK_STATUS_SEQ](#claim_work_status_seq) | Oracle | [unqualified]** | R | Supports Criteria data access. | `Criteria` |
| [CLM_DBA.CL_1502_DCBS_TRANSFER](#clm_dbacl_1502_dcbs_transfer) | Oracle | CLM_DBA | U | Supports Criteria data access. | `Criteria` |
| [CL_1502_DCBS_TRANSFER](#cl_1502_dcbs_transfer) | Oracle | [unqualified]** | C/D | Supports Criteria data access. | `Criteria` |
| [CL_1502_DCBS_TRANSFER_SEQ](#cl_1502_dcbs_transfer_seq) | Oracle | [unqualified]** | R | Supports Criteria data access. | `Criteria` |
| [CL_AWARD](#cl_award) | Oracle | [unqualified]** | R/U | Supports Criteria data access. | `Criteria` |
| [CL_BENEFIT_PAYMENT](#cl_benefit_payment) | Oracle | [unqualified]** | R/U/D | Supports Criteria data access. | `Criteria` |
| [CL_BENEFIT_SCHEDULE](#cl_benefit_schedule) | Oracle | [unqualified]** | R/U/D | Supports Criteria data access. | `Criteria` |
| [CL_CLAIM_EMPLOYEE_WORK_ADDRESS](#cl_claim_employee_work_address) | Oracle | [unqualified]** | C/R/U/D | Supports Criteria data access. | `Criteria` |
| [CL_CLAIM_WORK_RELEASE_STATUS](#cl_claim_work_release_status) | Oracle | [unqualified]** | C/R/U/D | Supports Criteria data access. | `Criteria` |
| [CL_CLAIM_WORK_STATUS](#cl_claim_work_status) | Oracle | [unqualified]** | C/R/U/D | Supports Criteria data access. | `Criteria` |
| [CL_FEDERAL_AWARD](#cl_federal_award) | Oracle | [unqualified]** | R/U | Supports Criteria data access. | `Criteria` |
| [CL_PPD_BODY_PART_CODE](#cl_ppd_body_part_code) | Oracle | [unqualified]** | R | Supports clsPPDBodyParts data access. | `clsPPDBodyParts` |
| [CL_PPD_SCHED_DEGREE_AWARD](#cl_ppd_sched_degree_award) | Oracle | [unqualified]** | R | Supports clsPPDScheduledDegreeAwards data access. | `clsPPDScheduledDegreeAwards` |
| [CL_PPD_UNSCHED_DEGREE_AWARD](#cl_ppd_unsched_degree_award) | Oracle | [unqualified]** | R | Supports clsPPDUnscheduledDegreeAwards data access. | `clsPPDUnscheduledDegreeAwards` |
| [CL_RESERVE_VOC_SERV_TYPE_CODE](#cl_reserve_voc_serv_type_code) | Oracle | [unqualified]** | R | Supports clsVocationalServiceTypes data access. | `clsVocationalServiceTypes` |
| [CL_WORKER_INJURED_BODY_PART](#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](sql/SQL-028-saif-business-claim.md)

---

## 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/SQL-004-saif-business-claim.md)
- [SQL-028](sql/SQL-028-saif-business-claim.md)
- [SQL-039](sql/SQL-039-saif-business-claim.md)

---

## 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/SQL-025-saif-business-claim.md)
- [SQL-037](sql/SQL-037-saif-business-claim.md)

---

## 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/SQL-015-saif-business-claim.md)
- [SQL-016](sql/SQL-016-saif-business-claim.md)
- [SQL-030](sql/SQL-030-saif-business-claim.md)
- [SQL-041](sql/SQL-041-saif-business-claim.md)

---

## 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/SQL-013-saif-business-claim.md)
- [SQL-017](sql/SQL-017-saif-business-claim.md)
- [SQL-022](sql/SQL-022-saif-business-claim.md)
- [SQL-029](sql/SQL-029-saif-business-claim.md)
- [SQL-031](sql/SQL-031-saif-business-claim.md)
- [SQL-036](sql/SQL-036-saif-business-claim.md)
- [SQL-040](sql/SQL-040-saif-business-claim.md)
- [SQL-042](sql/SQL-042-saif-business-claim.md)
- [SQL-046](sql/SQL-046-saif-business-claim.md)

---

## 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/SQL-005-saif-business-claim.md)
- [SQL-018](sql/SQL-018-saif-business-claim.md)
- [SQL-032](sql/SQL-032-saif-business-claim.md)
- [SQL-043](sql/SQL-043-saif-business-claim.md)

---

## 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/SQL-006-saif-business-claim.md)
- [SQL-019](sql/SQL-019-saif-business-claim.md)
- [SQL-033](sql/SQL-033-saif-business-claim.md)
- [SQL-044](sql/SQL-044-saif-business-claim.md)

---

## 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/SQL-007-saif-business-claim.md)
- [SQL-020](sql/SQL-020-saif-business-claim.md)
- [SQL-034](sql/SQL-034-saif-business-claim.md)
- [SQL-045](sql/SQL-045-saif-business-claim.md)

---

## 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/SQL-021-saif-business-claim.md)
- [SQL-035](sql/SQL-035-saif-business-claim.md)

---

## 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](sql/SQL-009-saif-business-claim.md)

---

## 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](sql/SQL-010-saif-business-claim.md)

---

## 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](sql/SQL-011-saif-business-claim.md)

---

## 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](sql/SQL-012-saif-business-claim.md)

---

## 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/SQL-008-saif-business-claim.md)
- [SQL-027](sql/SQL-027-saif-business-claim.md)
- [SQL-047](sql/SQL-047-saif-business-claim.md)
- [SQL-038](sql/SQL-038-saif-business-claim.md)

---

## Table relationship diagram

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

```mermaid
erDiagram
```

## Related documentation
- [Index](index.md)
- [Overview](overview.md)
- [Architecture](architecture.md)
- [Dependencies](dependencies.md)
- [Operations and processes](operations-processes.md)
- [Business rules](business-rules.md)
- [SQL catalog](sql/index.md)
- [Procedures](procedures/index.md)
- [API reference](api/index.md)

> **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`