SQL-016 Coverage bound flag

Retrieve the policy coverage bound flag for a policy period.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:in_policy_num	Input	Decimal	N/A	Policy number
:in_policy_period_eff_date	Input	Date	N/A	Policy period effective date

Tables

N/A — Stored procedure

Sample SQL

SELECT
  sp73089_get_policy_bound_flag(:in_policy_num, :in_policy_period_eff_date)
FROM dual

Operations and processes

• Lazy retrieval of policy detail and indicators

Sources

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