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).
- 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).
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). |
| 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). |
| 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). |
| 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). |
| 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). |
Behavioral notes¶
- The four SQL constants are public, so consumers can inspect the statements; they are cataloged individually in the SQL catalog.
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