SQL-012 Get policy waiver count¶
Retrieve the waiver count for a policy.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-012 |
| Operation type | Read |
| Execution method | Stored procedure |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | StoredProcedure |
| Business object | clsPolicyData |
| Criteria property | HasWaiverSQL |
| Lifecycle method | RetrieveHasWaiver (lazy read) |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:PolicyNum |
Input | Decimal | N/A | Policy number |
:WaiverCount |
ReturnValue | Integer | N/A | Number of waiver records for the policy |
Tables¶
N/A — Stored procedure
Sample SQL¶
-- Oracle stored procedure call (CommandType.StoredProcedure, Scalar)
-- clsPolicyData.RetrieveHasWaiver
CALL Pk82033_ThirdParty.get_policy_waiver_count(
:PolicyNum,
:WaiverCount) -- ParameterDirection.ReturnValue
Operations and processes¶
Business rules¶
Sources¶
SAIF.Business.View.Policy/clsPolicyData.vb