SQL-014: Insert Pa Review Result Data

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

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:ReviewResultSequenceNumber	Input	bound from ReviewResultSeqNum	—	Bound in clsAuditReviewResult.BeforeInsert (line 315)
:AuditSeqNum	Input	bound from AuditSeqNum	—	Bound in clsAuditReviewResult.BeforeInsert (line 316)
:ReviewerAuditorID	Input	bound from ReviewerAuditorID	10	Bound in clsAuditReviewResult.BeforeInsert (line 317)
:ReviewReasonCode	Input	bound from m_ReviewReasonCode	5	Bound in clsAuditReviewResult.BeforeInsert (line 321)
:ReviewResultCode	Input	bound from m_ReviewResultCode	5	Bound in clsAuditReviewResult.BeforeInsert (line 322)
:CreateUser	Input	bound from CreateUser	30	Bound in clsAuditReviewResult.BeforeInsert (line 318)
:CreateDate	Input	bound from CreateDate	—	Bound in clsAuditReviewResult.BeforeInsert (line 319)
:UpdateUser	Input	bound from m_UpdateUser	30	Bound in clsAuditReviewResult.BeforeInsert (line 323)
:UpdateDate	Input	bound from m_UpdateDate	—	Bound in clsAuditReviewResult.BeforeInsert (line 324)
:UpdateSeqNum	Input	bound from UpdateSeqNum	—	Bound in clsAuditReviewResult.BeforeInsert (line 320)

Tables

Table	Access	Columns used
PA_REVIEW_RESULT	INSERT	See sample SQL.

Sample SQL

INSERT INTO
  PA_REVIEW_RESULT
  (
    PA_REVIEW_RESULT_SEQ_NUM,
    PA_AUDIT_SEQ_NUM,
    REVIEWER_AUDITOR_ID,
    PA_REVIEW_REASON_CODE,
    PA_REVIEW_RESULT_CODE,
    CREATE_USER,
    CREATE_DATE,
    UPDATE_USER,
    UPDATE_DATE,
    UPDATE_SEQ_NUM
  )
VALUES
  (
    :ReviewResultSequenceNumber,
    :AuditSeqNum,
    :ReviewerAuditorID,
    :ReviewReasonCode,
    :ReviewResultCode,
    :CreateUser,
    :CreateDate,
    :UpdateUser,
    :UpdateDate,
    :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:655