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

# SAIF.Business.Policy.Agency SQL catalog

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

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-retrieve-agency-by-sequence-number.md) | Retrieve one agency by sequence number | Inline | AGENCY | `clsAgency` |
| [SQL-002](SQL-002-search-agencies-by-feid-and-contract-types.md) | Retrieve agencies by FEID and contract criteria | Inline | AGENCY, AGENCY_CONTRACT | `clsAgencyCollection` |
| [SQL-003](SQL-003-retrieve-agency-contract-by-sequence-number.md) | Retrieve one agency contract by sequence number | Inline | AGENCY_CONTRACT | `clsAgencyContract` |
| [SQL-004](SQL-004-retrieve-agency-contracts.md) | Retrieve agency contracts with optional agency scope | Inline | AGENCY_CONTRACT | `clsAgencyContractCollection` |
| [SQL-005](SQL-005-retrieve-agency-office-by-agent-number.md) | Retrieve one agency office by agent number | Inline | AGENT | `clsAgencyOffice` |
| [SQL-006](SQL-006-retrieve-agency-offices-for-an-agency.md) | Retrieve agency offices for one agency | Inline | AGENT | `clsAgencyOfficeCollection` |
| [SQL-007](SQL-007-retrieve-producer-by-agent-number.md) | Retrieve one producer by agent number | Inline | AGENT | `clsProducer` |
| [SQL-008](SQL-008-retrieve-agent-of-record-for-a-policy.md) | Retrieve a policy's agent of record | Inline | POLICY | `N/A (Application layer)` |
| [SQL-009](SQL-009-retrieve-producers.md) | Retrieve producers with optional agency scope | Inline | AGENT | `clsProducerCollection` |

## 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)
- [Configuration](../configuration.md)
- [API reference](../api/index.md)

## Sources
- `Business\SAIF.Business.Policy.Agency\clsAgency.vb`
- `Business\SAIF.Business.Policy.Agency\clsAgencyCollection.vb`
- `Business\SAIF.Business.Policy.Agency\clsAgencyContract.vb`
- `Business\SAIF.Business.Policy.Agency\clsAgencyContractCollection.vb`
- `Business\SAIF.Business.Policy.Agency\clsAgencyOffice.vb`
- `Business\SAIF.Business.Policy.Agency\clsAgencyOfficeCollection.vb`
- `Business\SAIF.Business.Policy.Agency\clsProducer.vb`
- `Business\SAIF.Business.Policy.Agency\clsProducerCollection.vb`