SQL-007 Information page printed check¶

Checks ENDORSEMENT for a printed P401 (information page) endorsement matching the given policy number and policy-period effective date, consumed by PolicyInformation.IsInformationPagePrinted.

Classification¶

Field	Value
SQL ID	SQL-007
Operation type	Read
Execution method	Inline SQL (literal in property, reconstructed from `"..." & _` concatenation)
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	N/A (Application layer)
Criteria property	N/A
Lifecycle method	N/A
Application class	`PolicyInformation` (property `IsInformationPagePrinted`, Get)

Parameters¶

Parameter	Direction	Type	Max length	Description
`:PolicyNumber`	Input	Decimal (`inPolicyNumber`)	N/A	Policy number filter on `ENDORSEMENT`.
`:PolicyPeriodEffectiveDate`	Input	Date (`inPolicyPeriodEffectiveDate`)	N/A	Policy-period effective date filter on `ENDORSEMENT`.

Tables¶

Table	Access	Columns used
ENDORSEMENT	SELECT	`POLICY_NUM`, `POLICY_PERIOD_EFF_DATE`, `ENDORSE_CODE`, `PRINTED_DATE`

Sample SQL¶

Select policy_num
FROM endorsement
WHERE policy_num = :PolicyNumber
  AND policy_period_eff_date = :PolicyPeriodEffectiveDate
  AND endorse_code = 'P401'
  AND printed_date IS NOT NULL

Operations and processes¶

Determine whether the information page was printed

Sources¶

SAIF.Business.Policy\PolicyInformation.vb