SQL-011: Retrieve policy period expiration date¶
Retrieve policy-period expiration date by policy and effective date.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-011 |
| Operation type | Read |
| Execution method | Inline SQL |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | N/A (Application layer) |
| Criteria property | N/A |
| Lifecycle method | PolicyPeriodExpirationDate |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
| :in_policy_num | Input | NUMBER | N/A | Policy number. |
| :in_policy_period_eff_date | Input | DATE | N/A | Policy period effective date. |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| POLICY_PERIOD | SELECT | POLICY_NUM, POLICY_PERIOD_EFF_DATE, POLICY_PERIOD_EXP_DATE |
| POLICY_PERIOD_NON_WCIS | SELECT | POLICY_NUM, POLICY_PERIOD_EFF_DATE, POLICY_PERIOD_EXP_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¶
Business rules¶
- See Business rules.
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.Policy\PolicyInformation.vb