SQL-037: Read Er Combination Policy Data¶

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

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:PolicyNumber`	Input	bound from `Audit.PolicyNumber`	—	Bound in `clsAuditPolicyCollection.GetERComboMembers` (line 632)

Tables¶

Table	Access	Columns used
`ER_COMBINATION_POLICY`	JOIN	See sample SQL.
`POLICY`	JOIN	See sample SQL.

Sample SQL¶

SELECT
  ecp2.policy_num as PolicyNumber
FROM
  er_combination_policy ecp,
  er_combination_policy ecp2,
  policy p
WHERE
  ecp.policy_num = :PolicyNumber
  AND ecp.exp_date is null
  AND ecp.er_combination_seq_num = ecp2.er_combination_seq_num
  AND ecp2.exp_date is null
  AND ecp2.rowid <> ecp.rowid
  AND ecp2.policy_num = p.policy_num
  AND p.policy_status_code in ('0','3')

Operations and processes¶

Synchronize an audit with WCIS policy-period changes

Business rules¶

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/clsAuditPolicyCollection.vb:620-650, 801-815