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	Inline create used by clsNationalDrug	Inline	CBP_NATIONAL_DRUG	clsNationalDrug
SQL-002	Inline create used by clsNationalDrugPrice	Inline	CBP_NATIONAL_DRUG_PRICE	clsNationalDrugPrice
SQL-003	Inline create used by clsNdcPriceHistory	Inline	CBP_NDC_PRICE_HISTORY	clsNdcPriceHistory

Read operations

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

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-014	Inline update used by clsNationalDrug	Inline	CBP_NATIONAL_DRUG	clsNationalDrug
SQL-015	Inline update used by clsNationalDrugPrice	Inline	CBP_NATIONAL_DRUG_PRICE	clsNationalDrugPrice

Delete operations

SQL ID	Description	Type	Tables	Business object
SQL-016	Inline delete used by clsNationalDrugPrice	Inline	—	clsNationalDrugPrice

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• Security and authorization
• Procedures
• API reference

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