SQL-062: Retrieve legacy policy period¶
Retrieve legacy policy period in the context of clsLegacyPolicyPeriod.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-062 |
| Operation type | Read |
| Execution method | CommandType.StoredProcedure |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsLegacyPolicyPeriod |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve / AfterRetrieve |
Parameters¶
This statement has no bind parameters.
Tables¶
This statement executes as a stored procedure call and does not expose table references in repository source.**
Sample SQL¶
-- Stored-procedure invocation; no standalone SQL text in source.
WHERE
POLICY_PERIOD_NON_WCIS.POLICY_NUM = :PolicyNumber
AND :PolicyPeriodEffDate BETWEEN POLICY_PERIOD_NON_WCIS.POLICY_PERIOD_EFF_DATE
AND POLICY_PERIOD_NON_WCIS.POLICY_PERIOD_EXP_DATE
Operations and processes¶
- Build a unified policy period timeline
- Determine standard premium for a period
- Determine whether a period is issued
Business rules¶
- BR-010: A policy's period history is the union of
- BR-013: Standard premium is sourced from WCIS for WCIS
- BR-015: A legacy policy period is never reported as
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.Core\clsLegacyPolicyPeriod.vb