SQL-034: Criteria
This document records the SQL used by Criteria in SAIF.Business.Claim.Bill.
Classification
Field
Value
SQL ID SQL-034
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
:AuditAdjustmentCodeInput
String
N/A
Binds AuditAdjustmentCode from active calling code or Oracle signature.
:AuditAdjustmentAmountInput
Number
N/A
Binds AuditAdjustmentAmount from active calling code or Oracle signature.
:UpdateUserInput
Date
N/A
Binds UpdateUser from active calling code or Oracle signature.
:UpdateDateInput
Date
N/A
Binds UpdateDate from active calling code or Oracle signature.
:BillIDInput
Number
N/A
Binds BillID from active calling code or Oracle signature.
:AuditServiceIDInput
Number
N/A
Binds AuditServiceID from active calling code or Oracle signature.
:CodeInput
String
N/A
Binds Code from active calling code or Oracle signature.
:UpdateNumberInput
Date
N/A
Binds UpdateNumber from active calling code or Oracle signature.
Tables
Table
Access
Columns used
CBP_AUDITED_SERVICE_ADJUSTMENT UPDATE
A, AND, AUDIT_ADJUSTMENT_AMT, AUDIT_ADJUSTMENT_CODE, AUDIT_SEQ_NUM, B, BILL_ID, C, CBP_AUDITED_SERVICE_ADJUSTMENT, D, ID, N
Sample SQL
Update CBP_AUDITED_SERVICE_ADJUSTMENT
SET AUDIT_ADJUSTMENT_CODE = : AuditAdjustmentCode , AUDIT_ADJUSTMENT_AMT = : AuditAdjustmentAmount , UPDATE_USER = : UpdateUser , UPDATE_NUM = UPDATE_NUM + 1 , UPDATE_DATE = : UpdateDate
WHERE BILL_ID = : BillID
AND AUDIT_SEQ_NUM = : AuditServiceID
AND AUDIT_ADJUSTMENT_CODE = : Code
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\clsAuditedServiceAdjustment.vb