SQL-VP-013 Retrieve a future cancellation date for a policy¶
Returns a cancellation date on or after the current date for a policy, used by
clsPolicyData.GetFutureCancelDate.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-VP-013 |
| Operation type | Read |
| Execution method | Inline SQL |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsPolicyData |
| Criteria property | GetFutureCancelDate() (ad hoc method) |
| Lifecycle method | ad hoc method |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:PolicyNumber |
Input | Decimal | N/A | Policy number to look up a future cancellation date for. |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| CANCELLATION | SELECT | POLICY_NUM, CANCEL_DATE |
Sample SQL¶
SELECT
CANCELLATION.CANCEL_DATE
FROM
CANCELLATION
WHERE
CANCELLATION.POLICY_NUM = :PolicyNumber
AND CANCELLATION.CANCEL_DATE > SYSDATE
Column names inferred from method naming and typical cancellation semantics.
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¶
SAIF.Business.View.Policy\clsPolicyData.vb