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

# SAIF.Business.Policy.Audit.Premium stored procedures

This page catalogs Oracle stored procedures and packages invoked by this library.

## Procedure catalog

| Package / Procedure | Schema | Type | Purpose | Calling business objects |
| --- | --- | --- | --- | --- |
| [`pk73211_premium_audit.GetExpiringPolicies`](pk73211-premium-audit-getexpiringpolicies.md) | `WCIS_DBA` | Package procedure (ref cursor out) | Opens a ref cursor of policy periods expiring on a given date, tagged `'EXP'`, excluding cancelled and pending periods | `clsAuditSelectionPolicyPeriod`, `clsAuditSelectionPolicyPeriodCollection` |
| [`pk73211_premium_audit.GetOffCyclePolicies`](pk73211-premium-audit-getoffcyclepolicies.md) | `WCIS_DBA` | Package procedure (ref cursor out) | Unions four candidate populations — new-business `P401` endorsements, batch payroll audits, leasing-parent payroll audits and 15-day-delayed mid-term cancellations — into one ref cursor | `clsAuditSelectionPolicyPeriod`, `clsAuditSelectionPolicyPeriodCollection` |
| [`pk73211_premium_audit.GetAuditLocationSeqNum`](pk73211-premium-audit-getauditlocationseqnum.md) | `WCIS_DBA` | Package function | Picks the single best visitable location for an audit — AUD, then PAY, then POL, then primary BUS — rejecting expired locations and post-office boxes | `clsAudit`, `clsAuditCollection` |
| [`pk73211_premium_audit.get_ending_er_mod_for_pol_per`](pk73211-premium-audit-get-ending-er-mod-for-pol-per.md) | `WCIS_DBA` | Package function | Returns the ERP rating-plan factor in force on the last day of audited coverage, or the neutral `1.0` | `clsAuditPolicyPeriod` |
| [`pk73211_premium_audit.get_current_premium`](pk73211-premium-audit-get-current-premium.md) | `WCIS_DBA` | Package function | Nets `NEAP` base amounts against `DCBS` difference amounts over the newest premium-history set | `clsAuditPolicyPeriod` |
| [`pk73211_premium_audit.get_payroll_classes`](pk73211-premium-audit-get-payroll-classes.md) | `WCIS_DBA` | Package procedure (ref cursor out) | Opens a ref cursor of distinct four-digit manual class numbers and their rates from the newest premium-history set | `clsAuditPolicyPeriod` |
| [`pk73211_premium_audit.insert_pol_per_payroll_audit`](pk73211-premium-audit-insert-pol-per-payroll-audit.md) | `WCIS_DBA` | Package function (remote wrapper `@POLDB`) | Remote-only wrapper: forwards policy number, period effective date, last date of coverage, revision flag and due date to the policy database and returns the new payroll sequence number | `clsAuditPolicyPeriod` |
| [`pk73211_premium_audit.cancel_pol_per_payroll_audit`](pk73211-premium-audit-cancel-pol-per-payroll-audit.md) | `WCIS_DBA` | Package function (remote wrapper `@POLDB`) | Remote-only wrapper: forwards the payroll sequence number to the policy database | `clsAuditPolicyPeriod` |
| [`pk73211_premium_audit.generate_wcis_audit_documents`](pk73211-premium-audit-generate-wcis-audit-documents.md) | `WCIS_DBA` | Package procedure (remote wrapper `@POLDB`) | Remote-only wrapper: forwards the audit sequence number and revision indicator to the policy database, which produces the audit endorsement/document set | `clsAudit` |
| [`pk72846_view_policy.sp73111_get_wcis_std_premium`](pk72846-view-policy-sp73111-get-wcis-std-premium.md) | `WCIS_DBA` | Package function | Resolves the newest premium-history set for the policy period and returns its standard premium | `clsAuditPolicyPeriod` |
| [`pk73057_billing_master.is_on_arrears_plan`](pk73057-billing-master-is-on-arrears-plan.md) | `WCIS_DBA` | Package function | Walks billing master → billing defaults → payment plan type and reports `'Y'` unless the plan generates instalment or pre-pay billing | `clsAuditPolicyCollection` |
| [`pk73211_premium_audit.get_auditable_policy_periods`](pk73211-premium-audit-get-auditable-policy-periods.md) | *(unknown)* | Package procedure (assumed ref cursor out) | Oracle procedure/package referenced by the library; not found in Oracle or SQL Server (re-checked 2026-08-17). | `clsAuditablePeriodCollection` |
| [`pk73211_premium_audit.get_claim_for_0_payroll_count`](pk73211-premium-audit-get-claim-for-0-payroll-count.md) | *(unknown)* | Package function (assumed) | Oracle procedure/package referenced by the library; not found in Oracle or SQL Server (re-checked 2026-08-17). | `clsAuditPolicyPeriod` |
| [`sp72658_get_gov_class`](sp72658-get-gov-class.md) | *(unknown; standalone)* | Standalone function (assumed) | Oracle procedure/package referenced by the library; not found in Oracle or SQL Server (re-checked 2026-08-17). | `clsAuditPolicyPeriod` |

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

> **Note:** Statements marked with * were inferred from code structure, naming conventions, or
> contextual evidence where direct confirmation was not available in source artifacts. Statements
> marked with ** could not be confirmed; treat as unknown until verified.

## Sources
- `Business\SAIF.Business.Policy.Audit.Premium\clsAuditSelectionPolicyPeriod.vb`
- `Business\SAIF.Business.Policy.Audit.Premium\clsAuditSelectionPolicyPeriodCollection.vb`
- `Business\SAIF.Business.Policy.Audit.Premium\clsAudit.vb`
- `Business\SAIF.Business.Policy.Audit.Premium\clsAuditCollection.vb`
- `Business\SAIF.Business.Policy.Audit.Premium\clsAuditPolicyPeriod.vb`
- `Business\SAIF.Business.Policy.Audit.Premium\clsAuditPolicyCollection.vb`
- `Business\SAIF.Business.Policy.Audit.Premium\clsAuditablePeriodCollection.vb`
- Individual procedure pages listed in the catalog above, each citing its own Oracle/`DBA_SOURCE` or referencing-code evidence