SQL-003: Association type code table load

clsAssociationTypeCodeCollection loads the entire association type code table in a single unfiltered read. The loaded rows drive association classification, display ordering, security grouping, and the data-driven procedure dispatch used by the policy-header association path.

Classification

Field	Value
SQL ID	SQL-003
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsAssociationTypeCodeCollection
Criteria property	RetrieveSQL
Lifecycle method	BeforeRetrieve / AfterRetrieve

Parameters

This statement takes no parameters; the table is loaded in full.

Tables

Table	Access	Columns used
ASSOCIATION_TYPE_CODE	SELECT	CODE, CODE_DESCR, ASSOCIATION_TYPE_CATEGORY_CODE, SOURCE_PROCEDURE_NAME, SECURITY_GROUP_NAME, SORT_ORDER, POLICY_HEADER_DEFAULT_FLAG

Sample SQL

SELECT
  ASSOCIATION_TYPE_CODE.CODE AS Code,
  ASSOCIATION_TYPE_CODE.CODE_DESCR AS Description,
  ASSOCIATION_TYPE_CODE.ASSOCIATION_TYPE_CATEGORY_CODE AS AssociationTypeCategoryCode,
  ASSOCIATION_TYPE_CODE.SOURCE_PROCEDURE_NAME AS SourceProcedureName,
  ASSOCIATION_TYPE_CODE.SECURITY_GROUP_NAME AS SecurityGroupName,
  ASSOCIATION_TYPE_CODE.SORT_ORDER AS SortOrder,
  ASSOCIATION_TYPE_CODE.POLICY_HEADER_DEFAULT_FLAG AS PolicyHeaderDefaultFlag
FROM ASSOCIATION_TYPE_CODE

Operations and processes

• Resolve policy-header associations

Business rules

• BR-015: Unrecognized relationship codes are classified as not specified
• BR-017: Association rows without a matching type code are discarded

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.View.Policy/Associations/clsAssociationTypeCodeCollection.vb
• Business/SAIF.Business.View.Policy/Associations/clsAssociationTypeCode.vb