---
title: SAIF.Business.Policy.Affiliate SQL catalog
summary: Index of SQL statements used by SAIF.Business.Policy.Affiliate.
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Affiliate
reference_type: package
---

# SAIF.Business.Policy.Affiliate SQL catalog

This page indexes the inline SQL statements used by `SAIF.Business.Policy.Affiliate`.

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-saif-business-policy-affiliate.md) | Retrieve one affiliate person record by SSN | Inline | AFFILIATE | `clsAffiliate` |
| [SQL-002](SQL-002-saif-business-policy-affiliate.md) | Retrieve one corporate officer exemption by sequence number | Inline | CORP_OFFICER_EXEMPTION | `clsCorporateOfficerExemption` |
| [SQL-003](SQL-003-saif-business-policy-affiliate.md) | Retrieve corporate officer exemptions for one policy | Inline | CORP_OFFICER_EXEMPTION | `clsCorporateOfficerExemptionCollection` |
| [SQL-004](SQL-004-saif-business-policy-affiliate.md) | Retrieve one interested-party association by policy, affiliate, and effective date | Inline | BUSINESS_AFFILIATE, AFFILIATE | `clsInterestedParty` |
| [SQL-005](SQL-005-saif-business-policy-affiliate.md) | Retrieve interested parties for a policy and date window | Inline | BUSINESS_AFFILIATE, AFFILIATE | `clsInterestedPartyCollection` |
| [SQL-006](SQL-006-saif-business-policy-affiliate.md) | Retrieve one preferred-worker association by policy, affiliate, and effective date | Inline | BUSINESS_AFFILIATE, AFFILIATE | `clsPolicyPreferredWorker` |
| [SQL-007](SQL-007-saif-business-policy-affiliate.md) | Load the earliest preferred-worker eligibility row covering the association dates | Inline | PREFERRED_WORKER | N/A (Application layer) |
| [SQL-008](SQL-008-saif-business-policy-affiliate.md) | Retrieve preferred workers for a policy and date window | Inline | BUSINESS_AFFILIATE, AFFILIATE | `clsPolicyPreferredWorkerCollection` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [API reference](../api/index.md)
- [Configuration](../configuration.md)

## Sources
- `Business\SAIF.Business.Policy.Affiliate\clsAffiliate.vb`
- `Business\SAIF.Business.Policy.Affiliate\clsCorporateOfficerExemption.vb`
- `Business\SAIF.Business.Policy.Affiliate\clsCorporateOfficerExemptionCollection.vb`
- `Business\SAIF.Business.Policy.Affiliate\clsInterestedParty.vb`
- `Business\SAIF.Business.Policy.Affiliate\clsInterestedPartyCollection.vb`
- `Business\SAIF.Business.Policy.Affiliate\clsPolicyPreferredWorker.vb`
- `Business\SAIF.Business.Policy.Affiliate\clsPolicyPreferredWorkerCollection.vb`