---
title: SAIF.Business.Policy.Rating stored procedures
summary: Oracle stored procedures and package routines referenced by this library.
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Rating
reference_type: package
---

# SAIF.Business.Policy.Rating stored procedures

This page catalogs Oracle stored procedures and package routines invoked by `SAIF.Business.Policy.Rating`.

## Procedure catalog

| Package / Procedure | Schema | Type | Purpose | Calling business objects |
| --- | --- | --- | --- | --- |
| [`pk73059_prem_hist_summary.sp62005_retrieve_rate`](pk73059-prem-hist-summary-sp62005-retrieve-rate.md) | WCIS_DBA | Package procedure | Resolves the applicable manual class, rate, and rate-file sequence number for a rating period. | `clsManualClassBase` |
| [`pk73059_prem_hist_summary.get_applicable_ard`](pk73059-prem-hist-summary-get-applicable-ard.md) | WCIS_DBA | Package helper function | Derives the anniversary-rating date that should govern class lookup. | `clsManualClassBase` |
| [`PK73193_submission.get_rate_file_seq_num`](pk73193-submission-get-rate-file-seq-num.md) | WCIS_DBA | Package function | Returns the active non-outstanding rate file for an anniversary rating date and risk type. | `clsManualClassBaseCollection` |

## Related documentation

- [Business rules](../business-rules.md)
- [Operations and processes](../operations-processes.md)
- [SQL catalog](../sql/index.md)
- [Database tables](../database-tables.md)

## Sources
- Oracle DBA_SOURCE: WCIS_DBA.pk73059_prem_hist_summary
- Oracle DBA_SOURCE: WCIS_DBA.PK73193_submission
- `Business\SAIF.Business.Policy.Rating\clsManualClassBase.vb`
- `Business\SAIF.Business.Policy.Rating\clsManualClassBaseCollection.vb`
