SQL-019: Read Pa Audit Data

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

Classification

Field	Value
SQL ID	SQL-019
Operation type	Read
Execution method	CommandType.Text / DataRequestType.Scalar
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsAudit
Criteria property	n/a — application layer
Lifecycle method	clsAudit.DuplicateAuditExists (application layer)

Parameters

Parameter	Direction	Type	Max length	Description
:in_auditseqnum	Input	bound from AuditSeqNum	—	Bound in clsAudit.DuplicateAuditExists (line 3245)
:in_policynumber	Input	bound from PolicyNumber	—	Bound in clsAudit.DuplicateAuditExists (line 3244)
:in_audittypecode	Input	bound from PremiumAuditTypeCode	5	Bound in clsAudit.DuplicateAuditExists (line 3248)
:in_auditstartdate	Input	bound from StartDate	—	Bound in clsAudit.DuplicateAuditExists (line 3247)

Tables

Table	Access	Columns used
PA_AUDIT	JOIN	See sample SQL.
PA_POLICY_PERIOD	JOIN	See sample SQL.

Sample SQL

SELECT
  count(*)
FROM
  pa_audit pa,
  pa_policy_period ppp
WHERE
  ppp.pa_audit_seq_num <> :in_auditseqnum
  AND ppp.policy_num = :in_policynumber
  AND ppp.pa_audit_seq_num = pa.pa_audit_seq_num
  AND pa.pa_type_code = :in_audittypecode
  AND pa.start_date = :in_auditstartdate
  AND pa.pa_status_code <> 'CANC'

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:3233-3260, 4983-5003