SQL-017 Information page printed flag¶
Retrieve whether an information page was printed for a policy period.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-017 |
| Operation type | Read |
| Execution method | Stored procedure |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | StoredProcedure |
| Business object | clsPolicyData |
| Criteria property | GetIsInformationPagePrintedSQL |
| Lifecycle method | IsInformationPagePrinted |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:in_policy_num |
Input | Decimal | N/A | Policy number |
:in_policy_period_eff_date |
Input | Date | N/A | Policy period effective date |
:out_flag |
ReturnValue | String | 1 | Printed-information-page flag |
Tables¶
N/A — Stored procedure
Sample SQL¶
-- Oracle stored procedure call (CommandType.StoredProcedure, Scalar)
-- clsPolicyData.IsInformationPagePrinted
CALL SP72347_INFO_PAGE_PRINTED_YN(
:in_policy_num,
:in_policy_period_eff_date,
:out_flag) -- ParameterDirection.ReturnValue, max length 1
Operations and processes¶
Business rules¶
Sources¶
SAIF.Business.View.Policy/clsPolicyData.vb