SQL-031: Criteria¶

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

Classification¶

Field	Value
SQL ID	SQL-031
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
`:BillID`	Input	Number	N/A	Binds BillID from active calling code or Oracle signature.
`:ClaimID`	Input	Number	N/A	Binds ClaimID from active calling code or Oracle signature.
`:ProviderLocSeqNum`	Input	Number	N/A	Binds ProviderLocSeqNum from active calling code or Oracle signature.
`:TaxIDDisplayDescr`	Input	Number	N/A	Binds TaxIDDisplayDescr from active calling code or Oracle signature.
`:ProviderTypeCode`	Input	Number	N/A	Binds ProviderTypeCode from active calling code or Oracle signature.
`:WorkerID`	Input	Number	N/A	Binds WorkerID from active calling code or Oracle signature.
`:PayeeTypeCode`	Input	String	N/A	Binds PayeeTypeCode from active calling code or Oracle signature.
`:TransactionAmt`	Input	Number	N/A	Binds TransactionAmt from active calling code or Oracle signature.
`:WorkerPayReasonCode`	Input	String	N/A	Binds WorkerPayReasonCode from active calling code or Oracle signature.
`:SpecialHandlingCode`	Input	String	N/A	Binds SpecialHandlingCode from active calling code or Oracle signature.
`:IssueDate`	Input	Date	N/A	Binds IssueDate from active calling code or Oracle signature.
`:TransactionFromDate`	Input	Date	N/A	Binds TransactionFromDate from active calling code or Oracle signature.
`:TransactionThruDate`	Input	Date	N/A	Binds TransactionThruDate from active calling code or Oracle signature.
`:ChargeableCostFlag`	Input	String	N/A	Binds ChargeableCostFlag from active calling code or Oracle signature.
`:McoFeeFlag`	Input	String	N/A	Binds McoFeeFlag from active calling code or Oracle signature.
`:BillPaymentCategoryCode`	Input	String	N/A	Binds BillPaymentCategoryCode from active calling code or Oracle signature.
`:FederalDataFlag`	Input	String	N/A	Binds FederalDataFlag from active calling code or Oracle signature.
`:ApproverUser`	Input	String	N/A	Binds ApproverUser from active calling code or Oracle signature.
`:InitiatorUser`	Input	String	N/A	Binds InitiatorUser from active calling code or Oracle signature.
`:ProcessCode`	Input	String	N/A	Binds ProcessCode from active calling code or Oracle signature.
`:PrintEobFlag`	Input	String	N/A	Binds PrintEobFlag from active calling code or Oracle signature.
`:EbillFlag`	Input	String	N/A	Binds EbillFlag from active calling code or Oracle signature.
`:ProcessDate`	Input	Date	N/A	Binds ProcessDate from active calling code or Oracle signature.
`:MessageText`	Input	String	N/A	Binds MessageText from active calling code or Oracle signature.
`:UpdateUser`	Input	Date	N/A	Binds UpdateUser from active calling code or Oracle signature.
`:BillPaymentSeqNum`	Input	Number	N/A	Binds BillPaymentSeqNum from active calling code or Oracle signature.

Tables¶

Table	Access	Columns used
CBP_BILL_PAYMENT_REQUEST	UPDATE	A, APPROVER_USER, B, BILL_ID, BILL_PAYMENT_CATEGORY_CODE, BILL_PAYMENT_SEQ_NUM, C, CBP_BILL_PAYMENT_REQUEST, CHARGEABLE_COST_FLAG, CLAIM_ID, D, E

Sample SQL¶

Update CBP_BILL_PAYMENT_REQUEST 
SET BILL_ID = :BillID, CLAIM_ID = :ClaimID, PROVIDER_LOC_SEQ_NUM = :ProviderLocSeqNum, TAX_ID_DISPLAY_DESCR = :TaxIDDisplayDescr, PROVIDER_TYPE_CODE = :ProviderTypeCode, WORKER_ID = :WorkerID, PAYEE_TYPE_CODE = :PayeeTypeCode, TRANSACTION_AMT = :TransactionAmt, WORKER_PAY_REASON_CODE = :WorkerPayReasonCode, SPECIAL_HANDLING_CODE = :SpecialHandlingCode, ISSUE_DATE = :IssueDate, TRANSACTION_FROM_DATE = :TransactionFromDate, TRANSACTION_THRU_DATE = :TransactionThruDate, CHARGEABLE_COST_FLAG = :ChargeableCostFlag, MCO_FEE_FLAG = :McoFeeFlag, BILL_PAYMENT_CATEGORY_CODE = :BillPaymentCategoryCode, FEDERAL_DATA_FLAG = :FederalDataFlag, APPROVER_USER = :ApproverUser, INITIATOR_USER = :InitiatorUser, PROCESS_CODE = :ProcessCode, PRINT_EOB_FLAG = :PrintEobFlag, EBILL_FLAG = :EbillFlag, PROCESS_DATE = :ProcessDate, UPDATE_DATE = SYSDATE, UPDATE_NUM = UPDATE_NUM + 1, MESSAGE_TEXT = :MessageText, UPDATE_USER = :UpdateUser 
WHERE CBP_BILL_PAYMENT_REQUEST.BILL_PAYMENT_SEQ_NUM = :BillPaymentSeqNum

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