SQL-008 Insert a new injured body-part record

Inserts a new injured-body-part row for a claim, capturing body part, side, primary flag, and injury nature.

Classification

Field	Value
SQL ID	SQL-008
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsWorkerInjuredBodyPart
Criteria property	InsertSQL
Lifecycle method	BeforeInsert

Parameters

Parameter	Direction	Type	Max length	Description
ClaimID	Input	Decimal	—	Claim identifier
BodyPartCode	Input	String	5	Injured body part code
BodyPartSideCode	Input	String	5	Body part side/laterality code
PrimaryIndicator	Input	String	1	Y/N primary body part flag
InjuryNatureCode	Input	String	5	Nature of injury code
UpdateNum	Input	Decimal	—	Optimistic-concurrency counter
UpdateUser	Input	String	30	Auditing user

Tables

Table	Access	Columns used
CL_WORKER_INJURED_BODY_PART	INSERT	CLAIM_ID, BODY_PART_CODE, BODY_PART_SIDE_CODE, PRIMARY_BODY_PART_IND, INJURY_NATURE_CODE, UPDATE_NUM, UPDATE_USER_ID, UPDATE_DATE

Sample SQL

-- Insert a new injured body-part record
Insert Into CL_WORKER_INJURED_BODY_PART
       (CLAIM_ID,
        BODY_PART_CODE,
        BODY_PART_SIDE_CODE,
        PRIMARY_BODY_PART_IND,
        INJURY_NATURE_CODE,
        UPDATE_NUM,
        UPDATE_USER_ID,
        UPDATE_DATE)
Values (:ClaimID,
        :BodyPartCode,
        :BodyPartSideCode,
        :PrimaryIndicator,
        :InjuryNatureCode,
        :UpdateNum,
        :UpdateUser,
        SYSDATE)

Operations and processes

• Injured body-part maintenance

Business rules

• BR-006: Primary body part is required
• BR-007: Only one primary body part is allowed
• BR-012: Optimistic concurrency contention check

Sources

• SAIF.Business.Claim/clsWorkerInjuredBodyPart.vb