Skip to content

SQL-033: Criteria

This document records the SQL used by Criteria in SAIF.Business.Claim.Bill.

Classification

Field Value
SQL ID SQL-033
Operation type Update
Execution method Inline
Database Oracle
Schema [unqualified]**
Command type Text
Business object Criteria
Criteria property UpdateSQL
Lifecycle method BeforeUpdate

Parameters

Parameter Direction Type Max length Description
:AllowedAmount Input Number N/A Binds AllowedAmount from active calling code or Oracle signature.
:OriginalBillCode Input String N/A Binds OriginalBillCode from active calling code or Oracle signature.
:BillPaymentCategoryCode Input String N/A Binds BillPaymentCategoryCode from active calling code or Oracle signature.
:BillServiceCode Input String N/A Binds BillServiceCode from active calling code or Oracle signature.
:BillServiceTypeCode Input String N/A Binds BillServiceTypeCode from active calling code or Oracle signature.
:BillServDescrEffDate Input Date N/A Binds BillServDescrEffDate from active calling code or Oracle signature.
:ChargeAmount Input Number N/A Binds ChargeAmount from active calling code or Oracle signature.
:DiagnosisPointerCode1 Input String N/A Binds DiagnosisPointerCode1 from active calling code or Oracle signature.
:DiagnosisPointerCode2 Input String N/A Binds DiagnosisPointerCode2 from active calling code or Oracle signature.
:DiagnosisPointerCode3 Input String N/A Binds DiagnosisPointerCode3 from active calling code or Oracle signature.
:DiagnosisPointerCode4 Input String N/A Binds DiagnosisPointerCode4 from active calling code or Oracle signature.
:DispenseASWrittenCode Input String N/A Binds DispenseASWrittenCode from active calling code or Oracle signature.
:FeeScheduleAmount Input Number N/A Binds FeeScheduleAmount from active calling code or Oracle signature.
:McoAdminFeeAmount Input Number N/A Binds McoAdminFeeAmount from active calling code or Oracle signature.
:McoAdminFeeRate Input String N/A Binds McoAdminFeeRate from active calling code or Oracle signature.
:McoDiscountPlanID Input Number N/A Binds McoDiscountPlanID from active calling code or Oracle signature.
:McoEligibilityStatusCode Input String N/A Binds McoEligibilityStatusCode from active calling code or Oracle signature.
:McoGsaLocationID Input Number N/A Binds McoGsaLocationID from active calling code or Oracle signature.
:McoPlanID Input Number N/A Binds McoPlanID from active calling code or Oracle signature.
:MsrpInvoiceAmount Input Number N/A Binds MsrpInvoiceAmount from active calling code or Oracle signature.
:MsrpInvoiceCode Input String N/A Binds MsrpInvoiceCode from active calling code or Oracle signature.
:NationalDrugCode Input String N/A Binds NationalDrugCode from active calling code or Oracle signature.
:OriginalAuditServiceID Input Number N/A Binds OriginalAuditServiceID from active calling code or Oracle signature.
:OriginalBillID Input Number N/A Binds OriginalBillID from active calling code or Oracle signature.
:PrescProviderLocationID Input Number N/A Binds PrescProviderLocationID from active calling code or Oracle signature.
:ReauditCode Input String N/A Binds ReauditCode from active calling code or Oracle signature.
:SecondaryServiceCode Input String N/A Binds SecondaryServiceCode from active calling code or Oracle signature.
:SecondaryServiceTypeCode Input String N/A Binds SecondaryServiceTypeCode from active calling code or Oracle signature.
:ServiceDate Input Date N/A Binds ServiceDate from active calling code or Oracle signature.
:ServiceEndDate Input Date N/A Binds ServiceEndDate from active calling code or Oracle signature.
:ServiceLocationCode Input String N/A Binds ServiceLocationCode from active calling code or Oracle signature.
:ServiceModifierCode1 Input String N/A Binds ServiceModifierCode1 from active calling code or Oracle signature.
:ServiceModifierCode2 Input String N/A Binds ServiceModifierCode2 from active calling code or Oracle signature.
:ServiceModifierCode3 Input String N/A Binds ServiceModifierCode3 from active calling code or Oracle signature.
:ServiceModifierCode4 Input String N/A Binds ServiceModifierCode4 from active calling code or Oracle signature.
:ServiceProviderLocationID Input Number N/A Binds ServiceProviderLocationID from active calling code or Oracle signature.
:ServiceQuantity Input String N/A Binds ServiceQuantity from active calling code or Oracle signature.
:PrescribingProviderID Input Number N/A Binds PrescribingProviderID from active calling code or Oracle signature.
:PrescribingProviderCode Input Number N/A Binds PrescribingProviderCode from active calling code or Oracle signature.
:PrescriberLastName Input String N/A Binds PrescriberLastName from active calling code or Oracle signature.
:PrescriberFirstName Input String N/A Binds PrescriberFirstName from active calling code or Oracle signature.
:PrescriptionWrittenDate Input Date N/A Binds PrescriptionWrittenDate from active calling code or Oracle signature.
:CompoundDrugFlag Input String N/A Binds CompoundDrugFlag from active calling code or Oracle signature.
:TaxChargedAmount Input Number N/A Binds TaxChargedAmount from active calling code or Oracle signature.
:TotalAdjustmentAmount Input Number N/A Binds TotalAdjustmentAmount from active calling code or Oracle signature.
:UpdateUser Input Date N/A Binds UpdateUser from active calling code or Oracle signature.
:UpdateDate Input Date N/A Binds UpdateDate from active calling code or Oracle signature.
:BillID Input Number N/A Binds BillID from active calling code or Oracle signature.
:AuditedServiceID Input Number N/A Binds AuditedServiceID from active calling code or Oracle signature.
:UpdateNumber Input Date N/A Binds UpdateNumber from active calling code or Oracle signature.

Tables

Table Access Columns used
CBP_AUDITED_SERVICE UPDATE A, ALLOWED_AMT, ASW, AUDIT_SEQ_NUM, B, BILL_ID, BILL_ORIG_CODE, BILL_PAYMENT_CATEGORY_CODE, BILL_SERVICE_CODE, BILL_SERVICE_TYPE_CODE, BILL_SERV_DESCR_EFF_DATE, C

Sample SQL

Update CBP_AUDITED_SERVICE 
SET ALLOWED_AMT = :AllowedAmount, BILL_ORIG_CODE = :OriginalBillCode, BILL_PAYMENT_CATEGORY_CODE = :BillPaymentCategoryCode, BILL_SERVICE_CODE = :BillServiceCode, BILL_SERVICE_TYPE_CODE = :BillServiceTypeCode, BILL_SERV_DESCR_EFF_DATE = :BillServDescrEffDate, CHARGE_AMT = :ChargeAmount, DIAGNOSIS_POINTER_CODE1 = :DiagnosisPointerCode1, DIAGNOSIS_POINTER_CODE2 = :DiagnosisPointerCode2, DIAGNOSIS_POINTER_CODE3 = :DiagnosisPointerCode3, DIAGNOSIS_POINTER_CODE4 = :DiagnosisPointerCode4, DISPENSE_AS_WRITTEN_CODE = :DispenseASWrittenCode, FEE_SCHEDULE_AMT = :FeeScheduleAmount, MCO_ADMIN_FEE_AMT = :McoAdminFeeAmount, MCO_ADMIN_FEE_RATE = :McoAdminFeeRate, MCO_DISCOUNT_PLAN_ID = :McoDiscountPlanID, MCO_ELIGIBILITY_STATUS_CODE = :McoEligibilityStatusCode, MCO_GSA_LOCATION_ID = :McoGsaLocationID, MCO_PLAN_ID = :McoPlanID, MSRP_INVOICE_AMT = :MsrpInvoiceAmount, MSRP_INVOICE_CODE = :MsrpInvoiceCode, NATIONAL_DRUG_CODE = :NationalDrugCode, ORIG_AUDIT_SEQ_NUM = :OriginalAuditServiceID, ORIG_BILL_ID = :OriginalBillID, PRESC_PROVIDER_LOC_SEQ_NUM = :PrescProviderLocationID, REAUDIT_CODE = :ReauditCode, SECONDARY_CBP_SERVICE_CODE = :SecondaryServiceCode, SECONDARY_SERVICE_TYPE_CODE = :SecondaryServiceTypeCode, SERVICE_DATE = :ServiceDate, SERVICE_END_DATE = :ServiceEndDate, SERVICE_LOCATION_CODE = :ServiceLocationCode, SERVICE_MODIFIER_CODE1 = :ServiceModifierCode1, SERVICE_MODIFIER_CODE2 = :ServiceModifierCode2, SERVICE_MODIFIER_CODE3 = :ServiceModifierCode3, SERVICE_MODIFIER_CODE4 = :ServiceModifierCode4, SERV_PROVIDER_LOC_SEQ_NUM = :ServiceProviderLocationID, SERVICE_QUANTITY = :ServiceQuantity, PRESCRIBING_PROVIDER_ID = :PrescribingProviderID, PRESCRIBING_PROVIDER_CODE = :PrescribingProviderCode, PRESCRIBER_LAST_NAME = :PrescriberLastName, PRESCRIBER_FIRST_NAME = :PrescriberFirstName, PRESCRIPTION_WRITTEN_DATE = :PrescriptionWrittenDate, COMPOUND_DRUG_FLAG = :CompoundDrugFlag, TAX_CHARGED_AMT = :TaxChargedAmount, TOTAL_ADJUSTMENT_AMT = :TotalAdjustmentAmount, UPDATE_USER = :UpdateUser, UPDATE_NUM = UPDATE_NUM + 1, UPDATE_DATE = :UpdateDate 
WHERE BILL_ID = :BillID 
  AND AUDIT_SEQ_NUM = :AuditedServiceID 
  AND UPDATE_NUM = :UpdateNumber

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\clsAuditedService.vb