--- title: SAIF.Business.Claim.Bill SQL catalog summary: SQL catalog for 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 SQL catalog This page indexes the SQL statements used by `SAIF.Business.Claim.Bill`. ## Create operations | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-001](SQL-001-saif-business-claim-bill.md) | Inline create used by BillCriteria | Inline | CBP_BILL | `BillCriteria` | | [SQL-002](SQL-002-saif-business-claim-bill.md) | Inline create used by Criteria | Inline | CBP_BILL_PAYMENT_REQUEST | `Criteria` | | [SQL-003](SQL-003-saif-business-claim-bill.md) | Inline create used by Criteria | Inline | CBP_AUDIT | `Criteria` | | [SQL-004](SQL-004-saif-business-claim-bill.md) | Inline create used by Criteria | Inline | CBP_AUDITED_SERVICE | `Criteria` | | [SQL-005](SQL-005-saif-business-claim-bill.md) | Inline create used by Criteria | Inline | CBP_AUDITED_SERVICE_ADJUSTMENT | `Criteria` | | [SQL-006](SQL-006-saif-business-claim-bill.md) | Inline create used by Criteria | Inline | CBP_AUDIT_MESSAGE | `Criteria` | | [SQL-007](SQL-007-saif-business-claim-bill.md) | Inline create used by Criteria | Inline | CBP_BILL_DIAGNOSIS | `Criteria` | | [SQL-008](SQL-008-saif-business-claim-bill.md) | Inline create used by Criteria | Inline | CBP_BILL_PROCEDURE | `Criteria` | | [SQL-009](SQL-009-saif-business-claim-bill.md) | Inline create used by Criteria | Inline | CBP_BILL_SERVICE | `Criteria` | | [SQL-010](SQL-010-saif-business-claim-bill.md) | Inline create used by Criteria | Inline | CBP_BILL_STATUS | `Criteria` | ## Read operations | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-011](SQL-011-saif-business-claim-bill.md) | Inline read used by AdjustmentCategoryList | Inline | CBP_AUDIT_ADJUST_CAT_CODE | `AdjustmentCategoryList` | | [SQL-012](SQL-012-saif-business-claim-bill.md) | sp82385_get_next_bill_seqnum | StoredProc | N/A | `AdjustmentTypeInfo` | | [SQL-013](SQL-013-saif-business-claim-bill.md) | Inline read used by AdjustmentTypeList | Inline | CBP_AUDIT_ADJUSTMENT_TYPE | `AdjustmentTypeList` | | [SQL-014](SQL-014-saif-business-claim-bill.md) | StringBuilder read used by clsClaimMCO | StringBuilder | CL_CLAIM_MCO_ELIGIBILITY | `clsClaimMCO` | | [SQL-015](SQL-015-saif-business-claim-bill.md) | StringBuilder read used by clsMCOProviderTypeAdminFeeList | StringBuilder | MCO_TYPE_ADMIN_FEE | `clsMCOProviderTypeAdminFeeList` | | [SQL-016](SQL-016-saif-business-claim-bill.md) | StringBuilder read used by clsNationalDrug | StringBuilder | CBP_NATIONAL_DRUG_PRICE | `clsNationalDrug` | | [SQL-017](SQL-017-saif-business-claim-bill.md) | Inline read used by clsServiceCategoryList | Inline | CBP_SERVICE_CATEGORY_CODE | `clsServiceCategoryList` | | [SQL-018](SQL-018-saif-business-claim-bill.md) | Inline read used by clsServiceLocationList | Inline | CBP_SERVICE_LOCATION_CODE | `clsServiceLocationList` | | [SQL-019](SQL-019-saif-business-claim-bill.md) | Inline read used by clsServiceModifierList | Inline | CBP_SERVICE_MODIFIER_CODE | `clsServiceModifierList` | | [SQL-020](SQL-020-saif-business-claim-bill.md) | Inline read used by clsServiceSubCategoryList | Inline | CBP_SERVICE_SUBCAT_CODE | `clsServiceSubCategoryList` | | [SQL-021](SQL-021-saif-business-claim-bill.md) | Inline read used by Criteria | Inline | CBP_BILL_PAYMENT_REQUEST | `Criteria` | | [SQL-022](SQL-022-saif-business-claim-bill.md) | Inline read used by Criteria | Inline | CBP_BILL_PAYMENT_REQUEST | `Criteria` | | [SQL-023](SQL-023-saif-business-claim-bill.md) | Inline read used by Criteria | Inline | CBP_BILL_PROCEDURE | `Criteria` | | [SQL-024](SQL-024-saif-business-claim-bill.md) | Inline read used by DCBSConversionFactorList | Inline | CBP_DCBS_CONVERSION_FACTOR | `DCBSConversionFactorList` | | [SQL-025](SQL-025-saif-business-claim-bill.md) | Inline read used by DiagnosisCategories | Inline | CBP_DIAGNOSIS_CATEGORY_CODE | `DiagnosisCategories` | | [SQL-026](SQL-026-saif-business-claim-bill.md) | Inline read used by DiagnosisCodes | Inline | CBP_DIAGNOSIS | `DiagnosisCodes` | | [SQL-027](SQL-027-saif-business-claim-bill.md) | Inline read used by PharmacyAllowanceList | Inline | CBP_PHARMACY_ALLOWANCE | `PharmacyAllowanceList` | | [SQL-028](SQL-028-saif-business-claim-bill.md) | Inline read used by ProcedureCodes | Inline | CBP_PROCEDURE_CODE | `ProcedureCodes` | | [SQL-029](SQL-029-saif-business-claim-bill.md) | Inline read used by RevenueExceptionsList | Inline | CBP_AUD_REVENUE_EXCP | `RevenueExceptionsList` | ## Update operations | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-030](SQL-030-saif-business-claim-bill.md) | Inline update used by BillCriteria | Inline | CBP_BILL | `BillCriteria` | | [SQL-031](SQL-031-saif-business-claim-bill.md) | Inline update used by Criteria | Inline | CBP_BILL_PAYMENT_REQUEST | `Criteria` | | [SQL-032](SQL-032-saif-business-claim-bill.md) | Inline update used by Criteria | Inline | CBP_AUDIT | `Criteria` | | [SQL-033](SQL-033-saif-business-claim-bill.md) | Inline update used by Criteria | Inline | CBP_AUDITED_SERVICE | `Criteria` | | [SQL-034](SQL-034-saif-business-claim-bill.md) | Inline update used by Criteria | Inline | CBP_AUDITED_SERVICE_ADJUSTMENT | `Criteria` | | [SQL-035](SQL-035-saif-business-claim-bill.md) | Inline update used by Criteria | Inline | CBP_AUDIT_MESSAGE | `Criteria` | | [SQL-036](SQL-036-saif-business-claim-bill.md) | Inline update used by Criteria | Inline | CBP_BILL_DIAGNOSIS | `Criteria` | | [SQL-037](SQL-037-saif-business-claim-bill.md) | Inline update used by Criteria | Inline | CBP_BILL_PROCEDURE | `Criteria` | | [SQL-038](SQL-038-saif-business-claim-bill.md) | Inline update used by Criteria | Inline | CBP_BILL_SERVICE | `Criteria` | | [SQL-039](SQL-039-saif-business-claim-bill.md) | Inline update used by Criteria | Inline | CBP_BILL_STATUS | `Criteria` | ## Delete operations | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-040](SQL-040-saif-business-claim-bill.md) | Inline delete used by BillCriteria | Inline | CBP_BILL | `BillCriteria` | | [SQL-041](SQL-041-saif-business-claim-bill.md) | Inline delete used by Criteria | Inline | CBP_BILL_PAYMENT_REQUEST | `Criteria` | | [SQL-042](SQL-042-saif-business-claim-bill.md) | Inline delete used by Criteria | Inline | CBP_AUDIT | `Criteria` | | [SQL-043](SQL-043-saif-business-claim-bill.md) | Inline delete used by Criteria | Inline | CBP_AUDITED_SERVICE | `Criteria` | | [SQL-044](SQL-044-saif-business-claim-bill.md) | Inline delete used by Criteria | Inline | CBP_AUDITED_SERVICE_ADJUSTMENT | `Criteria` | | [SQL-045](SQL-045-saif-business-claim-bill.md) | Inline delete used by Criteria | Inline | CBP_AUDIT_MESSAGE | `Criteria` | | [SQL-046](SQL-046-saif-business-claim-bill.md) | Inline delete used by Criteria | Inline | CBP_BILL_DIAGNOSIS | `Criteria` | | [SQL-047](SQL-047-saif-business-claim-bill.md) | Inline delete used by Criteria | Inline | CBP_BILL_PROCEDURE | `Criteria` | | [SQL-048](SQL-048-saif-business-claim-bill.md) | Inline delete used by Criteria | Inline | CBP_BILL_SERVICE | `Criteria` | | [SQL-049](SQL-049-saif-business-claim-bill.md) | Inline delete used by Criteria | Inline | CBP_BILL_STATUS | `Criteria` | ## 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) - [Procedures](../procedures/index.md) - [Configuration](../configuration.md) - [API reference](../api/index.md) ## 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`