DB-CLL-009 — Generate the next appeal sequence value

Classification

Field	Value
SQL ID	DB-CLL-009
Operation type	C
Execution method	Text
Database	Oracle (Case Management)
Schema	[unqualified]**
Command type	Inline text SQL
Business object	clsAppeal
Criteria property	CreateSQL
Lifecycle method	AfterCreate

Parameters

No bound parameters were identified for this statement.

Tables

Table	Access	Columns/Notes
APPEAL	SELECT	sequence-only

Sample SQL

Select
  APPEAL_SEQ_NUM_NEXTVAL
From
  DUAL

Operations and processes

• Manage appeals and appeal extensions

Business rules

• BR-CLM-LGL-005

Sources

• SAIF.Business.Claim.Legal\LegalNet\clsAppeal.vb