SQL-021 Get specific limits for policy number¶
This stored procedure call retrieves employer liability coverage limits for a policy and effective period so policy period detail can lazily load specific limits.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-021 |
| Operation type | Read |
| Execution method | StoredProc |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | StoredProcedure |
| Business object | clsPolicyPeriod |
| Criteria property | GetSpecificELCBLimitsSQL |
| Lifecycle method | RetrieveEmployerLiabLimits |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:apolicynum |
Input | Decimal | N/A | Policy number whose employer liability limits are requested. |
:PeriodEffDate |
Input | Date | N/A | Policy period effective date identifying the period to read. |
recordset |
Output (Cursor) | REF CURSOR | N/A | Result set containing the specific employer liability limits for the policy period. |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| N/A — Stored procedure | SELECT | Procedure body resides in the database. |
Sample SQL¶
-- Oracle stored procedure call (CommandType.StoredProcedure, Reader)
-- clsPolicyPeriod.RetrieveEmployerLiabLimits
CALL coveragelimits_pkg.getSpecificLimitsForPolicyNum(
:apolicynum,
:PeriodEffDate,
:recordset)
The procedure body resides in the Oracle database; it was not retrievable for this run.
Operations and processes¶
Business rules¶
None.
Sources¶
SAIF.Business.View.Policy/clsPolicyPeriod.vb