---
title: SAIF.Business.Policy.Correspondence SQL catalog
summary: SQL catalog for SAIF.Business.Policy.Correspondence.
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Correspondence
reference_type: package
---

# SAIF.Business.Policy.Correspondence SQL catalog

This page indexes the SQL statements used by `SAIF.Business.Policy.Correspondence`.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-002](SQL-002-saif-business-policy-correspondence.md) | Insert correspondence or endorsement row | Inline | ENDORSEMENT | `clsCorrespondence` |
| [SQL-003](SQL-003-saif-business-policy-correspondence.md) | Legacy output-log stored-procedure call* | Stored procedure | Unknown | `clsCorrespondence` |
| [SQL-004](SQL-004-saif-business-policy-correspondence.md) | Output-document stored-procedure call | Stored procedure | OUTPUT_DOCUMENT, POLICY_OUTPUT_DOCUMENT, OUTPUT_DOCUMENT_TYPE_CODE | `clsOutputDocumentInserter` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-005](SQL-005-saif-business-policy-correspondence.md) | Retrieve correspondence by sequence number | Inline | ENDORSEMENT, OUTPUT_LOG | `clsCorrespondence` |
| [SQL-006](SQL-006-saif-business-policy-correspondence.md) | Retrieve correspondence by policy-period key | Inline | ENDORSEMENT, OUTPUT_LOG | `clsCorrespondence` |
| [SQL-007](SQL-007-saif-business-policy-correspondence.md) | Look up image sequence number | Inline | OUTPUT_LOG | Application layer |
| [SQL-008](SQL-008-saif-business-policy-correspondence.md) | Retrieve one correspondence code | Inline | ENDORSE_CODE | `clsCorrespondenceCode` |
| [SQL-009](SQL-009-saif-business-policy-correspondence.md) | Retrieve all correspondence codes | Inline | ENDORSE_CODE | `clsCorrespondenceCodeCollection` |
| [SQL-010](SQL-010-saif-business-policy-correspondence.md) | Retrieve correspondence collection for a policy | Inline | ENDORSEMENT, OUTPUT_LOG | `clsCorrespondenceCollection` |
| [SQL-011](SQL-011-saif-business-policy-correspondence.md) | Retrieve one correspondence data element | Inline | POLICY_CORRESPOND_DATA, ENDORSEMENT, CORRESPOND_DATA_ELEMENT | `clsCorrespondenceDetail` |
| [SQL-012](SQL-012-saif-business-policy-correspondence.md) | Retrieve all correspondence data elements | Inline | POLICY_CORRESPOND_DATA, ENDORSEMENT, CORRESPOND_DATA_ELEMENT | `clsCorrespondenceDetailCollection` |
| [SQL-013](SQL-013-saif-business-policy-correspondence.md) | Retrieve one endorsement by sequence number | Inline | ENDORSEMENT, ENDORSE_CODE, OUTPUT_LOG | `clsEndorsement` |
| [SQL-014](SQL-014-saif-business-policy-correspondence.md) | Retrieve endorsements for a policy | Inline | ENDORSEMENT, ENDORSE_CODE, OUTPUT_LOG | `clsEndorsementCollection` |
| [SQL-015](SQL-015-saif-business-policy-correspondence.md) | Retrieve endorsements for a policy period | Inline | ENDORSEMENT, POLICY_PERIOD, ENDORSE_CODE, OUTPUT_LOG | `clsEndorsementCollection` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-016](SQL-016-saif-business-policy-correspondence.md) | Update correspondence or endorsement row | Inline | ENDORSEMENT | `clsCorrespondence` |

## Sequence operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-saif-business-policy-correspondence.md) | Endorsement sequence acquisition* | Framework helper | N/A | `clsCorrespondence` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [Configuration](../configuration.md)
- [API reference](../api/index.md)



> **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`
- `Business\SAIF.Business.Policy.Correspondence\clsCorrespondenceCode.vb`
- `Business\SAIF.Business.Policy.Correspondence\clsCorrespondenceCollection.vb`
- `Business\SAIF.Business.Policy.Correspondence\clsCorrespondenceDetail.vb`
- `Business\SAIF.Business.Policy.Correspondence\clsCorrespondenceDetailCollection.vb`
- `Business\SAIF.Business.Policy.Correspondence\clsEndorsement.vb`
- `Business\SAIF.Business.Policy.Correspondence\clsEndorsementCollection.vb`
- `Business\SAIF.Business.Policy.Correspondence\clsOutputDocumentInserter.vb`