---
title: SAIF.Business.Claim.Entry SQL catalog
summary: Index of SQL statements used by SAIF.Business.Claim.Entry.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-28
library: SAIF.Business.Claim.Entry
reference_type: package
---

# SAIF.Business.Claim.Entry SQL catalog

This page indexes SQL statements and stored-procedure calls used by `SAIF.Business.Claim.Entry`.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-005](SQL-005.md) | Inline create used by CriteriaBase | Inline | CL_CLAIM_POLICY_HISTORY | `CriteriaBase` |
| [SQL-006](SQL-006.md) | Inline create used by CriteriaBase | Inline | CL_CLAIM_MCO_ELIGIBILITY | `CriteriaBase` |
| [SQL-007](SQL-007.md) | Inline create used by CriteriaBase | Inline | CL_CLAIM_REQUEST_DECISION | `CriteriaBase` |
| [SQL-008](SQL-008.md) | Inline create used by CriteriaBase | Inline | CL_CLAIM_STATUS_ACTIVITY | `CriteriaBase` |
| [SQL-009](SQL-009.md) | Inline create used by CriteriaBase | Inline | CL_CLAIM_TYPE_ACTIVITY | `CriteriaBase` |
| [SQL-010](SQL-010.md) | Inline create used by CriteriaBase | Inline | CL_INJURY_CLAIM | `CriteriaBase` |
| [SQL-011](SQL-011.md) | StoredProc create used by cls801Document | StoredProc | CL_801_DOCUMENT | `cls801Document` |
| [SQL-012](SQL-012.md) | StoredProc create used by cls801Submission | StoredProc | CL_801_SUBMISSION | `cls801Submission` |
| [SQL-013](SQL-013.md) | StoredProc create used by cls801SubmissionData | StoredProc | CL_801_SUBMISSION_DATA | `cls801SubmissionData` |
| [SQL-014](SQL-014.md) | Inline create used by clsPharmacyEligibilityReport | Inline | CL_PHARMACY_ELIGIBILITY_REPORT | `clsPharmacyEligibilityReport` |
| [SQL-015](SQL-015.md) | Inline create used by clsStateClaimEntry | Inline | CL_MULT_EMPLOYER_LETTER_REQ | `clsStateClaimEntry` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-016](SQL-016.md) | Inline read used by CriteriaBase | Inline | CL_INJURY_CLAIM | `CriteriaBase` |
| [SQL-017](SQL-017.md) | Inline read used by CriteriaBase | Inline | CL_INJURY_CLAIM | `CriteriaBase` |
| [SQL-018](SQL-018.md) | StoredProc read used by cls801SubmissionData | StoredProc | CL_801_SUBMISSION_DATA | `cls801SubmissionData` |
| [SQL-019](SQL-019.md) | Inline read used by clsStateClaimEntry | Inline | ZIP_MCO_COUNTY | `clsStateClaimEntry` |
| [SQL-020](SQL-020.md) | StoredProc read used by clsSubmissionResult | StoredProc | — | `clsSubmissionResult` |
| [SQL-021](SQL-021.md) | StoredProc read used by clsSubmissionResult | StoredProc | — | `clsSubmissionResult` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-022](SQL-022.md) | Inline update used by CriteriaBase | Inline | CL_INJURY_CLAIM | `CriteriaBase` |
| [SQL-023](SQL-023.md) | StoredProc update used by cls801Document | StoredProc | CL_801_DOCUMENT | `cls801Document` |
| [SQL-024](SQL-024.md) | StoredProc update used by cls801Submission | StoredProc | CL_801_SUBMISSION | `cls801Submission` |
| [SQL-025](SQL-025.md) | StoredProc update used by cls801SubmissionData | StoredProc | CL_801_SUBMISSION_DATA | `cls801SubmissionData` |
| [SQL-026](SQL-026.md) | Inline update used by clsPharmacyEligibilityReport | Inline | CL_PHARMACY_ELIGIBILITY_REPORT | `clsPharmacyEligibilityReport` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-027](SQL-027.md) | Inline delete used by CriteriaBase | Inline | — | `CriteriaBase` |
| [SQL-028](SQL-028.md) | StoredProc delete used by cls801Submission | StoredProc | CL_801_SUBMISSION | `cls801Submission` |
| [SQL-029](SQL-029.md) | StoredProc delete used by cls801SubmissionData | StoredProc | CL_801_SUBMISSION_DATA | `cls801SubmissionData` |

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001.md) | `SELECT CLAIM_ID_SEQ.NEXTVAL FROM DUAL` sequence used by CriteriaBase | `SELECT CLAIM_ID_SEQ.NEXTVAL FROM DUAL` | DUAL | `CriteriaBase` |
| [SQL-002](SQL-002.md) | `SELECT SAIF_CLAIM_NUM_SEQ.NEXTVAL FROM DUAL` sequence used by CriteriaBase | `SELECT SAIF_CLAIM_NUM_SEQ.NEXTVAL FROM DUAL` | DUAL | `CriteriaBase` |
| [SQL-003](SQL-003.md) | `select cl_801_Document_seq.nextval from dual` sequence used by cls801Document | `select cl_801_Document_seq.nextval from dual` | DUAL | `cls801Document` |
| [SQL-004](SQL-004.md) | `select cl_801_submission_seq.nextval from dual` sequence used by cls801Submission | `select cl_801_submission_seq.nextval from dual` | DUAL | `cls801Submission` |

## Other operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-030](SQL-030.md) | Inline other used by cls801Submission | Inline | — | `cls801Submission` |

## 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.Entry\Online801\Submission\cls801Document.vb`
- `Business\SAIF.Business.Claim.Entry\Online801\Submission\cls801Submission.vb`
- `Business\SAIF.Business.Claim.Entry\Online801\Submission\cls801SubmissionData.vb`
- `Business\SAIF.Business.Claim.Entry\clsClaimEntry.vb`
- `Business\SAIF.Business.Claim.Entry\clsPharmacyEligibility.vb`
- `Business\SAIF.Business.Claim.Entry\clsStateClaimEntry.vb`