Skip to content

SQL-030: BillCriteria

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

Classification

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

Parameters

Parameter Direction Type Max length Description
:ProviderLocationID Input Number N/A Binds ProviderLocationID from active calling code or Oracle signature.
:ClaimID Input Number N/A Binds ClaimID from active calling code or Oracle signature.
:BillTypeCode Input String N/A Binds BillTypeCode from active calling code or Oracle signature.
:PatientReferenceNumber Input Number N/A Binds PatientReferenceNumber from active calling code or Oracle signature.
:MailRoomReceivedDate Input Date N/A Binds MailRoomReceivedDate from active calling code or Oracle signature.
:ClaimNumber Input Number N/A Binds ClaimNumber from active calling code or Oracle signature.
:ClaimCheckValue Input String N/A Binds ClaimCheckValue from active calling code or Oracle signature.
:WorkerFirstName Input String N/A Binds WorkerFirstName from active calling code or Oracle signature.
:WorkerMiddleInitial Input Number N/A Binds WorkerMiddleInitial from active calling code or Oracle signature.
:WorkerLastName Input String N/A Binds WorkerLastName from active calling code or Oracle signature.
:WorkerPhoneNum Input Number N/A Binds WorkerPhoneNum from active calling code or Oracle signature.
:WorkerBirthDate Input Date N/A Binds WorkerBirthDate from active calling code or Oracle signature.
:WorkerAddressLine1 Input String N/A Binds WorkerAddressLine1 from active calling code or Oracle signature.
:WorkerAddressLine2 Input String N/A Binds WorkerAddressLine2 from active calling code or Oracle signature.
:WorkerAddressLine3 Input String N/A Binds WorkerAddressLine3 from active calling code or Oracle signature.
:WorkerAddressLine4 Input String N/A Binds WorkerAddressLine4 from active calling code or Oracle signature.
:GenderCode Input String N/A Binds GenderCode from active calling code or Oracle signature.
:PatientAccountNumber Input Number N/A Binds PatientAccountNumber from active calling code or Oracle signature.
:ProviderTaxID Input Number N/A Binds ProviderTaxID from active calling code or Oracle signature.
:ProviderAddressLine1 Input Number N/A Binds ProviderAddressLine1 from active calling code or Oracle signature.
:ProviderAddressLine2 Input Number N/A Binds ProviderAddressLine2 from active calling code or Oracle signature.
:ProviderCityName Input Number N/A Binds ProviderCityName from active calling code or Oracle signature.
:ProviderStateCode Input Number N/A Binds ProviderStateCode from active calling code or Oracle signature.
:ProviderZipCode Input Number N/A Binds ProviderZipCode from active calling code or Oracle signature.
:ProviderLicenseNumber Input Number N/A Binds ProviderLicenseNumber from active calling code or Oracle signature.
:AdmissionDate Input Date N/A Binds AdmissionDate from active calling code or Oracle signature.
:DischargeDate Input Date N/A Binds DischargeDate from active calling code or Oracle signature.
:StatementFromDate Input Date N/A Binds StatementFromDate from active calling code or Oracle signature.
:StatementThruDate Input Date N/A Binds StatementThruDate from active calling code or Oracle signature.
:WorkerTaxID Input Number N/A Binds WorkerTaxID from active calling code or Oracle signature.
:Towid Input Number N/A Binds Towid from active calling code or Oracle signature.
:RebillFlag Input String N/A Binds RebillFlag from active calling code or Oracle signature.
:CurrentBillStatusID Input Number N/A Binds CurrentBillStatusID from active calling code or Oracle signature.
:PriorityNumber Input Number N/A Binds PriorityNumber 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.
:ReferringProviderName Input Number N/A Binds ReferringProviderName from active calling code or Oracle signature.
:BillTotalAmount Input Number N/A Binds BillTotalAmount from active calling code or Oracle signature.
:DRGCode Input String N/A Binds DRGCode from active calling code or Oracle signature.
:BillPackageQuantity Input String N/A Binds BillPackageQuantity from active calling code or Oracle signature.
:WorkflowBypassCode Input String N/A Binds WorkflowBypassCode from active calling code or Oracle signature.
:CurrentBillStatusCode Input String N/A Binds CurrentBillStatusCode from active calling code or Oracle signature.
:CurrentResponsiblePartyID Input Number N/A Binds CurrentResponsiblePartyID from active calling code or Oracle signature.
:CurrentStatusEffectiveDate Input Date N/A Binds CurrentStatusEffectiveDate from active calling code or Oracle signature.
:CurrentUpdateUser Input Date N/A Binds CurrentUpdateUser from active calling code or Oracle signature.
:CurrentNextReviewDate Input Date N/A Binds CurrentNextReviewDate from active calling code or Oracle signature.
:UBBillTypeCodeCBP_ADMISSION_TYPE_CODE Input String N/A Binds UBBillTypeCodeCBP_ADMISSION_TYPE_CODE from active calling code or Oracle signature.
:AdmitTypeCode Input String N/A Binds AdmitTypeCode from active calling code or Oracle signature.
:BillID Input Number N/A Binds BillID 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_BILL UPDATE A, ADMISSION_DATE, AND, B, BILL_ID, BILL_PACKAGE_QUANTITY, BILL_TOTAL_AMT, BILL_TYPE_CODE, C, CBP_ADMISSION_TYPE_CODE, CBP_BILL, CLAIM_ID

Sample SQL

Update CBP_BILL 
SET PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationID, CLAIM_ID = :ClaimID, BILL_TYPE_CODE = :BillTypeCode, PATIENT_REFERENCE_NUM = :PatientReferenceNumber, MAIL_ROOM_RECEIVED_DATE = :MailRoomReceivedDate, SAIF_CLAIM_NUM = :ClaimNumber, SAIF_CLAIM_CHK_VALUE = :ClaimCheckValue, WORKER_FIRST_NAME = :WorkerFirstName, WORKER_MIDDLE_INITIAL = :WorkerMiddleInitial, WORKER_LAST_NAME = :WorkerLastName, WORKER_PHONE_NUM = :WorkerPhoneNum, WORKER_BIRTH_DATE = :WorkerBirthDate, WORKER_ADDRESS_LINE1 = :WorkerAddressLine1, WORKER_ADDRESS_LINE2 = :WorkerAddressLine2, WORKER_ADDRESS_LINE3 = :WorkerAddressLine3, WORKER_ADDRESS_LINE4 = :WorkerAddressLine4, GENDER_CODE = :GenderCode, PATIENT_ACCOUNT_NUM = :PatientAccountNumber, PROVIDER_TAX_ID = :ProviderTaxID, PROVIDER_ADDRESS_LINE1 = :ProviderAddressLine1, PROVIDER_ADDRESS_LINE2 = :ProviderAddressLine2, PROVIDER_CITY_NAME = :ProviderCityName, PROVIDER_STATE_CODE = :ProviderStateCode, PROVIDER_ZIP_CODE = :ProviderZipCode, PROVIDER_LICENSE_NUM = :ProviderLicenseNumber, ADMISSION_DATE = :AdmissionDate, DISCHARGE_DATE = :DischargeDate, STATEMENT_FROM_DATE = :StatementFromDate, STATEMENT_THRU_DATE = :StatementThruDate, WORKER_TAX_ID = :WorkerTaxID, TOWID = :Towid, REBILL_FLAG = :RebillFlag, CURRENT_BILL_STATUS_ID = :CurrentBillStatusID, PRIORITY_NUM = :PriorityNumber, UPDATE_USER = :UpdateUser, UPDATE_NUM = UPDATE_NUM + 1, UPDATE_DATE = :UpdateDate, REFERRING_PROVIDER_NAME = :ReferringProviderName, BILL_TOTAL_AMT = :BillTotalAmount, DRG_CODE = :DRGCode, BILL_PACKAGE_QUANTITY = :BillPackageQuantity, WORKFLOW_BYPASS_CODE = :WorkflowBypassCode, CURRENT_BILL_STATUS_CODE = :CurrentBillStatusCode, CURRENT_RESPONSIBLE_PARTY_ID = :CurrentResponsiblePartyID, CURRENT_STATUS_EFF_DATE = :CurrentStatusEffectiveDate, CURRENT_UPDATE_USER = :CurrentUpdateUser, CURRENT_NEXT_REVIEW_DATE = :CurrentNextReviewDate, UB_BILL_TYPE_CODE = :UBBillTypeCodeCBP_ADMISSION_TYPE_CODE = :AdmitTypeCode 
WHERE CBP_BILL.BILL_ID = :BillID 
  AND CBP_BILL.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\clsBill.vb