SQL-044 Update a claim work-release-status row

Updates the work-release-status code and effective date on a row, guarded by optimistic concurrency.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
WorkReleaseStatusCode	Input	String	5	Work release status code
EffectiveDate	Input	Date	—	Effective date
UpdateUser	Input	String	30	Auditing user
ClaimID	Input	Decimal	—	Row key
SeqNum	Input	Decimal	—	Row key
UpdateNum	Input	Decimal	—	Optimistic-concurrency check value

Tables

Table	Access	Columns used
CL_CLAIM_WORK_RELEASE_STATUS	UPDATE	WORK_RELEASE_STATUS_CODE, EFFECTIVE_DATE, UPDATE_NUM, UPDATE_USER_ID, UPDATE_DATE, CLAIM_ID, CLAIM_WORK_REL_STATUS_SEQ_NUM

Sample SQL

-- Update claim work-release-status
Update CL_CLAIM_WORK_RELEASE_STATUS
   Set WORK_RELEASE_STATUS_CODE = :WorkReleaseStatusCode,
       EFFECTIVE_DATE           = :EffectiveDate,
       UPDATE_NUM               = UPDATE_NUM + 1,
       UPDATE_USER_ID           = :UpdateUser,
       UPDATE_DATE              = SYSDATE
 Where CLAIM_ID                      = :ClaimID
   And CLAIM_WORK_REL_STATUS_SEQ_NUM = :SeqNum
   And UPDATE_NUM                    = :UpdateNum

Business rules

• BR-004: Work release date must be valid at level two
• BR-005: Work release status data must be present
• BR-012: Optimistic concurrency contention check

Sources

• SAIF.Business.Claim/clsClaimWorkReleaseStatus.vb