SQL-091: Delete Pa Policy Period Data

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

Classification

Field	Value
SQL ID	SQL-091
Operation type	Delete
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsAuditPolicyPeriod
Criteria property	DeleteSQL
Lifecycle method	BeforeDelete / AfterDelete

Parameters

Parameter	Direction	Type	Max length	Description
:AuditSequenceNumber	Input	bound from AuditSequenceNumber	—	Bound in clsAuditPolicyPeriod.BeforeDelete (line 447)
:PolicyNumber	Input	bound from PolicyNumber	—	Bound in clsAuditPolicyPeriod.BeforeDelete (line 448)
:PolicyPeriodEffectiveDate	Input	bound from PolicyPeriodEffectiveDate	—	Bound in clsAuditPolicyPeriod.BeforeDelete (line 449)
:UpdateSequenceNumber	Input	bound from UpdateSequenceNumber	—	Bound in clsAuditPolicyPeriod.BeforeDelete (line 450)

Tables

Table	Access	Columns used
PA_POLICY_PERIOD	DELETE	See sample SQL.

Sample SQL

DELETE FROM
  PA_POLICY_PERIOD
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:1132