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	Insert correspondence or endorsement row	Inline	ENDORSEMENT	clsCorrespondence
SQL-003	Legacy output-log stored-procedure call*	Stored procedure	Unknown	clsCorrespondence
SQL-004	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	Retrieve correspondence by sequence number	Inline	ENDORSEMENT, OUTPUT_LOG	clsCorrespondence
SQL-006	Retrieve correspondence by policy-period key	Inline	ENDORSEMENT, OUTPUT_LOG	clsCorrespondence
SQL-007	Look up image sequence number	Inline	OUTPUT_LOG	Application layer
SQL-008	Retrieve one correspondence code	Inline	ENDORSE_CODE	clsCorrespondenceCode
SQL-009	Retrieve all correspondence codes	Inline	ENDORSE_CODE	clsCorrespondenceCodeCollection
SQL-010	Retrieve correspondence collection for a policy	Inline	ENDORSEMENT, OUTPUT_LOG	clsCorrespondenceCollection
SQL-011	Retrieve one correspondence data element	Inline	POLICY_CORRESPOND_DATA, ENDORSEMENT, CORRESPOND_DATA_ELEMENT	clsCorrespondenceDetail
SQL-012	Retrieve all correspondence data elements	Inline	POLICY_CORRESPOND_DATA, ENDORSEMENT, CORRESPOND_DATA_ELEMENT	clsCorrespondenceDetailCollection
SQL-013	Retrieve one endorsement by sequence number	Inline	ENDORSEMENT, ENDORSE_CODE, OUTPUT_LOG	clsEndorsement
SQL-014	Retrieve endorsements for a policy	Inline	ENDORSEMENT, ENDORSE_CODE, OUTPUT_LOG	clsEndorsementCollection
SQL-015	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	Update correspondence or endorsement row	Inline	ENDORSEMENT	clsCorrespondence

Sequence operations

SQL ID	Description	Type	Tables	Business object
SQL-001	Endorsement sequence acquisition*	Framework helper	N/A	clsCorrespondence

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• Configuration
• API reference

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