SQL-002 Get next claim work-release-status sequence value

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

Classification

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

Tables

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

Sample SQL

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

Business rules

• BR-004: Work release date must be valid at level two
• BR-005: Work release status data must be present

Sources

• SAIF.Business.Claim/clsClaimWorkReleaseStatus.vb