SQL-085: Update Pa Review Result Data

This statement supports the premium-audit library by update Pa Review Result Data.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:ReviewerAuditorID	Input	bound from ReviewerAuditorID	10	Bound in clsAuditReviewResult.BeforeUpdate (line 379)
:ReviewReasonCode	Input	bound from m_ReviewReasonCode	5	Bound in clsAuditReviewResult.BeforeUpdate (line 381)
:ReviewResultCode	Input	bound from m_ReviewResultCode	5	Bound in clsAuditReviewResult.BeforeUpdate (line 382)
:UpdateUser	Input	bound from m_UpdateUser	30	Bound in clsAuditReviewResult.BeforeUpdate (line 383)
:UpdateDate	Input	bound from m_UpdateDate	—	Bound in clsAuditReviewResult.BeforeUpdate (line 384)
:UpdateSeqNum	Input	bound from UpdateSeqNum	—	Bound in clsAuditReviewResult.BeforeUpdate (line 380)
:ReviewResultSeqNum	Input	bound from ReviewResultSeqNum	—	Bound in clsAuditReviewResult.BeforeUpdate (line 387)

Tables

Table	Access	Columns used
PA_REVIEW_RESULT	UPDATE	See sample SQL.

Sample SQL

UPDATE
  PA_REVIEW_RESULT
SET
  REVIEWER_AUDITOR_ID = :ReviewerAuditorID,
  PA_REVIEW_REASON_CODE = :ReviewReasonCode,
  PA_REVIEW_RESULT_CODE = :ReviewResultCode,
  UPDATE_USER = :UpdateUser,
  UPDATE_DATE = :UpdateDate,
  UPDATE_SEQ_NUM = :UpdateSeqNum + 1
WHERE
  PA_REVIEW_RESULT.PA_REVIEW_RESULT_SEQ_NUM = :ReviewResultSeqNum
  AND pa_review_result.update_seq_num = :UpdateSeqNum

Operations and processes

• Select policies for premium audit (batch/expiring)
• Save a premium audit

Business rules

• BR-031
• BR-070

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/clsAuditReviewResult.vb:704