SQL-004: Insert auditor zip code¶

Inserts a single auditor-to-zip-code geographic assignment record into PA_AUDITOR_ZIP_CODE.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:PAAuditorID`	Input	Decimal	N/A	Auditor primary key.
`:ZipCode`	Input	String	5	Zip code to assign to this auditor.

Tables¶

Table	Access	Columns used
PA_AUDITOR_ZIP_CODE	INSERT	`PA_AUDITOR_ID`, `ZIP_CODE`

Sample SQL¶

INSERT INTO PA_AUDITOR_ZIP_CODE (PA_AUDITOR_ID, ZIP_CODE)
VALUES (:PAAuditorID, :ZipCode)

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