SQL-006 Insert a new claim work-release-status record

Inserts a new work-release-status history row for a claim.

Classification

Field	Value
SQL ID	SQL-006
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsClaimWorkReleaseStatus
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-002
WorkReleaseStatusCode	Input	String	5	Work release status code
EffectiveDate	Input	Date	—	Status effective date
UpdateNum	Input	Decimal	—	Optimistic-concurrency counter
UpdateUser	Input	String	30	Auditing user

Tables

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

Sample SQL

-- Insert a new claim work-release-status record
Insert Into CL_CLAIM_WORK_RELEASE_STATUS
       (CLAIM_ID,
        CLAIM_WORK_REL_STATUS_SEQ_NUM,
        WORK_RELEASE_STATUS_CODE,
        EFFECTIVE_DATE,
        UPDATE_NUM,
        UPDATE_USER_ID,
        UPDATE_DATE)
Values (:ClaimID,
        :SeqNum,
        :WorkReleaseStatusCode,
        :EffectiveDate,
        :UpdateNum,
        :UpdateUser,
        SYSDATE)

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