---
title: SAIF.Business.View.Policy SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-31
library: SAIF.Business.View.Policy
reference_type: package
---

# SAIF.Business.View.Policy SQL catalog

This page indexes every SQL statement and stored procedure call issued by `SAIF.Business.View.Policy`. All twenty-nine statements are reads: the library implements no create, update, delete, or sequence path ([BR-021](../business-rules.md#br-021-this-library-never-writes-policy-data)).

Every statement executes through the SAIF BOF data portal rather than through a directly constructed command object. The first eleven statements, [SQL-001](SQL-001-affiliated-policy-list.md) to [SQL-011](SQL-011-trading-as-by-policy.md), are the standard `RetrieveSQL` reads that back one business object each; the remainder, [SQL-012](SQL-012-officer-of-notice.md) to [SQL-029](SQL-029-non-typed-associations.md), are additional reads issued by helper members outside the standard criteria pattern.

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-affiliated-policy-list.md) | Retrieve affiliated policies for a policy and affiliate type | Stored Proc | N/A — stored procedure | `clsAffiliatedPolicyCollection` |
| [SQL-002](SQL-002-agency-retrieval.md) | Retrieve agency and producer details for a policy | Stored Proc | N/A — stored procedure | `clsAgency` |
| [SQL-003](SQL-003-association-type-code-table.md) | Load the association type code table | Inline | `ASSOCIATION_TYPE_CODE` | `clsAssociationTypeCodeCollection` |
| [SQL-004](SQL-004-non-employer-account.md) | Retrieve a non-employer account by account number | Inline | `NON_EMPR_ACCT` | `clsNonEmployerAccount` |
| [SQL-005](SQL-005-policy-address-by-type.md) | Retrieve a policy address by address and contact type | Stored Proc | N/A — stored procedure | `clsPolicyAddress` |
| [SQL-006](SQL-006-policy-address-by-location.md) | Retrieve a policy address by location sequence number | Stored Proc | N/A — stored procedure | `clsPolicyAddress` |
| [SQL-007](SQL-007-policy-header.md) | Retrieve the policy header for a policy number | Stored Proc | N/A — stored procedure | `clsPolicyData` |
| [SQL-008](SQL-008-policy-periods.md) | Retrieve policy periods, optionally the most recent N | Stored Proc | N/A — stored procedure | `clsPolicyPeriodCollection` |
| [SQL-009](SQL-009-team-assignments.md) | Retrieve staff team assignments for a policy | Stored Proc | N/A — stored procedure | `clsTeamAssignmentCollection` |
| [SQL-010](SQL-010-trading-as-by-seq-num.md) | Retrieve a trading-as name by sequence number | Inline | `TRADING_AS` | `clsTradingAs` |
| [SQL-011](SQL-011-trading-as-by-policy.md) | Retrieve all trading-as names for a policy | Inline | `TRADING_AS` | `clsTradingAsCollection` |
| [SQL-012](SQL-012-officer-of-notice.md) | Retrieve the officer-of-notice name for a policy | Inline | `BUSINESS_AFFILIATE`, `AFFILIATE` | `clsPolicyAddress` |
| [SQL-013](SQL-013-policy-affiliate-type.md) | Classify a policy's affiliate type (superseded path) | Stored Proc | N/A — stored procedure | `clsPolicyData` |
| [SQL-014](SQL-014-coverage-bound-flag.md) | Determine whether coverage is bound for a period | Inline | N/A — stored procedure | `clsPolicyData` |
| [SQL-015](SQL-015-future-cancel-date.md) | Retrieve the pending future cancellation date | Inline | `CANCELLATION` | `clsPolicyData` |
| [SQL-016](SQL-016-coverage-gaps.md) | Retrieve coverage gap date ranges for a policy | Stored Proc | N/A — stored procedure | `clsPolicyData` |
| [SQL-017](SQL-017-info-page-printed.md) | Check whether the information page has printed | Stored Proc | N/A — stored procedure | `clsPolicyData` |
| [SQL-018](SQL-018-last-audit-date.md) | Retrieve the most recent completed final audit date | Inline | `PA_AUDIT` | `clsPolicyData` |
| [SQL-019](SQL-019-parent-policy.md) | Resolve the parent policy number (superseded path) | Stored Proc | N/A — stored procedure | `clsPolicyData` |
| [SQL-020](SQL-020-secondary-policy-status.md) | Derive the secondary cancellation and collection status | Inline | N/A — stored procedure | `clsPolicyData` |
| [SQL-021](SQL-021-wrapup-legal-name.md) | Retrieve the wrap-up legal name for a policy | Stored Proc | N/A — stored procedure | `clsPolicyData` |
| [SQL-022](SQL-022-policy-waiver-count.md) | Count waiver records to detect waiver existence | Stored Proc | N/A — stored procedure | `clsPolicyData` |
| [SQL-023](SQL-023-employer-liability-limits.md) | Retrieve employer-liability limits for a policy period | Stored Proc | N/A — stored procedure | `clsPolicyPeriod` |
| [SQL-024](SQL-024-external-client-lookup-legacy.md) | Look up an external client e-mail address (legacy path) | Stored Proc | N/A — stored procedure | `clsTeamAssignment` |
| [SQL-025](SQL-025-system-user-email-lookup.md) | Look up a system user's e-mail address | Stored Proc | N/A — stored procedure | `clsTeamAssignment` |
| [SQL-026](SQL-026-policy-association-union.md) | Retrieve all policy associations across four association families | Inline | `POLICY_RELATIONSHIP`, `POLICY`, `COMBO_POLICY_PERIOD`, `POLICY_PERIOD`, `ER_COMBINATION_POLICY` | `PolicyAssociationList` |
| [SQL-027](SQL-027-max-policy-period-eff-date.md) | Retrieve the latest policy-period effective date | Inline | `POLICY_PERIOD` | `PolicyAssociationList` |
| [SQL-028](SQL-028-association-period-dates.md) | Retrieve effective and expiration dates for issued periods | Inline | `POLICY_PERIOD_ALL`, `ENDORSEMENT`, `POLICY_PERIOD_NON_WCIS` | `clsAssociationTypeCode` |
| [SQL-029](SQL-029-non-typed-associations.md) | Retrieve untyped associations from a data-driven procedure | Stored Proc | N/A — stored procedure | `clsAssociationTypeCode` |

Nine of these statements call procedures or functions whose bodies live in the Oracle database. Those bodies are documented on the [Procedures](../procedures/index.md) pages.

## 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)
- [Security and authorization](../security-authorization.md)
- [Database tables](../database-tables.md)
- [Procedures](../procedures/index.md)
- [API reference](../api/index.md)
- [Configuration](../configuration.md)

## Sources

- `Business/SAIF.Business.View.Policy/Associations/clsAssociationTypeCode.vb`
- `Business/SAIF.Business.View.Policy/Associations/clsAssociationTypeCodeCollection.vb`
- `Business/SAIF.Business.View.Policy/PolicyAssociations.vb`
- `Business/SAIF.Business.View.Policy/clsAffiliatedPolicyCollection.vb`
- `Business/SAIF.Business.View.Policy/clsAgency.vb`
- `Business/SAIF.Business.View.Policy/clsNonEmployerAccount.vb`
- `Business/SAIF.Business.View.Policy/clsPolicyAddress.vb`
- `Business/SAIF.Business.View.Policy/clsPolicyData.vb`
- `Business/SAIF.Business.View.Policy/clsPolicyPeriod.vb`
- `Business/SAIF.Business.View.Policy/clsPolicyPeriodCollection.vb`
- `Business/SAIF.Business.View.Policy/clsTeamAssignment.vb`
- `Business/SAIF.Business.View.Policy/clsTeamAssignmentCollection.vb`
- `Business/SAIF.Business.View.Policy/clsTradingAs.vb`
- `Business/SAIF.Business.View.Policy/clsTradingAsCollection.vb`