---
title: SAIF.Business.Claim SQL catalog
summary: SQL catalog for SAIF.Business.Claim.
status: draft
owner: Technical Writer
last_reviewed: 2026-07-28
library: SAIF.Business.Claim
reference_type: package
---

# SAIF.Business.Claim SQL catalog

This page indexes the SQL statements used by `SAIF.Business.Claim`.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-004](SQL-004-saif-business-claim.md) | Inline create used by Criteria | Inline | CL_1502_DCBS_TRANSFER | `Criteria` |
| [SQL-005](SQL-005-saif-business-claim.md) | Inline create used by Criteria | Inline | CL_CLAIM_EMPLOYEE_WORK_ADDRESS | `Criteria` |
| [SQL-006](SQL-006-saif-business-claim.md) | Inline create used by Criteria | Inline | CL_CLAIM_WORK_RELEASE_STATUS | `Criteria` |
| [SQL-007](SQL-007-saif-business-claim.md) | Inline create used by Criteria | Inline | CL_CLAIM_WORK_STATUS | `Criteria` |
| [SQL-008](SQL-008-saif-business-claim.md) | Inline create used by Criteria | Inline | CL_WORKER_INJURED_BODY_PART | `Criteria` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-009](SQL-009-saif-business-claim.md) | Inline read used by clsPPDBodyParts | Inline | CL_PPD_BODY_PART_CODE | `clsPPDBodyParts` |
| [SQL-010](SQL-010-saif-business-claim.md) | StringBuilder read used by clsPPDScheduledDegreeAwards | StringBuilder | CL_PPD_SCHED_DEGREE_AWARD | `clsPPDScheduledDegreeAwards` |
| [SQL-011](SQL-011-saif-business-claim.md) | StringBuilder read used by clsPPDUnscheduledDegreeAwards | StringBuilder | CL_PPD_UNSCHED_DEGREE_AWARD | `clsPPDUnscheduledDegreeAwards` |
| [SQL-012](SQL-012-saif-business-claim.md) | Inline read used by clsVocationalServiceTypes | Inline | CL_RESERVE_VOC_SERV_TYPE_CODE | `clsVocationalServiceTypes` |
| [SQL-013](SQL-013-saif-business-claim.md) | Inline read used by Criteria | Inline | CL_BENEFIT_SCHEDULE | `Criteria` |
| [SQL-014](SQL-014-saif-business-claim.md) | sp82046_CalcAggRightDates | StoredProc | N/A | `Criteria` |
| [SQL-015](SQL-015-saif-business-claim.md) | Inline read used by Criteria | Inline | CL_BENEFIT_PAYMENT | `Criteria` |
| [SQL-016](SQL-016-saif-business-claim.md) | Inline read used by Criteria | Inline | CL_BENEFIT_PAYMENT | `Criteria` |
| [SQL-017](SQL-017-saif-business-claim.md) | Inline read used by Criteria | Inline | CL_BENEFIT_SCHEDULE | `Criteria` |
| [SQL-018](SQL-018-saif-business-claim.md) | Inline read used by Criteria | Inline | CL_CLAIM_EMPLOYEE_WORK_ADDRESS | `Criteria` |
| [SQL-019](SQL-019-saif-business-claim.md) | Inline read used by Criteria | Inline | CL_CLAIM_WORK_RELEASE_STATUS | `Criteria` |
| [SQL-020](SQL-020-saif-business-claim.md) | Inline read used by Criteria | Inline | CL_CLAIM_WORK_STATUS | `Criteria` |
| [SQL-021](SQL-021-saif-business-claim.md) | Inline read used by Criteria | Inline | CL_FEDERAL_AWARD | `Criteria` |
| [SQL-022](SQL-022-saif-business-claim.md) | Inline read used by Criteria | Inline | CL_BENEFIT_SCHEDULE | `Criteria` |
| [SQL-023](SQL-023-saif-business-claim.md) | sp82067_TimelinessOf1stPayment | StoredProc | N/A | `Criteria` |
| [SQL-024](SQL-024-saif-business-claim.md) | sp82289_medicallystationarydt | StoredProc | N/A | `Criteria` |
| [SQL-025](SQL-025-saif-business-claim.md) | Inline read used by Criteria | Inline | CL_AWARD | `Criteria` |
| [SQL-026](SQL-026-saif-business-claim.md) | sp82286_statutoryweeklywage | StoredProc | N/A | `Criteria` |
| [SQL-027](SQL-027-saif-business-claim.md) | Inline read used by Criteria | Inline | CL_WORKER_INJURED_BODY_PART | `Criteria` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-028](SQL-028-saif-business-claim.md) | Inline update used by Criteria | Inline | CLM_DBA.CL_1502_DCBS_TRANSFER | `Criteria` |
| [SQL-029](SQL-029-saif-business-claim.md) | Inline update used by Criteria | Inline | CL_BENEFIT_SCHEDULE | `Criteria` |
| [SQL-030](SQL-030-saif-business-claim.md) | Inline update used by Criteria | Inline | CL_BENEFIT_PAYMENT | `Criteria` |
| [SQL-031](SQL-031-saif-business-claim.md) | Inline update used by Criteria | Inline | CL_BENEFIT_SCHEDULE | `Criteria` |
| [SQL-032](SQL-032-saif-business-claim.md) | Inline update used by Criteria | Inline | CL_CLAIM_EMPLOYEE_WORK_ADDRESS | `Criteria` |
| [SQL-033](SQL-033-saif-business-claim.md) | Inline update used by Criteria | Inline | CL_CLAIM_WORK_RELEASE_STATUS | `Criteria` |
| [SQL-034](SQL-034-saif-business-claim.md) | Inline update used by Criteria | Inline | CL_CLAIM_WORK_STATUS | `Criteria` |
| [SQL-035](SQL-035-saif-business-claim.md) | Inline update used by Criteria | Inline | CL_FEDERAL_AWARD | `Criteria` |
| [SQL-036](SQL-036-saif-business-claim.md) | Inline update used by Criteria | Inline | CL_BENEFIT_SCHEDULE | `Criteria` |
| [SQL-037](SQL-037-saif-business-claim.md) | Inline update used by Criteria | Inline | CL_AWARD | `Criteria` |
| [SQL-038](SQL-038-saif-business-claim.md) | Inline update used by Criteria | Inline | CL_WORKER_INJURED_BODY_PART | `Criteria` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-039](SQL-039-saif-business-claim.md) | Inline delete used by Criteria | Inline | CL_1502_DCBS_TRANSFER | `Criteria` |
| [SQL-040](SQL-040-saif-business-claim.md) | Inline delete used by Criteria | Inline | CL_BENEFIT_SCHEDULE | `Criteria` |
| [SQL-041](SQL-041-saif-business-claim.md) | Inline delete used by Criteria | Inline | CL_BENEFIT_PAYMENT | `Criteria` |
| [SQL-042](SQL-042-saif-business-claim.md) | Inline delete used by Criteria | Inline | CL_BENEFIT_SCHEDULE | `Criteria` |
| [SQL-043](SQL-043-saif-business-claim.md) | Inline delete used by Criteria | Inline | CL_CLAIM_EMPLOYEE_WORK_ADDRESS | `Criteria` |
| [SQL-044](SQL-044-saif-business-claim.md) | Inline delete used by Criteria | Inline | CL_CLAIM_WORK_RELEASE_STATUS | `Criteria` |
| [SQL-045](SQL-045-saif-business-claim.md) | Inline delete used by Criteria | Inline | CL_CLAIM_WORK_STATUS | `Criteria` |
| [SQL-046](SQL-046-saif-business-claim.md) | Inline delete used by Criteria | Inline | CL_BENEFIT_SCHEDULE | `Criteria` |
| [SQL-047](SQL-047-saif-business-claim.md) | Inline delete used by Criteria | Inline | CL_WORKER_INJURED_BODY_PART | `Criteria` |

## Sequence operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-saif-business-claim.md) | Inline sequence used by Criteria | Inline | N/A | `Criteria` |
| [SQL-002](SQL-002-saif-business-claim.md) | Inline sequence used by Criteria | Inline | N/A | `Criteria` |
| [SQL-003](SQL-003-saif-business-claim.md) | Inline sequence used by Criteria | Inline | N/A | `Criteria` |

## 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)
- [Database tables](../database-tables.md)
- [Procedures](../procedures/index.md)
- [API reference](../api/index.md)

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