---
title: "SQL-003: Association type code table load"
summary: Load the association type code table.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-31
library: SAIF.Business.View.Policy
reference_type: package
---

# 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](../database-tables.md#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

```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](../operations/resolve-policy-header-associations.md)

## Business rules

- [BR-015: Unrecognized relationship codes are classified as not specified](../business-rules.md#br-015-unrecognized-relationship-codes-are-classified-as-not-specified)
- [BR-017: Association rows without a matching type code are discarded](../business-rules.md#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`