SQL-043 Update a claim employee work address¶

Updates all fields of an employee work-address row, guarded by optimistic concurrency.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`AddressLine1`	Input	String	40	Address line 1
`AddressLine2`	Input	String	40	Address line 2
`City`	Input	String	20	City
`StateCode`	Input	String	2	State code
`ZipCode`	Input	String	5	ZIP code
`ZipCodeExtension`	Input	String	4	ZIP+4 extension
`CountyCode`	Input	String	5	County code
`UpdateUser`	Input	String	30	Auditing user
`ClaimID`	Input	Decimal	—	Row key
`UpdateNum`	Input	Decimal	—	Optimistic-concurrency check value

Tables¶

Table	Access	Columns used
CL_CLAIM_EMPLOYEE_WORK_ADDRESS	UPDATE	ADDRESS_LINE_1_TEXT, ADDRESS_LINE_2_TEXT, CITY_NAME, STATE_CODE, ZIP_CODE, ZIP_CODE_EXTENSION, COUNTY_CODE, UPDATE_NUM, UPDATE_USER_ID, UPDATE_DATE, CLAIM_ID

Sample SQL¶

-- Update claim employee work address
Update CL_CLAIM_EMPLOYEE_WORK_ADDRESS
   Set ADDRESS_LINE_1_TEXT = :AddressLine1,
       ADDRESS_LINE_2_TEXT = :AddressLine2,
       CITY_NAME           = :City,
       STATE_CODE          = :StateCode,
       ZIP_CODE            = :ZipCode,
       ZIP_CODE_EXTENSION  = :ZipCodeExtension,
       COUNTY_CODE         = :CountyCode,
       UPDATE_NUM          = UPDATE_NUM + 1,
       UPDATE_USER_ID      = :UpdateUser,
       UPDATE_DATE         = SYSDATE
 Where CLAIM_ID   = :ClaimID
   And UPDATE_NUM = :UpdateNum

Business rules¶

BR-012: Optimistic concurrency contention check

Sources¶

SAIF.Business.Claim/clsClaimEmployeeWorkAddress.vb