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	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¶

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

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