SQL-008: Insert Pa Auditor Data

This statement supports the premium-audit library by insert Pa Auditor Data.

Classification

Field	Value
SQL ID	SQL-008
Operation type	Insert
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsAuditor
Criteria property	InsertSQL
Lifecycle method	BeforeInsert / AfterInsert

Parameters

Parameter	Direction	Type	Max length	Description
:AssignFlag	Input	bound from m_AssignFlag	1	Bound in clsAuditor.BeforeInsert (line 433)
:AuditorAssigneeID	Input	bound from m_AuditorAssigneeID	10	Bound in clsAuditor.BeforeInsert (line 438)
:AuditorEmailAddr	Input	bound from m_AuditorEmailAddr	40	Bound in clsAuditor.BeforeInsert (line 439)
:AuditorName	Input	bound from AuditorName	65	Bound in clsAuditor.BeforeInsert (line 434)
:AuditorShortName	Input	bound from AuditorShortName	20	Bound in clsAuditor.BeforeInsert (line 435)
:FilterListFlag	Input	bound from m_FilterListFlag	1	Bound in clsAuditor.BeforeInsert (line 436)
:MonthlyMaximumCount	Input	bound from m_MonthlyMaximumCount	—	Bound in clsAuditor.BeforeInsert (line 440)
:AuditorID	Input	bound from Me.AuditorID	10	Bound in clsAuditor.BeforeInsert (line 447)
:ScheduleFlag	Input	bound from m_ScheduleFlag	1	Bound in clsAuditor.BeforeInsert (line 437)
:UserID	Input	bound from m_UserID	30	Bound in clsAuditor.BeforeInsert (line 441)
:VendorNumber	Input	bound from m_VendorNumber	9	Bound in clsAuditor.BeforeInsert (line 442)
:ReviewerFlag	Input	bound from m_ReviewerFlag	—	Bound in clsAuditor.BeforeInsert (line 443)
:ActiveReviewerFlag	Input	bound from m_ActiveReviewerFlag	—	Bound in clsAuditor.BeforeInsert (line 444)

Tables

Table	Access	Columns used
PA_AUDITOR	INSERT	See sample SQL.

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

• Assign renewal (batch) audits to auditors
• Assign off-cycle audits to auditors
• Assign an audit to an auditor

Business rules

• BR-014
• BR-018
• BR-055

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.Policy.Audit.Premium/clsAuditor.vb:796