SQL-082: Update Pa Policy Period Data

This statement supports the premium-audit library by update Pa Policy Period Data.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:PolicyPeriodExpirationDate	Input	bound from PolicyPeriodExpirationDate	—	Bound in clsAuditPolicyPeriod.BeforeUpdate (line 524)
:CancelDate	Input	bound from m_CancelDate	—	Bound in clsAuditPolicyPeriod.BeforeUpdate (line 525)
:AfterAuditStdPremAmount	Input	bound from m_AfterAuditStdPremAmount	—	Bound in clsAuditPolicyPeriod.BeforeUpdate (line 521)
:BeforeAuditStdPremAmount	Input	bound from m_BeforeAuditStdPremAmount	—	Bound in clsAuditPolicyPeriod.BeforeUpdate (line 522)
:WaiverAmount	Input	bound from m_WaiverAmount	—	Bound in clsAuditPolicyPeriod.BeforeUpdate (line 523)
:PayrollSequenceNumber	Input	bound from m_PayrollSequenceNumber	—	Bound in clsAuditPolicyPeriod.BeforeUpdate (line 526)
:UpdateDate	Input	bound from UpdateDate	—	Bound in clsAuditPolicyPeriod.BeforeUpdate (line 527)
:UpdateUser	Input	bound from UpdateUser	30	Bound in clsAuditPolicyPeriod.BeforeUpdate (line 528)
:AuditSequenceNumber	Input	bound from AuditSequenceNumber	—	Bound in clsAuditPolicyPeriod.BeforeUpdate (line 532)
:PolicyNumber	Input	bound from PolicyNumber	—	Bound in clsAuditPolicyPeriod.BeforeUpdate (line 533)
:PolicyPeriodEffectiveDate	Input	bound from PolicyPeriodEffectiveDate	—	Bound in clsAuditPolicyPeriod.BeforeUpdate (line 534)
:UpdateSequenceNumber	Input	bound from UpdateSequenceNumber	—	Bound in clsAuditPolicyPeriod.BeforeUpdate (line 529)

Tables

Table	Access	Columns used
PA_POLICY_PERIOD	UPDATE	See sample SQL.

Sample SQL

UPDATE
  PA_POLICY_PERIOD
SET
  POLICY_PERIOD_EXP_DATE = :PolicyPeriodExpirationDate,
  CANCEL_DATE = :CancelDate,
  after_audit_std_prem_amount = :AfterAuditStdPremAmount,
  BEFORE_audit_std_prem_amount = :BeforeAuditStdPremAmount,
  waiver_amount = :WaiverAmount,
  PAYROLL_SEQ_NUM = :PayrollSequenceNumber,
  UPDATE_DATE = :UpdateDate,
  UPDATE_SEQ_NUM = UPDATE_SEQ_NUM + 1,
  UPDATE_USER = :UpdateUser
WHERE
  PA_AUDIT_SEQ_NUM = :AuditSequenceNumber
  AND POLICY_NUM = :PolicyNumber
  AND POLICY_PERIOD_EFF_DATE = :PolicyPeriodEffectiveDate
  AND UPDATE_SEQ_NUM = :UpdateSequenceNumber

Operations and processes

• Synchronize an audit with WCIS policy-period changes
• Save a premium audit

Business rules

• BR-027
• BR-028
• BR-029
• BR-032

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/clsAuditPolicyPeriod.vb:1181