---
title: "SQL-043: clsAuditor"
summary: Update statement for clsAuditor.
status: draft
owner: <owner>
last_reviewed: 2026-07-24
library: SAIF.Business.External.Users
reference_type: package
---

# SQL-043: clsAuditor

Updates all editable fields of an existing premium auditor record in `PA_AUDITOR`, identified by auditor ID.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-043 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | Text |
| **Business object** | `clsAuditor` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:AssignFlag` | Input | String | 1 | Assignment availability flag. |
| `:AuditorAssigneeID` | Input | Decimal | N/A | Linked assignee ID. |
| `:AuditorEmailAddr` | Input | String | 65 | Auditor email address. |
| `:AuditorName` | Input | String | 40 | Full auditor name. |
| `:AuditorShortName` | Input | String | 20 | Abbreviated name. |
| `:FilterListFlag` | Input | String | 1 | Filter list membership flag. |
| `:MonthlyMaximumCount` | Input | Decimal | N/A | Max monthly assignments. |
| `:ScheduleFlag` | Input | String | 1 | Scheduling eligibility flag. |
| `:UserID` | Input | String | 30 | AD user ID. |
| `:VendorNumber` | Input | String | 9 | Vendor number. |
| `:ReviewerFlag` | Input | String | 1 | Reviewer flag. |
| `:ActiveReviewerFlag` | Input | String | 1 | Active reviewer flag. |
| `:AuditorID` | Input | Decimal | N/A | Primary key for the WHERE clause. |

## Tables

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

## Sample SQL

```sql
UPDATE PA_AUDITOR
SET ASSIGN_FLAG = :AssignFlag,
    AUDITOR_ASSIGNEE_ID = :AuditorAssigneeID,
    AUDITOR_EMAIL_ADDR = :AuditorEmailAddr,
    AUDITOR_NAME = :AuditorName,
    AUDITOR_SHORT_NAME = :AuditorShortName,
    FILTER_LIST_FLAG = :FilterListFlag,
    MONTHLY_MAXIMUM_COUNT = :MonthlyMaximumCount,
    SCHEDULE_FLAG = :ScheduleFlag,
    USER_ID = :UserID,
    VENDOR_NUM = :VendorNumber,
    REVIEWER_FLAG = :ReviewerFlag,
    ACTIVE_REVIEWER_FLAG = :ActiveReviewerFlag
WHERE PA_AUDITOR.PA_AUDITOR_ID = :AuditorID
```

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