--- title: SAIF.Business.Claim.MedicalBill database tables summary: Database tables used by SAIF.Business.Claim.MedicalBill. status: draft owner: SAIF Doc Gen last_reviewed: 2026-07-28 library: SAIF.Business.Claim.MedicalBill reference_type: package --- # SAIF.Business.Claim.MedicalBill database tables This page catalogs database tables accessed by `SAIF.Business.Claim.MedicalBill`. ## Table catalog | Table | Database | Schema/Link | CRUD | Purpose | Primary business object | | --- | --- | --- | --- | --- | --- | | [CBP_AUDITED_SERVICE](#cbp_audited_service) | Oracle | `[unqualified]`** | R | Used by clsAuditServiceCollection for persisted claim workflows. | `clsAuditServiceCollection` | | [CBP_AUDITED_SERVICE_ADJUSTMENT](#cbp_audited_service_adjustment) | Oracle | `[unqualified]`** | R | Used by clsServiceAdjustmentCollection for persisted claim workflows. | `clsServiceAdjustmentCollection` | | [CBP_AUDIT_ADJUSTMENT_TYPE](#cbp_audit_adjustment_type) | Oracle | `[unqualified]`** | R | Used by clsAdjustmentCode, clsAdjustmentCodeCollection for persisted claim workflows. | `clsAdjustmentCode, clsAdjustmentCodeCollection` | | [CBP_EOB_NOTE](#cbp_eob_note) | Oracle | `[unqualified]`** | R | Used by clsEOBNoteCollection for persisted claim workflows. | `clsEOBNoteCollection` | | [CBP_NATIONAL_DRUG](#cbp_national_drug) | Oracle | `[unqualified]`** | CRU | Used by clsAuditServiceCollection, clsNationalDrug for persisted claim workflows. | `clsAuditServiceCollection, clsNationalDrug` | | [CBP_NATIONAL_DRUG_PRICE](#cbp_national_drug_price) | Oracle | `[unqualified]`** | CRU | Used by clsNationalDrugPrice, clsNationalDrugPriceCollection for persisted claim workflows. | `clsNationalDrugPrice, clsNationalDrugPriceCollection` | | [CBP_NDC_PRICE_HISTORY](#cbp_ndc_price_history) | Oracle | `[unqualified]`** | CR | Used by clsNdcPriceHistory, clsNdcPriceHistoryCollection for persisted claim workflows. | `clsNdcPriceHistory, clsNdcPriceHistoryCollection` | | [CBP_SERVICE_DESCRIPTION](#cbp_service_description) | Oracle | `[unqualified]`** | R | Used by clsAuditServiceCollection for persisted claim workflows. | `clsAuditServiceCollection` | ## CBP_AUDITED_SERVICE | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `clsAuditServiceCollection` within the SAIF.Business.Claim.MedicalBill workflow. | | Access pattern | Stored procedure | | 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 | `clsAuditServiceCollection` | ### Operations referencing this table - [clsAuditServiceCollection BeforeRetrieve](operations/audit-service-and-adjustment-retrieval.md) ### SQL referencing this table - [SQL-006: pk82396_medical_bills.GetAuditServices](sql/SQL-006.md) --- ## CBP_AUDITED_SERVICE_ADJUSTMENT | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `clsServiceAdjustmentCollection` within the SAIF.Business.Claim.MedicalBill workflow. | | Access pattern | Stored procedure | | 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 | `clsServiceAdjustmentCollection` | ### Operations referencing this table - [clsServiceAdjustmentCollection BeforeRetrieve](operations/audit-service-and-adjustment-retrieval.md) ### SQL referencing this table - [SQL-013: pk82396_medical_bills.GetServiceAdjustments](sql/SQL-013.md) --- ## CBP_AUDIT_ADJUSTMENT_TYPE | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `clsAdjustmentCode, clsAdjustmentCodeCollection` within the SAIF.Business.Claim.MedicalBill 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 | `clsAdjustmentCode, clsAdjustmentCodeCollection` | ### Operations referencing this table - [clsAdjustmentCode BeforeRetrieve](operations/adjustment-code-lookup.md) - [clsAdjustmentCodeCollection BeforeRetrieve](operations/adjustment-code-lookup.md) ### SQL referencing this table - [SQL-004: Select AUDIT_ADJUSTMENT_CODE as Code, AUDIT_ADJ_DESCR as Description, AUDIT_ADJ_…](sql/SQL-004.md) - [SQL-005: Select AUDIT_ADJUSTMENT_CODE as Code, AUDIT_ADJ_DESCR as Description, AUDIT_ADJ_…](sql/SQL-005.md) --- ## CBP_EOB_NOTE | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `clsEOBNoteCollection` within the SAIF.Business.Claim.MedicalBill workflow. | | Access pattern | Stored procedure | | 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 | `clsEOBNoteCollection` | ### Operations referencing this table - [clsEOBNoteCollection BeforeRetrieve](operations/eob-note-retrieval.md) ### SQL referencing this table - [SQL-007: pk82396_medical_bills.GetEOBNotes](sql/SQL-007.md) --- ## CBP_NATIONAL_DRUG | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `clsAuditServiceCollection, clsNationalDrug` within the SAIF.Business.Claim.MedicalBill workflow. | | Access pattern | Stored procedure | | 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 | `clsAuditServiceCollection, clsNationalDrug` | ### Operations referencing this table - [clsNationalDrug BeforeInsert](operations/drug-pricing-data-management.md) - [clsAuditServiceCollection BeforeRetrieve](operations/audit-service-and-adjustment-retrieval.md) - [clsNationalDrug BeforeRetrieve](operations/drug-pricing-data-management.md) - [clsNationalDrug BeforeUpdate](operations/drug-pricing-data-management.md) ### SQL referencing this table - [SQL-001: Insert into CBP_NATIONAL_DRUG ( NATIONAL_DRUG_CODE, EFF_DATE, EXP_DATE, ACTIVITY…](sql/SQL-001.md) - [SQL-006: pk82396_medical_bills.GetAuditServices](sql/SQL-006.md) - [SQL-008: Select CBP_NATIONAL_DRUG.NATIONAL_DRUG_CODE as NationalDrugCode, CBP_NATIONAL_DR…](sql/SQL-008.md) - [SQL-014: Update CBP_NATIONAL_DRUG Set EFF_DATE = :EffDate, EXP_DATE = :ExpDate, ACTIVITY_…](sql/SQL-014.md) --- ## CBP_NATIONAL_DRUG_PRICE | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `clsNationalDrugPrice, clsNationalDrugPriceCollection` within the SAIF.Business.Claim.MedicalBill 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 | `clsNationalDrugPrice, clsNationalDrugPriceCollection` | ### Operations referencing this table - [clsNationalDrugPrice BeforeInsert](operations/drug-pricing-data-management.md) - [clsNationalDrugPrice BeforeRetrieve](operations/drug-pricing-data-management.md) - [clsNationalDrugPriceCollection BeforeRetrieve](operations/drug-pricing-data-management.md) - [clsNationalDrugPrice BeforeUpdate](operations/drug-pricing-data-management.md) ### SQL referencing this table - [SQL-002: Insert into CBP_NATIONAL_DRUG_PRICE ( NATIONAL_DRUG_CODE, EFF_DATE, EXP_DATE, AV…](sql/SQL-002.md) - [SQL-009: Select CBP_NATIONAL_DRUG_PRICE.NATIONAL_DRUG_CODE as NationalDrugCode, CBP_NATIO…](sql/SQL-009.md) - [SQL-010: Select CBP_NATIONAL_DRUG_PRICE.NATIONAL_DRUG_CODE as NationalDrugCode, CBP_NATIO…](sql/SQL-010.md) - [SQL-015: Update CBP_NATIONAL_DRUG_PRICE Set EXP_DATE = :ExpDate, AVERAGE_WHOLESALE_UNIT_A…](sql/SQL-015.md) --- ## CBP_NDC_PRICE_HISTORY | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `clsNdcPriceHistory, clsNdcPriceHistoryCollection` within the SAIF.Business.Claim.MedicalBill workflow. | | Access pattern | Direct SQL | | CRUD operations | CR | | Key columns used | Not enumerated directly in the stage findings for every statement.** | | Sequence | N/A | | Related tables | None identified | | Business objects | `clsNdcPriceHistory, clsNdcPriceHistoryCollection` | ### Operations referencing this table - [clsNdcPriceHistory BeforeInsert](operations/drug-pricing-data-management.md) - [clsNdcPriceHistory BeforeRetrieve](operations/drug-pricing-data-management.md) - [clsNdcPriceHistoryCollection BeforeRetrieve](operations/drug-pricing-data-management.md) ### SQL referencing this table - [SQL-003: Insert into CBP_NDC_PRICE_HISTORY ( NATIONAL_DRUG_CODE, EFF_DATE, EXP_DATE, AVER…](sql/SQL-003.md) - [SQL-011: Select CBP_NDC_PRICE_HISTORY.NATIONAL_DRUG_CODE as NationalDrugCode, CBP_NDC_PRI…](sql/SQL-011.md) - [SQL-012: Select CBP_NDC_PRICE_HISTORY.NATIONAL_DRUG_CODE as NationalDrugCode, CBP_NDC_PRI…](sql/SQL-012.md) --- ## CBP_SERVICE_DESCRIPTION | Field | Value | | --- | --- | | Database | Oracle | | Schema/Link | `[unqualified]`** | | Purpose | Used by `clsAuditServiceCollection` within the SAIF.Business.Claim.MedicalBill workflow. | | Access pattern | Stored procedure | | 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 | `clsAuditServiceCollection` | ### Operations referencing this table - [clsAuditServiceCollection BeforeRetrieve](operations/audit-service-and-adjustment-retrieval.md) ### SQL referencing this table - [SQL-006: pk82396_medical_bills.GetAuditServices](sql/SQL-006.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) - [Security and authorization](security-authorization.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.MedicalBill\clsAdjustmentCode.vb` - `Business\SAIF.Business.Claim.MedicalBill\clsAdjustmentCodeCollection.vb` - `Business\SAIF.Business.Claim.MedicalBill\clsAuditServiceCollection.vb` - `Business\SAIF.Business.Claim.MedicalBill\clsEOBNoteCollection.vb` - `Business\SAIF.Business.Claim.MedicalBill\clsNationalDrug.vb` - `Business\SAIF.Business.Claim.MedicalBill\clsNationalDrugPrice.vb` - `Business\SAIF.Business.Claim.MedicalBill\clsNationalDrugPriceCollection.vb` - `Business\SAIF.Business.Claim.MedicalBill\clsNdcPriceHistory.vb` - `Business\SAIF.Business.Claim.MedicalBill\clsNdcPriceHistoryCollection.vb` - `Business\SAIF.Business.Claim.MedicalBill\clsServiceAdjustmentCollection.vb`