SQL-088: Delete Pa Audit Data

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

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:AuditSeqNum	Input	bound from AuditSeqNum	—	Bound in clsAudit.BeforeDelete (line 2398)
:UpdateSeqNum	Input	bound from UpdateSeqNum	—	Bound in clsAudit.BeforeDelete (line 2399)

Tables

Table	Access	Columns used
PA_AUDIT	DELETE	See sample SQL.

Sample SQL

DELETE FROM
  pa_audit
WHERE
  pa_audit_seq_num = :AuditSeqNum
  AND update_seq_num = :UpdateSeqNum

Operations and processes

• Assign an audit to an auditor
• Synchronize an audit with WCIS policy-period changes
• Save a premium audit
• Audit lifecycle status transitions

Business rules

• BR-020
• BR-021
• BR-032
• BR-035
• BR-036
• BR-037
• BR-057

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/clsAudit.vb:4793