---
title: SAIF.Business.Claim.MedicalBill SQL catalog
summary: Index of SQL statements 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 SQL catalog

This page indexes SQL statements and stored-procedure calls used by `SAIF.Business.Claim.MedicalBill`.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001.md) | Inline create used by clsNationalDrug | Inline | CBP_NATIONAL_DRUG | `clsNationalDrug` |
| [SQL-002](SQL-002.md) | Inline create used by clsNationalDrugPrice | Inline | CBP_NATIONAL_DRUG_PRICE | `clsNationalDrugPrice` |
| [SQL-003](SQL-003.md) | Inline create used by clsNdcPriceHistory | Inline | CBP_NDC_PRICE_HISTORY | `clsNdcPriceHistory` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-004](SQL-004.md) | Inline read used by clsAdjustmentCode | Inline | CBP_AUDIT_ADJUSTMENT_TYPE | `clsAdjustmentCode` |
| [SQL-005](SQL-005.md) | Inline read used by clsAdjustmentCodeCollection | Inline | CBP_AUDIT_ADJUSTMENT_TYPE | `clsAdjustmentCodeCollection` |
| [SQL-006](SQL-006.md) | StoredProc read used by clsAuditServiceCollection | StoredProc | CBP_AUDITED_SERVICE, CBP_SERVICE_DESCRIPTION, CBP_NATIONAL_DRUG | `clsAuditServiceCollection` |
| [SQL-007](SQL-007.md) | StoredProc read used by clsEOBNoteCollection | StoredProc | CBP_EOB_NOTE | `clsEOBNoteCollection` |
| [SQL-008](SQL-008.md) | Inline read used by clsNationalDrug | Inline | CBP_NATIONAL_DRUG | `clsNationalDrug` |
| [SQL-009](SQL-009.md) | Inline read used by clsNationalDrugPrice | Inline | CBP_NATIONAL_DRUG_PRICE | `clsNationalDrugPrice` |
| [SQL-010](SQL-010.md) | Inline read used by clsNationalDrugPriceCollection | Inline | CBP_NATIONAL_DRUG_PRICE | `clsNationalDrugPriceCollection` |
| [SQL-011](SQL-011.md) | Inline read used by clsNdcPriceHistory | Inline | CBP_NDC_PRICE_HISTORY | `clsNdcPriceHistory` |
| [SQL-012](SQL-012.md) | Inline read used by clsNdcPriceHistoryCollection | Inline | CBP_NDC_PRICE_HISTORY | `clsNdcPriceHistoryCollection` |
| [SQL-013](SQL-013.md) | StoredProc read used by clsServiceAdjustmentCollection | StoredProc | CBP_AUDITED_SERVICE_ADJUSTMENT | `clsServiceAdjustmentCollection` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-014](SQL-014.md) | Inline update used by clsNationalDrug | Inline | CBP_NATIONAL_DRUG | `clsNationalDrug` |
| [SQL-015](SQL-015.md) | Inline update used by clsNationalDrugPrice | Inline | CBP_NATIONAL_DRUG_PRICE | `clsNationalDrugPrice` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-016](SQL-016.md) | Inline delete used by clsNationalDrugPrice | Inline | — | `clsNationalDrugPrice` |

## 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)
- [Database tables](../database-tables.md)
- [Security and authorization](../security-authorization.md)
- [Procedures](../procedures/index.md)
- [API reference](../api/index.md)

## 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`