SQL-010 Get policy¶
Retrieve core policy data for a policy number.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-010 |
| Operation type | Read |
| Execution method | Stored procedure |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | StoredProcedure |
| Business object | clsPolicyData |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve / AfterRetrieve |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:apolicynum |
Input | Decimal | N/A | Policy number |
recordset |
Output (Cursor) | REF CURSOR | N/A | Policy row |
Tables¶
N/A — Stored procedure
Sample SQL¶
-- Oracle stored procedure call (CommandType.StoredProcedure)
-- clsPolicyData.BeforeRetrieve
CALL pk73094_policy_data.getpolicy(
:apolicynum,
:recordset)
Operations and processes¶
Business rules¶
- BR-VP-001: Policy number must be valid before retrieve
- BR-VP-010: Demo users see masked data
- BR-VP-016: Market type mapping
- BR-VP-023: Login date on or before 2000-01-01 is "never logged in"
- BR-VP-027: Create/Insert/Update/Delete SQL are invalid
Sources¶
SAIF.Business.View.Policy/clsPolicyData.vb