---
title: "SQL-001: Endorsement sequence acquisition"
summary: Framework sequence lookup that allocates ENDORSEMENT primary keys for new correspondence items.
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Correspondence
reference_type: package
---

# 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

```sql
SELECT Endorsement_Seq.NEXTVAL
FROM DUAL
```

## Operations and processes
- [Create a new correspondence or endorsement](../operations/create-a-new-correspondence-or-endorsement.md)

## Business rules
- [BR-006: New correspondence uses the Endorsement_Seq sequence](../business-rules.md#br-006-new-correspondence-uses-the-endorsement_seq-sequence)
- [BR-007: Create stamps audit fields from the data portal](../business-rules.md#br-007-create-stamps-audit-fields-from-the-data-portal)
- [BR-014: Correspondence does not expose create-SQL or delete-SQL criteria](../business-rules.md#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`