SQL-035 Max policy effective date

This SQL retrieves the maximum policy period effective date for a policy so association retrieval can default missing date filters.

Classification

Field	Value
SQL ID	SQL-035
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	PolicyAssociationList
Criteria property	N/A
Lifecycle method	GetMaxPolicyEffectiveDate

Parameters

Parameter	Direction	Type	Max length	Description
:PolicyNumber	Input	Decimal	N/A	Policy number whose latest policy period effective date is requested.

Tables

Table	Access	Columns used
POLICY_PERIOD	SELECT	policy_num, policy_period_eff_date

Sample SQL

SELECT
  MAX(policy_period_eff_date)
FROM policy_period pp
WHERE pp.policy_num = :PolicyNumber

Operations and processes

• Retrieve policy associations

Business rules

• BR-VP-024: Default association dates

Sources

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