SQL-003 Get next claim work-status sequence value

Retrieves the next sequence value used to key a new claim work-status row before insert.

Classification

Field	Value
SQL ID	SQL-003
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsClaimWorkStatus
Criteria property	CreateSQL
Lifecycle method	BeforeCreate

Tables

Table	Access	Columns used
CL_CLAIM_WORK_STATUS	N/A	N/A — sequence read from DUAL

Sample SQL

-- Next sequence value for CLAIM_WORK_STATUS_SEQ
Select CLAIM_WORK_STATUS_SEQ.NEXTVAL
  FROM DUAL

Business rules

• BR-003: Work status date cannot be in the future

Sources

• SAIF.Business.Claim/clsClaimWorkStatus.vb