SQL-023: Employer-liability limits retrieval¶
clsPolicyPeriod uses this call to load the employer-liability coverage limits in force for a policy period. The procedure falls back through a hierarchy from policy-specific limits to legacy defaults.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-023 |
| Operation type | Read |
| Execution method | Stored procedure |
| 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 | not specified | Policy number whose coverage limits are requested. |
:PeriodEffDate |
Input | Date | not specified | Policy period effective date whose employer-liability limits are requested. |
recordset |
Output (Cursor) | REF CURSOR | N/A | Result set of the employer-liability statutory code and up to three formatted limit amounts. |
Tables¶
No table is referenced directly in the .NET source. The tables read by the procedure body reside in the Oracle database and are described under coveragelimits_pkg.
Sample SQL¶
-- Stored procedure call (procedure body resides in the Oracle database - WCIS_DBA.coveragelimits_pkg)
CALL coveragelimits_pkg.getSpecificLimitsForPolicyNum(
aPolicyNum => :apolicynum,
PeriodEffDate => :PeriodEffDate,
recordset => :recordset) -- REF CURSOR output
Operations and processes¶
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.View.Policy/clsPolicyPeriod.vb