SQL-022: Read Trading As Data

This statement supports the premium-audit library by read Trading As Data.

Classification

Field	Value
SQL ID	SQL-022
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.PolicyHasABN (application layer)

Parameters

Parameter	Direction	Type	Max length	Description
:policynumber	Input	bound from PolicyNumber	—	Bound in clsAudit.BeforeInsert (line 2462)

Tables

Table	Access	Columns used
TRADING_AS	SELECT	See sample SQL.

Sample SQL

SELECT
  COUNT(*)
FROM
  trading_as
WHERE
  policy_num = :policynumber
  AND trading_as_type_code = 'ABN'
  AND trunc(SYSDATE) BETWEEN trading_as_name_eff_date
  AND NVL (trading_as_cancel_date - 1, SYSDATE + 1)

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:2666-2685, 5004-5015