---
title: "SQL-003: Insert auditor"
summary: Inserts a new premium auditor record into PA_AUDITOR.
status: draft
owner: <owner>
last_reviewed: 2026-07-24
library: SAIF.Business.External.Users
reference_type: package
---

# SQL-003: Insert auditor

Inserts a new premium auditor record into `PA_AUDITOR` with all scheduling, filtering, and reviewer designation columns.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-003 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | Text |
| **Business object** | `clsAuditor` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | `BeforeInsert` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:AssignFlag` | Input | String | 1 | Controls availability for audit assignment. |
| `:AuditorAssigneeID` | Input | Decimal | N/A | ID of the linked assignee. |
| `:AuditorEmailAddr` | Input | String | 65 | Auditor email address. |
| `:AuditorName` | Input | String | 40 | Full auditor name. |
| `:AuditorShortName` | Input | String | 20 | Abbreviated auditor name. |
| `:FilterListFlag` | Input | String | 1 | Filter list membership flag. |
| `:MonthlyMaximumCount` | Input | Decimal | N/A | Maximum monthly audit assignments. |
| `:AuditorID` | Input | Decimal | N/A | Auditor primary key (from SQL-001). |
| `:ScheduleFlag` | Input | String | 1 | Scheduling eligibility flag. |
| `:UserID` | Input | String | 30 | AD user ID of the auditor. |
| `:VendorNumber` | Input | String | 9 | Vendor number. |
| `:ReviewerFlag` | Input | String | 1 | Reviewer designation flag. |
| `:ActiveReviewerFlag` | Input | String | 1 | Active reviewer status flag. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [PA_AUDITOR](../database-tables.md#pa_auditor) | INSERT | `ASSIGN_FLAG`, `AUDITOR_ASSIGNEE_ID`, `AUDITOR_EMAIL_ADDR`, `AUDITOR_NAME`, `AUDITOR_SHORT_NAME`, `FILTER_LIST_FLAG`, `MONTHLY_MAXIMUM_COUNT`, `PA_AUDITOR_ID`, `SCHEDULE_FLAG`, `USER_ID`, `VENDOR_NUM`, `REVIEWER_FLAG`, `ACTIVE_REVIEWER_FLAG` |

## Sample SQL

```sql
INSERT INTO PA_AUDITOR (
    ASSIGN_FLAG, AUDITOR_ASSIGNEE_ID, AUDITOR_EMAIL_ADDR, AUDITOR_NAME,
    AUDITOR_SHORT_NAME, FILTER_LIST_FLAG, MONTHLY_MAXIMUM_COUNT, PA_AUDITOR_ID,
    SCHEDULE_FLAG, USER_ID, VENDOR_NUM, REVIEWER_FLAG, ACTIVE_REVIEWER_FLAG
)
VALUES (
    :AssignFlag, :AuditorAssigneeID, :AuditorEmailAddr, :AuditorName,
    :AuditorShortName, :FilterListFlag, :MonthlyMaximumCount, :AuditorID,
    :ScheduleFlag, :UserID, :VendorNumber, :ReviewerFlag, :ActiveReviewerFlag
)
```

## Operations and processes
- [Auditor assignment / override](../operations/auditor-assignment-override.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.External.Users\clsAuditor.vb`