SQL-017: Information-page-printed check¶
clsPolicyData uses this call to ask whether the information page for a policy period has been printed. The answer governs whether reduced-form period values are shown or masked.
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 | not specified | Policy number being checked. |
:in_policy_period_eff_date |
Input | Date | not specified | Policy period effective date being checked. |
:out_flag |
ReturnValue | String | 1 | Y/N result stating whether the information page printed for that period. |
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 sp72347_info_page_printed_yn.
Sample SQL¶
-- Stored procedure call (procedure body resides in the Oracle database - WCIS_DBA)
CALL SP72347_INFO_PAGE_PRINTED_YN(
in_policy_num => :in_policy_num,
in_policy_period_eff_date => :in_policy_period_eff_date,
out_flag => :out_flag) -- return-value output parameter
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/clsPolicyData.vb