Business Customisation of Closings Input

Business Customisation of Closings Input

Business Customisation of Closings Input

Distribution : / Alan Chisham
IUG
Reference : / Q:\Lmd\Development\300062867-Business Customisation of Closings Input-IUG\02 Specification\IUG-300062867-Business Customisation of Closings Input-Functional.01.doc
Author : / Nitin Jain
Applicability : / Product
Customers / IRIS 9.15
IUG
Global Insurance Solutions Ref / 300062867
IUG Reference : / 628
Version : / 01
Revision Date : / 31stMarch 2005
Authorised by: / ______/ Projects Manager / Date: / / /

© Xchanging Global Insurance Solutions Ltd. 2004

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 Groupsolely 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

Reason / Date / NewReference
Version 1 / 31/03/05 / Q:\Lmd\Development\300062867-Business Customisation of Closings Input-IUG\02 Specification\IUG-300062867-Business Customisation of Closings Input-Functional.01.doc

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.2Functional Description......

3.2.1Closings Input function in Business Customisation......

3.2.2Field Groups Tab - Availability of the fields on the screen......

3.2.3Rules Tab – Adding / Editing Rules on the fields......

3.2.4Additional Frames in the Policy Info Tab......

3.2.5Claims Details in Claims Closings......

4.Unit Test plan......

5.Costing......

2.Introduction

2.1High Level Business Overview

Business Customisation for Closings Input has to be introduced. This should allow the users to select / deselect any field they want to show on the screen. The Users should also be able to define rules they want to set on any field.

2.2Background

The enhancement was raised as item 628 on the IRIS user group voting list. The text was as follows: -

Business Customisation of Closings Input

2.3Scope

The enhancement will involve changes in Codes Database and handling the processing of rules in Closings Input

2.4Outside Scope

Customisation of Bureau Closings is outside the scope of the enhancement.

2.5Detailed Requirements List

To provide the above functionality

2.6Acceptance Criteria

Implementation of the above

3.Functional Design

3.1Summary

At present, the user does not have the ability to change the availability of fields on the Closings Input screen. The user cannot control the displaying of the fields on the screen. Also the user cannot define rules on the fields,

This enhancement will allow the user to customise the closings input screens. The user will be able to select which fields are to be displayed on the screen and also their order. The selection and the de-selection of fields will be done through Business Customisation.

The user will also be able to define rules on the fields at Product Level although system rules will not be editable.

3.2Functional Description

3.2.1Closings Input function in Business Customisation

In Business Customisation, for LIVE products, “Closings Input” will be made available as an application.

The user will have the option of selecting fields and defining rules for Closings Input Application for different products.

3.2.2Field Groups Tab - Availability of the fields on the screen

The Closing Input application will include the following Field Groups:

• A/C Term Codes
• A/C Term Days
• A/C Term Premiums
• Claims Codes
• Claims Dates
• Claims References
• Codes
• Dates
• Exchange Rate
• LPSO Codes
• Percentages
• Policy Amounts
• Policy Amount Columns
• Policy Codes
• Policy Dates
• Policy References
• References

Note: Claims Codes, Claims Dates and Claims References Field Groups will only be available for Claims Closings.

3.2.2.1Fields List

The following fields will be included for the respective Field Groups:

Group / Fields
A/C Terms Codes / Fieldcode / Name
ATVACD / Period
ATACBS / A/C Basis
ATDDTM / Deduction Terms
ATPYDU / Payment Due
ATEQIN / Equal Inst
ATPPCD / Premium Payment Warranty
A/C Terms Days / Fieldcode / Name
ATRGDY / Receipt Days
ATSIDY / Settlement Days
ATPREA / Premium Earning Basis
ATEARN / Earning Days
ATATDY / Adjustment Terms Days
A/C Term Premiums / Fieldcode / Name
AAA1XR / Additional Original to Base Exchange Rate
AAABXR / A/C Currency to Base ROE Exchange Rate
AAAYCD / Accounting Currency
AAD1@O / Premium B Amount
AAM1@O / Premium A Amount
AAM1XR / Prem Orig/Base Xchange Rate-Numeric
AAOGCU / Original Currency
AAPR@O / Total of Rate Derived Premium in Orig Ccy
VRMS@A / Deposit
VRMS@B / Deposit
VRMS@O / Deposit
VRPR@O / Total Earned
VRPS@A / Earned
VRPS@B / Earned
VRPS@O / Earned
Claims Codes / Fieldcode / Name
KMEVVD / Event/Sub-Evnt
KMLBRC / Account Source
KMCBCD / Class
KMEPCD / Equipment
KMZGCD / Settling Agent
KMLJCD / Survyr/Adjr
KMPYCD / Paymnt Type
KMLNCD / Line Code
KMGZCD / Goods
KMGNCD / Gen Purpose
KMIMCD / Item
KMIYCD / Industry
KMLOCD / Loss Type
KMCMCN / Claim Ctrl
KMLOCY / Loss Loc Country
KMICCD / Person In Charge
KMCMSE / Claim Section
KMMUCU / Orig Mkt Claim Ccy
KMSBCD / Account Source Sub A/C
KMTFCD / US Trust Fund
KMKLLF / Claim Linking field
KMPCD1 / Policy Code Number 1
KMPCD2 / Policy Code Number 2
KMPCD3 / Policy Code Number 3
KMPCD4 / Risk/Audit
KMPCD5 / FIL (2)
KMPCD6 / FIL (4)
Claims Dates / fieldcode / Name
POWNDT / Written Date
POICDT / Inception Date
POEKDT / Expiry Date
KMLODT / Loss Date
KMLADT / Loss Advice Date
KMFZDT / Closed Date
KMRGDT / Bkr Claim Rec'd
KMZRLA / Reassd Loss Adv
POEHJF / Effective From Date
Claims References / Fieldcode / Name
KMBRKF / Bkr Claim Ref
KMASNM / Assured Name
KMVSDS / Vessel/Whse Desc
KMMKKF / Market Clm Ref
KMCMQQ / Claimant
KMMDMM / Orig Mkt Claim Amt
KMLOTW / Loc Name
KMNPLQ / Plant Location
KMASOG / Original Insured
KMACYR / A/C Year
PODQHP / Deductibles
POTSHP / Current Tsi/Cover/Capacity
Codes / Fieldcode / Name
POSSCD / Status
C1TRRF / Trans Ref
C1LBRC / Account Source
POSECD / Section
C2BHCD / Branch
C1CBCD / Class
C1ATCD / Account Type
C1DKTY / Direct Type
VCZMVD / Stamp Code
Dates / Fieldcode / Name
C1CNDT / Control Date
POCGDT / Date Closed
VCDUJF / Due From
VCDUJT / Due To
Exchange Rate / Fieldcode / Name
C1PECG / Period Closed
VCPEDS / Periods Closed Description
C1OGCU / Original Currency
C1OBXC / Original Currency Closed Exchange rate
VCACCU / A/C Currency
C1ABXC / Accounting Currency closed Exchange rate
LPSO Codes / Fieldcode / Name
CARSCD / Risk Code
CACACD / Lloyd's Ca Category
CAFICD / Lloyd's FIL Market Code
CAQCCD / Lloyd's CA Qualifying Cat Code
CAF1CD / FIL Code 1
CABCCD / Business Category Code
CAF2CD / FIL Code 2
CATFCD / Trust Fund
Percentages / Fieldcode / Name
POWLPC / Written Line %
POPROZ / Brokers Written Order %
POSLPC / Signed Line%
POSGOZ / Brk Signed Order %
Policy Amount Columns / Fieldcode / Name
PO|CTL / Amount Base Currency Equivalents
PO|LXS / Amount Qualifiers
PO|LX2 / Amount Qualifiers (Currency Specific)
PO|CC1 / Currency amounts
Policy Amounts / Fieldcode / Name
PAAMT1 / Additional Amount Field No.1
PAAMT2 / Additional Amount Field No.2
PAAMT3 / Additional Amount Field No.3
PAADD1 / Additional Deductibles 1
PAADD2 / Additional Deductibles 2
PAADD3 / Additional Deductibles 3
PAADD4 / Additional Deductibles 4
PAADD5 / Additional Deductibles 5
PAAEP1 / Additional EPI 1
PAAEP2 / Additional EPI 2
PAAEP3 / Additional EPI 3
PAAED1 / Additional EPI Change Date 1
PAAED2 / Additional EPI Change Date 2
PAAED3 / Additional EPI Change Date 3
PAALM1 / Additional Event Limit 1
PAALM2 / Additional Event Limit 2
PAALM3 / Additional Event Limit 3
PAALM4 / Additional Event Limit 4
PAALM5 / Additional Event Limit 5
PAOBX1 / Additional Exchange Rate 1
PAAGH1 / Aggregate Deductible 1
PAEIHP / Base EPI
PAOGCU / Currency
PATSHP / Current Tsi/Cover/Capacity
PADQHP / Deductibles
PAEVHP / Event Limit
PALIXR / Liability Original To base Exchange Rate
PAOBXW / Original to Base Written Exchange Rate
PAOGP1 / Original Trans Amount Closed
PAMS@O / Possible Maximum Loss
PAMSPC / Possible Maximum Loss Percent
PARBHP / Rating Basis Amount
PATVHP / TSI At Inception
PATCHP / TSI For Earthquake
PAOWAR / War Limit
PAWTH1 / Written 100% EPI
PAEIWO / Written Org Cur EPI
PAXQHP / XS Point
Policy Codes / Fieldcode / Name
POSECD / Section
POBHCD / Branch
POUWCD / Underwriter
POWHCD / Whole A/C
POLDCD / Leader(Coded)
PORITY / R/I Type
POZMVD / Stamp Code
PORWTY / Renewal Type
POUGCN / Underwriting Control
POCBCD / Class
PODICD / DTI
POOGCD / Origin
POMKCD / Market
POTACD / Territory
POLQCD / Location
PORRCD / Retro
POCCCD / Ceding Company
POLBR1 / Account Source
POLBRC / Source
POPLCD / Placing
POZQCD / Special Clause
POLOPE / Loss Period
POBSPI / POBSPI
POAACV / Country
POGKCD / Risk Grade
POGUCD / Group ID Cde
PODNCD / Dimension
POXXCD / Exposure
POCYCD / Country
POKXCD / Construction Class
POLMCD / Limit
POQOSS / Out Mode Status
POZJCD / Project
POCSCD / Company Master
POLYCD / List
PONPCD / Property ID
POIXTY / Index Type
POSXCD / Syndicate Code -Agen
POBOLD / Bureau Leader
POSYC2 / Bureau 2 char ID code
POCSSX / Company Master Suffx
POIZCO / Intermediary Company
POIZLQ / Intermediary Company Location
POIZTA / IntermediaryTerritory
POMPCD / Major Peril
POTDVD / Trade
POZICD / Standard R/I
POQDFG / Direct/Reinsurance
POUGTY / Underwriting Type
POPC01 / Policy Code Number 1
POPC02 / Policy Code Number 2
POPC03 / Policy Code Number 3
POPC04 / Policy Code Number 4
POPC05 / Policy Code Number 5
POPC06 / Policy Code Number 6
POSBCD / Sub Account
POSBC1 / Account Source Sub Account
POLBR2 / Originating Broker
POSBC2 / Originating Broker Sub Account
POUSTF / Us Trust Fund
POSOCD / Source Of Business
POJRCD / Jurisdiction
POPC07 / Policy Code Number 7
POPC08 / Policy Code Number 8
POPC09 / Policy Code Number 9
POPC10 / Policy Code Number 10
POPC11 / Policy Code Number 11
POPC12 / Policy Code Number 12
POPC13 / Policy Code Number 13
POPC14 / Policy Code Number 14
POPC15 / Policy Code Number 15
POPC16 / Policy Code Number 16
POLWCU / Orig Loss Wrrnty Ccy
EDEUCD / Endorsing Underwriter
PHNUCD / NTU Reason
PHPDCD / Policy Description
PODMCD / Domicile
POCDCD / Conditions
POELCD / Exclusions
POIPCD / Incident or Peril
POETCD / Event
POCRCD / Coverage
POPTCD / Policy Type
POPC17 / Policy Code Number 17
POPC18 / Policy Code Number 18
POPC19 / Policy Code Number 19
POPC20 / Policy Code Number 20
PSNOTY / NOC Type
PSLMTY / Lineslip Type
PSBXS1 / Allow Bx Closings
PSBXKT / Allow Bx Claims
POPETP / Period Type
PHTICD / TRIA Code
Policy Dates / Fieldcode / Name
POEHJT / Effective To Date
POPOET / Policy Entry Date
POEHJF / Effective From Date
POPDDT / Paid Date
PODJDT / Diary Date
POCGDT / Date Closed
POEKDT / Expiry Date
POICDT / Inception Date
POFIDT / 1St Inception Date
POWGDT / Wording Date
POWNDT / Written Date
PONCDT / Notice Of Cancellati
POENDT / Entry Date
POSPDT / Slip Date
POADF1 / Additional Date Field No.1
POADF2 / Additional Date Field No.2
POADF3 / Additional Date Field No.3
POADF4 / Additional Date Field No.4
PONNDY / Notice Number of Days
POCVDT / Cover Date
POEDDZ / Latest Endorsement Date
PHQEDT / Quote Expiry Date
POPEQU / Period Units
PSNCID / NOC Issued
PSNCAD / NOC Acknowledged
PSNCDD / NOC Due Date
PSCSDT / Date of Last Survey
PSR1DT / Peer Review Date
PSR2DT / Peer Review Date 2
PSLRDT / Last Review Date
PSUVDT / Last U/W Visit to Binding Office
PSWDAD / Wording Agreed Date
PSWDQD / Wording Queried Date
Policy References / Fieldcode / Name
POPSRF / Psac Reference
POTNRF / Transaction Reference
POASNM / Assured Name
POBRRF / Broker/Their Ref
POOGRF / Original Reference
POMKRF / Market Ref
POPEAZ / Period
POIWRF / Inward Policy Reference
PORRID / Retro ID
PORF01 / Additional Reference Field No 1
PORF02 / Additional Reference Field No 2
PORF03 / Additional Reference Field No 3
POBRKC / Broker Contact
POLCNM / Assured Name
VRTQRF / QPM Reference
VRQBRF / Bound Policy Reference
PHUSRF / Our Reference
PORF04 / Declined Comment
PORF05 / Additional Reference Field No 5
PORF06 / Additional Reference Field No 6
PORF07 / Additional Reference Field No 7
PORF08 / Additional Reference Field No 8
PORF09 / Additional Reference Field No 9
PORF10 / Additional Reference Field No 10
PORF11 / Additional Reference Field No 11
PORF12 / Additional Reference Field No 12
PORF13 / Additional Reference Field No 13
PORF14 / Additional Reference Field No 14
POWRDG / Wording
POOXID / Operator ID
PSSLNM / Slip Leader
PSLCNM / Leading Company
PSL2NM / Second Company Lead
PHPKNO / Package Number
PHPMCD / Programme Code
PHRFNO / Unique Ref Number
PHR011 / 1 Char Reference
PHT1CD / Risk Type
PHT2CD / Risk Sub type
References / Fieldcode / Name
VCCTNM / Contract Name
C1ACDL / Account Details

These fields will appear in the list for their respective field groups. The user will have the option of moving the fields from the available list to the selected list and vice versa. The fields finally selected by the user will appear on the Closings Screen.

Note:The “Excess Qualifiers” fields are internally dependent upon the fields of the “Policy Amounts” field group. This implies that when a field in the “Policy Amounts” group is selected the corresponding field in the “Excess Qualifiers” will be selectedautomatically and shown on the Closings Input Screen.

The user will also have the option of selecting the Qualifiers column from the Policy Amount Columns Field Group to make it appear on the screen. If it is not selected then the Qualifiers Column and its fields will not appear on the screen.

3.2.3Rules Tab – Adding / Editing Rules on the fields

3.2.3.1Creating / Editing Rules

Selecting the Rules tab for the application Closings Input will list all the System and Product Rules for the application. System rules will not be editable by the user. The user will be able to ADD, EDIT, DELETE, and INSERT Product Rules.

3.2.3.2Rules Processing

Closings Input will be made to read and implement rules, setup through Business Customisation.

3.2.3.3Rules setup for Closings Type

There will be a provision of setting up different Rules for different Closings Type (Policy Closings, Claim Closings, First and Final Closings).

Using the “Conditional Rule Group” Rule type, the user will be able to set up Rules for different Closings Type, using the statement [vrCLTY] = ’Policy’/ ‘Claim’/ ‘FirstAndFinalClaim’

After creating the Policy type conditional group, the user will be able to create Rules under this group. All the Rules created under the group will be applicable for the respective Closings Type.

3.2.3.4Rules setup for Closings Action

Similar to the Closings Type Rules, the user will be able to have different set of Rules for different Closings Action (New Closings, Edit Closings and Copy Closings).

Conditional Rule group will be used and the statement to be used will be [vrCLAC] = ‘New’ / ‘Edit’ / ‘Copy’.

Under the group, the user can have combination of Rules that will apply to the respective Closings Action.

3.2.3.5Copy Rules on Fields

The users can also define Copy Rules on the fields that they want to be copied when Copy Closings is done.

3.2.3.6Fields available for Rules

Rules will only be available for input capable fields. However, the user can define Rules such that the fields in the list belowcan get values from any other field (Input capable or not).

Rules can be setup for the following fields:

Fields
Fieldcode / Name
C1ACDL / Account Details
C1TRRF / Trans Ref
C2BHCD / Branch
C1CBCD / Class
C1ATCD / Account Type
C1CNDT / Control Date
VCDUJF / Due From
VCDUJT / Due To
C1PECG / Period Closed
C1OGCU / Original Currency
VCACCU / A/C Currency
C1OBXC / Original Currency Closed Exchange Rate
C1ABXC / Accounting Currency Closed Exchange Rate
VCSLPC / Signed Input %
C4LBRC / Long Broker Code
C4SBCD / Posting Account Sub Account
C4DUDT / Installment Due Date
C4S1CU / Settlement Currency
C4OQXP / Original Currency Paid Exchange Rate
C4PSRF / Bureau Reference
C4BXCD / Broker Code
POSYC2 / Bureau 2 Char ID Code
CARSCD / Risk Code
CACACD / Lloyd's Ca Category
CAFICD / Lloyd's FIL Market Code
CAQCCD / Lloyd's CA Qualifying Cat Code
CAF1CD / FIL Code 1
CABCCD / Business Category Code
CAF2CD / FIL Code 2
CATFCD / Trust Fund
VCEVVD / Event and Sub Event Codes
vrCLTY / Closings Type
vrCLAC / Closings Action
On Outstandings Screen
KTCMTN / Trans Type
KTCNDT / Control Date
KTOGCU / Org Ccy
KTAYDS / A/C Ccy
KTOBXC / Org Ccy/Base Clsd Exchge Rate
KTABXC / Acc Ccy/Base Closed Exchge Rate
KTOWDT / Alt O/S Date
KTSPC1 / Share
KTOMEN / Outstanding Amount
KTAPEN / Paid Amount
KTACEN / Cash Amount
On Reserves Screen
RSRVNR / Reserve Narrative
vrRA@O / Retained Amount in Original Currency
vrLA@O / Released Amount in Original Currency

Note:Rules on the fields vrCLTY and vrCLACwill only be Read only i.e. the user will only be able to use them when defining them in conditions rules group, but no rules will be allowed to change their value.

3.2.4Additional Frames in the Policy Info Tab

3.2.4.1Amounts Frame

Policy Info Tab on the Closings Input screen will also contain Amounts frame displaying the Amounts Details of the Policy.

The User will be able to customise fields in the Amounts Frame through Business Customisation.

3.2.4.2Accounting Terms Details Frame

Accounting Terms Details will also be shown on the Closings Input screen along with the Policy and Claims (in Claims Closings) details.

In Policy Info Tab, there will be an “Accounting Terms Details” frame that will have the Accounting Terms Details.

Fields in the Accounting Terms Frame are customisable through Business Customisation.

Note: Fields in the Accounting Terms Details frame will only be in viewable mode and hence not editable.

3.2.5Claims Details in Claims Closings

When doing the Claims Closings, in addition to the existing Tabs (Account Details and Policy Info) under Closings Header Tab, there will be one more tab Claims Info available to the user to see the Claims Details of the Policy.