SQL-023: Read Policy Data

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

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:FEIN	Input	bound from PolicyData.FeidNum	11	Bound in clsAudit.GetPriorPolicyNumbers (line 2760)
:Current_policy_number	Input	bound from PolicyNumber	—	Bound in clsAudit.GetPriorPolicyNumbers (line 2761)

Tables

Table	Access	Columns used
POLICY	JOIN	See sample SQL.
BUSINESS	JOIN	See sample SQL.

Sample SQL

SELECT
  p.policy_num
FROM
  policy p
JOIN
  BUSINESS B on (b.POLICY_NUM = p.policy_num)
WHERE
  FEID_NUM = :FEIN
  AND p.policy_num <> :Current_policy_number
  AND B.primary_bus_flag = 'Y'

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:2750-2780, 5061-5071