Skip to content

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 Oracle [unqualified]** R Used by clsAuditServiceCollection for persisted claim workflows. clsAuditServiceCollection
CBP_AUDITED_SERVICE_ADJUSTMENT Oracle [unqualified]** R Used by clsServiceAdjustmentCollection for persisted claim workflows. clsServiceAdjustmentCollection
CBP_AUDIT_ADJUSTMENT_TYPE Oracle [unqualified]** R Used by clsAdjustmentCode, clsAdjustmentCodeCollection for persisted claim workflows. clsAdjustmentCode, clsAdjustmentCodeCollection
CBP_EOB_NOTE Oracle [unqualified]** R Used by clsEOBNoteCollection for persisted claim workflows. clsEOBNoteCollection
CBP_NATIONAL_DRUG Oracle [unqualified]** CRU Used by clsAuditServiceCollection, clsNationalDrug for persisted claim workflows. clsAuditServiceCollection, clsNationalDrug
CBP_NATIONAL_DRUG_PRICE Oracle [unqualified]** CRU Used by clsNationalDrugPrice, clsNationalDrugPriceCollection for persisted claim workflows. clsNationalDrugPrice, clsNationalDrugPriceCollection
CBP_NDC_PRICE_HISTORY Oracle [unqualified]** CR Used by clsNdcPriceHistory, clsNdcPriceHistoryCollection for persisted claim workflows. clsNdcPriceHistory, clsNdcPriceHistoryCollection
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

SQL referencing this table

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

SQL referencing this table

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

SQL referencing this table

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

SQL referencing this table

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

SQL referencing this table

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

SQL referencing this table

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

SQL referencing this table

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

SQL referencing this table

Table relationship diagram

No cross-table relationships were identified in this library's SQL.

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