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

# SAIF.Business.Claim.Bill database tables

This page catalogs the Oracle tables used by `SAIF.Business.Claim.Bill`.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [CBP_AUDIT](#cbp_audit) | Oracle | [unqualified]** | C/U | Supports Criteria data access. | `Criteria` |
| [CBP_AUDITED_SERVICE](#cbp_audited_service) | Oracle | [unqualified]** | C/U | Supports Criteria data access. | `Criteria` |
| [CBP_AUDITED_SERVICE_ADJUSTMENT](#cbp_audited_service_adjustment) | Oracle | [unqualified]** | C/U | Supports Criteria data access. | `Criteria` |
| [CBP_AUDIT_ADJUSTMENT_TYPE](#cbp_audit_adjustment_type) | Oracle | [unqualified]** | R | Supports AdjustmentTypeList data access. | `AdjustmentTypeList` |
| [CBP_AUDIT_ADJUST_CAT_CODE](#cbp_audit_adjust_cat_code) | Oracle | [unqualified]** | R | Supports AdjustmentCategoryList data access. | `AdjustmentCategoryList` |
| [CBP_AUDIT_MESSAGE](#cbp_audit_message) | Oracle | [unqualified]** | C/U | Supports Criteria data access. | `Criteria` |
| [CBP_AUD_REVENUE_EXCP](#cbp_aud_revenue_excp) | Oracle | [unqualified]** | R | Supports RevenueExceptionsList data access. | `RevenueExceptionsList` |
| [CBP_BILL](#cbp_bill) | Oracle | [unqualified]** | C/U | Supports BillCriteria data access. | `BillCriteria` |
| [CBP_BILL_DIAGNOSIS](#cbp_bill_diagnosis) | Oracle | [unqualified]** | C/U | Supports Criteria data access. | `Criteria` |
| [CBP_BILL_PAYMENT_REQUEST](#cbp_bill_payment_request) | Oracle | [unqualified]** | C/R/U | Supports Criteria data access. | `Criteria` |
| [CBP_BILL_PROCEDURE](#cbp_bill_procedure) | Oracle | [unqualified]** | C/R/U | Supports Criteria data access. | `Criteria` |
| [CBP_BILL_SERVICE](#cbp_bill_service) | Oracle | [unqualified]** | C/U | Supports Criteria data access. | `Criteria` |
| [CBP_BILL_STATUS](#cbp_bill_status) | Oracle | [unqualified]** | C/U | Supports Criteria data access. | `Criteria` |
| [CBP_DCBS_CONVERSION_FACTOR](#cbp_dcbs_conversion_factor) | Oracle | [unqualified]** | R | Supports DCBSConversionFactorList data access. | `DCBSConversionFactorList` |
| [CBP_DIAGNOSIS](#cbp_diagnosis) | Oracle | [unqualified]** | R | Supports DiagnosisCodes data access. | `DiagnosisCodes` |
| [CBP_DIAGNOSIS_CATEGORY_CODE](#cbp_diagnosis_category_code) | Oracle | [unqualified]** | R | Supports DiagnosisCategories data access. | `DiagnosisCategories` |
| [CBP_NATIONAL_DRUG_PRICE](#cbp_national_drug_price) | Oracle | [unqualified]** | R | Supports clsNationalDrug data access. | `clsNationalDrug` |
| [CBP_PHARMACY_ALLOWANCE](#cbp_pharmacy_allowance) | Oracle | [unqualified]** | R | Supports PharmacyAllowanceList data access. | `PharmacyAllowanceList` |
| [CBP_PROCEDURE_CODE](#cbp_procedure_code) | Oracle | [unqualified]** | R | Supports ProcedureCodes data access. | `ProcedureCodes` |
| [CBP_SERVICE_CATEGORY_CODE](#cbp_service_category_code) | Oracle | [unqualified]** | R | Supports clsServiceCategoryList data access. | `clsServiceCategoryList` |
| [CBP_SERVICE_LOCATION_CODE](#cbp_service_location_code) | Oracle | [unqualified]** | R | Supports clsServiceLocationList data access. | `clsServiceLocationList` |
| [CBP_SERVICE_MODIFIER_CODE](#cbp_service_modifier_code) | Oracle | [unqualified]** | R | Supports clsServiceModifierList data access. | `clsServiceModifierList` |
| [CBP_SERVICE_SUBCAT_CODE](#cbp_service_subcat_code) | Oracle | [unqualified]** | R | Supports clsServiceSubCategoryList data access. | `clsServiceSubCategoryList` |
| [CL_CLAIM_MCO_ELIGIBILITY](#cl_claim_mco_eligibility) | Oracle | [unqualified]** | R | Supports clsClaimMCO data access. | `clsClaimMCO` |
| [MCO_TYPE_ADMIN_FEE](#mco_type_admin_fee) | Oracle | [unqualified]** | R | Supports clsMCOProviderTypeAdminFeeList data access. | `clsMCOProviderTypeAdminFeeList` |

## CBP_AUDIT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/U/D |
| **Key columns used** | A, ALLOWED_AMT, AND, ASW, AUDIT_ADJUSTMENT_AMT, AUDIT_ADJUSTMENT_CODE, AUDIT_LINE_NUM, AUDIT_RECEIPT_DATE, AUDIT_SEQ_NUM, B |
| **Sequence** | N/A |
| **Related tables** | CBP_AUDIT, CBP_AUDITED_SERVICE, CBP_AUDITED_SERVICE_ADJUSTMENT, CBP_AUDIT_ADJUSTMENT_TYPE, CBP_AUDIT_ADJUST_CAT_CODE, CBP_AUDIT_MESSAGE |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-003](sql/SQL-003-saif-business-claim-bill.md)
- [SQL-004](sql/SQL-004-saif-business-claim-bill.md)
- [SQL-005](sql/SQL-005-saif-business-claim-bill.md)
- [SQL-006](sql/SQL-006-saif-business-claim-bill.md)
- [SQL-011](sql/SQL-011-saif-business-claim-bill.md)
- [SQL-013](sql/SQL-013-saif-business-claim-bill.md)
- [SQL-032](sql/SQL-032-saif-business-claim-bill.md)
- [SQL-033](sql/SQL-033-saif-business-claim-bill.md)
- [SQL-034](sql/SQL-034-saif-business-claim-bill.md)
- [SQL-035](sql/SQL-035-saif-business-claim-bill.md)
- [SQL-042](sql/SQL-042-saif-business-claim-bill.md)

---

## CBP_AUDITED_SERVICE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/U/D |
| **Key columns used** | A, ALLOWED_AMT, AND, ASW, AUDIT_ADJUSTMENT_AMT, AUDIT_ADJUSTMENT_CODE, AUDIT_LINE_NUM, AUDIT_SEQ_NUM, B, BILL_ID |
| **Sequence** | N/A |
| **Related tables** | CBP_AUDITED_SERVICE, CBP_AUDITED_SERVICE_ADJUSTMENT |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-004](sql/SQL-004-saif-business-claim-bill.md)
- [SQL-005](sql/SQL-005-saif-business-claim-bill.md)
- [SQL-033](sql/SQL-033-saif-business-claim-bill.md)
- [SQL-034](sql/SQL-034-saif-business-claim-bill.md)
- [SQL-043](sql/SQL-043-saif-business-claim-bill.md)

---

## CBP_AUDITED_SERVICE_ADJUSTMENT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/U/D |
| **Key columns used** | A, AND, AUDIT_ADJUSTMENT_AMT, AUDIT_ADJUSTMENT_CODE, AUDIT_SEQ_NUM, B, BILL_ID, C, CBP_AUDITED_SERVICE_ADJUSTMENT, D |
| **Sequence** | N/A |
| **Related tables** | CBP_AUDITED_SERVICE_ADJUSTMENT |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-005](sql/SQL-005-saif-business-claim-bill.md)
- [SQL-034](sql/SQL-034-saif-business-claim-bill.md)
- [SQL-044](sql/SQL-044-saif-business-claim-bill.md)

---

## CBP_AUDIT_ADJUSTMENT_TYPE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `AdjustmentTypeList` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | _ |
| **Sequence** | N/A |
| **Related tables** | CBP_AUDIT_ADJUSTMENT_TYPE |
| **Business objects** | `AdjustmentTypeList` |

### SQL referencing this table
- [SQL-013](sql/SQL-013-saif-business-claim-bill.md)

---

## CBP_AUDIT_ADJUST_CAT_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `AdjustmentCategoryList` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | _ |
| **Sequence** | N/A |
| **Related tables** | CBP_AUDIT_ADJUST_CAT_CODE |
| **Business objects** | `AdjustmentCategoryList` |

### SQL referencing this table
- [SQL-011](sql/SQL-011-saif-business-claim-bill.md)

---

## CBP_AUDIT_MESSAGE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/U/D |
| **Key columns used** | AND, B, BILL_ID, C, CBP_AUDIT_MESSAGE, CBP_AUDIT_MESSAGE_SEQ_NUM, D, I, ID, M |
| **Sequence** | N/A |
| **Related tables** | CBP_AUDIT_MESSAGE |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-006](sql/SQL-006-saif-business-claim-bill.md)
- [SQL-035](sql/SQL-035-saif-business-claim-bill.md)
- [SQL-045](sql/SQL-045-saif-business-claim-bill.md)

---

## CBP_AUD_REVENUE_EXCP

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `RevenueExceptionsList` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | _ |
| **Sequence** | N/A |
| **Related tables** | CBP_AUD_REVENUE_EXCP |
| **Business objects** | `RevenueExceptionsList` |

### SQL referencing this table
- [SQL-029](sql/SQL-029-saif-business-claim-bill.md)

---

## CBP_BILL

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `BillCriteria` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/U/D |
| **Key columns used** | A, ADMISSION_DATE, AND, APPROVER_USER, ASW, B, BILL_ID, BILL_PACKAGE_QUANTITY, BILL_PAYMENT_CATEGORY_CODE, BILL_PAYMENT_SEQ_NUM |
| **Sequence** | N/A |
| **Related tables** | CBP_BILL, CBP_BILL_DIAGNOSIS, CBP_BILL_PAYMENT_REQUEST, CBP_BILL_PROCEDURE, CBP_BILL_SERVICE, CBP_BILL_STATUS |
| **Business objects** | `BillCriteria` |

### SQL referencing this table
- [SQL-001](sql/SQL-001-saif-business-claim-bill.md)
- [SQL-002](sql/SQL-002-saif-business-claim-bill.md)
- [SQL-007](sql/SQL-007-saif-business-claim-bill.md)
- [SQL-008](sql/SQL-008-saif-business-claim-bill.md)
- [SQL-009](sql/SQL-009-saif-business-claim-bill.md)
- [SQL-010](sql/SQL-010-saif-business-claim-bill.md)
- [SQL-021](sql/SQL-021-saif-business-claim-bill.md)
- [SQL-022](sql/SQL-022-saif-business-claim-bill.md)
- [SQL-023](sql/SQL-023-saif-business-claim-bill.md)
- [SQL-030](sql/SQL-030-saif-business-claim-bill.md)
- [SQL-031](sql/SQL-031-saif-business-claim-bill.md)
- [SQL-036](sql/SQL-036-saif-business-claim-bill.md)
- [SQL-037](sql/SQL-037-saif-business-claim-bill.md)
- [SQL-038](sql/SQL-038-saif-business-claim-bill.md)
- [SQL-039](sql/SQL-039-saif-business-claim-bill.md)
- [SQL-040](sql/SQL-040-saif-business-claim-bill.md)

---

## CBP_BILL_DIAGNOSIS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/U/D |
| **Key columns used** | AND, B, BILL_ID, C, CBP_BILL_DIAGNOSIS, D, DIAGNOSIS_CODE, DIAGNOSIS_POINTER_CODE, DIAGNOSIS_TYPE_CODE, I |
| **Sequence** | N/A |
| **Related tables** | CBP_BILL_DIAGNOSIS |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-007](sql/SQL-007-saif-business-claim-bill.md)
- [SQL-036](sql/SQL-036-saif-business-claim-bill.md)
- [SQL-046](sql/SQL-046-saif-business-claim-bill.md)

---

## CBP_BILL_PAYMENT_REQUEST

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/R/U/D |
| **Key columns used** | A, APPROVER_USER, B, BILL_ID, BILL_PAYMENT_CATEGORY_CODE, BILL_PAYMENT_SEQ_NUM, C, CBP_BILL_PAYMENT_REQUEST, CHARGEABLE_COST_FLAG, CLAIM_ID |
| **Sequence** | N/A |
| **Related tables** | CBP_BILL_PAYMENT_REQUEST |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-002](sql/SQL-002-saif-business-claim-bill.md)
- [SQL-021](sql/SQL-021-saif-business-claim-bill.md)
- [SQL-022](sql/SQL-022-saif-business-claim-bill.md)
- [SQL-031](sql/SQL-031-saif-business-claim-bill.md)
- [SQL-041](sql/SQL-041-saif-business-claim-bill.md)

---

## CBP_BILL_PROCEDURE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/R/U/D |
| **Key columns used** | AND, B, BILL_ID, BILL_PROCEDURE_SEQ_NUM, BILL_SERVICE_TYPE_CODE, C, CBP_BILL_PROCEDURE, CBP_SERVICE_CODE, D, F |
| **Sequence** | N/A |
| **Related tables** | CBP_BILL_PROCEDURE |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-008](sql/SQL-008-saif-business-claim-bill.md)
- [SQL-023](sql/SQL-023-saif-business-claim-bill.md)
- [SQL-037](sql/SQL-037-saif-business-claim-bill.md)
- [SQL-047](sql/SQL-047-saif-business-claim-bill.md)

---

## CBP_BILL_SERVICE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/U/D |
| **Key columns used** | A, AND, ASW, B, BILL_ID, BILL_SERVICE_DATE, BILL_SERVICE_END_DATE, BILL_SERVICE_SEQ_NUM, BILL_SERVICE_TYPE_CODE, C |
| **Sequence** | N/A |
| **Related tables** | CBP_BILL_SERVICE |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-009](sql/SQL-009-saif-business-claim-bill.md)
- [SQL-038](sql/SQL-038-saif-business-claim-bill.md)
- [SQL-048](sql/SQL-048-saif-business-claim-bill.md)

---

## CBP_BILL_STATUS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/U/D |
| **Key columns used** | AND, B, BILL_ID, BILL_STATUS_ID, C, CBP_BILL_STATUS, CBP_BILL_STATUS_CODE, D, E, I |
| **Sequence** | N/A |
| **Related tables** | CBP_BILL_STATUS |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-010](sql/SQL-010-saif-business-claim-bill.md)
- [SQL-039](sql/SQL-039-saif-business-claim-bill.md)
- [SQL-049](sql/SQL-049-saif-business-claim-bill.md)

---

## CBP_DCBS_CONVERSION_FACTOR

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `DCBSConversionFactorList` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | _ |
| **Sequence** | N/A |
| **Related tables** | CBP_DCBS_CONVERSION_FACTOR |
| **Business objects** | `DCBSConversionFactorList` |

### SQL referencing this table
- [SQL-024](sql/SQL-024-saif-business-claim-bill.md)

---

## CBP_DIAGNOSIS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `DiagnosisCodes` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | _ |
| **Sequence** | N/A |
| **Related tables** | CBP_DIAGNOSIS, CBP_DIAGNOSIS_CATEGORY_CODE |
| **Business objects** | `DiagnosisCodes` |

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

---

## CBP_DIAGNOSIS_CATEGORY_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `DiagnosisCategories` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | _ |
| **Sequence** | N/A |
| **Related tables** | CBP_DIAGNOSIS_CATEGORY_CODE |
| **Business objects** | `DiagnosisCategories` |

### SQL referencing this table
- [SQL-025](sql/SQL-025-saif-business-claim-bill.md)

---

## CBP_NATIONAL_DRUG_PRICE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `clsNationalDrug` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | C, D, N, _ |
| **Sequence** | N/A |
| **Related tables** | CBP_NATIONAL_DRUG_PRICE |
| **Business objects** | `clsNationalDrug` |

### SQL referencing this table
- [SQL-016](sql/SQL-016-saif-business-claim-bill.md)

---

## CBP_PHARMACY_ALLOWANCE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `PharmacyAllowanceList` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | _ |
| **Sequence** | N/A |
| **Related tables** | CBP_PHARMACY_ALLOWANCE |
| **Business objects** | `PharmacyAllowanceList` |

### SQL referencing this table
- [SQL-027](sql/SQL-027-saif-business-claim-bill.md)

---

## CBP_PROCEDURE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `ProcedureCodes` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | _ |
| **Sequence** | N/A |
| **Related tables** | CBP_PROCEDURE_CODE |
| **Business objects** | `ProcedureCodes` |

### SQL referencing this table
- [SQL-028](sql/SQL-028-saif-business-claim-bill.md)

---

## CBP_SERVICE_CATEGORY_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `clsServiceCategoryList` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | _ |
| **Sequence** | N/A |
| **Related tables** | CBP_SERVICE_CATEGORY_CODE |
| **Business objects** | `clsServiceCategoryList` |

### SQL referencing this table
- [SQL-017](sql/SQL-017-saif-business-claim-bill.md)

---

## CBP_SERVICE_LOCATION_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `clsServiceLocationList` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | _ |
| **Sequence** | N/A |
| **Related tables** | CBP_SERVICE_LOCATION_CODE |
| **Business objects** | `clsServiceLocationList` |

### SQL referencing this table
- [SQL-018](sql/SQL-018-saif-business-claim-bill.md)

---

## CBP_SERVICE_MODIFIER_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `clsServiceModifierList` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | _ |
| **Sequence** | N/A |
| **Related tables** | CBP_SERVICE_MODIFIER_CODE |
| **Business objects** | `clsServiceModifierList` |

### SQL referencing this table
- [SQL-019](sql/SQL-019-saif-business-claim-bill.md)

---

## CBP_SERVICE_SUBCAT_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `clsServiceSubCategoryList` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | _ |
| **Sequence** | N/A |
| **Related tables** | CBP_SERVICE_SUBCAT_CODE |
| **Business objects** | `clsServiceSubCategoryList` |

### SQL referencing this table
- [SQL-020](sql/SQL-020-saif-business-claim-bill.md)

---

## CL_CLAIM_MCO_ELIGIBILITY

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `clsClaimMCO` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | B, C, CLAIM_ID, CL_CLAIM_MCO_ELIGIBILITY, D, F, ID, MCO_ELIGIBILITY_REASON_CODE, MCO_ELIGIBILITY_STATUS_CODE, MCO_ID |
| **Sequence** | N/A |
| **Related tables** | CL_CLAIM_MCO_ELIGIBILITY |
| **Business objects** | `clsClaimMCO` |

### SQL referencing this table
- [SQL-014](sql/SQL-014-saif-business-claim-bill.md)

---

## MCO_TYPE_ADMIN_FEE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `clsMCOProviderTypeAdminFeeList` data access in `SAIF.Business.Claim.Bill`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | A, ADMIN_FEE_RATE, C, D, E, EFF_DATE, EXP_DATE, F, G, ID |
| **Sequence** | N/A |
| **Related tables** | MCO_TYPE_ADMIN_FEE |
| **Business objects** | `clsMCOProviderTypeAdminFeeList` |

### SQL referencing this table
- [SQL-015](sql/SQL-015-saif-business-claim-bill.md)

---

## Table relationship diagram

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

```mermaid
erDiagram
    CBP_BILL ||--o{ CBP_BILL_SERVICE : "CBP_BILL.BILL_ID = CBP_BILL_SERVICE.BILL_ID"
    CBP_BILL ||--o{ CBP_BILL_SERVICE : "CBP_BILL.BILL_ID = CBP_BILL_SERVICE.BILL_ID"
    CBP_BILL ||--o{ CBP_BILL_SERVICE : "CBP_BILL.BILL_ID = CBP_BILL_SERVICE.BILL_ID"
```

## 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)
- [Configuration](configuration.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.Bill\Core\clsBill.vb`
- `Business\SAIF.Business.Claim.Bill\clsCBPBillPaymentRequest.vb`
- `Business\SAIF.Business.Claim.Bill\Core\clsAudit.vb`
- `Business\SAIF.Business.Claim.Bill\Core\clsAuditedService.vb`
- `Business\SAIF.Business.Claim.Bill\Core\clsAuditedServiceAdjustment.vb`
- `Business\SAIF.Business.Claim.Bill\Core\clsAuditMessage.vb`
- `Business\SAIF.Business.Claim.Bill\Core\clsBillDiagnosis.vb`
- `Business\SAIF.Business.Claim.Bill\Core\clsBillProcedure.vb`
- `Business\SAIF.Business.Claim.Bill\Core\clsBillService.vb`
- `Business\SAIF.Business.Claim.Bill\Core\clsBillStatus.vb`
- `Business\SAIF.Business.Claim.Bill\AuditSupport\mdlCBPSupportingData.vb`
- `Business\SAIF.Business.Claim.Bill\AuditSupport\MCO\clsClaimMCO.vb`
- `Business\SAIF.Business.Claim.Bill\AuditSupport\MCO\clsMCOProviderTypeAdminFee.vb`
- `Business\SAIF.Business.Claim.Bill\AuditSupport\Services\clsNationalDrug.vb`
- `Business\SAIF.Business.Claim.Bill\AuditSupport\Services\mdlServices.vb`
- `Business\SAIF.Business.Claim.Bill\clsCBPBillPaymentRequestCollection.vb`
- `Business\SAIF.Business.Claim.Bill\SAIF.BOF.Business.Claim.Bill.vbproj`