SQL-077: Update Pa Assign Override Data

This statement supports the premium-audit library by update Pa Assign Override Data.

Classification

Field	Value
SQL ID	SQL-077
Operation type	Update
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsAuditAssignmentOverride
Criteria property	UpdateSQL
Lifecycle method	BeforeUpdate / AfterUpdate

Parameters

Parameter	Direction	Type	Max length	Description
:DefaultAuditorID	Input	bound from m_DefaultAuditorID	10	Bound in clsAuditAssignmentOverride.BeforeUpdate (line 311)
:DoNotAssignAuditorID	Input	bound from m_DoNotAssignAuditorID	10	Bound in clsAuditAssignmentOverride.BeforeUpdate (line 312)
:UpdateUser	Input	bound from m_UpdateUser	30	Bound in clsAuditAssignmentOverride.BeforeUpdate (line 313)
:UpdateDate	Input	bound from m_UpdateDate	—	Bound in clsAuditAssignmentOverride.BeforeUpdate (line 314)
:PolicyNumber	Input	bound from MyCriteria.PolicyNumber	—	Bound in clsAuditAssignmentOverride.BeforeUpdate (line 317)

Tables

Table	Access	Columns used
PA_ASSIGN_OVERRIDE	UPDATE	See sample SQL.

Sample SQL

UPDATE
  PA_ASSIGN_OVERRIDE
SET
  DEFAULT_PA_AUDITOR_ID = :DefaultAuditorID,
  DONOT_ASSIGN_PA_AUDITOR_ID = :DoNotAssignAuditorID,
  UPDATE_USER = :UpdateUser,
  UPDATE_DATE = :UpdateDate,
  UPDATE_SEQ_NUM = UPDATE_SEQ_NUM + 1
WHERE
  POLICY_NUM = :PolicyNumber

Operations and processes

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

Business rules

• BR-015
• BR-019
• BR-064
• BR-065
• BR-066

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/clsAuditAssignmentOverride.vb:576