SAIF.Business.Claim.Bill database tables

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

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
CBP_AUDIT	Oracle	[unqualified]**	C/U	Supports Criteria data access.	Criteria
CBP_AUDITED_SERVICE	Oracle	[unqualified]**	C/U	Supports Criteria data access.	Criteria
CBP_AUDITED_SERVICE_ADJUSTMENT	Oracle	[unqualified]**	C/U	Supports Criteria data access.	Criteria
CBP_AUDIT_ADJUSTMENT_TYPE	Oracle	[unqualified]**	R	Supports AdjustmentTypeList data access.	AdjustmentTypeList
CBP_AUDIT_ADJUST_CAT_CODE	Oracle	[unqualified]**	R	Supports AdjustmentCategoryList data access.	AdjustmentCategoryList
CBP_AUDIT_MESSAGE	Oracle	[unqualified]**	C/U	Supports Criteria data access.	Criteria
CBP_AUD_REVENUE_EXCP	Oracle	[unqualified]**	R	Supports RevenueExceptionsList data access.	RevenueExceptionsList
CBP_BILL	Oracle	[unqualified]**	C/U	Supports BillCriteria data access.	BillCriteria
CBP_BILL_DIAGNOSIS	Oracle	[unqualified]**	C/U	Supports Criteria data access.	Criteria
CBP_BILL_PAYMENT_REQUEST	Oracle	[unqualified]**	C/R/U	Supports Criteria data access.	Criteria
CBP_BILL_PROCEDURE	Oracle	[unqualified]**	C/R/U	Supports Criteria data access.	Criteria
CBP_BILL_SERVICE	Oracle	[unqualified]**	C/U	Supports Criteria data access.	Criteria
CBP_BILL_STATUS	Oracle	[unqualified]**	C/U	Supports Criteria data access.	Criteria
CBP_DCBS_CONVERSION_FACTOR	Oracle	[unqualified]**	R	Supports DCBSConversionFactorList data access.	DCBSConversionFactorList
CBP_DIAGNOSIS	Oracle	[unqualified]**	R	Supports DiagnosisCodes data access.	DiagnosisCodes
CBP_DIAGNOSIS_CATEGORY_CODE	Oracle	[unqualified]**	R	Supports DiagnosisCategories data access.	DiagnosisCategories
CBP_NATIONAL_DRUG_PRICE	Oracle	[unqualified]**	R	Supports clsNationalDrug data access.	clsNationalDrug
CBP_PHARMACY_ALLOWANCE	Oracle	[unqualified]**	R	Supports PharmacyAllowanceList data access.	PharmacyAllowanceList
CBP_PROCEDURE_CODE	Oracle	[unqualified]**	R	Supports ProcedureCodes data access.	ProcedureCodes
CBP_SERVICE_CATEGORY_CODE	Oracle	[unqualified]**	R	Supports clsServiceCategoryList data access.	clsServiceCategoryList
CBP_SERVICE_LOCATION_CODE	Oracle	[unqualified]**	R	Supports clsServiceLocationList data access.	clsServiceLocationList
CBP_SERVICE_MODIFIER_CODE	Oracle	[unqualified]**	R	Supports clsServiceModifierList data access.	clsServiceModifierList
CBP_SERVICE_SUBCAT_CODE	Oracle	[unqualified]**	R	Supports clsServiceSubCategoryList data access.	clsServiceSubCategoryList
CL_CLAIM_MCO_ELIGIBILITY	Oracle	[unqualified]**	R	Supports clsClaimMCO data access.	clsClaimMCO
MCO_TYPE_ADMIN_FEE	Oracle	[unqualified]**	R	Supports clsMCOProviderTypeAdminFeeList data access.	clsMCOProviderTypeAdminFeeList

CBP_AUDIT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.Bill.
Access pattern	direct SQL
CRUD operations	C/U/D
Key columns used	A, ALLOWED_AMT, AND, ASW, AUDIT_ADJUSTMENT_AMT, AUDIT_ADJUSTMENT_CODE, AUDIT_LINE_NUM, AUDIT_RECEIPT_DATE, AUDIT_SEQ_NUM, B
Sequence	N/A
Related tables	CBP_AUDIT, CBP_AUDITED_SERVICE, CBP_AUDITED_SERVICE_ADJUSTMENT, CBP_AUDIT_ADJUSTMENT_TYPE, CBP_AUDIT_ADJUST_CAT_CODE, CBP_AUDIT_MESSAGE
Business objects	Criteria

SQL referencing this table

• SQL-003
• SQL-004
• SQL-005
• SQL-006
• SQL-011
• SQL-013
• SQL-032
• SQL-033
• SQL-034
• SQL-035
• SQL-042

---

CBP_AUDITED_SERVICE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.Bill.
Access pattern	direct SQL
CRUD operations	C/U/D
Key columns used	A, ALLOWED_AMT, AND, ASW, AUDIT_ADJUSTMENT_AMT, AUDIT_ADJUSTMENT_CODE, AUDIT_LINE_NUM, AUDIT_SEQ_NUM, B, BILL_ID
Sequence	N/A
Related tables	CBP_AUDITED_SERVICE, CBP_AUDITED_SERVICE_ADJUSTMENT
Business objects	Criteria

SQL referencing this table

• SQL-004
• SQL-005
• SQL-033
• SQL-034
• SQL-043

---

CBP_AUDITED_SERVICE_ADJUSTMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.Bill.
Access pattern	direct SQL
CRUD operations	C/U/D
Key columns used	A, AND, AUDIT_ADJUSTMENT_AMT, AUDIT_ADJUSTMENT_CODE, AUDIT_SEQ_NUM, B, BILL_ID, C, CBP_AUDITED_SERVICE_ADJUSTMENT, D
Sequence	N/A
Related tables	CBP_AUDITED_SERVICE_ADJUSTMENT
Business objects	Criteria

SQL referencing this table

• SQL-005
• SQL-034
• SQL-044

---

CBP_AUDIT_ADJUSTMENT_TYPE

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

SQL referencing this table

• SQL-013

---

CBP_AUDIT_ADJUST_CAT_CODE

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

SQL referencing this table

• SQL-011

---

CBP_AUDIT_MESSAGE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.Bill.
Access pattern	direct SQL
CRUD operations	C/U/D
Key columns used	AND, B, BILL_ID, C, CBP_AUDIT_MESSAGE, CBP_AUDIT_MESSAGE_SEQ_NUM, D, I, ID, M
Sequence	N/A
Related tables	CBP_AUDIT_MESSAGE
Business objects	Criteria

SQL referencing this table

• SQL-006
• SQL-035
• SQL-045

---

CBP_AUD_REVENUE_EXCP

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

SQL referencing this table

• SQL-029

---

CBP_BILL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports BillCriteria data access in SAIF.Business.Claim.Bill.
Access pattern	direct SQL
CRUD operations	C/U/D
Key columns used	A, ADMISSION_DATE, AND, APPROVER_USER, ASW, B, BILL_ID, BILL_PACKAGE_QUANTITY, BILL_PAYMENT_CATEGORY_CODE, BILL_PAYMENT_SEQ_NUM
Sequence	N/A
Related tables	CBP_BILL, CBP_BILL_DIAGNOSIS, CBP_BILL_PAYMENT_REQUEST, CBP_BILL_PROCEDURE, CBP_BILL_SERVICE, CBP_BILL_STATUS
Business objects	BillCriteria

SQL referencing this table

• SQL-001
• SQL-002
• SQL-007
• SQL-008
• SQL-009
• SQL-010
• SQL-021
• SQL-022
• SQL-023
• SQL-030
• SQL-031
• SQL-036
• SQL-037
• SQL-038
• SQL-039
• SQL-040

---

CBP_BILL_DIAGNOSIS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.Bill.
Access pattern	direct SQL
CRUD operations	C/U/D
Key columns used	AND, B, BILL_ID, C, CBP_BILL_DIAGNOSIS, D, DIAGNOSIS_CODE, DIAGNOSIS_POINTER_CODE, DIAGNOSIS_TYPE_CODE, I
Sequence	N/A
Related tables	CBP_BILL_DIAGNOSIS
Business objects	Criteria

SQL referencing this table

• SQL-007
• SQL-036
• SQL-046

---

CBP_BILL_PAYMENT_REQUEST

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.Bill.
Access pattern	direct SQL
CRUD operations	C/R/U/D
Key columns used	A, APPROVER_USER, B, BILL_ID, BILL_PAYMENT_CATEGORY_CODE, BILL_PAYMENT_SEQ_NUM, C, CBP_BILL_PAYMENT_REQUEST, CHARGEABLE_COST_FLAG, CLAIM_ID
Sequence	N/A
Related tables	CBP_BILL_PAYMENT_REQUEST
Business objects	Criteria

SQL referencing this table

• SQL-002
• SQL-021
• SQL-022
• SQL-031
• SQL-041

---

CBP_BILL_PROCEDURE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.Bill.
Access pattern	direct SQL
CRUD operations	C/R/U/D
Key columns used	AND, B, BILL_ID, BILL_PROCEDURE_SEQ_NUM, BILL_SERVICE_TYPE_CODE, C, CBP_BILL_PROCEDURE, CBP_SERVICE_CODE, D, F
Sequence	N/A
Related tables	CBP_BILL_PROCEDURE
Business objects	Criteria

SQL referencing this table

• SQL-008
• SQL-023
• SQL-037
• SQL-047

---

CBP_BILL_SERVICE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.Bill.
Access pattern	direct SQL
CRUD operations	C/U/D
Key columns used	A, AND, ASW, B, BILL_ID, BILL_SERVICE_DATE, BILL_SERVICE_END_DATE, BILL_SERVICE_SEQ_NUM, BILL_SERVICE_TYPE_CODE, C
Sequence	N/A
Related tables	CBP_BILL_SERVICE
Business objects	Criteria

SQL referencing this table

• SQL-009
• SQL-038
• SQL-048

---

CBP_BILL_STATUS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in SAIF.Business.Claim.Bill.
Access pattern	direct SQL
CRUD operations	C/U/D
Key columns used	AND, B, BILL_ID, BILL_STATUS_ID, C, CBP_BILL_STATUS, CBP_BILL_STATUS_CODE, D, E, I
Sequence	N/A
Related tables	CBP_BILL_STATUS
Business objects	Criteria

SQL referencing this table

• SQL-010
• SQL-039
• SQL-049

---

CBP_DCBS_CONVERSION_FACTOR

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

SQL referencing this table

• SQL-024

---

CBP_DIAGNOSIS

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

SQL referencing this table

• SQL-025
• SQL-026

---

CBP_DIAGNOSIS_CATEGORY_CODE

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

SQL referencing this table

• SQL-025

---

CBP_NATIONAL_DRUG_PRICE

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

SQL referencing this table

• SQL-016

---

CBP_PHARMACY_ALLOWANCE

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

SQL referencing this table

• SQL-027

---

CBP_PROCEDURE_CODE

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

SQL referencing this table

• SQL-028

---

CBP_SERVICE_CATEGORY_CODE

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

SQL referencing this table

• SQL-017

---

CBP_SERVICE_LOCATION_CODE

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

SQL referencing this table

• SQL-018

---

CBP_SERVICE_MODIFIER_CODE

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

SQL referencing this table

• SQL-019

---

CBP_SERVICE_SUBCAT_CODE

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

SQL referencing this table

• SQL-020

---

CL_CLAIM_MCO_ELIGIBILITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsClaimMCO data access in SAIF.Business.Claim.Bill.
Access pattern	direct SQL
CRUD operations	R
Key columns used	B, C, CLAIM_ID, CL_CLAIM_MCO_ELIGIBILITY, D, F, ID, MCO_ELIGIBILITY_REASON_CODE, MCO_ELIGIBILITY_STATUS_CODE, MCO_ID
Sequence	N/A
Related tables	CL_CLAIM_MCO_ELIGIBILITY
Business objects	clsClaimMCO

SQL referencing this table

• SQL-014

---

MCO_TYPE_ADMIN_FEE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsMCOProviderTypeAdminFeeList data access in SAIF.Business.Claim.Bill.
Access pattern	direct SQL
CRUD operations	R
Key columns used	A, ADMIN_FEE_RATE, C, D, E, EFF_DATE, EXP_DATE, F, G, ID
Sequence	N/A
Related tables	MCO_TYPE_ADMIN_FEE
Business objects	clsMCOProviderTypeAdminFeeList

SQL referencing this table

• SQL-015

---

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_BILL_SERVICE : "CBP_BILL.BILL_ID = CBP_BILL_SERVICE.BILL_ID"
    CBP_BILL ||--o{ CBP_BILL_SERVICE : "CBP_BILL.BILL_ID = CBP_BILL_SERVICE.BILL_ID"

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• Procedures
• Configuration
• API reference

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\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
• Business\SAIF.Business.Claim.Bill\SAIF.BOF.Business.Claim.Bill.vbproj