SQL-035: Criteria¶

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

Classification¶

Field	Value
SQL ID	SQL-035
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
`:AnnualIncreaseFlag`	Input	String	N/A	Binds AnnualIncreaseFlag from active calling code or Oracle signature.
`:AwardBalanceAmount`	Input	Number	N/A	Binds AwardBalanceAmount from active calling code or Oracle signature.
`:AwardEffDate`	Input	Date	N/A	Binds AwardEffDate from active calling code or Oracle signature.
`:AwardStatusCode`	Input	String	N/A	Binds AwardStatusCode from active calling code or Oracle signature.
`:AwardTotalAmount`	Input	Number	N/A	Binds AwardTotalAmount from active calling code or Oracle signature.
`:ClaimID`	Input	Number	N/A	Binds ClaimID from active calling code or Oracle signature.
`:ClosureSeqNum`	Input	Number	N/A	Binds ClosureSeqNum from active calling code or Oracle signature.
`:InitialCompRate`	Input	String	N/A	Binds InitialCompRate from active calling code or Oracle signature.
`:NextIssueDate`	Input	Date	N/A	Binds NextIssueDate from active calling code or Oracle signature.
`:OrderSeqNum`	Input	Number	N/A	Binds OrderSeqNum from active calling code or Oracle signature.
`:PpdScheduledFlag`	Input	String	N/A	Binds PpdScheduledFlag from active calling code or Oracle signature.
`:ReleasedPaymentCount`	Input	Number	N/A	Binds ReleasedPaymentCount from active calling code or Oracle signature.
`:AwardNum`	Input	Number	N/A	Binds AwardNum from active calling code or Oracle signature.
`:UpdateUser`	Input	Date	N/A	Binds UpdateUser from active calling code or Oracle signature.
`:UpdateNum`	Input	Date	N/A	Binds UpdateNum from active calling code or Oracle signature.

Tables¶

Table	Access	Columns used
CL_FEDERAL_AWARD	UPDATE	A, AND, ANNUAL_INCREASE_FLAG, AWARD_BALANCE_AMOUNT, AWARD_EFF_DATE, AWARD_STATUS_CODE, AWARD_TOTAL_AMOUNT, B, C, CLAIM_ID, CLOSURE_SEQ_NUM, CL_FEDERAL_AWARD

Sample SQL¶

Update CL_FEDERAL_AWARD 
SET ANNUAL_INCREASE_FLAG = :AnnualIncreaseFlag, AWARD_BALANCE_AMOUNT = :AwardBalanceAmount, AWARD_EFF_DATE = :AwardEffDate, AWARD_STATUS_CODE = :AwardStatusCode, AWARD_TOTAL_AMOUNT = :AwardTotalAmount, CLAIM_ID = :ClaimID, CLOSURE_SEQ_NUM = :ClosureSeqNum, INITIAL_COMP_RATE = :InitialCompRate, NEXT_ISSUE_DATE = :NextIssueDate, ORDER_SEQ_NUM = :OrderSeqNum, PPD_SCHEDULED_FLAG = :PpdScheduledFlag, RELEASED_PAYMENT_COUNT = :ReleasedPaymentCount, SAIF_AWARD_NUM = :AwardNum, UPDATE_DATE = SYSDATE, UPDATE_NUM = UPDATE_NUM + 1, UPDATE_USER = :UpdateUser 
WHERE CL_FEDERAL_AWARD.SAIF_AWARD_NUM = :AwardNum 
  AND UPDATE_NUM = :UpdateNum

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