SQL-001: Endorsement sequence acquisition

This sequence operation allocates the next correspondence identifier before the object is inserted into ENDORSEMENT. The actual SQL is emitted by the BOF framework helper rather than being written inline in this repository.*

Classification

Field	Value
SQL ID	SQL-001
Operation type	Sequence
Execution method	Framework sequence call
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsCorrespondence
Criteria property	N/A
Lifecycle method	Create

Parameters

Parameter	Direction	Type	Max length	Description
—	—	—	—	No bound parameters; the framework helper resolves Endorsement_Seq.

Tables

Table	Access	Columns used
N/A	Sequence	N/A

Sample SQL

SELECT Endorsement_Seq.NEXTVAL
FROM DUAL

Operations and processes

• Create a new correspondence or endorsement

Business rules

• BR-006: New correspondence uses the Endorsement_Seq sequence
• BR-007: Create stamps audit fields from the data portal
• BR-014: Correspondence does not expose create-SQL or delete-SQL criteria

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.Policy.Correspondence\clsCorrespondence.vb