Retrieve policy period expiration date

Retrieve policy period expiration date.

Field	Value
Operation ID	OP-002
Trigger	A caller supplies a policy number and effective date.
Inputs	IDataPortalInfo, policy number, policy period effective date
Outputs	Policy period expiration date
Primary components	PolicyInformation
Entry point	Business\SAIF.Business.Policy\PolicyInformation.vb

Steps

1. Execute SQL-011 against POLICY_PERIOD and POLICY_PERIOD_NON_WCIS.
2. Bind the policy number and effective date for both UNION branches.
3. Return the expiration date found in either source-system table.
4. Apply related business rules: BR-POL-002

Process flow

The following diagram visualizes the main control flow for this operation.

flowchart TD

  Start([Trigger]) --> Work[Execute operation steps]

  Work --> Done([Return result])

Failure and edge-case behavior

• Business rules are cross-referenced from the catalog page and the SQL or procedure logic cited in these steps.
• Database and procedure failures surface according to the underlying implementation path.

Related documentation

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

Sources

• Business\SAIF.Business.Policy\PolicyInformation.vb