SQL-007 Insert a new claim work-status record

Inserts a new return-to-work status history row for a claim, hard-coding the initial work-status code.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
ClaimID	Input	Decimal	—	Claim identifier
SeqNum	Input	Decimal	—	Sequence value from SQL-003
EffectiveDate	Input	Date	—	Work status effective date
UpdateNum	Input	Decimal	—	Optimistic-concurrency counter
UpdateUser	Input	String	30	Auditing user (WORK_STATUS_CODE is hard-coded to '1')

Tables

Table	Access	Columns used
CL_CLAIM_WORK_STATUS	INSERT	CLAIM_ID, CLAIM_WORK_STATUS_SEQ_NUM, WORK_STATUS_CODE, EFFECTIVE_DATE, UPDATE_NUM, UPDATE_USER_ID, UPDATE_DATE

Sample SQL

-- Insert a new claim work-status record
Insert Into CL_CLAIM_WORK_STATUS
       (CLAIM_ID,
        CLAIM_WORK_STATUS_SEQ_NUM,
        WORK_STATUS_CODE,
        EFFECTIVE_DATE,
        UPDATE_NUM,
        UPDATE_USER_ID,
        UPDATE_DATE)
Values (:ClaimID,
        :SeqNum,
        '1',
        :EffectiveDate,
        :UpdateNum,
        :UpdateUser,
        SYSDATE)

Business rules

• BR-003: Work status date cannot be in the future
• BR-012: Optimistic concurrency contention check

Sources

• SAIF.Business.Claim/clsClaimWorkStatus.vb