SQL-002: Insert audit assignment override

Inserts a new policy-level audit assignment override record into PA_ASSIGN_OVERRIDE, specifying the default auditor and the do-not-assign auditor for a given policy number. Enforces BR-EU-03 (the two auditor IDs must differ) before this insert is reached.*

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:PolicyNumber	Input	Decimal	10	Policy number for the override.
:DefaultAuditorID	Input	Decimal	N/A	ID of the default preferred auditor.
:DoNotAssignAuditorID	Input	Decimal	N/A	ID of the auditor who must not be assigned.
:CreateUser	Input	String	30	Username creating the record.
:CreateDate	Input	DateTime	N/A	Date the record was created.

Tables

Table	Access	Columns used
PA_ASSIGN_OVERRIDE	INSERT	POLICY_NUM, DEFAULT_PA_AUDITOR_ID, DONOT_ASSIGN_PA_AUDITOR_ID, CREATE_USER, CREATE_DATE

Sample SQL

INSERT INTO PA_ASSIGN_OVERRIDE
VALUES (:PolicyNumber, :DefaultAuditorID, :DoNotAssignAuditorID, :CreateUser, :CreateDate, null, null, 0)

Operations and processes

• Auditor assignment / override

Business rules

• BR-EU-03: Audit-assignment auditor distinctness

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\clsAuditAssignmentOverride.vb