Skip to content

SAIF.Business.Claim.Bill.AutomatedAudit database tables

This page catalogs the Oracle tables used by SAIF.Business.Claim.Bill.AutomatedAudit.

Table catalog

Table Database Schema/Link CRUD Purpose Primary business object
CBP_BILL Oracle [unqualified]** R Supports clsClaimBillHistory data access. clsClaimBillHistory
CBP_DRG_CODE Oracle [unqualified]** R Supports clsBillAuditor data access. clsBillAuditor
CL_PHARMACY_ELIGIBILITY_REPORT Oracle [unqualified]** R Supports clsPharmacyEnrollment data access. clsPharmacyEnrollment

CBP_BILL

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supports clsClaimBillHistory data access in SAIF.Business.Claim.Bill.AutomatedAudit.
Access pattern direct SQL
CRUD operations R
Key columns used A, ADMISSION_DATE, ALLOWED_AMT, AND, ASV, AUDIT_SEQ_NUM, B, BIL, BILL_ID, BILL_ORIG_CODE
Sequence N/A
Related tables CBP_BILL
Business objects clsClaimBillHistory

SQL referencing this table

CBP_DRG_CODE

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supports clsBillAuditor data access in SAIF.Business.Claim.Bill.AutomatedAudit.
Access pattern direct SQL
CRUD operations R
Key columns used C, _
Sequence N/A
Related tables CBP_DRG_CODE
Business objects clsBillAuditor

SQL referencing this table

CL_PHARMACY_ELIGIBILITY_REPORT

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supports clsPharmacyEnrollment data access in SAIF.Business.Claim.Bill.AutomatedAudit.
Access pattern direct SQL
CRUD operations R
Key columns used C, CLAIM_ID, CL_PHARMACY_ELIGIBILITY_REPORT, D, E, ELIGIBILITY_STATUS_CODE, ID, P, S, U
Sequence N/A
Related tables CL_PHARMACY_ELIGIBILITY_REPORT
Business objects clsPharmacyEnrollment

SQL referencing this table

Table relationship diagram

The following diagram shows the relationships identified in this library's SQL.

erDiagram
    CBP_BILL ||--o{ CBP_BILL_SERVICE : "CBP_BILL.BILL_ID = CBP_BILL_SERVICE.BILL_ID"
    CBP_BILL ||--o{ CBP_AUDITED_SERVICE : "CBP_BILL.BILL_ID = CBP_AUDITED_SERVICE.BILL_ID"

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.Bill.AutomatedAudit\AuditUtilities\clsBillAuditor.vb
  • Business\SAIF.Business.Claim.Bill.AutomatedAudit\AuditUtilities\clsClaimBillHistory.vb
  • Business\SAIF.Business.Claim.Bill.AutomatedAudit\AuditUtilities\clsPharmacyEnrollment.vb
  • Business\SAIF.Business.Claim.Bill.AutomatedAudit\SAIF.BOF.Business.Claim.Bill.AutomatedAudit.vbproj