--- title: SAIF.Business.Claim.Entry database tables summary: Database tables 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 database tables This page catalogs database tables accessed by `SAIF.Business.Claim.Entry`. ## Table catalog | Table | Database | Schema/Link | CRUD | Purpose | Primary business object | | --- | --- | --- | --- | --- | --- | | [CL_801_DOCUMENT](#cl_801_document) | Oracle | `[unqualified]`** | CU | Used by cls801Document for persisted claim workflows. | `cls801Document` | | [CL_801_SUBMISSION](#cl_801_submission) | Oracle | `[unqualified]`** | CDU | Used by cls801Submission for persisted claim workflows. | `cls801Submission` | | [CL_801_SUBMISSION_DATA](#cl_801_submission_data) | Oracle | `[unqualified]`** | CDRU | Used by cls801SubmissionData for persisted claim workflows. | `cls801SubmissionData` | | [CL_CLAIM_MCO_ELIGIBILITY](#cl_claim_mco_eligibility) | Oracle | `[unqualified]`** | C | Used by CriteriaBase for persisted claim workflows. | `CriteriaBase` | | [CL_CLAIM_POLICY_HISTORY](#cl_claim_policy_history) | Oracle | `[unqualified]`** | C | Used by CriteriaBase for persisted claim workflows. | `CriteriaBase` | | [CL_CLAIM_REQUEST_DECISION](#cl_claim_request_decision) | Oracle | `[unqualified]`** | C | Used by CriteriaBase for persisted claim workflows. | `CriteriaBase` | | [CL_CLAIM_STATUS_ACTIVITY](#cl_claim_status_activity) | Oracle | `[unqualified]`** | C | Used by CriteriaBase for persisted claim workflows. | `CriteriaBase` | | [CL_CLAIM_TYPE_ACTIVITY](#cl_claim_type_activity) | Oracle | `[unqualified]`** | C | Used by CriteriaBase for persisted claim workflows. | `CriteriaBase` | | [CL_INJURY_CLAIM](#cl_injury_claim) | Oracle | `[unqualified]`** | CRU | Used by CriteriaBase for persisted claim workflows. | `CriteriaBase` | | [CL_MULT_EMPLOYER_LETTER_REQ](#cl_mult_employer_letter_req) | Oracle | `[unqualified]`** | C | Used by clsStateClaimEntry for persisted claim workflows. | `clsStateClaimEntry` | | [CL_PHARMACY_ELIGIBILITY_REPORT](#cl_pharmacy_eligibility_report) | Oracle | `[unqualified]`** | CU | Used by clsPharmacyEligibilityReport for persisted claim workflows. | `clsPharmacyEligibilityReport` | | [DUAL](#dual) | Oracle | `[unqualified]`** | S | Used by CriteriaBase, cls801Document, cls801Submission for persisted claim workflows. | `CriteriaBase, cls801Document, cls801Submission` | | [ZIP_MCO_COUNTY](#zip_mco_county) | Oracle | `[unqualified]`** | R | Used by clsStateClaimEntry for persisted claim workflows. | `clsStateClaimEntry` | ## CL_801_DOCUMENT | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `cls801Document` within the SAIF.Business.Claim.Entry workflow. | | Access pattern | Stored procedure | | CRUD operations | CU | | Key columns used | Not enumerated directly in the stage findings for every statement.** | | Sequence | N/A | | Related tables | None identified | | Business objects | `cls801Document` | ### Operations referencing this table - [cls801Document BeforeInsert](operations/801-document-management.md) - [cls801Document BeforeUpdate](operations/801-document-management.md) ### SQL referencing this table - [SQL-011: PK82538_ONLINE_801_CLAIM.Document_insert](sql/SQL-011.md) - [SQL-023: PK82538_ONLINE_801_CLAIM.Document_update](sql/SQL-023.md) --- ## CL_801_SUBMISSION | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `cls801Submission` within the SAIF.Business.Claim.Entry workflow. | | Access pattern | Stored procedure | | CRUD operations | CDU | | Key columns used | Not enumerated directly in the stage findings for every statement.** | | Sequence | N/A | | Related tables | None identified | | Business objects | `cls801Submission` | ### Operations referencing this table - [cls801Submission BeforeInsert](operations/801-submission-crud.md) - [cls801Submission BeforeUpdate](operations/801-submission-crud.md) - [cls801Submission BeforeDelete](operations/801-submission-crud.md) ### SQL referencing this table - [SQL-012: PK82538_ONLINE_801_CLAIM.submission_insert](sql/SQL-012.md) - [SQL-024: PK82538_ONLINE_801_CLAIM.submission_update](sql/SQL-024.md) - [SQL-028: PK82538_ONLINE_801_CLAIM.submission_delete](sql/SQL-028.md) --- ## CL_801_SUBMISSION_DATA | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `cls801SubmissionData` within the SAIF.Business.Claim.Entry workflow. | | Access pattern | Stored procedure | | CRUD operations | CDRU | | Key columns used | Not enumerated directly in the stage findings for every statement.** | | Sequence | N/A | | Related tables | None identified | | Business objects | `cls801SubmissionData` | ### Operations referencing this table - [cls801SubmissionData BeforeInsert](operations/801-submission-data-crud.md) - [cls801SubmissionData BeforeRetrieve](operations/801-submission-data-crud.md) - [cls801SubmissionData BeforeUpdate](operations/801-submission-data-crud.md) - [cls801SubmissionData BeforeDelete](operations/801-submission-data-crud.md) ### SQL referencing this table - [SQL-013: pk82538_online_801_claim.submission_data_insert](sql/SQL-013.md) - [SQL-018: pk82538_online_801_claim.submission_data_select](sql/SQL-018.md) - [SQL-025: pk82538_online_801_claim.submission_data_update](sql/SQL-025.md) - [SQL-029: pk82538_online_801_claim.submission_data_delete](sql/SQL-029.md) --- ## CL_CLAIM_MCO_ELIGIBILITY | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `CriteriaBase` within the SAIF.Business.Claim.Entry workflow. | | Access pattern | Direct SQL | | CRUD operations | C | | Key columns used | Not enumerated directly in the stage findings for every statement.** | | Sequence | N/A | | Related tables | None identified | | Business objects | `CriteriaBase` | ### Operations referencing this table - [CriteriaBase AddNewStatusData](operations/insert-claim.md) ### SQL referencing this table - [SQL-006: INSERT INTO CL_CLAIM_MCO_ELIGIBILITY (CLAIM_ID, MCO_ID, UPDATE_DATE, UPDATE_USER…](sql/SQL-006.md) --- ## CL_CLAIM_POLICY_HISTORY | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `CriteriaBase` within the SAIF.Business.Claim.Entry workflow. | | Access pattern | Direct SQL | | CRUD operations | C | | Key columns used | Not enumerated directly in the stage findings for every statement.** | | Sequence | N/A | | Related tables | None identified | | Business objects | `CriteriaBase` | ### Operations referencing this table - [CriteriaBase AddNewStatusData](operations/insert-claim.md) ### SQL referencing this table - [SQL-005: INSERT INTO CL_CLAIM_POLICY_HISTORY (CLAIM_ID, POLICY_NUM, POLICY_SUB_CODE, UPDA…](sql/SQL-005.md) --- ## CL_CLAIM_REQUEST_DECISION | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `CriteriaBase` within the SAIF.Business.Claim.Entry workflow. | | Access pattern | Direct SQL | | CRUD operations | C | | Key columns used | Not enumerated directly in the stage findings for every statement.** | | Sequence | N/A | | Related tables | None identified | | Business objects | `CriteriaBase` | ### Operations referencing this table - [CriteriaBase AddNewStatusData](operations/insert-claim.md) ### SQL referencing this table - [SQL-007: INSERT INTO CL_CLAIM_REQUEST_DECISION (CLAIM_ID, PRIMARY_KEY_SEQ_NUM, REQUEST_DA…](sql/SQL-007.md) --- ## CL_CLAIM_STATUS_ACTIVITY | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `CriteriaBase` within the SAIF.Business.Claim.Entry workflow. | | Access pattern | Direct SQL | | CRUD operations | C | | Key columns used | Not enumerated directly in the stage findings for every statement.** | | Sequence | N/A | | Related tables | None identified | | Business objects | `CriteriaBase` | ### Operations referencing this table - [CriteriaBase AddNewStatusData](operations/insert-claim.md) ### SQL referencing this table - [SQL-008: INSERT INTO CL_CLAIM_STATUS_ACTIVITY (CLAIM_ID, CLAIM_STATUS_CODE, CLAIM_STATUS_…](sql/SQL-008.md) --- ## CL_CLAIM_TYPE_ACTIVITY | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `CriteriaBase` within the SAIF.Business.Claim.Entry workflow. | | Access pattern | Direct SQL | | CRUD operations | C | | Key columns used | Not enumerated directly in the stage findings for every statement.** | | Sequence | N/A | | Related tables | None identified | | Business objects | `CriteriaBase` | ### Operations referencing this table - [CriteriaBase AddNewStatusData](operations/insert-claim.md) ### SQL referencing this table - [SQL-009: INSERT INTO CL_CLAIM_TYPE_ACTIVITY (CLAIM_ID, CLAIM_TYPE_CODE, CLAIM_TYPE_ACTIVI…](sql/SQL-009.md) --- ## CL_INJURY_CLAIM | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `CriteriaBase` within the SAIF.Business.Claim.Entry workflow. | | Access pattern | Direct SQL | | CRUD operations | CRU | | Key columns used | Not enumerated directly in the stage findings for every statement.** | | Sequence | N/A | | Related tables | None identified | | Business objects | `CriteriaBase` | ### Operations referencing this table - [CriteriaBase BeforeInsert](operations/insert-claim.md) - [CriteriaBase CheckForMultipleClaimsForWorker](operations/check-multiple-claims.md) - [CriteriaBase BeforeRetrieve](operations/update-claim.md) - [CriteriaBase BeforeUpdate](operations/update-claim.md) ### SQL referencing this table - [SQL-010: Insert into CL_INJURY_CLAIM ( ACTIVE_CLAIM_FLAG, AGE_DOI_YEARS, AWARD_AUTO_RECAL…](sql/SQL-010.md) - [SQL-016: SELECT SAIF_CLAIM_NUM FROM CL_INJURY_CLAIM clm WHERE clm.WORKER_ID = :WorkerID A…](sql/SQL-016.md) - [SQL-017: Select AGE_DOI_YEARS as AgeDoiYears, CITY_NAME as CityName, CLAIM_ID as ClaimID,…](sql/SQL-017.md) - [SQL-022: Update CL_INJURY_CLAIM Set ACTIVE_CLAIM_FLAG = :ActiveClaimFlag, AGE_DOI_YEARS =…](sql/SQL-022.md) --- ## CL_MULT_EMPLOYER_LETTER_REQ | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `clsStateClaimEntry` within the SAIF.Business.Claim.Entry workflow. | | Access pattern | Direct SQL | | CRUD operations | C | | Key columns used | Not enumerated directly in the stage findings for every statement.** | | Sequence | N/A | | Related tables | None identified | | Business objects | `clsStateClaimEntry` | ### Operations referencing this table - [clsStateClaimEntry AddNewStatusData](operations/state-insert-extensions.md) ### SQL referencing this table - [SQL-015: INSERT INTO CL_MULT_EMPLOYER_LETTER_REQ ( SAIF_CLAIM_NUM, UPDATE_NUM, UPDATE_DAT…](sql/SQL-015.md) --- ## CL_PHARMACY_ELIGIBILITY_REPORT | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `clsPharmacyEligibilityReport` within the SAIF.Business.Claim.Entry workflow. | | Access pattern | Direct SQL | | CRUD operations | CU | | Key columns used | Not enumerated directly in the stage findings for every statement.** | | Sequence | N/A | | Related tables | None identified | | Business objects | `clsPharmacyEligibilityReport` | ### Operations referencing this table - [clsPharmacyEligibilityReport BeforeInsert](operations/pharmacy-eligibility-crud.md) - [clsPharmacyEligibilityReport BeforeUpdate](operations/pharmacy-eligibility-crud.md) ### SQL referencing this table - [SQL-014: INSERT INTO CL_PHARMACY_ELIGIBILITY_REPORT (CLAIM_ID, ELIGIBILITY_STATUS_CODE, E…](sql/SQL-014.md) - [SQL-026: Update CL_PHARMACY_ELIGIBILITY_REPORT Set ELIGIBILITY_STATUS_CODE = :Eligibility…](sql/SQL-026.md) --- ## DUAL | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `CriteriaBase, cls801Document, cls801Submission` within the SAIF.Business.Claim.Entry workflow. | | Access pattern | Direct SQL | | CRUD operations | S | | Key columns used | Not enumerated directly in the stage findings for every statement.** | | Sequence | CL_801_SUBMISSION_SEQ | | Related tables | None identified | | Business objects | `CriteriaBase, cls801Document, cls801Submission` | ### Operations referencing this table - [CriteriaBase identity/sequence generation](operations/create-new-claim.md) - [cls801Document identity/sequence generation](operations/801-document-management.md) - [cls801Submission identity/sequence generation](operations/801-submission-crud.md) ### SQL referencing this table - [SQL-001: SELECT CLAIM_ID_SEQ.NEXTVAL FROM DUAL](sql/SQL-001.md) - [SQL-002: SELECT SAIF_CLAIM_NUM_SEQ.NEXTVAL FROM DUAL](sql/SQL-002.md) - [SQL-003: select cl_801_Document_seq.nextval from dual](sql/SQL-003.md) - [SQL-004: select cl_801_submission_seq.nextval from dual](sql/SQL-004.md) --- ## ZIP_MCO_COUNTY | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `clsStateClaimEntry` within the SAIF.Business.Claim.Entry workflow. | | Access pattern | Direct SQL | | CRUD operations | R | | Key columns used | Not enumerated directly in the stage findings for every statement.** | | Sequence | N/A | | Related tables | None identified | | Business objects | `clsStateClaimEntry` | ### Operations referencing this table - [clsStateClaimEntry DetermineCountyCode](operations/state-insert-extensions.md) ### SQL referencing this table - [SQL-019: SELECT unique(county_code) FROM ZIP_MCO_COUNTY WHERE ZIP_CODE = :ZipCode](sql/SQL-019.md) ## Table relationship diagram No cross-table relationships were identified in this library's SQL. ## 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 `**` could not be confirmed; treat them as unknown until verified. ## 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`