---
title: PolicyAssociationList
summary: API reference for PolicyAssociationList.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-31
library: SAIF.Business.View.Policy
reference_type: package
---

# PolicyAssociationList

`PolicyAssociationList` assembles a policy's relationships from four separate queries — manual affiliation, policy relationship, discount combination, and experience-rating combination — and presents them as one list. It publishes the four statements as public constants, so a consumer can see exactly which relationships were considered, and it exposes lookups that narrow the set by association type.

## Purpose

- Retrieves the full association set for a policy from its four sources ([Resolve policy associations](../../operations/resolve-policy-associations.md)).
- Narrows the set to one association type, either as associations or as bare policy numbers.
- Optionally includes the source policy itself and evaluates relationships as at a supplied date ([BR-015](../../business-rules.md#br-015-unrecognized-relationship-codes-are-classified-as-not-specified)).

## Context

- Namespace: `SAIF.Business.View.Policy`
- Assembly/package: `SAIF.BOF.Business.View.Policy`
- Declared in: `Business/SAIF.Business.View.Policy/PolicyAssociations.vb`

## Public members

| Member | Signature | Purpose |
| --- | --- | --- |
| AssociationType | `Public ReadOnly Property AssociationType(ByVal inAssociationType As AssociationTypes) As IEnumerable(Of PolicyAssociation)` | The associations in this set that are of a given type. |
| PolicyNumbers | `Public ReadOnly Property PolicyNumbers(ByVal inAssociationType As AssociationTypes) As IEnumerable(Of Decimal)` | The policy numbers in this set for a given association type, for consumers that need only the keys. |
| ManualAffiliationSQL | `Public Const ManualAffiliationSQL As String = " SELECT mbr_policy_num as PolicyNumber, " & " '" & ManualAffiliationPrefix & "' \|\| pr.affil_typ_cd as RelationshipType, " & " DECODE(parent_pol …` | The branch of the association query that reads manually recorded affiliations ([SQL-026](../../sql/SQL-026-policy-association-union.md)). |
| PolicyRelationshipSQL | `Public Const PolicyRelationshipSQL As String = "SELECT policy_num as PolicyNumber, " & " p.policy_relationship_code, " & " DECODE(policy_relationship_policy_num, policy_num, 'Y', 'N') " & " …` | The branch of the association query that reads system-derived policy relationships ([SQL-026](../../sql/SQL-026-policy-association-union.md)). |
| DiscountCombinationSQL | `Public Const DiscountCombinationSQL As String = "SELECT cpp2.policy_num as PolicyNumber, " & " 'DiscountCombination', " & " NVL(cpp2.min_premium_member_flag, 'N') " & " FROM POLICY p " & " , …` | The branch of the association query that reads premium-discount combinations ([SQL-026](../../sql/SQL-026-policy-association-union.md)). |
| ERCombinationSQL | `Public Const ERCombinationSQL As String = "Select " & " ecp2.POLICY_NUM as PolicyNumber, " & " 'ExperienceCombination', " & " DECODE(ecp2.policy_num, p.rate_account, 'Y', 'N') " & "From " & …` | The branch of the association query that reads experience-rating combinations ([SQL-026](../../sql/SQL-026-policy-association-union.md)). |
| GetPolicyAssociationList | `Public Shared Function GetPolicyAssociationList(ByVal inDPI As IDataPortalInfo,` | Retrieves every association of a policy from all four sources, optionally including the source policy and evaluating as at a supplied date ([Resolve policy associations](../../operations/resolve-policy-associations.md)). |

## Behavioral notes

- The four SQL constants are public, so consumers can inspect the statements; they are cataloged individually in the [SQL catalog](../../sql/index.md).

> **Note:** Statements marked with `†` are derived from dependency library
> documentation via the Legends CLI. Statements marked with `*` were inferred
> from code structure or contextual evidence. Statements marked with `**` could
> not be confirmed; treat as unknown until verified.

## Sources

- `Business/SAIF.Business.View.Policy/PolicyAssociations.vb`