Determine policy-period expiration date

Determines the expiration date of a policy period by querying POLICY_PERIOD unioned with POLICY_PERIOD_NON_WCIS, covering policies issued through either system.

Field	Value
Operation ID	OP-POL-003
Trigger	Caller reads PolicyInformation.PolicyPeriodExpirationDate(inDPI, inPolicyNumber, inPolicyPeriodEffectiveDate)
Inputs	Data portal info, policy number, policy-period effective date
Outputs	Date
Primary components	PolicyInformation.PolicyPeriodExpirationDate
Entry point	SAIF.Business.Policy\PolicyInformation.vb

Steps

1. Caller reads PolicyInformation.PolicyPeriodExpirationDate(inDPI, inPolicyNumber, inPolicyPeriodEffectiveDate).
2. A scalar request is built with SQL.PolicyPeriodExpirationDate (SQL-011, a UNION across POLICY_PERIOD and POLICY_PERIOD_NON_WCIS), with parameters in_policy_num and in_policy_period_eff_date.
3. DAL.ProcessPortalRequest executes; result is cast to Date.
4. On failure/no match: no DBNull/Nothing guard is present — behavior is unconfirmed.**

Process flow

flowchart TD
    Start([PolicyPeriodExpirationDate read]) --> S1[Build IDataRequest with SQL-011]
    S1 --> S2[Bind policy_num and period_eff_date]
    S2 --> S3[DAL.ProcessPortalRequest executes UNION query]
    S3 --> EndOk([Cast result to Date])

Failure and edge-case behavior

• No null/DBNull guard on the cast result.**

Related documentation

• Operations and processes
• Business rules
• SQL catalog
• Database tables

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• SAIF.Business.Policy\PolicyInformation.vb