SQL-046 Update a federal award status¶

Updates a federal award's status code, guarded by optimistic concurrency; the update cascades to benefit-payment processing when the child is dirty and valid.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`AwardStatusCode`	Input	String	5	Federal award status being set
`UpdateUser`	Input	String	30	Auditing user
`ClaimID`	Input	Decimal	—	Row key
`AwardNum`	Input	Decimal	—	Row key
`UpdateNum`	Input	Decimal	—	Optimistic-concurrency check value

Tables¶

Table	Access	Columns used
CL_FEDERAL_AWARD	UPDATE	AWARD_STATUS_CODE, UPDATE_NUM, UPDATE_USER_ID, UPDATE_DATE, CLAIM_ID, SAIF_AWARD_NUM

Sample SQL¶

-- Update federal award status
Update CL_FEDERAL_AWARD
   Set AWARD_STATUS_CODE = :AwardStatusCode,
       UPDATE_NUM        = UPDATE_NUM + 1,
       UPDATE_USER_ID    = :UpdateUser,
       UPDATE_DATE       = SYSDATE
 Where CLAIM_ID       = :ClaimID
   And SAIF_AWARD_NUM = :AwardNum
   And UPDATE_NUM     = :UpdateNum

Business rules¶

BR-012: Optimistic concurrency contention check

Sources¶

SAIF.Business.Claim/clsFederalAwardStatus.vb