---
title: "pk73211_premium_audit.insert_pol_per_payroll_audit stored procedure documentation"
summary: "Analysis of Oracle package/procedure including business rules and operations."
status: draft
owner: "Technical Writer"
last_reviewed: "2026-07-31"
library: SAIF.Business.Policy.Audit.Premium
reference_type: package
source_schema: "`WCIS_DBA`"
source_name: "pk73211_premium_audit.insert_pol_per_payroll_audit"
source_type: "Package function (remote wrapper `@POLDB`)"
oracle_status: "found"
---

# pk73211_premium_audit.insert_pol_per_payroll_audit

## Overview

| Field | Value |
| --- | --- |
| **Schema** | `WCIS_DBA` |
| **Type** | Package function (remote wrapper `@POLDB`) |
| **Database** | Oracle / WCIS |
| **Calling libraries** | `SAIF.Business.Policy.Audit.Premium` |
| **Calling classes** | `clsAuditPolicyPeriod` |

## Purpose

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

## Procedures / Methods

### insert_pol_per_payroll_audit

| Field | Value |
| --- | --- |
| **Returns** | See Oracle signature / caller behavior |
| **Called by** | `InsertPolicyPeriodPayrollAudit` (SQL-010) |

**Description:** 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

## Business Rules

| Rule ID | Rule | Condition | Action |
| --- | --- | --- | --- |
| PROC-RULE-034 | Payroll-audit creation is **not** performed locally | Always | The body is a single `RETURN WCIS_DBA.PK73211_PREMIUM_AUDIT.INSERT_POL_PER_PAYROLL_AUDIT@POLDB(...)` — the local declarations `v_original_billed_count` / `v_original_unbilled_count` are dead |

## Operations

| Operation | Description | Trigger |
| --- | --- | --- |
| Create a payroll audit on the policy system | 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.InsertPolicyPeriodPayrollAudit` (SQL-010); OP-009 |

## Source Code

<details>
<summary>PL/SQL package or method excerpt</summary>

```sql
   FUNCTION insert_pol_per_payroll_audit(
      in_policynumber                IN policy_period_payroll_audit.policy_num%TYPE
    , in_policyperiodeffectivedate   IN policy_period_payroll_audit.policy_period_eff_date%TYPE
    , in_lastdateofcoverage          IN policy_period_payroll_audit.audit_period_end_date%TYPE
    , in_revisionflag                IN VARCHAR2
    , in_duedate                     IN policy_period_payroll_audit.due_date%TYPE)
      RETURN policy_period_payroll_audit.payroll_seq_num%TYPE
   IS
      v_payrollsequencenumber     policy_period_payroll_audit.payroll_seq_num%TYPE;
      v_original_billed_count     PLS_INTEGER := 0;
      v_original_unbilled_count   PLS_INTEGER := 0;

    BEGIN
       RETURN WCIS_DBA.PK73211_PREMIUM_AUDIT.INSERT_POL_PER_PAYROLL_AUDIT@POLDB(
         in_policynumber,
         in_policyperiodeffectivedate,
         in_lastdateofcoverage,
         in_revisionflag,
         in_duedate);
    END insert_pol_per_payroll_audit;

   /********************************************************************
   | Name             : cancel_pol_per_payroll_audit
   | Prepared By      : carade
   | Created          : 09/18/2008
   | Description      : Cancel a non billed payroll audit.
   | Modification History
   | ------------------------------------------------------------------*/
```

</details>

## Related documentation
- [Procedure catalog](index.md)
- [Business rules](../business-rules.md)
- [Operations and processes](../operations-processes.md)
- [SQL catalog](../sql/index.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
- Oracle DBA_SOURCE: pk73211_premium_audit.insert_pol_per_payroll_audit
- Calling code: ``analysis\oracle-source\pk73211_premium_audit.sql`; `clsAuditPolicyPeriod.vb`