---
title: SAIF.Business.View.Claim database tables
summary: Database tables used by this library with relationships and usage context.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-28
library: SAIF.Business.View.Claim
reference_type: package
---

# SAIF.Business.View.Claim database tables

This page catalogs database tables accessed by this library.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [CL_CLAIM_COST_CATEGORY_CODE](#cl-claim-cost-category-code) | Oracle | [unqualified]** | R | Stores claim cost category reference codes. | `Criteria` |
| [CL_CLAIM_RESPONSIBILITY](#cl-claim-responsibility) | Oracle | [unqualified]** | R | Stores claim responsibility assignments and related routing metadata. | `Criteria` |
| [cl_claim_support_order](#cl-claim-support-order) | Oracle | [unqualified]** | R | Stores support-order rows used to determine whether a worker has active support orders. | `clsClaimData` |
| [CL_CLOSURE_LOCATION_TYPE_CODE](#cl-closure-location-type-code) | Oracle | [unqualified]** | R | Stores closure-location type reference codes. | `Criteria` |
| [CL_CLOSURE_TYPE_OF_ORDER_CODE](#cl-closure-type-of-order-code) | Oracle | [unqualified]** | R | Stores closure order-type reference codes. | `Criteria` |
| [cl_cond_compensability_decisn](#cl-cond-compensability-decisn) | Oracle | [unqualified]** | R | Stores medical-condition compensability decision history. | `Criteria` |
| [CL_MCO_STATUS_REASON_CODE](#cl-mco-status-reason-code) | Oracle | [unqualified]** | R | Stores MCO status reason lookup values. | `Criteria` |
| [cl_medical_condition](#cl-medical-condition) | Oracle | [unqualified]** | R | Stores claim medical-condition records. | `Criteria` |
| [CL_ORDER_TYPE_CODE](#cl-order-type-code) | Oracle | [unqualified]** | R | Stores claim order-type reference codes. | `Criteria` |
| [CL_PRISON_CODE](#cl-prison-code) | Oracle | [unqualified]** | R | Stores prison address and display metadata for claim-related prison lookups. | `Criteria` |
| [CL_WORK_RELEASE_CODE](#cl-work-release-code) | Oracle | [unqualified]** | R | Stores work-release reference codes. | `Criteria` |
| [CL_WORK_STATUS_CODE](#cl-work-status-code) | Oracle | [unqualified]** | R | Stores work-status reference codes. | `Criteria` |
| [CLAIM_ACTIVITY_CAT_TYPE_CODE](#claim-activity-cat-type-code) | Oracle | [unqualified]** | R | Stores claim activity category-to-type mappings. | `Criteria` |
| [CLAIM_ACTIVITY_TYPE_CODE](#claim-activity-type-code) | Oracle | [unqualified]** | R | Stores claim activity type descriptions. | `Criteria` |
| [claim_decision_code](#claim-decision-code) | Oracle | [unqualified]** | R | Stores claim decision descriptions. | `Criteria` |
| [claim_denial_final_reas_cd](#claim-denial-final-reas-cd) | Oracle | [unqualified]** | R | Stores final denial reason descriptions. | `Criteria` |
| [claim_denial_reason_code](#claim-denial-reason-code) | Oracle | [unqualified]** | R | Stores denial reason descriptions. | `Criteria` |
| [claim_denial_status_code](#claim-denial-status-code) | Oracle | [unqualified]** | R | Stores denial status descriptions. | `Criteria` |
| [CLAIM_SUPERVISOR](#claim-supervisor) | Oracle | [unqualified]** | R | Stores supervisor metadata joined to claim responsibility records. | `Criteria` |
| [condition_type_code](#condition-type-code) | Oracle | [unqualified]** | R | Stores medical-condition type descriptions. | `Criteria` |
| [MCO_PLAN](#mco-plan) | Oracle | [unqualified]** | R | Stores managed care organization plan descriptions resolved from claim data. | `clsClaimData` |
| [VOCATIONAL_RESP_CODE](#vocational-resp-code) | Oracle | [unqualified]** | R | Stores vocational responsibility user lookups. | `Criteria` |

## CL_CLAIM_COST_CATEGORY_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores claim cost category reference codes. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | None identified |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Reference code retrieval](operations/reference-code-retrieval.md)

### SQL referencing this table
- [SQL-012](sql/SQL-012.md)

---

## CL_CLAIM_RESPONSIBILITY

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores claim responsibility assignments and related routing metadata. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | `CLAIM_SUPERVISOR` |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Claim responsibility retrieval](operations/claim-responsibility-retrieval.md)

### SQL referencing this table
- [SQL-013](sql/SQL-013.md)

---

## cl_claim_support_order

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores support-order rows used to determine whether a worker has active support orders. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | None identified |
| **Business objects** | `clsClaimData`, `may` |

### Operations referencing this table
- [Claim summary and detail retrieval](operations/claim-summary-and-detail-retrieval.md)

### Business rules referencing this table
- [BR-002](business-rules.md#br-002-active-support-orders-exclude-terminated-rows)

### SQL referencing this table
- [SQL-001](sql/SQL-001.md)
- [SQL-030](sql/SQL-030.md)

---

## CL_CLOSURE_LOCATION_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores closure-location type reference codes. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | None identified |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Reference code retrieval](operations/reference-code-retrieval.md)

### SQL referencing this table
- [SQL-014](sql/SQL-014.md)
- [SQL-015](sql/SQL-015.md)

---

## CL_CLOSURE_TYPE_OF_ORDER_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores closure order-type reference codes. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | None identified |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Reference code retrieval](operations/reference-code-retrieval.md)

### SQL referencing this table
- [SQL-016](sql/SQL-016.md)
- [SQL-017](sql/SQL-017.md)

---

## cl_cond_compensability_decisn

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores medical-condition compensability decision history. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | `cl_medical_condition`, `claim_decision_code`, `claim_denial_final_reas_cd`, `claim_denial_reason_code`, `claim_denial_status_code` |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Medical condition retrieval](operations/medical-condition-retrieval.md)

### Business rules referencing this table
- [BR-004](business-rules.md#br-004-medical-condition-detail-uses-the-latest-compensability-decision)

### SQL referencing this table
- [SQL-022](sql/SQL-022.md)

---

## CL_MCO_STATUS_REASON_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores MCO status reason lookup values. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | None identified |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Reference code retrieval](operations/reference-code-retrieval.md)

### SQL referencing this table
- [SQL-018](sql/SQL-018.md)
- [SQL-019](sql/SQL-019.md)

---

## cl_medical_condition

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores claim medical-condition records. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | `cl_cond_compensability_decisn`, `condition_type_code` |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Medical condition retrieval](operations/medical-condition-retrieval.md)

### Business rules referencing this table
- [BR-004](business-rules.md#br-004-medical-condition-detail-uses-the-latest-compensability-decision)

### SQL referencing this table
- [SQL-022](sql/SQL-022.md)

---

## CL_ORDER_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores claim order-type reference codes. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | None identified |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Reference code retrieval](operations/reference-code-retrieval.md)

### SQL referencing this table
- [SQL-020](sql/SQL-020.md)
- [SQL-021](sql/SQL-021.md)

---

## CL_PRISON_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores prison address and display metadata for claim-related prison lookups. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | None identified |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Prison code retrieval](operations/prison-code-retrieval.md)

### Business rules referencing this table
- [BR-003](business-rules.md#br-003-prison-lookup-prepends-a-synthetic-blank-choice)

### SQL referencing this table
- [SQL-010](sql/SQL-010.md)
- [SQL-011](sql/SQL-011.md)

---

## CL_WORK_RELEASE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores work-release reference codes. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | None identified |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Reference code retrieval](operations/reference-code-retrieval.md)

### SQL referencing this table
- [SQL-025](sql/SQL-025.md)
- [SQL-026](sql/SQL-026.md)

---

## CL_WORK_STATUS_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores work-status reference codes. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | None identified |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Reference code retrieval](operations/reference-code-retrieval.md)

### SQL referencing this table
- [SQL-023](sql/SQL-023.md)
- [SQL-024](sql/SQL-024.md)

---

## CLAIM_ACTIVITY_CAT_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores claim activity category-to-type mappings. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | `CLAIM_ACTIVITY_TYPE_CODE` |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Reference code retrieval](operations/reference-code-retrieval.md)

### SQL referencing this table
- [SQL-028](sql/SQL-028.md)

---

## CLAIM_ACTIVITY_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores claim activity type descriptions. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | `CLAIM_ACTIVITY_CAT_TYPE_CODE` |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Reference code retrieval](operations/reference-code-retrieval.md)

### SQL referencing this table
- [SQL-028](sql/SQL-028.md)

---

## claim_decision_code

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores claim decision descriptions. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | `cl_cond_compensability_decisn` |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Medical condition retrieval](operations/medical-condition-retrieval.md)

### SQL referencing this table
- [SQL-022](sql/SQL-022.md)

---

## claim_denial_final_reas_cd

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores final denial reason descriptions. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | `cl_cond_compensability_decisn` |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Medical condition retrieval](operations/medical-condition-retrieval.md)

### SQL referencing this table
- [SQL-022](sql/SQL-022.md)

---

## claim_denial_reason_code

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores denial reason descriptions. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | `cl_cond_compensability_decisn` |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Medical condition retrieval](operations/medical-condition-retrieval.md)

### SQL referencing this table
- [SQL-022](sql/SQL-022.md)

---

## claim_denial_status_code

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores denial status descriptions. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | `cl_cond_compensability_decisn` |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Medical condition retrieval](operations/medical-condition-retrieval.md)

### SQL referencing this table
- [SQL-022](sql/SQL-022.md)

---

## CLAIM_SUPERVISOR

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores supervisor metadata joined to claim responsibility records. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | `CL_CLAIM_RESPONSIBILITY` |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Claim responsibility retrieval](operations/claim-responsibility-retrieval.md)

### SQL referencing this table
- [SQL-013](sql/SQL-013.md)

---

## condition_type_code

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores medical-condition type descriptions. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | `cl_medical_condition` |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Medical condition retrieval](operations/medical-condition-retrieval.md)

### SQL referencing this table
- [SQL-022](sql/SQL-022.md)

---

## MCO_PLAN

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores managed care organization plan descriptions resolved from claim data. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | None identified |
| **Business objects** | `clsClaimData`, `may` |

### Operations referencing this table
- [Claim summary and detail retrieval](operations/claim-summary-and-detail-retrieval.md)

### SQL referencing this table
- [SQL-002](sql/SQL-002.md)
- [SQL-031](sql/SQL-031.md)

---

## VOCATIONAL_RESP_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores vocational responsibility user lookups. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Derived from inline SQL where visible; see linked SQL pages for column-level detail.* |
| **Sequence** | N/A |
| **Related tables** | None identified |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Reference code retrieval](operations/reference-code-retrieval.md)

### SQL referencing this table
- [SQL-027](sql/SQL-027.md)

---
## Table relationship diagram

The following diagram shows the cross-table relationships explicitly visible in this library's SQL.

```mermaid
erDiagram
    cl_medical_condition ||--o{ cl_cond_compensability_decisn : "claim_id + medical_condition_id"
    cl_medical_condition }o--|| condition_type_code : "condition_type_code"
    cl_cond_compensability_decisn }o--|| claim_decision_code : "decision code"
    cl_cond_compensability_decisn }o--|| claim_denial_final_reas_cd : "final denial reason"
    cl_cond_compensability_decisn }o--|| claim_denial_reason_code : "denial reason"
    cl_cond_compensability_decisn }o--|| claim_denial_status_code : "denial status"
    CL_CLAIM_RESPONSIBILITY }o--|| CLAIM_SUPERVISOR : "claim_supervisor_code"
    CLAIM_ACTIVITY_CAT_TYPE_CODE }o--|| CLAIM_ACTIVITY_TYPE_CODE : "type_code"
```

## 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 or contextual evidence.
> Statements marked with `**` could not be confirmed; treat as unknown until verified.

## Sources
- `Business\SAIF.Business.View.Claim\clsClaimActivityTypeCodeCollection.vb`
- `Business\SAIF.Business.View.Claim\clsClaimCostCategoryCodeCollection.vb`
- `Business\SAIF.Business.View.Claim\clsClaimData.vb`
- `Business\SAIF.Business.View.Claim\clsClaimResponsibilityData.vb`
- `Business\SAIF.Business.View.Claim\clsClosureLocationTypeCode.vb`
- `Business\SAIF.Business.View.Claim\clsClosureLocationTypeCodeCollection.vb`
- `Business\SAIF.Business.View.Claim\clsClosureTypeOfOrderCodeCollection.vb`
- `Business\SAIF.Business.View.Claim\clsClosureTypeofOrderCode.vb`
- `Business\SAIF.Business.View.Claim\clsMcoStatusReasonCode.vb`
- `Business\SAIF.Business.View.Claim\clsMcoStatusReasonCodeTable.vb`
- `Business\SAIF.Business.View.Claim\clsMedicalConditionData.vb`
- `Business\SAIF.Business.View.Claim\clsOrderTypeCode.vb`
- `Business\SAIF.Business.View.Claim\clsOrderTypeCodeCollection.vb`
- `Business\SAIF.Business.View.Claim\clsPrisonCode.vb`
- `Business\SAIF.Business.View.Claim\clsPrisonCodeCollection.vb`
- `Business\SAIF.Business.View.Claim\clsVocResponsibilityData.vb`
- `Business\SAIF.Business.View.Claim\clsWorkReleaseCode.vb`
- `Business\SAIF.Business.View.Claim\clsWorkReleaseCodeTable.vb`
- `Business\SAIF.Business.View.Claim\clsWorkStatusCode.vb`
- `Business\SAIF.Business.View.Claim\clsWorkStatusCodeTable.vb`