SQL-011 Policy period expiration date¶

Retrieves the policy-period expiration date for a policy period by checking both POLICY_PERIOD and POLICY_PERIOD_NON_WCIS via UNION, consumed by PolicyInformation.PolicyPeriodExpirationDate.

Classification¶

Field	Value
SQL ID	SQL-011
Operation type	Read
Execution method	Inline SQL, string-concatenation via `SQL.PolicyPeriodExpirationDate`
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	N/A (Application layer)
Criteria property	N/A
Lifecycle method	N/A
Application class	`PolicyInformation` (property `PolicyPeriodExpirationDate`, Get)

Parameters¶

Parameter	Direction	Type	Max length	Description
`:in_policy_num`	Input	Decimal (`inPolicyNumber`)	N/A	Policy number filter, applied to both halves of the `UNION`.
`:in_policy_period_eff_date`	Input	Date (`inPolicyPeriodEffectiveDate`)	N/A	Policy-period effective date filter, applied to both halves of the `UNION`.

Tables¶

Table	Access	Columns used
POLICY_PERIOD	SELECT	`POLICY_PERIOD_EXP_DATE`, `POLICY_NUM`, `POLICY_PERIOD_EFF_DATE`
POLICY_PERIOD_NON_WCIS	SELECT	`POLICY_PERIOD_EXP_DATE`, `POLICY_NUM`, `POLICY_PERIOD_EFF_DATE`

Sample SQL¶

Select policy_period_exp_date
from policy_period pp
where policy_num = :in_policy_num
  and policy_period_eff_date = :in_policy_period_eff_date
Union
Select policy_period_exp_date
from policy_period_non_wcis pp
where policy_num = :in_policy_num
  and policy_period_eff_date = :in_policy_period_eff_date

Operations and processes¶

Determine policy-period expiration date

Sources¶

SAIF.Business.Policy\PolicyInformation.vb