SQL-027: Latest policy-period effective date lookup¶

PolicyAssociationList uses this statement to establish a default as-of date for discount-combination selection when the caller supplies none.

Classification¶

Field	Value
SQL ID	SQL-027
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]`**
Command type	Text
Business object	`PolicyAssociationList`
Criteria property	N/A (ad hoc helper)
Lifecycle method	`GetMaxPolicyEffectiveDate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:PolicyNumber`	Input	Decimal	not specified	Policy number whose most recent policy-period effective date is used as the default discount-combination as-of date.

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¶

Resolve policy associations

Business rules¶

BR-014: Association date defaults differ per association family and detail-load failures are non-fatal

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.View.Policy/PolicyAssociations.vb