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

# SAIF.Business.Claim.Bill.AutomatedAudit database tables

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

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [CBP_BILL](#cbp_bill) | Oracle | [unqualified]** | R | Supports clsClaimBillHistory data access. | `clsClaimBillHistory` |
| [CBP_DRG_CODE](#cbp_drg_code) | Oracle | [unqualified]** | R | Supports clsBillAuditor data access. | `clsBillAuditor` |
| [CL_PHARMACY_ELIGIBILITY_REPORT](#cl_pharmacy_eligibility_report) | Oracle | [unqualified]** | R | Supports clsPharmacyEnrollment data access. | `clsPharmacyEnrollment` |

## CBP_BILL

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `clsClaimBillHistory` data access in `SAIF.Business.Claim.Bill.AutomatedAudit`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | A, ADMISSION_DATE, ALLOWED_AMT, AND, ASV, AUDIT_SEQ_NUM, B, BIL, BILL_ID, BILL_ORIG_CODE |
| **Sequence** | N/A |
| **Related tables** | CBP_BILL |
| **Business objects** | `clsClaimBillHistory` |

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

---

## CBP_DRG_CODE

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

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

---

## CL_PHARMACY_ELIGIBILITY_REPORT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `clsPharmacyEnrollment` data access in `SAIF.Business.Claim.Bill.AutomatedAudit`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | C, CLAIM_ID, CL_PHARMACY_ELIGIBILITY_REPORT, D, E, ELIGIBILITY_STATUS_CODE, ID, P, S, U |
| **Sequence** | N/A |
| **Related tables** | CL_PHARMACY_ELIGIBILITY_REPORT |
| **Business objects** | `clsPharmacyEnrollment` |

### SQL referencing this table
- [SQL-003](sql/SQL-003-saif-business-claim-bill-automatedaudit.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_AUDITED_SERVICE : "CBP_BILL.BILL_ID = CBP_AUDITED_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)
- [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.AutomatedAudit\AuditUtilities\clsBillAuditor.vb`
- `Business\SAIF.Business.Claim.Bill.AutomatedAudit\AuditUtilities\clsClaimBillHistory.vb`
- `Business\SAIF.Business.Claim.Bill.AutomatedAudit\AuditUtilities\clsPharmacyEnrollment.vb`
- `Business\SAIF.Business.Claim.Bill.AutomatedAudit\SAIF.BOF.Business.Claim.Bill.AutomatedAudit.vbproj`