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

# SAIF.Business.Policy SQL catalog

This page indexes the SQL statements and stored-procedure calls used by `SAIF.Business.Policy`.

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-saif-business-policy.md) | Retrieve benefit-jurisdiction code-table entries. | Inline | see SQL page | `clsBenefitJurisdictionCodeMap` |
| [SQL-002](SQL-002-saif-business-policy.md) | Load hazard groups active for a supplied date. | Inline | see SQL page | `clsHazardGroupCollection` |
| [SQL-003](SQL-003-saif-business-policy.md) | Retrieve manual-class-type code-table entries. | Inline | see SQL page | `clsManualClassTypeCodeMap` |
| [SQL-004](SQL-004-saif-business-policy.md) | Retrieve anniversary rate date by policy period. | Inline | see SQL page | N/A (Application layer) |
| [SQL-005](SQL-005-saif-business-policy.md) | Call the submission-ownership Oracle function. | Inline | see SQL page | N/A (Application layer) |
| [SQL-006](SQL-006-saif-business-policy.md) | Find a printed P401 endorsement for the policy period. | Inline | see SQL page | N/A (Application layer) |
| [SQL-007](SQL-007-saif-business-policy.md) | Retrieve the persisted market-type code for a policy. | Inline | see SQL page | N/A (Application layer) |
| [SQL-008](SQL-008-saif-business-policy.md) | Retrieve the maximum period effective date for a policy. | Inline | see SQL page | N/A (Application layer) |
| [SQL-009](SQL-009-saif-business-policy.md) | Retrieve the latest eligible premium-history set. | Inline | see SQL page | N/A (Application layer) |
| [SQL-010](SQL-010-saif-business-policy.md) | Call the Oracle rating package for minimum-premium calculation. | Stored Proc | see SQL page | N/A (Application layer) |
| [SQL-011](SQL-011-saif-business-policy.md) | Retrieve policy-period expiration date by policy and effective date. | Inline | see SQL page | N/A (Application layer) |

## 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)
- [Procedures](../procedures/index.md)

## Sources
- `Business\SAIF.Business.Policy\PolicyInformation.vb`
- `Business\SAIF.Business.Policy\clsHazardGroupCollection.vb`
- `Business\SAIF.Business.Policy\CodeMaps\clsBenefitJurisdictionCodeMap.vb`
- `Business\SAIF.Business.Policy\CodeMaps\clsManualClassTypeCodeMap.vb`