SQL-051 Propagate the primary body part to the injury claim¶

Propagates the primary body part and side to CL_INJURY_CLAIM when the worker injured-body-part object is dirty and marked primary (or blanks them when clearing).

Classification¶

Field	Value
SQL ID	SQL-051
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsWorkerInjuredBodyPart`
Criteria property	`UpdateInjuryClaimSQL`
Lifecycle method	`UpdateClaimBodyPart`

Parameters¶

Parameter	Direction	Type	Max length	Description
`BodyPartCode`	Input	String	5	Primary body part propagated to the claim (blanked when inClearFields is true)
`BodyPartSideCode`	Input	String	5	Primary body part side propagated to the claim
`UpdateUser`	Input	String	30	Auditing user
`ClaimID`	Input	Decimal	—	Row key

Tables¶

Table	Access	Columns used
CL_INJURY_CLAIM	UPDATE	BODY_PART_CODE, BODY_PART_SIDE_CODE, UPDATE_NUM, UPDATE_USER_ID, UPDATE_DATE, CLAIM_ID

Sample SQL¶

-- Propagate primary body part to injury claim
Update CL_INJURY_CLAIM
   Set BODY_PART_CODE      = :BodyPartCode,
       BODY_PART_SIDE_CODE = :BodyPartSideCode,
       UPDATE_NUM          = UPDATE_NUM + 1,
       UPDATE_USER_ID      = :UpdateUser,
       UPDATE_DATE         = SYSDATE
 Where CLAIM_ID = :ClaimID

Operations and processes¶

Injured body-part maintenance

Sources¶

SAIF.Business.Claim/clsWorkerInjuredBodyPart.vb