Full Policy History Enquiry

Full Policy History Enquiry

Full Policy History Enquiry

© Xchanging Global Insurance Solutions Ltd. 2005

All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior permission of Xchanging Global Insurance Solutions Limited (XGIS).

This document contains information which is confidential and of value to Xchanging Global Insurance Solutions Ltd. It may be used only for the agreed purpose for which it has been provided. Written consent is required before any part is reproduced.

Note: This document is submitted to the IRIS User Group solely for informational purposes and shall not be deemed or construed to be a contract or agreement binding on Xchanging Global Insurance Solutions Ltd. Only signed hard copies and electronic masters of documents will be controlled. Any other copy may not be current.

Trademark Information

Company, product, or brand names mentioned in this document, may be the trademarks of their owners.

1.Amendment History

Contents

1.Amendment History......

2.Introduction......

2.1High Level Business Overview......

2.2Background......

2.3Scope......

2.4Outside Scope......

2.5Detailed Requirements List......

2.6Acceptance Criteria......

3.Functional Design......

3.1Summary......

3.2Full Policy History by Reference Enquiry (F1, F2, F3 and F4)......

3.2.1Wizard Steps......

3.2.2Default Columns......

3.2.3Navigation Actions......

3.2.4Filters (F7)......

3.3Full Policy History Enquiry (F5)......

3.3.1Wizard Steps (F6)......

3.3.2Default Columns......

3.3.3Navigation Actions......

3.3.4Filters (F7)......

3.4History Data (F8)......

3.4.1Claims and OCRs (F9)......

3.4.2Written premium amounts (F11)......

3.4.3Written, Estimated Signed and Signed Share (F12)......

3.5iSeries Changes......

3.5.1Bureau Closings Batch Update (F10, F13)......

3.5.2Bureau Claims Batch Update (F10)......

3.5.3iSeries Claims and OCRs (F10)......

3.5.4iSeries Signed Share (F13)......

3.5.5History Rebuild (F14)......

3.6Security Setting for New Enquiries (F16)......

3.7Enquiries from Policy Input (F17)......

3.8Context Menu (F19)......

3.9Suppression of Repeated Data (F18)......

4.Unit Test plan......

5.Appendices......

5.1Appendix A – Enquiry Field List......

6.Costing......

2.Introduction

2.1High Level Business Overview

New enquiriesare required to provide Policy History information. The scope of the history information is to be extended to include other figures, for example outstanding claim amounts, OCRs and policy amounts.

2.2Background

This enhancement was raised as item 599 on the IRIS user group voting list. The original text was as follows:

“Have an enquiry which enables viewing of policy details (e.g. codes & EPI) and Policy History amounts (e.g. closed, o/s & paid balances).

In addition to this new enquiry it should also be possible when within enquiries to display a new screen (accessed via a right click) that will show summary information (i.e. the basic stats) for the specified policy in a standalone details form. This will include EPI, booked premium, paid and o/s claims and RI. This same screen should be made available from within policy input.”

2.3Scope

The scope of this enhancement covers all the requirements as listed in detailed requirements list in section2.5 below.

2.4Outside Scope

Any modifications to the existing history enquiries are outside the scope of this enhancement.

2.5Detailed Requirements List

F1)A new policy enquiry will be written to display the policy details, codes and history information. The enquiry will be of a similar format to the ‘Policy/Acc Terms/Deductions’ enquiry in that a row will be shown for each policy/currency combination, for the selected currency type. Policy details common to more than one row will only be displayed once, e.g. when viewing the RI history the enquiry will produce a row for each RI associated with that policy.

F2)Enquiry wizard step for F1) will be defined to allow multiple selections by Policy User Reference

F3)Enquiry wizard step for F1) will be defined to provide the option to include the policies in the renewal chain.

F4)Enquiry wizard step for F1) will be defined to provide the option to include the policies in the sequence chain.

F5)A second enquiry as per F1) will be created to display the policy details, codes and history information without the options of renewal chain and sequence chain. This enquiry will allow user to filter the results based on values of different fields.

F6)Enquiry wizard for step for F5) will be the ‘IRIS Custom Filter’ screen to allow any set of polices to be selected.

F7)The enquiries will be configured to allow filtering of the results by:

a)Amount type - Accounting, Base and Original.

b)Currency.

c)Figures- 100%, Gross, Net and RI.

F8)The history file (USHSREP) will be expanded to accommodate the extra amount types (Outstanding claim, OCRs and policy amounts).

F9)Enhance IRIS GUI on line processing of claims and OCR transactions (manual and bureau) to update the Policy History file.

F10)Enhance the iSeries batch processing of claims and OCR transactions to update the Policy History file.

F11)Enhance the IRIS GUI to update Policy History file with written premium figures. Both gross and RI figures are to be written to the file.

F12)Enhance the IRIS GUI to update the written signed share premium when a policy is signed.

F13)Enhance the iSeries batch processing of premium closings to update the written signed share premium when a policy is signed.

F14)Enhance the iSeries history rebuild to include all new amounts.

F15)Enhance IRIS to maintain UPR figures on the history file.[1]

F16)Authority to the new enquiries will be added to the IRIS System Administration function.

F17)To provide the option of including all policies in the renewal/sequence chain when running the query from policy input.

F18)IRIS Enquiries will be enhanced so that the suppression of repeated data can be turned on or off.

F19)Both of the above enquires will be made available when right clicking on a policy.

2.6Acceptance Criteria

The enhancements made to IRIS will meet the detailed requirements described above.

3.Functional Design

3.1Summary

The ‘Full Policy History’ enquiry will be implemented by creating two new enquiries; one to allow selection of policies by ‘Policy User Reference’ (supporting inclusion of renewals and/or sequences) and another to allow a set of policies to be selected using custom filters applied to policy fields.

3.2Full Policy History by Reference Enquiry (F1, F2, F3 and F4)

On the Enquiry Selection Screen, a new Enquiry Type will be made available under the History option.

The name of this Enquiry Type will be “Full Policy History by Reference”.

Results of this enquiry will include the policy details and codes as per the existing policy enquiry and the amounts described in section 3.4 on page 18.

On the results screen, filters will be available to filter the results based on currency type (similar to the existing History Enquiry).

Results will be displayed such that a row will be shown for each policy/syndicate line/currency combination, for the selected currency type.

Policy details common to more than one row will only be displayed once.This enquiry will allow user to include Policies in Renewaland Sequence Chain for the specified Policy Reference.

The enquiry will ONLY list full policies it will not include quotes, promises, memos, declinatures or skeletons.

Where a policy has been endorsed the enquiry will only show the policy amounts (as listed in section 3.4.2 on page 23) from the latest endorsement on that policy. All other amounts will be totalled across all endorsements.

Sample Enquiry Screen -

3.2.1Wizard Steps

This Enquiry will have two wizard steps - “Policy Selection” and “Select Fields”.

3.2.1.1Policy Selection

Policy Selection wizard step will have three input fields

“Policy User Reference” as a text input box,

“Include Policies in Renewal Chain” as a check box,

“Include Policies in Sequence Chain” as check box.

The “Policy User Reference” will be a mandatory field. The user will be able to enter a single value or a list of comma separated values in Policy User Reference field.

If the “Include Policies in Renewal Chain” checkbox is checked then the results will show records for all the policies from which the policy specified in Policy User Reference field has been renewed from and all the policies to which the policy in question has been renewed to.

If the “Include Policies in Sequence Chain” checkbox is checked then the results will show records for all the related polices in the sequence chain of the policy specified in the Policy User Reference.

If both these checkboxesare unchecked then the results will only show records for the policy specified in the Policy User Reference field.

Policy Selection wizard step screen -

3.2.1.2Select Fields

The “Select Fields” wizard step will list all the fields available for inclusion as columns in the enquiry. For complete list of fields, refer to Section5 on page 39.

On clicking the finish button the results will be displayed for the policies matching the criteria specified on the policy select step.

3.2.2Default Columns

For the default <New> viewthe following fields will be selected by default (see section 5 on page 39 for a full list of all available fields)

3.2.3Navigation Actions

Right clicking on any of the results will display the same context menu as is displayed in the case of right clicking on a policy in a policy list enquiry.

3.2.4Filters (F7)

The enquiry results for “Full Policy History Enquiry” and “Full Policy by Reference Enquiry” will have option to filter the results as follows –

a. Filter on Type – The Type dropdown list will have three options – Accounting, Base and Original. Base will be selected by default.

b. Filter on Currency – The Currency dropdown list will be populated depending on the value Type dropdown list. If the type is “Accounting” then the Currency dropdown list will be populated with all the accounting currencies from the history records. If the type is “Original” then Currency dropdown list will be populated with all the original currencies from the history records. If the type is “Base” then the Currency dropdown list will have one option “Closed Base Eq”. In all cases the default will be the <All> option.

c. Filter on Figures – The Figures dropdown list will have four options - 100%, Gross, Net and RI. The default will be Gross.

d. Filter on Share – The Share dropdown list will have four options – 100%, Written[2], Estimated Signed[3] and Signed[4]. The default will be “Written”.

In terms of written policy amounts all 4 settings will result in the amounts being recalculated (with the exception of excess points and deductibles).

For excess points and deductibles the amounts will NOT be recalculated based on the selection made in the share dropdown.

In the case of booked amounts the actual booked amounts will be shown for the Written, Estimated Signed and Signed settings. For booked amounts the 100% option will result in the booked amount being signed up to the 100% share using the signed share for that line on the policy.

3.3Full Policy History Enquiry (F5)

On the Enquiry Selection Screen, an additionalnew Enquiry Type will be made available under History option.

The name of this Enquiry Type will be “Full Policy History”.

The results of this enquiry will include the policy details and codes as per the existing policy list enquiry and including the amounts describedin section 3.4 on page 18.

On the results screen, filters will be available to filter the results based on currency type (similar to the existing History Enquiry).

Results will be displayed such that a row will be shown for each policy/syndicate line/currency combination, for the selected currency type.

This enquiry will allow a user to filter the results based on the values of policy fields using a custom filter step.

The enquiry will ONLY list full policies it will not include quotes, promises, memos, declinatures or skeletons.

Where a policy has been endorsed the enquiry will only show the policy amounts (as listed in section 3.4.2 on page 23) from the latest endorsement on that policy. All other amounts will be totalled across all endorsements.

3.3.1Wizard Steps (F6)

The Full Policy History Enquiry will have two wizard steps – “Custom Filter” and “Select Fields”.

3.3.1.1Customer Filter

The “Custom Filter” wizard step will allow user to specify filters to select any set of polices to be selected.

For a complete list of fields available in both the “Custom Filter” and “Select Fields”, refer to the Appendix in Section 5 on page 39.

3.3.1.2Select Fields

The “Select Fields” wizard step will list all the fields available for inclusion as columns in the enquiry.

For a complete list of fields available in both the “Custom Filter” and “Select Fields”, refer to Section 5 on page 39.

3.3.2Default Columns

For the default <New> view, in addition to the Policy History file amount fields mentioned in section 3.4 on page 18, the following fields will be selected by default –

3.3.3Navigation Actions

Right clicking on any of the results will display the same context menu as is displayed in the case of right clicking on a policy in a policy list enquiry.

3.3.4Filters (F7)

The enquiry results for “Full Policy History Enquiry” and “Full Policy by Reference Enquiry” will have option to filter the results as follows –

a. Filter on Type – The Type dropdown list will have three options – Accounting, Base and Original. Base will be selected by default.

b. Filter on Currency – The Currency dropdown list will be populated depending on the value Type dropdown list. If the type is “Accounting” then the Currency dropdown list will be populated with all the accounting currencies from the history records. If the type is “Original” then Currency dropdown list will be populated with all the original currencies from the history records. If the type is “Base” then the Currency dropdown list will have one option “Closed Base Eq”. In all cases the default will be the <All> option.

c. Filter on Figures – The Figures dropdown list will have four options - 100%, Gross, Net and RI. The default will be Gross.

d. Filter on Share – The Share dropdown list will have four options – 100%, Written[5], Estimated Signed[6] and Signed[7]. The default will be “Written”.

In terms of written policy amounts all 4 settings will result in the amounts being recalculated (with the exception of excess points and deductibles).

For excess points and deductibles the amounts will NOT be recalculated based on the selection made in the share dropdown.

In the case of booked amounts the actual booked amounts will be shown for the Written, Estimated Signed and Signed settings. For booked amounts the 100% option will result in the booked amount being signed up to the 100% share using the signed share for that line on the policy.

3.4History Data (F8)

The History File currently already captures all data from closings on a policy.

It will be modifiedto allow the following additional data to be captured on it –

• Policy Amounts
• Outstanding Claim Amounts
• OCRs
• Signed Share

Following table lists the new fields on History File (USHSREP)