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

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

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