SQL-015 Secondary policy status

Retrieve the secondary policy cancellation status.

Classification

Field	Value
SQL ID	SQL-015
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsPolicyData
Criteria property	GetSecondaryPolicyStatusSQL
Lifecycle method	GetSecondaryPolicyStatus

Parameters

Parameter	Direction	Type	Max length	Description
:in_policy_num	Input	Decimal	N/A	Policy number

Tables

N/A — Stored procedure

Sample SQL

SELECT
  sp72268_get_cancel_status(:in_policy_num)
FROM dual

Operations and processes

• Lazy retrieval of policy detail and indicators

Business rules

• BR-VP-017: Future cancel date only for Pending Cancellation

Sources

• SAIF.Business.View.Policy/clsPolicyData.vb