DB-CLL-053 — Generate the next print-document sequence number

Classification

Field	Value
SQL ID	DB-CLL-053
Operation type	R
Execution method	Text
Database	Oracle (Case Management)
Schema	[unqualified]**
Command type	Inline text SQL
Business object	clsCreateFile.GetNextDocSeqNum
Criteria property	n/a (custom method)
Lifecycle method	n/a

Parameters

No bound parameters were identified for this statement.

Tables

Table	Access	Columns/Notes
xprint_control_seq	SELECT	sequence only

Sample SQL

select
  xprint_control_seq.nextval
from
  dual

Operations and processes

• Create legal case file and assign document sequence
• Print a legal letter

Business rules

• BR-CLM-LGL-020
• BR-CLM-LGL-021
• BR-CLM-LGL-022
• BR-CLM-LGL-023

Sources

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