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

# SAIF.Business.Policy.Rating SQL catalog

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

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-010](SQL-010-saif-business-policy-rating.md) | Retrieve clsDTECRate data | Inline | DTEC_RATE | `clsDTECRate` |
| [SQL-011](SQL-011-saif-business-policy-rating.md) | Retrieve clsEmployeeRatingType data | Inline | EMPLOYEE_RATING_TYPE_CODE | `clsEmployeeRatingType` |
| [SQL-012](SQL-012-saif-business-policy-rating.md) | Retrieve clsFederalCoverageLiabilityLimit data | Inline | FED_COVERAGE_LIABILITY_LIMIT | `clsFederalCoverageLiabilityLimit` |
| [SQL-013](SQL-013-saif-business-policy-rating.md) | Retrieve clsFederalCoverageLiabilityLimitCollection data | Inline | FED_COVERAGE_LIABILITY_LIMIT | `clsFederalCoverageLiabilityLimitCollection` |
| [SQL-014](SQL-014-saif-business-policy-rating.md) | Retrieve clsFederalCoverageTypeCode data | Inline | FED_COVERAGE_TYPE_CODE | `clsFederalCoverageTypeCode` |
| [SQL-015](SQL-015-saif-business-policy-rating.md) | Retrieve clsManualClassAssociation data | Inline | MANUAL_CLASS_ASSOCIATION | `clsManualClassAssociation` |
| [SQL-016](SQL-016-saif-business-policy-rating.md) | Retrieve clsManualClassAssociationCollection data | Inline | MANUAL_CLASS_ASSOCIATION | `clsManualClassAssociationCollection` |
| [SQL-017](SQL-017-saif-business-policy-rating.md) | Check premium-history references before class delete | Inline | PREM_HIST_CLASS_COVERAGE | `clsManualClassBase` |
| [SQL-018](SQL-018-saif-business-policy-rating.md) | Retrieve active class paragraph text | Inline | MANUAL_CLASS_PARAGRAPH_USAGE, MANUAL_CLASS_PARAGRAPH | `clsManualClassBase` |
| [SQL-019](SQL-019-saif-business-policy-rating.md) | Resolve manual class and filing through stored procedure | Stored Proc | N/A | `clsManualClassBase` |
| [SQL-020](SQL-020-saif-business-policy-rating.md) | Retrieve clsManualClassBase data | Inline | MANUAL_CLASS_BASE | `clsManualClassBase` |
| [SQL-021](SQL-021-saif-business-policy-rating.md) | Resolve active rate file sequence number | Stored Proc | N/A | `clsManualClassBaseCollection` |
| [SQL-022](SQL-022-saif-business-policy-rating.md) | Retrieve clsManualClassBaseCollection data | Inline | MANUAL_CLASS_BASE, MANUAL_CLASS_DETAIL | `clsManualClassBaseCollection` |
| [SQL-023](SQL-023-saif-business-policy-rating.md) | Retrieve clsManualClassParagraph data | Inline | MANUAL_CLASS_PARAGRAPH | `clsManualClassParagraph` |
| [SQL-024](SQL-024-saif-business-policy-rating.md) | Retrieve clsManualClassParagraphUsage data | Inline | MANUAL_CLASS_PARAGRAPH_USAGE | `clsManualClassParagraphUsage` |
| [SQL-025](SQL-025-saif-business-policy-rating.md) | Retrieve clsManualClassParagraphUsageCollection data | Inline | MANUAL_CLASS_PARAGRAPH_USAGE | `clsManualClassParagraphUsageCollection` |
| [SQL-026](SQL-026-saif-business-policy-rating.md) | Retrieve clsManualClassType data | Inline | MANUAL_CLASS_TYPE_CODE | `clsManualClassType` |
| [SQL-027](SQL-027-saif-business-policy-rating.md) | Retrieve period rating context from WCIS and legacy tables | Inline | POLICY, POLICY_PERIOD, POLICY_PERIOD_NON_WCIS | `clsPeriodRatingInfo` |
| [SQL-028](SQL-028-saif-business-policy-rating.md) | Retrieve clsPremiumSizeDiscount data | Inline | PREMIUM_DISCOUNT_RANGE | `clsPremiumSizeDiscount` |
| [SQL-029](SQL-029-saif-business-policy-rating.md) | Retrieve clsPrepayDiscountFactor data | Inline | PREPAY_DISCOUNT_FACTOR | `clsPrepayDiscountFactor` |
| [SQL-030](SQL-030-saif-business-policy-rating.md) | Retrieve clsPrepayDiscountFactorCollection data | Inline | PREPAY_DISCOUNT_FACTOR | `clsPrepayDiscountFactorCollection` |
| [SQL-031](SQL-031-saif-business-policy-rating.md) | Retrieve clsPrepayFrequency data | Inline | PREPAY_FREQUENCY_CODE | `clsPrepayFrequency` |
| [SQL-032](SQL-032-saif-business-policy-rating.md) | Check whether rate file still has manual classes | Inline | MANUAL_CLASS_BASE | `clsRateFileMaster` |
| [SQL-033](SQL-033-saif-business-policy-rating.md) | Retrieve clsRateFileMaster data | Inline | RATE_FILE_MASTER | `clsRateFileMaster` |
| [SQL-034](SQL-034-saif-business-policy-rating.md) | Retrieve clsRateFileMasterCollection data | Inline | RATE_FILE_MASTER | `clsRateFileMasterCollection` |
| [SQL-035](SQL-035-saif-business-policy-rating.md) | Retrieve clsRateTier data | Inline | RISK_TYPE_CODE | `clsRateTier` |
| [SQL-036](SQL-036-saif-business-policy-rating.md) | Retrieve clsRateTierCollection data | Inline | RISK_TYPE_CODE | `clsRateTierCollection` |
| [SQL-037](SQL-037-saif-business-policy-rating.md) | Retrieve clsRateTierFactor data | Inline | RISK_TYPE_DESCRIPTION | `clsRateTierFactor` |
| [SQL-038](SQL-038-saif-business-policy-rating.md) | Retrieve clsRatingPlanCode data | Inline | RATING_PLAN_CODE | `clsRatingPlanCode` |
| [SQL-039](SQL-039-saif-business-policy-rating.md) | Retrieve clsRatingPlanFactor data | Inline | RATING_PLAN_FACTOR | `clsRatingPlanFactor` |
| [SQL-040](SQL-040-saif-business-policy-rating.md) | Retrieve clsRatingPlanFactorCollection data | Inline | RATING_PLAN_FACTOR | `clsRatingPlanFactorCollection` |
| [SQL-041](SQL-041-saif-business-policy-rating.md) | Retrieve clsRatingPlanTypeCode data | Inline | RATING_PLAN_TYPE_CODE | `clsRatingPlanTypeCode` |
| [SQL-042](SQL-042-saif-business-policy-rating.md) | Retrieve clsSAIFPlusDiscount data | Inline | SAIFPLUS_DISCOUNT | `clsSAIFPlusDiscount` |
| [SQL-043](SQL-043-saif-business-policy-rating.md) | Retrieve clsStatPremiumClass data | Inline | STAT_PREMIUM_CLASS | `clsStatPremiumClass` |
| [SQL-044](SQL-044-saif-business-policy-rating.md) | Retrieve clsStatPremiumClassCollection data | Inline | STAT_PREMIUM_CLASS | `clsStatPremiumClassCollection` |
| [SQL-045](SQL-045-saif-business-policy-rating.md) | Retrieve clsTerrorismRate data | Inline | TERRORISM_RATE | `clsTerrorismRate` |
| [SQL-046](SQL-046-saif-business-policy-rating.md) | Retrieve effective USL&HW compensation factor | Inline | USLHW_COMP_FACTOR | `clsUSLHWCompFactor` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-047](SQL-047-saif-business-policy-rating.md) | Update clsManualClassAssociation row | Inline | MANUAL_CLASS_ASSOCIATION | `clsManualClassAssociation` |
| [SQL-048](SQL-048-saif-business-policy-rating.md) | Update clsManualClassBase row | Inline | MANUAL_CLASS_BASE | `clsManualClassBase` |
| [SQL-049](SQL-049-saif-business-policy-rating.md) | Update clsManualClassDetail row | Inline | MANUAL_CLASS_DETAIL | `clsManualClassDetail` |
| [SQL-050](SQL-050-saif-business-policy-rating.md) | Update clsManualClassParagraph row | Inline | MANUAL_CLASS_PARAGRAPH | `clsManualClassParagraph` |
| [SQL-051](SQL-051-saif-business-policy-rating.md) | Update clsManualClassParagraphUsage row | Inline | MANUAL_CLASS_PARAGRAPH_USAGE | `clsManualClassParagraphUsage` |
| [SQL-052](SQL-052-saif-business-policy-rating.md) | Update prepay frequency code row (compiled SQL is incomplete) | Inline | PREPAY_FREQUENCY_CODE | `clsPrepayFrequencyCodeCollection` |
| [SQL-053](SQL-053-saif-business-policy-rating.md) | Update clsRateFileMaster row | Inline | RATE_FILE_MASTER | `clsRateFileMaster` |
| [SQL-054](SQL-054-saif-business-policy-rating.md) | Update clsStatPremiumClass row | Inline | STAT_PREMIUM_CLASS | `clsStatPremiumClass` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-055](SQL-055-saif-business-policy-rating.md) | Delete clsManualClassAssociation row | Inline | MANUAL_CLASS_ASSOCIATION | `clsManualClassAssociation` |
| [SQL-056](SQL-056-saif-business-policy-rating.md) | Delete clsManualClassBase row | Inline | MANUAL_CLASS_BASE | `clsManualClassBase` |
| [SQL-057](SQL-057-saif-business-policy-rating.md) | Bulk delete manual class bases by rate file | Inline | MANUAL_CLASS_BASE | `clsManualClassBaseCollection` |
| [SQL-058](SQL-058-saif-business-policy-rating.md) | Delete clsManualClassDetail row | Inline | MANUAL_CLASS_DETAIL | `clsManualClassDetail` |
| [SQL-059](SQL-059-saif-business-policy-rating.md) | Delete clsManualClassParagraph row | Inline | MANUAL_CLASS_PARAGRAPH | `clsManualClassParagraph` |
| [SQL-060](SQL-060-saif-business-policy-rating.md) | Delete clsManualClassParagraphUsage row | Inline | MANUAL_CLASS_PARAGRAPH_USAGE | `clsManualClassParagraphUsage` |
| [SQL-061](SQL-061-saif-business-policy-rating.md) | Delete clsRateFileMaster row | Inline | RATE_FILE_MASTER | `clsRateFileMaster` |
| [SQL-062](SQL-062-saif-business-policy-rating.md) | Delete clsStatPremiumClass row | Inline | STAT_PREMIUM_CLASS | `clsStatPremiumClass` |

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-saif-business-policy-rating.md) | Fetch next manual class paragraph number token | DUAL | DUAL | `clsManualClassParagraph` |
| [SQL-002](SQL-002-saif-business-policy-rating.md) | Fetch next rate file sequence number | DUAL | DUAL | `clsRateFileMaster` |

## 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)

## Sources
- `Business\SAIF.Business.Policy.Rating\clsManualClassAssociation.vb`
- `Business\SAIF.Business.Policy.Rating\clsManualClassBase.vb`
- `Business\SAIF.Business.Policy.Rating\clsManualClassBaseCollection.vb`
- `Business\SAIF.Business.Policy.Rating\clsManualClassDetail.vb`
- `Business\SAIF.Business.Policy.Rating\clsManualClassParagraph.vb`
- `Business\SAIF.Business.Policy.Rating\clsManualClassParagraphUsage.vb`
- `Business\SAIF.Business.Policy.Rating\clsPeriodRatingInfo.vb`
- `Business\SAIF.Business.Policy.Rating\clsPrepayFrequencyCollection.vb`
- `Business\SAIF.Business.Policy.Rating\clsRateFileMaster.vb`
- `Business\SAIF.Business.Policy.Rating\clsStatPremiumClass.vb`