Skip to content

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 Inline create used by BillCriteria Inline CBP_BILL BillCriteria
SQL-002 Inline create used by Criteria Inline CBP_BILL_PAYMENT_REQUEST Criteria
SQL-003 Inline create used by Criteria Inline CBP_AUDIT Criteria
SQL-004 Inline create used by Criteria Inline CBP_AUDITED_SERVICE Criteria
SQL-005 Inline create used by Criteria Inline CBP_AUDITED_SERVICE_ADJUSTMENT Criteria
SQL-006 Inline create used by Criteria Inline CBP_AUDIT_MESSAGE Criteria
SQL-007 Inline create used by Criteria Inline CBP_BILL_DIAGNOSIS Criteria
SQL-008 Inline create used by Criteria Inline CBP_BILL_PROCEDURE Criteria
SQL-009 Inline create used by Criteria Inline CBP_BILL_SERVICE Criteria
SQL-010 Inline create used by Criteria Inline CBP_BILL_STATUS Criteria

Read operations

SQL ID Description Type Tables Business object
SQL-011 Inline read used by AdjustmentCategoryList Inline CBP_AUDIT_ADJUST_CAT_CODE AdjustmentCategoryList
SQL-012 sp82385_get_next_bill_seqnum StoredProc N/A AdjustmentTypeInfo
SQL-013 Inline read used by AdjustmentTypeList Inline CBP_AUDIT_ADJUSTMENT_TYPE AdjustmentTypeList
SQL-014 StringBuilder read used by clsClaimMCO StringBuilder CL_CLAIM_MCO_ELIGIBILITY clsClaimMCO
SQL-015 StringBuilder read used by clsMCOProviderTypeAdminFeeList StringBuilder MCO_TYPE_ADMIN_FEE clsMCOProviderTypeAdminFeeList
SQL-016 StringBuilder read used by clsNationalDrug StringBuilder CBP_NATIONAL_DRUG_PRICE clsNationalDrug
SQL-017 Inline read used by clsServiceCategoryList Inline CBP_SERVICE_CATEGORY_CODE clsServiceCategoryList
SQL-018 Inline read used by clsServiceLocationList Inline CBP_SERVICE_LOCATION_CODE clsServiceLocationList
SQL-019 Inline read used by clsServiceModifierList Inline CBP_SERVICE_MODIFIER_CODE clsServiceModifierList
SQL-020 Inline read used by clsServiceSubCategoryList Inline CBP_SERVICE_SUBCAT_CODE clsServiceSubCategoryList
SQL-021 Inline read used by Criteria Inline CBP_BILL_PAYMENT_REQUEST Criteria
SQL-022 Inline read used by Criteria Inline CBP_BILL_PAYMENT_REQUEST Criteria
SQL-023 Inline read used by Criteria Inline CBP_BILL_PROCEDURE Criteria
SQL-024 Inline read used by DCBSConversionFactorList Inline CBP_DCBS_CONVERSION_FACTOR DCBSConversionFactorList
SQL-025 Inline read used by DiagnosisCategories Inline CBP_DIAGNOSIS_CATEGORY_CODE DiagnosisCategories
SQL-026 Inline read used by DiagnosisCodes Inline CBP_DIAGNOSIS DiagnosisCodes
SQL-027 Inline read used by PharmacyAllowanceList Inline CBP_PHARMACY_ALLOWANCE PharmacyAllowanceList
SQL-028 Inline read used by ProcedureCodes Inline CBP_PROCEDURE_CODE ProcedureCodes
SQL-029 Inline read used by RevenueExceptionsList Inline CBP_AUD_REVENUE_EXCP RevenueExceptionsList

Update operations

SQL ID Description Type Tables Business object
SQL-030 Inline update used by BillCriteria Inline CBP_BILL BillCriteria
SQL-031 Inline update used by Criteria Inline CBP_BILL_PAYMENT_REQUEST Criteria
SQL-032 Inline update used by Criteria Inline CBP_AUDIT Criteria
SQL-033 Inline update used by Criteria Inline CBP_AUDITED_SERVICE Criteria
SQL-034 Inline update used by Criteria Inline CBP_AUDITED_SERVICE_ADJUSTMENT Criteria
SQL-035 Inline update used by Criteria Inline CBP_AUDIT_MESSAGE Criteria
SQL-036 Inline update used by Criteria Inline CBP_BILL_DIAGNOSIS Criteria
SQL-037 Inline update used by Criteria Inline CBP_BILL_PROCEDURE Criteria
SQL-038 Inline update used by Criteria Inline CBP_BILL_SERVICE Criteria
SQL-039 Inline update used by Criteria Inline CBP_BILL_STATUS Criteria

Delete operations

SQL ID Description Type Tables Business object
SQL-040 Inline delete used by BillCriteria Inline CBP_BILL BillCriteria
SQL-041 Inline delete used by Criteria Inline CBP_BILL_PAYMENT_REQUEST Criteria
SQL-042 Inline delete used by Criteria Inline CBP_AUDIT Criteria
SQL-043 Inline delete used by Criteria Inline CBP_AUDITED_SERVICE Criteria
SQL-044 Inline delete used by Criteria Inline CBP_AUDITED_SERVICE_ADJUSTMENT Criteria
SQL-045 Inline delete used by Criteria Inline CBP_AUDIT_MESSAGE Criteria
SQL-046 Inline delete used by Criteria Inline CBP_BILL_DIAGNOSIS Criteria
SQL-047 Inline delete used by Criteria Inline CBP_BILL_PROCEDURE Criteria
SQL-048 Inline delete used by Criteria Inline CBP_BILL_SERVICE Criteria
SQL-049 Inline delete used by Criteria Inline CBP_BILL_STATUS Criteria

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