SQL-009: Retrieve all correspondence codes

This unfiltered code-table load builds the in-memory correspondence-code collection that endorsement retrieval uses to avoid repeated single-code queries.

Classification

Field	Value
SQL ID	SQL-009
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsCorrespondenceCodeCollection
Criteria property	RetrieveSqlStatement reuse
Lifecycle method	GetCorrespondenceCodes

Parameters

Parameter	Direction	Type	Max length	Description
—	—	—	—	No bind parameters; the full code table is loaded.

Tables

Table	Access	Columns used
ENDORSE_CODE	SELECT	same code-table projection as SQL-008

Sample SQL

SELECT
  ENDORSE_CODE.CODE AS Code,
  ENDORSE_CODE.CODE_DESCR AS Description,
  ENDORSE_CODE.NCCI_CODE AS NCCIEndorsementCode,
  ENDORSE_CODE.PRINT_ENDORSE_FLAG AS PrintCorrespondenceFlag,
  ENDORSE_CODE.PICS_REPORT_FLAG AS PICSReportFlag,
  ENDORSE_CODE.MANUAL_ADD_FLAG AS ManualAddFlag,
  ENDORSE_CODE.REVISION_DATE AS RevisionDate,
  ENDORSE_CODE.CORRESPOND_TYPE_CODE AS CorrespondenceTypeCode,
  ENDORSE_CODE.PROGRAM_ID AS ProgramID,
  ENDORSE_CODE.AUTO_ADD_FLAG AS AutoAddFlag,
  ENDORSE_CODE.PRINT_PRIORITY_NUM AS PrintPriorityNumber,
  ENDORSE_CODE.INFOPAGE_PRINT_FLAG AS InformationPagePrintFlag,
  ENDORSE_CODE.CANCEL_ENDORSE_CODE AS CancelEndorsementCode,
  ENDORSE_CODE.CANCELLATION_DOC_FLAG AS CancellationDocumentFlag,
  ENDORSE_CODE.SVC_SIGNATURE_FLAG AS ServiceCenterSignatureFlag,
  ENDORSE_CODE.SIGNATURE_TEAM_FUNC_CODE AS SignatureTeamFunctionCode,
  ENDORSE_CODE.DEFAULT_DUPLEX_FLAG AS DefaultDuplexFlag,
  ENDORSE_CODE.PRINT_BEFORE_INFO_PAGE_FLAG AS PrintBeforeInformationPageFlag,
  ENDORSE_CODE.RNW_AUTO_ENDORSE_FLAG AS RenewalAutoEndorsementFlag,
  ENDORSE_CODE.IMAGE_CATEGORY_CODE AS ImageCategoryCode,
  ENDORSE_CODE.IMAGE_DOCUMENT_TYPE_CODE AS ImageDocumentTypeCode,
  ENDORSE_CODE.IMAGE_DOCUMENT_DATE_RULE_CODE AS ImageDocumentDateRuleCode
FROM ENDORSE_CODE

Operations and processes

• Retrieve endorsement collections for a policy or policy period

Business rules

• BR-010: Transaction-pending endorsement loads reuse a pre-fetched code collection
• BR-019: Correspondence codes must exist in ENDORSE_CODE
• BR-023: Correspondence descriptions resolve through the code collection cache

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\clsCorrespondenceCode.vb