iris 9.15-enh-000 installation instructions part 1...

IRIS 9.15-ENH-000 Installation Instructions Part 1 (AS400)

IRIS 9.15-ENH Installation

Instructions Part 1 (AS400)

Ref -- /tt/file_convert/5ad86b4d7f8b9a9d5c8d4822/document.doc Printed 22/01/07XGIS Version 01 of 88


Copyright notice

(c) Copyright Xchanging Global Insurance Solutions 2006. 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 XGIS.

Disclaimer

Information in this document is subject to change without notice and does not represent a commitment on the part of XGIS. XGIS provides no warranty of any kind with regard to this material including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. XGIS shall not be liable for errors contained herein or for any direct, incidental or consequential damages resulting from the use of this material



1. AMENDMENT HISTORYReason Date New ReferenceVersion 1 10/06 Q:\Iris Support\IRIS GUI Installations\Installation 9.15-ENH \

IRIS 9.15-ENH Installation Instructions Part 1 (AS400).01.doc



CONTENTS

1. AMENDMENT HISTORY ............................................................................................3

2. INTRODUCTION ..........................................................................................................6

3. OVERVIEW ....................................................................................................................7

IRIS RELEASE NAMING CONVENTION.............................................................................7

IRIS UPGRADE APPLICABILITY........................................................................................7

4. EXPECTED TIME .........................................................................................................8

5. INSTALLATION MATERIALS ...................................................................................9

ENCLOSED ITEMS...............................................................................................................9

OTHER ITEMS REQUIRED..................................................................................................9

6. INSTALLATION PRE-REQUISITES .......................................................................10

7. INSTALLATION REQUIREMENTS ........................................................................11

CURRENT VERSION OF IRIS............................................................................................11

EXCLUSIVITY....................................................................................................................11

8. INSTALLATION INSTRUCTIONS ..........................................................................12

GENERAL INSTRUCTIONS.................................................................................................128.1.1 Conversion Menu Options...............................................................................................12

INSTALLATION APPLICATION STRATEGY OPTIONS.......................................................178.1.2 Environment (Mode)........................................................................................................17

PRE-INSTALLATION PROCEDURES..................................................................................178.1.3 IRIS Preparation..............................................................................................................178.1.4 Back-up IRIS System.......................................................................................................188.1.5 System Preparation (Live Environment only)................................................................188.1.6 Delete SQL Packages.......................................................................................................188.1.7 Restoring XUNMTOOLS.................................................................................................188.1.8 Begin Upgrading IRIS to 9.15-ENH...............................................................................21

9. SYSTEM LIBRARY CHANGES ................................................................................26

IMPLICATIONS FOR GUI..................................................................................................26

10. APD - MENU SYSTEM ...............................................................................................27

11. USER DEFINED QUERIES ........................................................................................28

12. POST UPGRADE PROCEDURES .............................................................................29



SET PRINTER FILES TO HOLD IF REQUIRED (ONLY RUN AFTER A LIVE UPGRADE)......29

INSTALLATION CHECKS...................................................................................................30

CONTACT XGIS................................................................................................................30

13. DATA AREAS ...............................................................................................................31

14. ASSISTANCE CONTACTS ........................................................................................33

15. FILES AFFECTED/UPDATED ..................................................................................34

NEW DATABASE FILES.....................................................................................................34

CHANGED DATABASE FILES............................................................................................35

16. NEW/CHANGED FIELDS ..........................................................................................43

17. SERVICE NOTIFICATIONS ADDRESSED ............................................................68

18. IR RELEASE NOTES ..................................................................................................69

19. FIX PROGRAMS .........................................................................................................70

20. APPENDIX ....................................................................................................................78

LIBRARY NAMING CONVENTION.....................................................................................78

21. SUPPLEMENT .............................................................................................................79

Progress Flow Sheets.......................................................................................................79



2. INTRODUCTION

Conventions

Throughout this guide the following conventions have been used:

AS/400 commands which are to be entered exactly as shown are displayed with a Bold typeface eg. CHGLIBL LIBL(QTEMP)

Any commands which require a generic parameter to be substituted by specific parameter are displayed with a Normal Italic typeface enclosed within curly brackets e.g. {IRIS Data Library}, {Tape Device}.

Any AS/400 commands where a parameter needs to be entered where one does not exist are displayed in a Bold Italic typeface. This generally only occurs on AS/400 screen displays where the screen is initially displayed without a parameter and one is selected from a list eg. *DEV *TAP

On AS/400 screens where the existing parameter requires amendment, the existing parameter is displayed in a Bold Italic typeface and is enclosed in curly brackets eg. {XUNMSYS}. The value that needs to be substituted is given in the accompanying text.



3. OVERVIEW

IRIS Release Naming Convention

Because of the development of a GUI (Graphical User Interface) version of the IRIS database, it has become necessary to introduce a revised naming convention for the releases of the IRIS software. Previously the naming convention consisted of two parts:

a Version number and

a Release number

For example IRIS 8.1.

With the introduction of the GUI version, the naming convention consists of three parts:

the GUI Version number,

the IRIS version number and

a Release number

For example 4.9.1

The last releases of the IRIS software were versions 8.14 and 9.15-PTF.

If the version of IRIS being used is earlier than version 8.14 then the current version of the IRIS software needs to be upgraded to version 8.14 before proceeding with this upgrade to version 9.15-ENH. If you do not have the upgrade instructions or tape for version 8.14, then please contact either the IRIS Helpdesk (020 7780 5373) or your Account Manager.

IRIS Upgrade Applicability

This documentation refers to the installation of the upgrade to IRIS version 9.15-ENH of IRIS from either version 8.14 or 9.15-PTF.

The installation is achieved via a central menu, which is provided on the tape supplied. This method of operation promotes ease of use and reduces the possibility for error.

Please read the whole of this documentation thoroughly and decide on the various options presented before undertaking the upgrade installation.



4. EXPECTED TIME

To assist with the planning of this installation, estimates of the expected time are provided for each of the major sections of the installation. This includes the preparation time before the actual install is attempted. It should be emphasised that the times provided are only estimates. The processor size of the AS/400 and the quantity of the data within the IRIS database will affect the times stated below.

Pre - Installation preparation 1.00 hours

Back-up of IRIS libraries 1.00 hours

Restore items from Installation Tape 1.00 hours

Apply Installation 2.00 hours

Post Installation Procedures 1.00 hours

Total 6.00



5. INSTALLATION MATERIALS

Enclosed Items

The following items are enclosed:

Item Type Title Received

Tape Release IRIS Version 9.15-ENH - Upgrade

Documentation IRIS 9.15-ENH Installation Instructions Part 1 (AS400)

If any of the above items are not received or received in a damaged condition then please contact your Account Manager or those personnel listed under Assistance / Contacts

The tapes specified above contain the following items for this installation

Tape Release IRIS Version 9.15-ENH Upgrade Contents

Type Name DescriptionLibrary XUNMTOOLS or

XUNMTOOE00U/W Utility Tools

Library XUNMDTXE00 IRIS Data ObjectsLibrary XUNMSYSE00 IRIS Program ObjectsFolder/ Document

USYSDOC/ USYSHLP

IRIS Help Text Documents

Other Items Required

The following documentation has been posted onto the web-site and relates to this installation.Date Document Identification Title

Installation Guide 9.15-ENH9.15-ENH Release Notes

IRIS 9.15-ENH Release Notes.01.doc



6. INSTALLATION PRE-REQUISITES

This upgrade installation has been prepared on the basis that the following conditions exist on your machine:

The AS/400 is currently using Version 3 Release 2 or later of the operating system

The person undertaking the Installation has authority equivalent to QSECOFR or QSECADM

The User Profile E#UW exists on the AS/400 and has authority to the following commands:

RSTLIB

RSTOBJ

RSTDLO.

If any of the above are either not true or are not available then the upgrade installation will not run. Please contact your Account Manager for guidance.



7. INSTALLATION REQUIREMENTS

Current Version of IRIS

This installation can only be applied to version 8.14 or one of the 8.14-PTF levels or one of the 9.15-PTF levels of IRIS. The current version of IRIS can be found in Data Area ZZPFRZA0. For example, if you are currently on V8.14 of IRIS, this data area should be set to either ‘8.14’ or ‘8.14’ or ‘8.14ptfn’ or ‘814n’ (where n is the ptf level of version 8.14, e.g. ‘8145’ means version 8.14-005). The Data area can be accessed through the Data Area Manager option within IRIS. This option is found on the Housekeeping Menu. The data area can be found within the section entitled ‘General Data Area Maintenance’ and is entitled ‘IRIS Release Status’. In the past, this data area was not updated automatically when a system was upgraded, so unless it has been updated manually, it may be misleading. If you are at all unsure of the version you are currently on, please do not hesitate to call us.

Exclusivity

The upgrade installation cannot be applied if the IRIS system is in use. Please ensure that Users have been advised in advance of the intended date for the upgrade and that no Users are signed on to IRIS during the installation process.



8. INSTALLATION INSTRUCTIONS

General Instructions

Please note that all commands must be entered in upper case unless otherwise indicated. Sign on to the AS/400 using the profile E#UW. This profile must be used to ensure that the correct authority is used when applying Release 9.15-ENH.

Before the upgrade you should try to obtain a password for one of the User signons. This will be useful for checking accessibility to the IRIS system after the upgrade is completed.

The following section is a description of each of the menu options. This should be read before starting the upgrade on page 18 under the Pre-Installation procedures.

Conversion Menu

8.1.1 Conversion Menu Options

Option 1. Set Parameters / Data-areasThis option allows the operator to enter the details of the conversion to be performed. These details are stored and used by the later options on the menu.

Option 2. Restore Upgrade LibrariesThis option restores all libraries necessary for the upgrade to version 9.15-ENH to your AS/400. The libraries are named according to the standard library naming convention (The naming standards are explained in the Appendix in section 20).


CNVMNU CONVERSION MENU Select one of the following: 1. Set Parameters / Data-areas 2. Restore Upgrade Libraries 3. End Journalling on Data Libraries 4. Re-size Upgrade Files 5. Upgrade Data Libraries 6. Run Fix Programs

7. Restart Journalling 8. Update Bureau Message Severities 9. Print Upgrade Messages 10. Display Upgrade Status Data-area 11. Tools 12. Apply PTF to System Library Selection or command ===>


Option 3. End Journalling on Data LibrariesJournalling is ended on the data library to be upgraded.

Option 4. Re-size Upgrade FilesThis routine re-sizes all the new or amended physical files being delivered. This ensures that they are big enough to receive all of the data currently held in the equivalent environment to be upgraded IRIS file.

Option 5. Upgrade Data LibrariesThis option upgrades the existing data library for the chosen environment on the AS/400 to version 9.15-ENH of IRIS. All current data and data-area settings are retained. The parameters required for the option have already been entered under Option 1 - Set Parameters / Data Areas

If the error report contains one of the following error messages:

'Error occurred while converting IRIS files: see report for details.' 'Error occurred while adding members to currency file: see report for details.' 'Error occurred while deleting unwanted objects: see report for details.' 'Error occurred while running V15 fix programs: see report for details.' 'Error occurred while changing authorities to *ALL: see report for details.' 'Error occurred while updating MAXMBRS parameter: see report for details.' 'Error occurred while setting data area values: see report for details.'

then the main data conversion has completed normally, but one of the additional conversion routines has failed. Menu option 5 - Upgrade Data Libraries can be re-run after the error has been corrected. The data conversion routine will continue from the point where the error occurred. The error report will be produced automatically on your spool queue and will help to determine the problem.

The upgrade can be re-started after any error that occurs during the Upgrade Data Libraries option has been corrected. It is not necessary to restore the AS/400 or start the whole upgrade again. The re-start is made available by re-running option 5 on the menu.

Option 6. Run Fix ProgramsThis option calls the relevant fix programs to be run. There are some fix programs that are run automatically, but there are others that are not. You need to check the Fix program section on page 71 and follow the instructions.

Option 7. Restart JournalingJournaling is restarted for the (now upgraded) data library. Option 8. Update Bureau Message SeveritiesThis resets the Bureau message severities back to your preferred values.



Option 9. Print Update MessagesThis option prints a report listing the current situation of the upgrade procedure, the upgraded library names and any outstanding tasks. The option can be run at any time to determine the status of the upgrade. It should be run if any of the options end abnormally.

Option 10. Display Upgrade Status Data-areaThis option displays the stage in the upgrade process that has been reached.

Option 11. ToolsThis is a menu consisting of various options designed to reduce the manual work involved in the upgrade. Details are below.

Option 12. Apply PTF to System LibraryThis option should only be run if a PTF is being applied. For full releases, a new copy of the system library is restored from tape. For PTFs, changed programs need to be applied to the existing system library, so this option needs to be run. A parameter screen will be displayed for the system library to be entered. (eg XUNMSYT for a test upgrade, XUNMSYS for a live upgrade).

Conversion Tools Menu (CNVTOL)

This is a fairly new menu that has been added since the 6.12 release to try to reduce the amount of manual job submission for the user. The Menu is accessed from the standard conversion menu. The options on the menu need not be taken in sequence, i.e. one after the other, but are to be used as and when the manual states. It is important to note that these options will not run unless the parameters have been set for the upgrade. This is explained later in the manual.

The menu is as below:---------------------------------------------------------------------------------------------------------

CNVTOL CNVTOL Menu Select one of the following: 1. Set output queue of this job's spooled files to HOLD 2. Check Scope (Parameters must be set for opt.1 on Conversion Menu) 3. Check for Data Library lock (Parameters must be set for opt.1 on Conversion Menu) 4. Rename System Library (only after LIVE upgrade) 5. Set Printer Files to HOLD 6. Update Library List 7. Release output queue of this job's spooled files 8. Set Printer Files to not held



9. Store Check Information Before Upgrade10. Store Check Information After Upgrade 11. Run Upgrade Check

Selection or command ===> F3=Exit F4=Prompt F9=Retrieve F12=Cancel F13=Information Assistant F16=AS/400 main menu

---------------------------------------------------------------------------------------------------------

Option 1. Set output queue of this job's spooled files to HOLD

It is recommended that this be run before you begin the upgrade to prevent reports printing automatically.

Option 2. Check Scope

This option will submit the integrity checking job, and can only be run if the parameters have been set. The parameters are set using option 1 from the main Conversion menu. (F12 back to this menu if you are currently in the ‘Cnvtol’ menu). You will be asked to enter the name of the data library, journal library etc, and these will be used throughout the upgrade. If files are detailed on the reports produced by the checking job, these will need to be deleted before the upgrade can take place.

Option 3. Check for Data Library Lock

This option will display any users locking the data library. It is essential that no-one is using the data whilst the upgrade takes place, so do not start the upgrade whilst there are locks shown here.

Option 4. Rename System Library (only after LIVE upgrade)

DO NOT RUN THIS IF APPLYING A PTF

This is not relevant for PTFs.

This option is relevant to this particular release, but only following an upgrade to the LIVE system and only if the system library you are upgrading is called XUNMSYS (most IRIS sites do have their live system library as XUNMSYS).

Option 5. Set Print files to HOLD



This option will prevent all print files produced by IRIS from printing automatically.

Option 6. Copy Library List

This option will copy ZCSLREP, which holds the information necessary for APD into the relevant system library.

DO NOT RUN THIS IF APPLYING A PTF

This is not relevant for PTFs.

Option 7. Release output queue of this job's spooled files

This option will release the output queue held by selecting option 1.

Option 8. Set Print files to not held

This option will reverse option 5 and allow all print files produced by IRIS reports to print automatically.

Option 9. Store Check Information before Upgrade

Running this option will store record counts for all files and hash totals from selected fields on selected files BEFORE the upgrade.

Option 10. Store Check Information after Upgrade

Running this option will store record counts for all files and hash totals from selected fields on selected files AFTER the upgrade.

Option 11. Run Upgrade Check

This option will run reports comparing the BEFORE and AFTER information stored from options 9 & 10.

Installation Application Strategy Options

Please note that it is important to decide on the strategy to be adopted when applying this upgrade in advance of undertaking the task.

The installation can be performed in a number of ways depending on your current set up and the intended objective. It is important to decide your preferred route in advance. The factors affecting the choice are detailed below.

8.1.2 Environment (Mode)

The following options are available for the upgrade of the environments on your system.

Upgrade of Test Environment or Training Environment



Upgrade of Live Environment

Your selection may depend on whether you intend to test the new installation prior to its release to general Users of the system for the live business activities

Places that hold library lists in the GUI/AS/400 (initial library lists/System administration) will have to be re-visited after a test upgrade has taken place, to reflect any changes in system libraries. Section 9 has some reminders of what may need to be changed.

Pre-Installation Procedures

Ensure you are signed on as E#UW.

8.1.3 IRIS Preparation

Before the installation is applied a check must be made to ensure that all batch jobs have completed normally. To check a particular job queue, use the command:

WRKJOBQ QBATCH

In this example QBATCH is the job queue, but you can substitute this for your own specific queue.

It is strongly recommended that a closings update and a post closings be run. Furthermore, any reports scheduled to run during or after the installation should be completed prior to this installation. If any jobs do not finish normally then the problem must be resolved before the installation is attempted.

8.1.4 Back-up IRIS System

Before applying Release 9.15-ENH, it is imperative that the IRIS system is backed up. This will ensure that the system can be restored to its previous state should the installation fail or an unforeseen event occur whilst the implementation is taking place.

8.1.5 System Preparation (Live Environment only)

The installation will proceed more quickly if the following subsystems are ended:

QSNADS

QBATCH

Note: These sub-systems can be ended for a LIVE upgrade, but NOT for a TEST upgrade, since it will affect Users of the LIVE system.

The subsystems can be ended one at a time using the following command:

ENDSBS SBS({name of subsystem})



8.1.6 Delete SQL Packages

Please note that you need to delete the SQL packages for QGPL if you are upgrading a test or live system environment. In both test and live upgrades, users will have to be signed off whilst this deletion takes place. They will be able to sign back on to any environment not being upgraded straight after the deletion. For example, if you are upgrading the test system, users will be able to sign back on to live once the sql packages have been deleted.

DLTSQLPKG QGPL/IRIS* DLTSQLPKG data library/IRIS*

8.1.7 Restoring XUNMTOOLS

Firstly, you will need to remove your existing copy of the conversion tools library, XUNMTOOLS, from the library list. This will enable the existing library to be deleted. To remove the library from the library list type:

EDTLIBL

on a command line and press enter. This will display the libraries currently associated with your job. If XUNMTOOLS is displayed simply remove it from the list. Press enter twice to return to the previous screen.

You can either rename or delete your current version of XUNMTOOLS.

To delete the existing XUNMTOOLS library from the AS/400 enter the following command:

DLTLIB LIB(XUNMTOOLS)If you receive the error message "Library XUNMTOOLS not found" as a result of the delete library command, then ignore it.

To rename the existing XUNMTOOLS, enter the following command:

RNMOBJ OBJ(XUNMTOOLS) OBJTYPE(*LIB) NEWOBJ(XUNMTOO145) Having deleted/renamed the library, the version of the XUNMTOOLS library on the tape can now be restored onto your computer.

Restoring XUNMTOOLS from Save File

If XUNMTOOLS has been sent via save file it may have been sent as XUNMTOOE00. In this case it will be necessary to rename this to XUNMTOOLS as follows:

RNMOBJ OBJ(XUNMTOOE00) OBJTYPE(*LIB) NEWOBJ(XUNMTOOLS)



Restoring XUNMTOOLS from Tape

Place the tape into the AS/400 tape drive and restore the conversion tools library, XUNMTOOLS, from the tape onto the AS/400, making sure you leave the tape in the drive when it has finished.

The command is

RSTLIB SAVLIB(XUNMTOOLS) DEV({TAP01}) SEQNBR(1) ENDOPT(*REWIND)

Change TAP01 for the tape device name on your AS/400. If you are unsure of the tape drive to use, follow the instructions below headed ‘Identifying the tape drive’.

The message 'Security or data format changes occurred' may be received as a result of this command. Scroll down on the message. If there is an additional message stating that '0 objects not restored', then the upgrade may be continued.

Identifying the tape drive (only read if you are unsure of the tape drive to use)

If you do not know which device name to enter, use the following command:

WRKCFGSTS (Prompt the command by pressing F4)

Amend the screen displayed over the page to reflect that below and press enter twice:

This will produce a list of device drives and their status.


Work with Configuration Status (WRKCFGSTS) Type choices, press Enter. Type . . . . . . . . . . . . . . *DEV *NWS, *NWI, *LIN, *CTL, *DEV Configuration description . . . *TAP Name, generic*, *ALL, *CMN... Output . . . . . . . . . . . . . * *, *PRINT Bottom F3=Exit F4=Prompt F5=Refresh F10=Additional parameters F12=Cancel F13=How to use this display F24=More keys




If more than one tape drive is listed, you need to determine which drive your tape is actually in. The following command can be used to see what is in each of the tape drives. By repeating the command for each one, you will see which drive the IRIS tape is in:

DSPTAP

Prompt the command by pressing F4

Enter the name of each of the tape devices. Continue to press enter until a field called ‘Volume id’ is in view. For the correct tape device this will have a description of ‘IRIS’. Once you have found the correct drive, there is no need to continue checking the remaining drives.

Once XUNMTOOLS has been successfully restored, continue as follows:

In order to access the routines the library needs to be added to the library list. This can be achieved using the following command:

CHGCURLIB CURLIB(XUNMTOOLS)


Display Tape (DSPTAP) Type choices, press Enter. Tape device . . . . . . . . . {Tape Device} Name Volume identifier . . . . . . . *MOUNTED Character value, *MOUNTED File label . . . . . . . . . . . *ALL Sequence number . . . . . . . . 1 1-9999 Data type . . . . . . . . . . . *LABELS *LABELS, *SAVRST Output . . . . . . . . . . . . . * *, *PRINT End of tape option . . . . . . . *REWIND *REWIND, *UNLOAD F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display F24=More keys




The upgrade is controlled via the specifically designed menu. To access this menu, type the following on a command line.

GO CNVMNU

8.1.8 Begin Upgrading IRIS to 9.15-ENH

Take each option in turn and follow the instructions detailed below. You will not be able to continue with the next option until the previous one has completed successfully.

8.1.8.1 Option 1: Set Parameters / DataAreas

This is the first and most important menu option in the upgrade. This screen initialises all the parameters used by the upgrade during its course. It is the only menu option in the installation process where information must be entered, and this must be done before any other options can be run.

----------------------------------------------------------------------------Set Parameters / Data-areas (UPG1SETPRM)

Type choices, press Enter. IRIS System Lib to Upgrade . . . XUNMSYS NameIRIS Data Library to Upgrade . . {IRIS Data Lib} Name IRIS Journal Library . . . . . . {IRIS Journal Lib} Name Statements Data Lib to Upgrade {IRIS Statements Lib} Name Test/Train/Live Environment . . {Environment} TST, TRN, LVE Device . . . . . . . . . . . . . {TAPE} Name Current IRIS Version . . . . . . 014 014, 015 New IRIS Version . . . . . . . . E00 E00 Bottom F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display ------------------------------------------------------------------------------------------------------------------

The parameters required by this command are as follows:

Parameter DescriptionIRIS System Library to Upgrade Enter the name of the current IRIS system library for the

version of IRIS that you wish to upgrade.IRIS Data Library to Upgrade Enter the name of the current IRIS data library for the

version of IRIS that you wish to upgrade.IRIS Journal Library: Enter the name of the current IRIS Journal Library to be

upgraded. Note each Environment (see below) has its own Journal Library. The correct Journal Library must be associated with the correct Environment.

Statements Data Library: Enter the name of the current IRIS Outward Statements



data library that you wish to upgrade. No action will be taken if the Outward Statements module is not installed. Note: The upgrade to 9.15-ENH does not require the Statements library to be upgraded. Please ensure this parameter is left blank.

Test / Train / Live Environment: State the type of environment that you are converting ie. TST for Test, or TRN for Train, or LVE for Live

Device: State the device name of the tape drive.

Current IRIS Version: State your current version of IRIS. (see data area ZZPFRZA0). The program default is 013

New IRIS Version State the AS/400 version of IRIS to be upgraded to. The program default is E00 (9.15-ENH)

If you are unsure of the library names, the IRIS standard naming conventions can be found in the Appendix in section 20.

8.1.8.2 Integrity Checks/Database Locks

Run option 1 from the CNVTOL menu (under option 11 from the Conversion menu) to hold the output queue where any spool files that are produced by the upgrade will be sent, thus preventing them from printing automatically.

Run option 3 from the CNVTOL menu (under option 11 from the Conversion menu) to check that no-one is signed on and using the environment to be upgraded. If users are found to be locking anything, it is imperative that they sign off.

The integrity check job can now be submitted.Run option 2 from the CNVTOL menu (under option 11 from the Conversion menu) to submit the integrity checking jobs.

The following jobs are submitted to batch. Reports are produced which detail any errors.

The routine checks that the scoping of the database is consistent. All database relations (logical and physical files) must exist in the same data library. If this is not the case, then errors may occur during the delivery routines. Errors are detailed on two reports:

Bad physical files are ones which have logicals scoped over them from outside the data library

Bad logical files are ones that are scoped over physical files that exist outside the data library.



You can see the output produced by typing the following command:

WRKSPLF

If there are any files listed in these reports, they will have to be deleted before the upgrade can go ahead.

8.1.8.3 Store Check Information before the Upgrade

Run option 9 from the CNVTOL menu (under option 11 from the Conversion menu).

This will produce data in two output files in XUNMTOOLS which will then be used once the upgrade has been completed to produce a checking report.

Continue by taking the following options from the main Conversion menu:

8.1.8.4 Option 2: Restore Upgrade Libraries

Take option 2 and press enter from the main Conversion menu. There are no parameters to enter.

NB. If the upgrade libraries have already been restored then this option can be bypassed. Instead run the command:

CHGDTAARA DTAARA(UPGSTATUS) VALUE('2')

8.1.8.5 Option 3: End Journalling on Upgrade Libraries


8.1.8.6 Option 4: Re-size Upgrade Files


8.1.8.7 Option 5: Upgrade Data Libraries


8.1.8.8 Option 6: Run Fix Programs

Take option 6 and press enter from the main Conversion menu. There are no parameters to enter. Refer to the Fix program section on p71, for details of fix programs you may need to run. (It is important you look at this section and run any fix programs required at this point).



8.1.8.9 Option 7: Restart Journalling


8.1.8.10 Option 8: Update Bureau Message Severities

For a PTF, before taking option 8, make sure that the name of the software library you are upgrading is in your library list. For a live upgrade this will usually be XUNMSYS. There is no need to do this for a full release. Take option 8 and press enter from the main Conversion menu. There are no parameters to enter. You must do this for both a PTF and a full upgrade.

8.1.8.11 Option 9: Print Upgrade Messages


8.1.8.12 Option 12: Apply PTF to System Library

This option should only be run if a PTF is being applied. For full releases, a new copy of the system library is restored from tape. For PTFs, changed programs need to be applied to the existing system library, so this option needs to be run. A parameter screen will be displayed for the system library to be entered. (eg XUNMSYT for a test upgrade, XUNMSYS for a live upgrade). You do not need to do this for this release.

8.1.8.13 Copy APD Library List Definitions to delivered System Library

This option only needs to be run if APD menus are installed.

This option should only be run if a full release is being installed. For full releases, a new copy of the system library is restored from tape. The APD library list definitions need to be copied from the current system library into the new copy of the system library.

Run option 6 from the CNVTOL menu (under option 11 from the Conversion menu) to copy ZCSLREP into the new copy of the system library.

8.1.8.14 Rename System Library

This option does need to be run for this particular release.

This option should only be run if a full release is being installed. For full releases, a new copy of the system library is restored from tape. It will be named with a suffix indicating its release. The current system library, e.g. XUNMSYS, must be renamed and given a suffix and then the new library must be renamed to be the system library, e.g. XUNMSYS.

Run option 4 from the CNVTOL menu (under option 11 from the Conversion menu) to carry out these system library renames.



8.1.8.15 Store Check Information after the Upgrade

Run option 10 from the CNVTOL menu (under option 11 from the Conversion menu).

This will produce data in two output files in XUNMTOOLS which will then be used by the next option to produce a checking report.

8.1.8.16 Run Upgrade Check

Run option 11 from the CNVTOL menu (under option 11 from the Conversion menu).This will run a report to check the details from before the upgrade against the details from after the upgrade.

This will produce reports on your spool queue. You can access these by typing the following command:

WRKSPLF

Pressing F11 will show you the date and time of each spool file, so you should be able to identify this report.

The upgrade is now complete. The remainder of the document still needs to be read and followed, as there may be client specific changes to be made.



9. SYSTEM LIBRARY CHANGES

Implications for GUI

If the Test system is being upgraded and a new system library has been created:

The system library specified in ‘Sys Admin’ for the Test system will need to be amended.

The following is also required (reminded again later in section 12)

- The library defined in ‘Sys Admin’ must be changed to XUNMSYT (or whichever library name you are using)

- DRPSTP will need to be run - CRTSTP will need to be run

If XGIS are performing the upgrade on behalf of a client, remember to remind them to do this.



10. APD - MENU SYSTEM

There are no APD changes in this Release.



11. USER DEFINED QUERIES

It is important to realise that any Queries that use a file or files that have been changed by this Installation, need to be recompiled. This can be achieved by taking Option 2 - ‘Amend’ against the particular query and, without changing it, press F3 to exit and save the query program. This will ensure that the file changes are saved into the query.

The full list of IRIS files affected by this installation is included in the section 15; Files Affected / Updated.



12. POST UPGRADE PROCEDURES

Set Printer Files to HOLD if required (only run after a live upgrade)Some clients like to have all their IRIS printer files set so that spooled-files are created in a HLD (held) status, instead of the normal default, which is RLS (released). Following an IRIS upgrade you can run option 5 from the CNVTOL menu. If your requirements change and you subsequently wish the files to be created in a RDY state, you can run option 8 from the CNVTOL menu.

Bureau Issues if System Library has changedIf a client keeps different versions of the system library (e.g. HIH), it will be necessary to change the following to record the new system library:

Jobd – DOWNLOAD in whichever library it’s held (replace old system library in list)

Dtaara - UTLLRYAS and UTPSRSAS in XUNMDTA (replace old system library)

Stored Procedures build for GUIThe GUI system uses stored procedures that get built as part of the upgrade. This build takes note of the data library and system library.

The stored procedures should be built with the correct data and system library.

Use the following command:

DRPSTP (press F4 to prompt)

Type in the relevant data library (e.g. XUNMDTA) and press enter.

CRTSTP (press F4 to prompt)

Type in the relevant data library (e.g. XUNMDTA) and system library (e.g. XUNMSYS) and press enter.

NB. The above names are examples of standard library names.

Authority ChangesRun the following command to ensure that all files have the appropriate authority. You will need to substitute the data library for the name of your data library:

CHGAUTALL DTALIB(XUNMDTA) and press enter.



Data AreasThe GUI data area values need to be synchronised with the actual AS/400 data area values. You need to run the following two commands:

CALL PGM(UCDATAC0) PARM('XUNMDT*' '*YES' *REPLACE)CALL PGM(UCDATAC1) PARM('XUNMDT*' *YES)

Replacing XUNMDT* in both commands with the name of the actual library that you want to synchronise the data areas in.

(The 1st program builds a list of data areas in the file UCDOREP and the 2nd program retrieves the value for each data area and writes it out to the file UCDTREP)

Installation checks Following the installation of the upgrade and before Users are allowed back onto the system, it is recommended that the following checks are made:

1. Go into Closings Update as far as the submit screen but do not submit the report.

2. Go into Policy Enquiry.

3. Sign-on with a User’s password and repeat checks under 1 and 2.

Contact XGIS Once the upgrade is complete you should contact the IRIS Helpdesk to inform us that your Test / Live system is now on version 9.15-ENH of IRIS. This will enable us to update our IRIS Support customer records.

e-mail: [email protected]



13. DATA AREAS

The data areas shown below are either new, have been amended by the installation, or are included in the delivery library:

Data Area Object Description Notes ValueUTBDRCA1300084652/5630

Adopt Current Control Date (ELASS) (1=Yes, 0=No)

The control date applied to bureau claims (outstanding loss movements) is normally picked up from the transmission date. However, this Data Area allows the control date to be defaulted from the current processing month if required. If the transmission date is within the current processing month, then the bureau date (transmission) is used as the control date. However, if the bureau date is outside the current processing month and this Data Area is set to '1', then the processing date is used instead. If the bureau date is before the processing month, then the first day of the current processing month is used. If the bureau date is after the processing month, then the last day of the processing month is used.

‘1’ - Adopt current processing month if required.‘0’ - Use bureau supplied date as control date.

Default is ‘0’.

UZCNRZA1300056527/5638

Syndicate Group Control Month

The new data area has been created and will ultimately control the Syndicate Group Month End Date processing when it is available. It should be set to 'N' for the moment.

Default is ‘N’.

UTLLRYB3300101089/5710

Suppress Lloyd's Claim Paid Trans in Closings Update

This data area controls whether the Closings Update will create claim paid or cash transactions (claim transaction type ‘P’ or ‘C’) for Lloyd’s claim closings. Note that this new data area is now used instead of data area UTLLRYAU which the program previously used for this purpose. This is because this data area was not actually specifically designed for this purpose.At the time of writing, this data area should be set to ‘Y’ only at LSML, Novae, Abacus and Limit.It should be ‘N’ elsewhere.

Default is ‘N’.Set to ‘Y’ if paid claims transactions are NOT required to be created for Lloyd’s claim closings.

Note that Paid claim transactions will still always be created for non-Lloyd’s claim closings, whatever of the value in this new data area.



Data Area Object Description Notes ValueUSCURZA2 Overwrite Closings

Entry Date and Time

This data area has been created to control the population of the entry date and time on the statistics files by closings update.

'N' - the entry date and time is not amended, i.e. it will be populated with the date and time from the Closings Log files.

'Y' - the entry date and time will be populated with the date and time that the transaction was written to the stats files by closings update.

The default for this data area is 'N', i.e. that the date will not get updated.

XSDLRZA1300027032/5546

Limit RISYS 2000 Download FTP Parameters

Stores details of the server to where the download file will be sent.

Position Length

1 10 User Name.

11 10 User Password.

21 15 Server IP Address.

36 25Directory (if applicable)

Set as per Notes.



14. ASSISTANCE CONTACTS

In addition to your Account Manager the following personnel may be contacted in relation to this installation for advice and assistance.

Help Desk (020) 7780 5373



15. FILES AFFECTED/UPDATED

Listed below are the new files that have been installed or existing files which have been affected by the application of this installation.

New Database Files

Physical files

File Description AttributeUCTCREP Tax Codes PFUCTPREP Tax Code Percentages PFUCZHREP Syndicate Groups (ZHCD) PFUCZMREP Syndicates (ZMCD) PFUKKIREP Claim Business Items PFUPETREP EPI Taxation PFUPMPREP MID Interface Policy Details File PFUPPLREP Policy Locking File PFUPSIREP Syndicate Index Table PFUPS0REP Security Field Index (Supports 1 Index) PFUPS1REP Security Field Index (Supports 2 indexes) PFUPS2REP Security Field Index (Supports 4 indexes) PFUPS3REP Security Field Index (Supports 8 indexes) PFUPS4REP Security Field Index (Supports 16 indexes) PFUTOIREP Bureau Closings Log - Taxation File PFUXFSWKP Unused References Workfile (TYPE!UGYR!RFKY!SLID) PFUXIRREP Initial Reference Ranges (TYPE!UGYR!RFKY) PFUXIRWKP Initial Reference Ranges Workfile (TYPE!UGYR!RFKY) PFUXMFREP MID Interface Header Audit File PFUXMTREP MID Interface Policy Details Audit File PFUXURQYP0 Populate Used & Unused Refs and Ref. Ranges-QRYF1 PFUXURQYP1 Populate Used & Unused Refs and Ref. Ranges-QRYF2 PFUXURREP Used References (UQCK!AUCV!SLID) PFUXURWKP Used References Workfile (UQCK!AUCV!SLID) PFUXUSWKP Next available Reference Workfile (UGYR!TYPE!RFKY) PFUZDYREP DY: Number of Days In Year PFXSD2REP Limit RISYS 2000 Accurals Download File PFXSD2WKP0 Limit RISYS 2000 Download FTP Script PFXSD2WKP1 Limit RISYS 2000 Download FTP Error Log PFXSD2WKP2 Limit RISYS 2000 Accruals Pipe Delimited FTP File PFXSD3REP Limit RISYS 2000 Claims Download File PFXSD3WKP2 Limit RISYS 2000 Claims Pipe Delimited FTP File PFZZDRREP Database Reconciliation Results PFZZDTREP Database Reconciliation Tests PF

Logical Files

File Description AttributeICDXREL3 Deduction calc Keyed DDCD, DXGU, AMCD LFICPFREL4 Pre-Allocation Flags KEYED COCD LECD TRF1 LFILALRELE TITLE AL:(ALTN|COCD|LECD|LBRC|SBCD|ENDT|AUNO|ALDT) LF



File Description AttributeICTRREL6 TITLE TR: TRANSACTION REFERENCES (TRRF,SMTY,COCD) LFILLEREL00 TITLE LE: LEDGER (COCD|LECD|LBRC|SBCD|ENDT) LFUCDNREL1 Dimension Code Keyed DNDNCD UNIQUE LFUCG1REL1 Class Analysis Group 1 Code Keyed G1CD LFUCG2REL1 Class Analysis Group 2 Keyed G2CD LFUCZHREL0 Syndicate Groups (ZHMY DESCEND) LFUCZLREL1 Stamp Code file KEYED ZMCD ZMYR LFUKKTRELK Claims Transactions(PHID!PSID!OGCU!CMSQ!KQID!KSID) LFUPAAREL3 Unique Key {PSID!ATID!TMNO!AAID} LFUPIZREL9 Policy Business Items Unique Key Logical LFUPPKREL8 POLICY FLAGS FILE (UNIQUE PSID) LFUPVSRELH Policy Vessel File Unique Key Logical LFUSCNREL1 Closings log - Narrative file LFUSCNREL2 Closings log - Narrative file LFUSHSREL9 TITLE HS: HISTORY FILE(PONO!POSQ!UGYR! ACYR!DANO!) LFUSSNREL1 Statistics - Narrative file LFUSSNREL2 Statistics - Narrative file LFUSS2REL4 Stats section file - Link to USS1REP LFUTKAREL6 Bureau Claims Summary Data(SYC2!FLMB!CGSN) LFUTKEREL0 Bureau Claims - Error Messages KES1BO LFUTKEREL1 Bureau Claims - Error Messages KES1BO!KEMGID LFUTMBREL1 Member Company x-ref KEYED SYC2 MBCO LFUTOMREL0 Bureau Closings - Error Messages TMS1SQ LFUTOMREL1 Bureau Closings - Error Messages TMS1SQ!OMMGID LFUTONREL1 Bureau Closings log - Narrative file LFUTONREL2 Bureau Closings log - Narrative file LFXSD2REL0 Limit RISYS 2000 Accurals Download Logical 0 LFXSD3REL0 Limit RISYS 2000 Claims Download Logical 0 LFZBV1DL01 ILUCMS Mapped Details - Key for UTILBLR3 LF

Changed Database Files

Physical Files

File Description AttributeICRUREP TITLE RU: REVENUE CODES (*NONE) PFILCPQYP1 CP: CREATE POSTINGS QUERY FILE PFILCPQYP2 T0 TRANSACTION FILE DUPLICATES QUERY FILE PFILCPQYP3 T0 TRANSACTION FILE BALANCE CHECK QUERY FILE PFILLEREP INCAS.Physical Ledger PFILT0CPP INCAS.Physical Ledger Transactions PFILYEWKP INCAS Ledger File back-up for year end roll PFIXLKREP INCAS Generic Locking File PFUCCAREP Category Codes PFUCRCREP Risk Code validation X-Ref PFUCZGREP Syndicate Group Codes PFUKKMREP CLAIMS MASTER (O!PONO!POSQ!UGYR!DANO!CMS PFUKMRWKP Fix KT Movements work file PFUKOTREP OCR TRANSACTIONS PFUKSRQYP0 TITLE KS: CLAIMS SUMMARY FORMAT FILE FOR SUMMARY R PF



File Description AttributeUPDDREP TITLE DD: DEDUCTIONS FILE (O!PONO!POSQ!UGYR!DANO!D PFUPFNREP FN: RISK FIELD HISTORY (NUMERIC) PFUPFTREP FT: RISK FIELD HISTORY (TEXT) PFUPIEWKP1 Iris Enquiries - Master Enquiry U/W work file PFUPIEWKP2 Iris Enquiries - Master Enquiry Stats work file PFUPKPREP TITLE KP: POLICY PERILS EXPOSURE (O!PONO!POSQ!UGYR PFUKKMREP CLAIMS MASTER (O!PONO!POSQ!UGYR!DANO!CMS PFUPINREP Policy Instalments PFUPMPREP MID Interface Policy Details File PFUSADQYP Reinsurers aged debt - Query File PFUSARP0P0 P9: USARP0P0 (*NONE) PFUSCIP0P5 P4: USCIP0P5 (*NONE) PFUSCIP0P8 PJ: USCIP0P8 Amounts PFUSCIWAP3 P3: USCIWAP3 (*NONE) PFUSCIWAP5 WA: USCIWAP5 (*NONE) PFUSCIWAP8 WA: USCIWAP8 Amounts work fields PFUSCNREP Closings log - narrative file PFUSCUQYP1 QY: Closings Updates query file PFUSC1REP CLOSINGS LOG - HEADER RECORD PFUSC2REP Closings Section log - Physical file PFUSC3REP TITLE C3: CLOSINGS LOG - AMOUNTS FILE PFUSF1REP F1: Participant Statistics Header Record PFUSHRQYP0 TITLE SH: DUMMY FILE FOR HISTORY REBUILD PFUSHRQYP2 Query file for history rebuild – part stats PFUSRAQYP Reinsurers Aged Debt - Query file PFUSSFREP Stats Premium/Claim/Outstanding PFUSSNREP Statistics - Narrative file PFUSS1REP Statistics header file PFUSS2REP Statistics section/code file PFUSS3REP TITLE S3: STATISTICS FILE AMOUNTS PFUSTCREP Triangulation Control PFUSTIREP Cash Taxation Log File PFUTD2F0P0 PSAC D02 Premium Signings - data structure PFUTD2F0P1 PSAC D02 Premium Signings - data structure alpha PFUTD2REP LIRMA D02 Premium Signings PFUTH1REP ILUCSM Signing Details PFUTKJREP Bureau Claims - Core SCM Transaction PFUTLRCPP Bureau Message Receipt Log File PFUTONREP Bureau Closings log - Narrative file PFUTO1REP Bureau closings log - Header file PFUTO1WKP0 Bureau closings - Dummy header for valdation PFUTO2REP TITLE O2: BUREAU CLOSINGS LOG - SECTION/CODE FILE PFUTO3REP Bureau closings log - Amounts file PFUTPSP0PP Parameter list for bureau closings edit PFUTXAREP Bureau Revenue code X-ref PFUXFSREP Unused References (TYPE!UGYR!RFKY!SLID) PFUXISREP Reference Formats (TYPE!YRFL!RFKY) PFUXUSREP Next available Reference (UGYR!TYPE!RFKY) PFUZFDRFP IRIS Field Reference File PFXSD1REP Limit Stats 2000 Download File PF



File Description AttributeILPXREL5 TITLE PX: PREALLOCATIONS (*NONE) <*N> LFILPXREL6 TITLE PX: PREALLOCATIONS (*NONE) <*N> LFILPXREL7 TITLE PX: PREALLOCATIONS (*NONE) <*N> LFILPXREL8 TITLE PX: PREALLOCATIONS (*NONE) <*N> LFILPXREL9 TITLE PX: PREALLOCATIONS (*NONE) <*N> LFILPXRELA TITLE PX: PREALLOCATIONS (*NONE) <*N> LFILPXRELB TITLE PX: PREALLOCATIONS (*NONE) <*N> LFILPXRELC TITLE PX: PREALLOCATIONS (*NONE) <*N> LFILPXRELD Pre-Allocations-Ledger Join Logical LFILT0CPL0 INCAS.Ledger Transactions - Logical 0 V2.00 LFILT0CPL1 INCAS.Ledger Transactions - Logical 1 V2.00 LFILT0CPL2 INCAS.Ledger Transactions - Logical 2 V2.00 LFILT0CPL3 INCAS.Ledger Transactions - Logical 3 V3.01 LFILT0CPL4 INCAS.Ledger Transactions - Logical 4 V2.00 LFILT0CPL5 INCAS.Ledger Transactions - Logical 5 V3.00 LFILT0CPL6 INCAS.Ledger Transactions - Logical 6 LFILT0CPL7 INCAS.Ledger Transactions - Logical 7 LFILT0CPL8 INCAS.Ledger Transactions - Logical 8 LFIXLKREL0 Generic Locking File Unique Key LFUCIIREL2 Interests - GUI Transfer LFUCMPREL2 Major Perils - GUI Transfer LFUCMQREL2 Minor Perils - GUI Transfer LFUCRCREL0 Risk Code validation X-Ref LFUKKMREL#X1 Claims Master - GUI (YRAC!CBCD) LFUKKMREL#X2 Claims Master - GUI (YRAC!MKKF) LFUKKMREL0 CLAIMS MASTER (O!PONO!POSQ!UGYR!DANO!CMS LFUKKMREL1 CLAIMS MASTER (O!EVCD!VBCD!) (RCFD<>"D") LFUKKMREL2 CLAIMS MASTER (O!PONO!POSQ!UGYR!DANO!CMS LFUKKMREL5 CLAIMS MASTER (O!PONO!POSQ!UGYR!DANO!CMS LFUKKMREL6 CLAIMS MASTER (O!PONO!POSQ!UGYR!DANO!CMS LFUKKMREL7 CLAIMS MASTER (MKKF!PONO!POSQ!UGYR!DANO! LFUKKMREL8 CLAIMS MASTER (O!PONO!POSQ!UGYR!DANO!CMS LFUKKMREL9 CLAIMS MASTER (O!PONO!POSQ!UGYR!DANO!CMS LFUKKMRELA CLAIMS MASTER (O!PONO!POSQ!UGYR!DANO!CMS LFUKKMRELB TITLE KM: CLAIMS MASTER (O!EVCD!VBCD!MKKF) LFUKKMRELC TITLE KM: CLAIMS MASTER (O!ACCD!MKKF) LFUKKMRELD Claims master by policy LFUKKMRELE Claims by Loss Date LFUKKMRELF Claims Master (PHID!PSID!CMSQ) LFUKKMRELG Claims Master (PSID!CMSQ) LFUKKMRELH Claims Master - GUI (PONO!MKKF) LFUKKMRELI Claims Master - GUI (MKKF) LFUKKMRELJ Claims Master - GUI (PONO!POSQ!UGYR!MKKF) LFUKKMRELK Claims Master - GUI (PONO!POSQ!UGYR!DANO!CMSQ(DESC LFUKKMRELL Claims Master - GUI (CMSQ!EDID) LFUKKMRELM Join logical - GUI - App.Enquiries - Claims/Event LFUKKMRELN Join logical - GUI App.Enquiries - Claims/Summary LFUKKQREL0 Claims Syndicates file (PHID!PSID!CMSQ!KQID) LFUKKSREL2 CLAIMS LOGICAL #2 LFUKKSREL3 CLAIMS LOGICAL #3 LFUKKSREL4 CLAIMS LOGICAL #4 LFUKKSREL5 CLAIMS LOGICAL #5 LFUKKSRELD Claims Logical D LF



File Description AttributeUKKSRELH Claims Summary(PSID!CMSQ!KQID!AYCD!OGCU!PHIO) LFUKKTREL8 JOIN LOGICAL FOR GUI CLAIM TRANS ENQUIRY (PERFRMNC LFUKOTREL1 OS: OCR TRNS (O!PONO!POSQ!UGYR!DANO!RICD!CBCD!AYCD LFUKOTREL2 OCR Transactions File LFUKOTREL3 OCR Trans File Logical by PONO/POSQ/OGCU/ACYR/DANO LFUKOTREL4 OCR Trans File By PONO/POSQ/ACYR LFUKOTREL5 OCR Transaction file LFUKOTREL6 OCR Trans Logical File (added fields ENDT & ENQT) LFUKOTREL7 OCR Transactions (PHID!PSID!SYID!SYSQ!OSID!OTID) LFUKOTREL8 OCR Transactions (PSID!SYID!SYSQ!OSID!OTID) LFUKOTREL9 OCR Transactions - GUI (PSID!RICD!CBCD!AYCD!OGCU) LFUKOTRELA OCR Transactions - GUI (PSID!OSID!PONO!POSQ!UGYR!A LFUKOTRELB OCR Transactions (OTID) LFUPDDREL0 DD: UPDDREL0 (PONO:POSQ:UGYR:DANO:TMNO:EDNO:DDSQ) LFUPDDREL1 DD: UPDDREL1 (PONO:POSQ:UGYR:DANO:EDNO:) LFUPDDREL2 DD: UPDDREL2 (PONO:POSQ:UGYR:DANO:EDNO:) LFUPDDREL3 DD: UPDDREL3 (PONO:POSQ:UGYR:DANO:EDNO:TMNO:DDSQ) LFUPDDREL4 DD: UPDDREL4 (PONO:POSQ:UGYR:DANO:EDNO:TMNO:DDSQ) LFUPDDREL5 DD: UPDDREL0 (PONO:POSQ:UGYR:DANO:EDNO:TMNO:DDSQ) LFUPDDREL7 DD: UPDDREL7 (PONO:POSQ:UGYR:DANO:EDNO:) LFUPDDREL8 DD: UPDDREL8

(PONO:POSQ:UGYR:DANO:EDNO:TMNO:DDCD:DLF

UPDDREL9 DD: UPDDREL8 (PONO:POSQ:UGYR:DANO:EDNO:TMNO:DDCD:D

LF

UPDDRELA Join lgl - Deductions & ded codes for print LFUPDDRELB Deductions (pono,posq,ugyr,dano,tmno,edno,ddsq) LFUPDDRELC DEDUCTIONS FILE (O!PONO!POSQ!UGYR!DANO!) LFUPDDRELD DEDUCTIONS FILE (O!PONO!POSQ!UGYR!DANO!) LFUPDDRELE DD: UPDDREL0 (PHID!PSID!DDID!TMNO!DDSQ) LFUPDDRELF DD: UPDDREL0 (PSID!DDID!TMNO!DDSQ) LFUPDDRELG Deductions file - GUI (PSID!DDID!TMNO!EDNO(Desc)) LFUPDDRELH Deductions file - GUI (PSID!DDID!TMNO(Desc)) LFUPDDRELI Deductions file - GUI (QPMU!QPMY!POTY) LFUPEDREL5 Endorsement log file - GUI (EDID) LFUPINREL0 Policy Instalments logical 0 LFUPINREL1 Policy Instalments logical 1 LFUPINREL2 Policy Instalments logical 2 GUI (PHID!PSID!INSQ) LFUPINREL3 Policy Instalments (PSID!SYID!SYSQ!AYCD) LFUPIZREL7 Policy Business Items LFUPKPREL0 Perils exposure logical 0 LFUPKPREL1 Perils exposure logical 1 LFUPKPREL2 POLICY PERILS EXPOSURE (O!PONO!POSQ!UGYR) LFUPKPREL3 Perils exposure logical 3 LFUPKPREL4 Perils Exposure logical 4 (PHID!PSID!KPID) LFUPKPREL5 Perils Exposure logical 5 (PSID!KPID) LFUPKPREL6 Perils Exposure logical - GUI(PONO!POSQ!UGYR!DANO! LFUPKPREL7 Perils Exposure logical - GUI(PSID!KPID!TACD!ZNCD! LFUPKPREL8 Perils Exposure logical - GUI(PSID!KPID!PJCD) LFUPKPREL9 Perils Exposure logical - GUI (QPMU!QPMY!POTY) LFUPKPRELA Join logical file - GUI App.Enquiries - Perils LFUPKPRELB Perils Exposure Logical B LFUPPHREL0 Policy Header - PHID LFUPPSREL1 Policy Sub-Type logical 1 LFUPPSREL2 Policy Sub Type (PSIM) LF



File Description AttributeUPSYREL2 Synidicates Share logical file 2 (PSID!SYID!SYSQ) LFUSC1REL0 CLOSINGS HEADER LOG - LGL #0 (S1SQ) LFUSC1REL1 CLOSINGS HEADER FILE - LGL #1 (S1SQ) LFUSC1REL2 LOGS LGL (|PONO|POSQ|UGYR|DANO|EDNO|ENDT LFUSC1REL3 CLOSINGS HEADER LOG - LGL #3 (CGSN) LFUSC1REL4 CLOSINGS HEADER LOG - LGL #4 (POLI) LFUSC1REL5 TITLE C1: CLOSINGS HEADER LOG - LGL #5 (PONO/POS LFUSC1REL6 Closings header log by policy LFUSC1REL7 Stats header file (CGSN|INNO|PONO|POSQ|UGYR|DANO) LFUSC1REL8 TITLE C1:CLOSINGS HEADER LOG (INRD!INNO!) LFUSC1REL9 Closings Header file lgl #9 LFUSC1RELA Closings header log (PHID!PSID!EDID!SYID!SYSQ!CMSQ LFUSC1RELB Closings header log (PSID!EDID!SYID!SYSQ!CMSQ!KQID LFUSC1RELC Closings header log (EDID!SYID!SYSQ!CMSQ!KQID!S1SQ LFUSC2REL0 Closings Section log - S1SQ/S2SQ excl dlts LFUSC2REL1 Closings Section log - default lgl S1SQ/S2SQ LFUSC3REL0 TITLE C3: CLOSINGS LOG - AMOUNTS FILE (S1SQ!S3SQ) LFUSC3REL1 TITLE C3: CLOSINGS LOG - AMOUNTS FILE (S1SQ!S3SQ) LFUSC3REL2 TITLE C3: CLOSINGS LOG - AMOUNTS FILE (S1SQ!S4SQ) LFUSC3REL3 TITLE C3: CLOSINGS AMOUNTS LOG (S1SQ!S4SQ!S5SQ!AM LFUSC3REL4 TITLE C3: CLOSINGS AMOUNTS LOG (S1SQ!S4SQ) LFUSC3REL5 C3: CLOSINGS AMOUNTS LOG (S1SQ!S4SQ!S3SQ) (RCFD<>" LFUSC3REL6 TITLE C3:CLOSINGS LOG - AMOUNTS FILE(S1SQ!S3SQ!S4S LFUSC3REL7 TITLE C3: CLOSINGS LOG - AMOUNTS FILE (S1SQ!S4SQ) LFUSC3REL8 TITLE C3:CLOSINGS LOG-AMOUNTS FILE(S1SQ!S2SQ!S5SQ) LFUSC3REL9 CLOSINGS LOG - AMOUNT FILE (S1SQ!S4SQ!S2SQ) LFUSC3RELA Closings log amounts (S1SQ!S2SQ!S4SQ) LFUSC3RELB Closings log amounts (S1SQ!S4SQ!S5SQ!S2SQ!AMCD) LFUSC3RELC Closings log amounts - GUI (S1SQ!S2SQ!S3SQ!S4SQ!S5 LFUSC4REL4 Clos J-lgl C1/C4/C5 by S1SQ/RDAU/RDBT/RDET LFUSC4REL7 CLOSINGS LOG JOIN-LOGICAL (USC4REP=USC1R LFUSC4REL9 C4-C1 join logical PSRF xd LFUSC4RELD Joined logicals USC4REP and USC1REP - GUI (PSRF) LFUSCNREL0 Closings log - Narrative file LFUSF1REL# Participant Stats (by F1INRD) LFUSF1REL0 PARTICIPANT STATS HEADER - LOGICAL #0 (S LFUSF1REL1 PARTICIPANT STATISTICS HEADER - LOGICA LFUSF1REL2 PARTICIPANT STATISTICS HEADER - LOGICA LFUSF1REL3 PARTICIPANT STATS HEADER - LOGICAL #0 (S LFUSF1REL4 PART"C STATS HEADER-LOG #0(PONO!POSQ!UGY LFUSF1REL5 PART"C STATS HEAD-LOG#5(PONO!POSQ!UGYR!DAN LFUSF1REL6 PART"C STATS HEAD-LOG#6(CCCD!S1SQ) LFUSF1REL7 PART"C STATS HEAD-LOG#7(CCCD!S1SQ) LFUSF1REL8 PARTICIPANT STATS HEADER FILE - LOGICAL LFUSF1REL9 Partc Stats F1 + F4 joined F1S1SQ/F4S1SQ LFUSF1RELA Participant statistics header by policy LFUSF1RELB PAR11C STATS HEAD - LOG#B (CCCD!AYCD) LFUSF1RELC Participants stats header by CCCD/COCD/AYCD LFUSF1RELD Participant statistics header LFUSF1RELE Participant statistics LFUSF1RELF Participant statistics file (PHID!PSID!EDID!SYID!S LFUSF1RELG Participant statistics file (PSID!EDID!SYID!SYSQ!C LFUSF1RELH Participant statistics file (EDID!SYID!SYSQ!CMSQ!K LF



File Description AttributeUSF1RELI Joined logicals USF1REP and USF4REP - GUI (F1PSID) LFUSF4REL3 Partc Stats F4 + F1 + F3 joined S1SQ/S4SQ xd LFUSHSREL9 TITLE HS: HISTORY FILE(PONO!POSQ!UGYR!ACYR!DANO!) LFUSS1REL0 Stats header file - By S1SQ excl dlts LFUSS1REL1 Stats header file - Default logical by S1SQ LFUSS1REL2 St Hdr PONO/POSQ/UGYR/DANO/INNO/OGCU/AYCD xd LFUSS1REL3 STATS HEADER FILE - JOIN LOGICAL TO POST LFUSS1REL4 St HdrPONO/POSQ/UGYR/DANO/INNO/PECG/OGCU/AYCD LFUSS1REL5 Stats header file - By S1SQ/OGCU XDlts LFUSS1REL6 Stt header PONO/POSQ/UGYR/DANO/S1SQ Ex Dlts LFUSS1REL7 St Hdr PONO/POSQ/UGYR/DANO/OGCU/S1SQ Ex dlts LFUSS1REL8 St Hdr CCCD/HEAD Ex dlts LFUSS1REL9 St Hdr CCCD/CCY/HEAD Ex dlts LFUSS1RELA Join Logical Over Stats. Header & Postings LFUSS1RELB Statistics header by policy LFUSS1RELC Joined file USS1REP and USS4REP INRD S1SQ S4SQ LFUSS1RELD JOIN LOGICAL FOR GUI TRANS ENQUIRY (PERFORMANCE) LFUSS1RELE Stats Header logical for summary database build LFUSS1RELF Statistics header by policy LFUSS1RELG Statistics header (PHID!PSID!EDID!SYID!SYSQ!CMSQ!K LFUSS1RELH Statistics header (PSID!EDID!SYID!SYSQ!CMSQ!KQID!S LFUSS1RELI Statistics header (EDID!SYID!SYSQ!CMSQ!KQID!S1SQ) LFUSS1RELJ Joined logicals USS1REP and USS4REP - GUI (S1PSID) LFUSS1RELK Joined logicals USS1REP,USS4REP,USS5REP-GUI (S1SQ) LFUSS1RELZ Test file for QUERY SZQRY LFUSS2REL0 Stats section file - By S1SQ/S2SQ excl dlts LFUSS2REL1 Stats section file - Default lgl S1SQ/S2SQ LFUSS2REL2 Stats section file - By S1SQ/CBCD excl dlts LFUSS2REL3 Stats section file - By S1SQ Temporary file LFUSS3REL0 TITLE S3: STATS AMOUNTS FILE - LOGICAL #0 (S1SQ!S3 LFUSS3REL1 TITLE S3: STATS AMOUNTS FILE - LOGICAL #1 (S1SQ!S3 LFUSS3REL2 TITLE S3: STATS AMOUNTS FILE - LGL #2 (S1SQ!S4SQ!S LFUSS3REL3 TITLE S3: STATS AMOUNTS FILE - LOG #3 (S1SQ!S4SQ!S LFUSS3REL4 Stats amounts file (S1SQ.S4SQ.AMCD) LFUSS3REL5 TITLE S3: STATS AMOUNTS FILE - LOG #5 (S1SQ!S2SQ!S LFUSS3RELC TITLE S3: STATS AMOUNTS FILE - LOGICAL #0 (S1SQ!S3 LFUSS4REL6 Stats postings file joined to header & R/I LFUSS4REL7 S4-S1-S3 join logical S1SQ/S4SQ xd LFUSS4REL9 S4-S1 join logical PSRF xd LFUSS4RELL Joined logicals USS4REP and USS1REP - GUI (PSRF) LFUSSFREL1 Claim Outstandings by relative key LFUSSFREL2 Statistics by Control Date LFUSSFREL3 Statistics by PHID PSID - NOT USED ????? LFUSSNREL0 Statistics - Narrative file LFUSTIREL0 Cash Taxation Log file logical - Key TIS1SQ LFUTBQREL0 Joined logicals UTBQREP and UTO1REP - GUI (OXID!LE LFUTD2REL0 LIRMA D02 Premium Signings LFUTD2REL1 LIRMA D02 Premium Signings LFUTH1REL0 Downloaded Signings key: FLMB LFUTH1REL1 Downloaded Signings key: FLMB,MSRN LFUTH1REL2 Downloaded Signings Key FLMB/COID/APTY/CUS1 LFUTH1REL3 ILUCSM signing details key: FLMB NWIR MSRN LFUTKJREL0 Bureau Claims - Core SCM Transaction (Logical) LF



File Description AttributeUTO1REL0 Bureau closings log - Header logical (w/o deleted) LFUTO1REL1 Bureau closings log - Header by S1SQ LFUTO1REL2 Bureau closings log - Header by S1SQ LFUTO1REL3 Bureau closings log - by O1SYC2 O1FLMB LFUTO1REL4 Bureau closings log - Header by S1SQ LFUTO1REL5 Bureau closings header by policy LFUTO1REL6 Bureau closings log - Header join to UTO2REP LFUTO1REL7 Bureau Closings Log(PHID!PSID!EDID!SYID!SYSQ!CMSQ) LFUTO1REL8 Bureau Closings Log(PSID!EDID!SYID!SYSQ!CMSQ!KQID) LFUTO1REL9 Bureau Closings Log(EDID!SYID!SYSQ!CMSQ!KQID) LFUTO1RELA Bureau closings log - Header join logical LFUTO1RELB Claim Outstandings Logical B - |SYC2|RCTY|RCFD| LFUTO1RELC Bureau Header File - by S1SQ LFUTO2REL1 Bureau closings log - by S2SQ LFUTO3REL0 Bureau closings log - Amounts file logical 0 LFUTO3REL1 Bureau closings log - GUI (S1SQ) LFUTO3REL2 Bureau closings log - GUI(S1SQ!S2SQ!S3SQ!S4SQ!S5SQ LFUTONREL0 Bureau Closings log - Narrative file LFUTXAREL0 Bureau Revenue code X-ref logical (w/o deleted) LFUXPOREL6 Join log.file - GUI- App.Enquiries (Acc.Terms/Ded) LFXSD1REL0 Limit Stats 2000 Download Logical LF



16. NEW/CHANGED FIELDS

New Fields

File File Description Field Field Description Type LengthICRUREP TITLE RU: REVENUE CODES

(*NONE)IATXCY Country Code *CHAR 5

ICRUREP TITLE RU: REVENUE CODES (*NONE)

IAZRFG Zero Amounts Allowed *CHAR 1

ILCPQYP1 CP: CREATE POSTINGS QUERY FILE IAINRF Invoice Reference *CHAR 50ILCPQYP1 CP: CREATE POSTINGS QUERY FILE IAYPID Claim Payee ID *PACKED 6 (0 d.p.)ILCPQYP2 T0 TRANSACTION FILE DUPLICATES

QUERY FILEIAINRF Invoice Reference *CHAR 50

ILCPQYP2 T0 TRANSACTION FILE DUPLICATES QUERY FILE

IAYPID Claim Payee ID *PACKED 6 (0 d.p.)

ILCPQYP3 T0 TRANSACTION FILE BALANCE CHECK QUERY FILE

IAINRF Invoice Reference *CHAR 50

ILCPQYP3 T0 TRANSACTION FILE BALANCE CHECK QUERY FILE


ILLEREP INCAS.Physical Ledger IAINRF Invoice Reference *CHAR 50ILLEREP INCAS.Physical Ledger IAYPID Claim Payee ID *PACKED 6 (0 d.p.)ILT0CPP INCAS.Physical Ledger Transactions IAINRF Invoice Reference *CHAR 50ILT0CPP INCAS.Physical Ledger Transactions IAYPID Claim Payee ID *PACKED 6 (0 d.p.)ILYEWKP INCAS Ledger File back-up for year end

rollIAINRF Invoice Reference *CHAR 50

ILYEWKP INCAS Ledger File back-up for year end roll


IXLKREP INCAS Generic Locking File LKLCDS Lock Description *CHAR 50UCCEREP CE: Contact Type CECECD Contact Type *CHAR 3UCCEREP CE: Contact Type CECEDS Contact Type Description *CHAR 50UCCEREP CE: Contact Type CECESD Contact Type Description *CHAR 15UCCEREP CE: Contact Type CEISPY Contact Is Payee *CHAR 1UCCEREP CE: Contact Type CERCFD Record Flag Delete *CHAR 1UCCEREP CE: Contact Type CESTSQ Sort Sequence Asc. *PACKED 1 (0 d.p.)UCTCREP Tax Codes TCCYCU ORIGINAL CURRENCY CODE *CHAR 3UCTCREP Tax Codes TCDDCD Tax Code *CHAR 6UCTCREP Tax Codes TCPYTY Payment Type *CHAR 1UCTCREP Tax Codes TCTXCY Country Code *CHAR 5UCTPREP Tax Code Percentages TPDDCD Tax Code *CHAR 6UCTPREP Tax Code Percentages TPEKDT Tax Percent Expiry *PACKED 7 (0 d.p.)UCTPREP Tax Code Percentages TPICDT Tax Percent Inception *PACKED 7 (0 d.p.)UCTPREP Tax Code Percentages TPTXPC Tax Percent *PACKED 11 (7 d.p.)UCYPREP YP: Payee Details YPBCPT BACS Payment Type *CHAR 1UCYPREP YP: Payee Details YPCECD Contact Type *CHAR 3UCYPREP YP: Payee Details YPCLCT Payee Name *CHAR 25UCYPREP YP: Payee Details YPCOCD Company Code *PACKED 1 (0 d.p.)UCYPREP YP: Payee Details YPCPA1 Payee Address 1 *CHAR 30UCYPREP YP: Payee Details YPCPA2 Payee Address 2 *CHAR 30UCYPREP YP: Payee Details YPCPA3 Payee Post Code *CHAR 30UCYPREP YP: Payee Details YPCPA4 Payee Address 3 *CHAR 30UCYPREP YP: Payee Details YPCPA5 Payee Address 4 *CHAR 30UCYPREP YP: Payee Details YPCPA6 Payee Address 5 *CHAR 30UCYPREP YP: Payee Details YPEMAL Payee Email *CHAR 50UCYPREP YP: Payee Details YPLBRC Long Account Code *CHAR 5UCYPREP YP: Payee Details YPLECD Ledger Code *PACKED 1 (0 d.p.)UCYPREP YP: Payee Details YPRCFD Record Flag Delete *CHAR 1UCYPREP YP: Payee Details YPSAID SUN Account ID *CHAR 15UCYPREP YP: Payee Details YPSBCD Sub-Account Code *CHAR 1UCYPREP YP: Payee Details YPTEL1 Payee Phone 1 Home *CHAR 20UCYPREP YP: Payee Details YPTEL2 Payee Phone 2 Work *CHAR 20UCYPREP YP: Payee Details YPTEL3 Payee Phone 3 Mobile *CHAR 20UCYPREP YP: Payee Details YPYPID Payee Details ID *PACKED 6 (0 d.p.)UCZHREP Syndicate Groups (ZHCD) ZHRCFD RECORD DELETE FLAG *CHAR 1UCZHREP Syndicate Groups (ZHCD) ZHZHCD SYND GROUP HEADER CODE *CHAR 10UCZHREP Syndicate Groups (ZHCD) ZHZHDS SYND GROUP DESCRIPTION *CHAR 30UCZHREP Syndicate Groups (ZHCD) ZHZHMY SYND GROUP CNTRL

MONTH/YR*PACKED 5 (0 d.p.)



File File Description Field Field Description Type LengthUCZHREP Syndicate Groups (ZHCD) ZHZHSD SYND GROUP SHORT

DESCRIPTION*CHAR 15

UCZMREP Syndicates (ZMCD) ZMRCFD RECORD DELETE FLAG *CHAR 1UCZMREP Syndicates (ZMCD) ZMZHCD SYND GROUP HEADER CODE *CHAR 10UCZMREP Syndicates (ZMCD) ZMZMCD STAMP CODE *CHAR 6UCZMREP Syndicates (ZMCD) ZMZMDS *CHAR 40UCZMREP Syndicates (ZMCD) ZMZMSD SYND SHORT DESCRIPTION *CHAR 15UKKIREP Claim Business Items KI0101 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0102 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0103 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0104 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0105 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0106 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0107 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0108 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0109 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0110 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0111 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0112 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0113 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0114 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0115 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0116 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0117 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0118 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0119 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0120 1 Character Code *CHAR 1UKKIREP Claim Business Items KI0301 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0302 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0303 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0304 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0305 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0306 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0307 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0308 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0309 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0310 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0311 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0312 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0313 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0314 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0315 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0316 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0317 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0318 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0319 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0320 3 Character Code *CHAR 3UKKIREP Claim Business Items KI0601 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0602 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0603 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0604 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0605 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0606 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0607 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0608 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0609 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0610 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0611 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0612 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0613 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0614 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0615 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0616 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0617 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0618 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0619 6 Character Code *CHAR 6



File File Description Field Field Description Type LengthUKKIREP Claim Business Items KI0620 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0621 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0622 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0623 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0624 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0625 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0626 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0627 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0628 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0629 6 Character Code *CHAR 6UKKIREP Claim Business Items KI0630 6 Character Code *CHAR 6UKKIREP Claim Business Items KI1201 12 Character Code *CHAR 12UKKIREP Claim Business Items KI1202 12 Character Code *CHAR 12UKKIREP Claim Business Items KI1203 12 Character Code *CHAR 12UKKIREP Claim Business Items KI1204 12 Character Code *CHAR 12UKKIREP Claim Business Items KI1205 12 Character Code *CHAR 12UKKIREP Claim Business Items KI1206 12 Character Code *CHAR 12UKKIREP Claim Business Items KI1207 12 Character Code *CHAR 12UKKIREP Claim Business Items KI1208 12 Character Code *CHAR 12UKKIREP Claim Business Items KI1209 12 Character Code *CHAR 12UKKIREP Claim Business Items KI1210 12 Character Code *CHAR 12UKKIREP Claim Business Items KI1211 12 Character Code *CHAR 12UKKIREP Claim Business Items KI1212 12 Character Code *CHAR 12UKKIREP Claim Business Items KI2501 25 Character Code *CHAR 25UKKIREP Claim Business Items KI2502 25 Character Code *CHAR 25UKKIREP Claim Business Items KI2503 25 Character Code *CHAR 25UKKIREP Claim Business Items KI2504 25 Character Code *CHAR 25UKKIREP Claim Business Items KI2505 25 Character Code *CHAR 25UKKIREP Claim Business Items KI2506 25 Character Code *CHAR 25UKKIREP Claim Business Items KI2507 25 Character Code *CHAR 25UKKIREP Claim Business Items KI2508 25 Character Code *CHAR 25UKKIREP Claim Business Items KI5001 50 Character Text *CHAR 50UKKIREP Claim Business Items KI5002 50 Character Text *CHAR 50UKKIREP Claim Business Items KI5003 50 Character Text *CHAR 50UKKIREP Claim Business Items KI5004 50 Character Text *CHAR 50UKKIREP Claim Business Items KI8001 80 Character Text *CHAR 80UKKIREP Claim Business Items KI8002 80 Character Text *CHAR 80UKKIREP Claim Business Items KIBI01 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI02 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI03 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI04 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI05 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI06 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI07 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI08 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI09 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI10 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI11 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI12 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI13 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI14 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI15 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI16 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI17 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI18 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI19 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KIBI20 Item 12 Digit Integer *PACKED 12 (0 d.p.)UKKIREP Claim Business Items KICC01 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC02 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC03 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC04 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC05 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC06 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC07 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC08 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC09 Item Currency Amount *PACKED 15 (2 d.p.)



File File Description Field Field Description Type LengthUKKIREP Claim Business Items KICC10 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC11 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC12 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC13 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC14 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC15 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC16 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC17 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC18 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC19 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC20 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC21 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC22 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC23 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC24 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC25 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC26 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC27 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC28 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC29 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICC30 Item Currency Amount *PACKED 15 (2 d.p.)UKKIREP Claim Business Items KICMSQ CLAIM SEQUENCE NO *PACKED 3 (0 d.p.)UKKIREP Claim Business Items KIDN01 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN02 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN03 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN04 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN05 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN06 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN07 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN08 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN09 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN10 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN11 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN12 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN13 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN14 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN15 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN16 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN17 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN18 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN19 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDN20 Item General Number *PACKED 15 (8 d.p.)UKKIREP Claim Business Items KIDT01 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT02 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT03 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT04 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT05 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT06 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT07 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT08 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT09 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT10 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT11 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT12 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT13 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT14 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT15 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT16 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT17 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT18 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT19 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIDT20 Item Date *PACKED 7 (0 d.p.)UKKIREP Claim Business Items KIITPS Parent Item Sequence *PACKED 5 (0 d.p.)UKKIREP Claim Business Items KIITSQ Business Item Sequence *PACKED 5 (0 d.p.)UKKIREP Claim Business Items KIITTY Business Item Type *CHAR 9UKKIREP Claim Business Items KIKHDZ LAST CHANGE DATE *PACKED 7 (0 d.p.)



File File Description Field Field Description Type LengthUKKIREP Claim Business Items KIPC01 Item Percentage *PACKED 11 (7 d.p.)UKKIREP Claim Business Items KIPC02 Item Percentage *PACKED 11 (7 d.p.)UKKIREP Claim Business Items KIPC03 Item Percentage *PACKED 11 (7 d.p.)UKKIREP Claim Business Items KIPC04 Item Percentage *PACKED 11 (7 d.p.)UKKIREP Claim Business Items KIPC05 Item Percentage *PACKED 11 (7 d.p.)UKKIREP Claim Business Items KIPC06 Item Percentage *PACKED 11 (7 d.p.)UKKIREP Claim Business Items KIPC07 Item Percentage *PACKED 11 (7 d.p.)UKKIREP Claim Business Items KIPC08 Item Percentage *PACKED 11 (7 d.p.)UKKIREP Claim Business Items KIPC09 Item Percentage *PACKED 11 (7 d.p.)UKKIREP Claim Business Items KIPC10 Item Percentage *PACKED 11 (7 d.p.)UKKIREP Claim Business Items KIPHID Policy (Dec) Header ID *PACKED 9 (0 d.p.)UKKIREP Claim Business Items KIPSID Policy (Dec) Sub-Type ID *PACKED 9 (0 d.p.)UKKIREP Claim Business Items KIRCFD RECORD DELETE FLAG *CHAR 1UKKIREP Claim Business Items KISI01 Item 8 Digit Integer *PACKED 8 (0 d.p.)UKKIREP Claim Business Items KISI02 Item 8 Digit Integer *PACKED 8 (0 d.p.)UKKIREP Claim Business Items KISI03 Item 8 Digit Integer *PACKED 8 (0 d.p.)UKKIREP Claim Business Items KISI04 Item 8 Digit Integer *PACKED 8 (0 d.p.)UKKIREP Claim Business Items KISI05 Item 8 Digit Integer *PACKED 8 (0 d.p.)UKKIREP Claim Business Items KISI06 Item 8 Digit Integer *PACKED 8 (0 d.p.)UKKIREP Claim Business Items KISI07 Item 8 Digit Integer *PACKED 8 (0 d.p.)UKKIREP Claim Business Items KISI08 Item 8 Digit Integer *PACKED 8 (0 d.p.)UKKIREP Claim Business Items KISI09 Item 8 Digit Integer *PACKED 8 (0 d.p.)UKKIREP Claim Business Items KISI10 Item 8 Digit Integer *PACKED 8 (0 d.p.)UKKIREP Claim Business Items KITI01 Item 3 Digit Integer *PACKED 3 (0 d.p.)UKKIREP Claim Business Items KITI02 Item 3 Digit Integer *PACKED 3 (0 d.p.)UKKIREP Claim Business Items KITI03 Item 3 Digit Integer *PACKED 3 (0 d.p.)UKKIREP Claim Business Items KITI04 Item 3 Digit Integer *PACKED 3 (0 d.p.)UKKIREP Claim Business Items KITI05 Item 3 Digit Integer *PACKED 3 (0 d.p.)UKKIREP Claim Business Items KITI06 Item 3 Digit Integer *PACKED 3 (0 d.p.)UKKIREP Claim Business Items KITI07 Item 3 Digit Integer *PACKED 3 (0 d.p.)UKKIREP Claim Business Items KITI08 Item 3 Digit Integer *PACKED 3 (0 d.p.)UKKIREP Claim Business Items KITI09 Item 3 Digit Integer *PACKED 3 (0 d.p.)UKKIREP Claim Business Items KITI10 Item 3 Digit Integer *PACKED 3 (0 d.p.)UKKMREP CLAIMS MASTER (O!PONO!POSQ!

UGYR!DANO!CMSKMLNBK LINK TO BLOCK CLAIM *PACKED 3 (0 d.p.)

UKKMREP CLAIMS MASTER (O!PONO!POSQ!UGYR!DANO!CMS

KMTPAN TPA Handling Co. *CHAR 6

UKMRWKP Fix KT Movements work file WAAMTY Orig, A/C, Base *CHAR 4UKMRWKP Fix KT Movements work file WAEXAM Existing Outst *PACKED 15 (2 d.p.)UKMRWKP Fix KT Movements work file WAEXOE Existing Movement *PACKED 15 (2 d.p.)UKMRWKP Fix KT Movements work file WANWOE Correct Movement *PACKED 15 (2 d.p.)UKOTREP OCR TRANSACTIONS OTSGOZ BRK SIGNED ORDER % - NUM *PACKED 11 (7 d.p.)UKOTREP OCR TRANSACTIONS OTSLPC SIGNED LINE% - NUMER *PACKED 11 (7 d.p.)UKSRQYP0 TITLE KS: CLAIMS SUMMARY

FORMAT FILE FOR SUMMARY RKSBLOS Balance O/S at 31/12 *PACKED 15 (2 d.p.)

UKSRQYP0 TITLE KS: CLAIMS SUMMARY FORMAT FILE FOR SUMMARY R

KSCHYE Change from 31/12 *PACKED 15 (2 d.p.)


KSGUFL GUI Update Flag *CHAR 1


KSLOCP LOC Paid to date *PACKED 15 (2 d.p.)


KSOO@A ORIGINAL O/S - A/C *PACKED 15 (2 d.p.)


KSOO@B ORIGINAL O/S - BASE *PACKED 15 (2 d.p.)


KSPDYE Paid since 31/12 *PACKED 15 (2 d.p.)

UPDDREP TITLE DD: DEDUCTIONS FILE (O!PONO!POSQ!UGYR!DANO!D

DDCYCU Country Ccy Code *CHAR 3


DDEIHP BASE EPI *PACKED 15 (2 d.p.)


DDPYTY Payment Type *CHAR 1


DDTXCY Country Code *CHAR 5

UPETREP EPI Taxation ETAM@O Tax Amount *PACKED 15 (2 d.p.)UPETREP EPI Taxation ETCOCD COMPANY CODE *PACKED 1 (0 d.p.)



File File Description Field Field Description Type LengthUPETREP EPI Taxation ETCYCU Country Ccy Code *CHAR 3UPETREP EPI Taxation ETDDCD DEDUCTIONS CODE *CHAR 6UPETREP EPI Taxation ETDDID Deductions ID *PACKED 9 (0 d.p.)UPETREP EPI Taxation ETDDPC DEDUCTIONS% *PACKED 11 (7 d.p.)UPETREP EPI Taxation ETDDSQ DEDUCTIONS SEQUENCE *PACKED 3 (0 d.p.)UPETREP EPI Taxation ETEDID Endorsement ID *PACKED 9 (0 d.p.)UPETREP EPI Taxation ETEIHP BASE EPI *PACKED 15 (2 d.p.)UPETREP EPI Taxation ETEKDT EXPIRY DATE -CYYMMDD *PACKED 7 (0 d.p.)UPETREP EPI Taxation ETENDT ENTRY DATE *PACKED 7 (0 d.p.)UPETREP EPI Taxation ETENQT ENTRY TIME *CHAR 6UPETREP EPI Taxation ETESPC ESTIMATED SIGNED % - *PACKED 11 (7 d.p.)UPETREP EPI Taxation ETICDT INCEPTION DATE *PACKED 7 (0 d.p.)UPETREP EPI Taxation ETOXID OPERATOR ID *CHAR 4UPETREP EPI Taxation ETPHID Policy (Dec) Header ID *PACKED 9 (0 d.p.)UPETREP EPI Taxation ETPROZ BROKERS WRITTEN ORDER % -

NUMERIC*PACKED 11 (7 d.p.)

UPETREP EPI Taxation ETPSID Policy (Dec) Sub-Type ID *PACKED 9 (0 d.p.)UPETREP EPI Taxation ETPYTY Payment Type *CHAR 1UPETREP EPI Taxation ETRCSS Record Status *CHAR 1UPETREP EPI Taxation ETSGOZ BRK SIGNED ORDER % - NUM *PACKED 11 (7 d.p.)UPETREP EPI Taxation ETSLPC SIGNED LINE% - NUMER *PACKED 11 (7 d.p.)UPETREP EPI Taxation ETSSCD STATUS CODE *CHAR 1UPETREP EPI Taxation ETSYID Syndicate ID *PACKED 9 (0 d.p.)UPETREP EPI Taxation ETSYSQ Syndicate sequence *PACKED 3 (0 d.p.)UPETREP EPI Taxation ETTMNO NUMBER OF A/C TERMS *PACKED 3 (0 d.p.)UPETREP EPI Taxation ETTXCY Country Code *CHAR 5UPETREP EPI Taxation ETTXSQ Tax Record Sequence *PACKED 4 (0 d.p.)UPETREP EPI Taxation ETWLPC WRITTEN LINE % - NUM *PACKED 11 (7 d.p.)UPETREP EPI Taxation ETZMCD STAMP CODE *CHAR 6UPETREP EPI Taxation ETZMYR STAMP CODE YEAR *PACKED 4 (0 d.p.)UPIEWKP1 Iris Enquiries - Master Enquiry U/W work

fileIEIPTF 2525 NEW BUS FLAG *CHAR 1

UPIEWKP1 Iris Enquiries - Master Enquiry U/W work file

IEPOET POLICY ENTRY DATE *PACKED 8 (0 d.p.)


IESSCD POLICY STATUS *CHAR 1


IEWRFL 2526 US EXP FLAG *CHAR 1

UPIEWKP2 Iris Enquiries - Master Enquiry Stats work file

IEDRCD RISK CODE *CHAR 2

UPIEWKP2 Iris Enquiries - Master Enquiry Stats work file

IEDRDS RISK CODE DESC *CHAR 50

UPINREP Policy Instalments INKHQT Last Changed Time *CHAR 6UPKPREP TITLE KP: POLICY PERILS EXPOSURE

(O!PONO!POSQ!UGYRKPKPNR Perils Narrative *CHAR 70

UPKPREP TITLE KP: POLICY PERILS EXPOSURE (O!PONO!POSQ!UGYR

KPMSPC POSSIBLE MAXIMUM LOSS PERCENT

*PACKED 11 (7 d.p.)

UPMPREP MID Interface Policy Details File MPADA1 ADDRESS LINE 1 *CHAR 40UPMPREP MID Interface Policy Details File MPADA2 ADDRESS LINE 2 *CHAR 40UPMPREP MID Interface Policy Details File MPADA3 ADDRESS LINE 3 *CHAR 40UPMPREP MID Interface Policy Details File MPADA4 ADDRESS LINE 4 *CHAR 40UPMPREP MID Interface Policy Details File MPADA5 ADDRESS LINE 5 *CHAR 40UPMPREP MID Interface Policy Details File MPADA6 ADDRESS LINE 6 *CHAR 40UPMPREP MID Interface Policy Details File MPADDR ADDITIONAL DRIVER

INDICATOR*CHAR 1

UPMPREP MID Interface Policy Details File MPASDL POLICY HOLDER CONTCT DETAILS

*CHAR 54

UPMPREP MID Interface Policy Details File MPASNM POLICY HOLDER NAME *CHAR 70UPMPREP MID Interface Policy Details File MPDAID DELEGATE AUTHORITY ID *CHAR 3UPMPREP MID Interface Policy Details File MPDBID DELEGATE AUTHORITY

BRANCH ID*CHAR 20

UPMPREP MID Interface Policy Details File MPDLFG DELETE NEW POLICY FLAG *CHAR 1UPMPREP MID Interface Policy Details File MPDTTY RECORD TYPE *CHAR 1UPMPREP MID Interface Policy Details File MPEDID Endorsement ID *PACKED 9 (0 d.p.)UPMPREP MID Interface Policy Details File MPEHJF EFFECTIVE FROM DATE *PACKED 7 (0 d.p.)UPMPREP MID Interface Policy Details File MPEHJT EFFECTIVE TO DATE *PACKED 7 (0 d.p.)UPMPREP MID Interface Policy Details File MPEKDT EXPIRY DATE -CYYMMDD *PACKED 7 (0 d.p.)



File File Description Field Field Description Type LengthUPMPREP MID Interface Policy Details File MPENDT ENTRY DATE *PACKED 7 (0 d.p.)UPMPREP MID Interface Policy Details File MPENQT ENTRY TIME *CHAR 6UPMPREP MID Interface Policy Details File MPERCD FILE ERROR CODES *CHAR 80UPMPREP MID Interface Policy Details File MPIBID INSURER BRANCH ID *CHAR 10UPMPREP MID Interface Policy Details File MPICDT INCEPTION DATE *PACKED 7 (0 d.p.)UPMPREP MID Interface Policy Details File MPINID INSURER ID *CHAR 3UPMPREP MID Interface Policy Details File MPMFSQ FILE SEQ *PACKED 6 (0 d.p.)UPMPREP MID Interface Policy Details File MPNDR1 NAMED DRIVER 1 *CHAR 70UPMPREP MID Interface Policy Details File MPNDR2 NAMED DRIVER 2 *CHAR 70UPMPREP MID Interface Policy Details File MPNDR3 NAMED DRIVER 3 *CHAR 70UPMPREP MID Interface Policy Details File MPNDR4 NAMED DRIVER 4 *CHAR 70UPMPREP MID Interface Policy Details File MPNDR5 NAMED DRIVER 5 *CHAR 70UPMPREP MID Interface Policy Details File MPNDR6 NAMED DRIVER 6 *CHAR 70UPMPREP MID Interface Policy Details File MPNMDR NO OF NAMED DRIVERS *PACKED 1 (0 d.p.)UPMPREP MID Interface Policy Details File MPPCNT POLICY CONTROL COUNT *PACKED 4 (0 d.p.)UPMPREP MID Interface Policy Details File MPPHID Policy (Dec) Header ID *PACKED 9 (0 d.p.)UPMPREP MID Interface Policy Details File MPPOAC POLICY ACCESS *PACKED 6 (0 d.p.)UPMPREP MID Interface Policy Details File MPPONO POLICY NUMBER *CHAR 20UPMPREP MID Interface Policy Details File MPPOST CANCELLATN/LAPSED

INDICATOR*CHAR 1

UPMPREP MID Interface Policy Details File MPPRDR PERMITTED DRIVER *CHAR 2UPMPREP MID Interface Policy Details File MPPSID Policy (Dec) Sub-Type ID *PACKED 9 (0 d.p.)UPMPREP MID Interface Policy Details File MPRNIN RENEWAL INDICATOR *CHAR 2UPMPREP MID Interface Policy Details File MPRPIN REPORT INDICATOR *CHAR 1UPMPREP MID Interface Policy Details File MPSDFG SEND FLAG *CHAR 1UPMPREP MID Interface Policy Details File MPSSCD FILE STATUS *CHAR 1UPMPREP MID Interface Policy Details File MPTRIN MOTOR TRADE POLICY

INDICATOR*CHAR 1

UPMPREP MID Interface Policy Details File MPUPTY UPDATE TYPE *CHAR 1UPMPREP MID Interface Policy Details File MPUSCL CLASS OF USE *CHAR 3UPMPREP MID Interface Policy Details File MPUSRF QUOTE BACK *CHAR 35UPMPREP MID Interface Policy Details File MPVRIN VEHICLE RECORD INDICATOR *CHAR 1UPMPREP MID Interface Policy Details File MPXDR1 EXCLUDE DRIVER 1 *CHAR 1UPMPREP MID Interface Policy Details File MPXDR2 EXCLUDE DRIVER 2 *CHAR 1UPMPREP MID Interface Policy Details File MPXDR3 EXCLUDE DRIVER 3 *CHAR 1UPMPREP MID Interface Policy Details File MPXDR4 EXCLUDE DRIVER 4 *CHAR 1UPMPREP MID Interface Policy Details File MPXDR5 EXCLUDE DRIVER 5 *CHAR 1UPMPREP MID Interface Policy Details File MPXDR6 EXCLUDE DRIVER 6 *CHAR 1UPMPREP MID Interface Policy Details File MPZTCD POST CODE *CHAR 8UPPLREP Policy Locking File PLCMSQ CLAIM SEQUENCE NO *PACKED 3 (0 d.p.)UPPLREP Policy Locking File PLJBUS JOB USER *CHAR 10UPPLREP Policy Locking File PLLKDT OBJECT LOCK DATE *PACKED 7 (0 d.p.)UPPLREP Policy Locking File PLLKQT OBJECT LOCK SYS TIME *CHAR 6UPPLREP Policy Locking File PLOXID OPERATOR ID *CHAR 4UPPLREP Policy Locking File PLPGNM *CHAR 30UPPLREP Policy Locking File PLPHID Policy (Dec) Header ID *PACKED 9 (0 d.p.)UPPLREP Policy Locking File PLWSID WORKSTATION ID *CHAR 2UPS0REP Security Field Index (Supports 1 Index) PSPHID Policy (Dec) Header ID *PACKED 9 (0 d.p.)UPS0REP Security Field Index (Supports 1 Index) PSV001 FIRST FIELD VALUE *CHAR 12UPS1REP Security Field Index (Supports 2 indexes) PSPHID Policy (Dec) Header ID *PACKED 9 (0 d.p.)UPS1REP Security Field Index (Supports 2 indexes) PSV001 FIRST FIELD VALUE *CHAR 12UPS1REP Security Field Index (Supports 2 indexes) PSV002 SECOND FIELD VALUE *CHAR 12UPS2REP Security Field Index (Supports 4 indexes) PSPHID Policy (Dec) Header ID *PACKED 9 (0 d.p.)UPS2REP Security Field Index (Supports 4 indexes) PSV001 FIRST FIELD VALUE *CHAR 12UPS2REP Security Field Index (Supports 4 indexes) PSV002 SECOND FIELD VALUE *CHAR 12UPS2REP Security Field Index (Supports 4 indexes) PSV003 THIRD FIELD VALUE *CHAR 12UPS2REP Security Field Index (Supports 4 indexes) PSV004 FOURTH FIELD VALUE *CHAR 12UPS3REP Security Field Index (Supports 8 indexes) PSPHID Policy (Dec) Header ID *PACKED 9 (0 d.p.)UPS3REP Security Field Index (Supports 8 indexes) PSV001 FIRST FIELD VALUE *CHAR 12UPS3REP Security Field Index (Supports 8 indexes) PSV002 SECOND FIELD VALUE *CHAR 12UPS3REP Security Field Index (Supports 8 indexes) PSV003 THIRD FIELD VALUE *CHAR 12UPS3REP Security Field Index (Supports 8 indexes) PSV004 FOURTH FIELD VALUE *CHAR 12UPS3REP Security Field Index (Supports 8 indexes) PSV005 FIFTH FIELD VALUE *CHAR 12UPS3REP Security Field Index (Supports 8 indexes) PSV006 SIXTH FIELD VALUE *CHAR 12UPS3REP Security Field Index (Supports 8 indexes) PSV007 SEVENTH FIELD VALUE *CHAR 12UPS3REP Security Field Index (Supports 8 indexes) PSV008 EIGHTH FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSPHID Policy (Dec) Header ID *PACKED 9 (0 d.p.)



File File Description Field Field Description Type LengthUPS4REP Security Field Index (Supports 16 indexes) PSV001 FIRST FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV002 SECOND FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV003 THIRD FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV004 FOURTH FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV005 FIFTH FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV006 SIXTH FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV007 SEVENTH FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV008 EIGHTH FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV009 NINTH FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV010 TENTH FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV011 ELEVENTH FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV012 TWELTH FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV013 THIRTEENTH FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV014 FOURTEENTH FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV015 FIFTEENTH FIELD VALUE *CHAR 12UPS4REP Security Field Index (Supports 16 indexes) PSV016 SIXTEENTH FIELD VALUE *CHAR 12UPSIREP Syndicate Index Table SIGF00 GROUP 0 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF01 GROUP 1 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF02 GROUP 2 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF03 GROUP 3 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF04 GROUP 4 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF05 GROUP 5 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF06 GROUP 6 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF07 GROUP 7 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF08 GROUP 8 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF09 GROUP 9 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF10 GROUP 10 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF11 GROUP 11 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF12 GROUP 12 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF13 GROUP 13 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF14 GROUP 14 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF15 GROUP 15 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF16 GROUP 16 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF17 GROUP 17 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF18 GROUP 18 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF19 GROUP 19 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF20 GROUP 20 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF21 GROUP 21 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF22 GROUP 22 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF23 GROUP 23 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF24 GROUP 24 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF25 GROUP 25 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF26 GROUP 26 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF27 GROUP 27 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF28 GROUP 28 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF29 GROUP 29 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF30 GROUP 30 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF31 GROUP 31 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF32 GROUP 32 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF33 GROUP 33 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF34 GROUP 34 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF35 GROUP 35 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF36 GROUP 36 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF37 GROUP 37 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF38 GROUP 38 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF39 GROUP 39 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF40 GROUP 40 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF41 GROUP 41 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF42 GROUP 42 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF43 GROUP 43 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF44 GROUP 44 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF45 GROUP 45 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF46 GROUP 46 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF47 GROUP 47 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF48 GROUP 48 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF49 GROUP 49 EXISTS *CHAR 1



File File Description Field Field Description Type LengthUPSIREP Syndicate Index Table SIGF50 GROUP 50 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF51 GROUP 51 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF52 GROUP 52 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF53 GROUP 53 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF54 GROUP 54 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF55 GROUP 55 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF56 GROUP 56 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF57 GROUP 57 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF58 GROUP 58 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF59 GROUP 59 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF60 GROUP 60 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF61 GROUP 61 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF62 GROUP 62 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIGF63 GROUP 63 EXISTS *CHAR 1UPSIREP Syndicate Index Table SIPHID Policy (Dec) Header ID *PACKED 9 (0 d.p.)USADQYP Reinsurers aged debt - Query File F1PSID Policy (Dec) Sub-Type ID *PACKED 9 (0 d.p.)USADQYP Reinsurers aged debt - Query File F1SYID Syndicate ID *PACKED 9 (0 d.p.)USADQYP Reinsurers aged debt - Query File F1SYSQ Syndicate sequence *PACKED 3 (0 d.p.)USARP0P0 P9: USARP0P0 (*NONE) P9AUN1 Audit Numbers 1 *CHAR 240USARP0P0 P9: USARP0P0 (*NONE) P9AUN2 Audit Numbers 2 *CHAR 240USARP0P0 P9: USARP0P0 (*NONE) P9AUN3 Audit Numbers 3 *CHAR 120USARP0P0 P9: USARP0P0 (*NONE) P9BTS1 Batch Numbers 1 *CHAR 250USARP0P0 P9: USARP0P0 (*NONE) P9BTS2 Batch Numbers 2 *CHAR 250USARP0P0 P9: USARP0P0 (*NONE) P9CND1 Dates 1 *CHAR 245USARP0P0 P9: USARP0P0 (*NONE) P9CND2 Dates 2 *CHAR 245USARP0P0 P9: USARP0P0 (*NONE) P9CND3 Dates 3 *CHAR 210USC1REP CLOSINGS LOG - HEADER RECORD C1AACD Lloyd's Aviation Audit Code *CHAR 2USC1REP CLOSINGS LOG - HEADER RECORD C1ACRF Associated closing Section

Reference*PACKED 3 (0 d.p.)

USC1REP CLOSINGS LOG - HEADER RECORD C1ADIN Lloyd's Adjustable Indcator *CHAR 1USC1REP CLOSINGS LOG - HEADER RECORD C1ASRF Associated Sub Account Reference *PACKED 2 (0 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1ATIN Attachment Indcator *CHAR 1USC1REP CLOSINGS LOG - HEADER RECORD C1ATRF Associated Technical Account

Reference*CHAR 9

USC1REP CLOSINGS LOG - HEADER RECORD C1BCAM Syndiate's Balance of Cash Amount *PACKED 15 (2 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1BCCD Business Category *CHAR 3USC1REP CLOSINGS LOG - HEADER RECORD C1BLIN Bulk Settlement Indicator *CHAR 1USC1REP CLOSINGS LOG - HEADER RECORD C1BRPS Broker Pseudonym *CHAR 4USC1REP CLOSINGS LOG - HEADER RECORD C1BRRF BROKER/THEIR REF *CHAR 12USC1REP CLOSINGS LOG - HEADER RECORD C1CACD Lloyd's CA Category Code *CHAR 1USC1REP CLOSINGS LOG - HEADER RECORD C1CKKY Currency Key *PACKED 1 (0 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1CNRF Collection Note Reference *CHAR 17USC1REP CLOSINGS LOG - HEADER RECORD C1COOR Country of Origin *CHAR 2USC1REP CLOSINGS LOG - HEADER RECORD C1CORS Country of Risk *CHAR 2USC1REP CLOSINGS LOG - HEADER RECORD C1CPIN Claims Payable Abroad Indicator *CHAR 1USC1REP CLOSINGS LOG - HEADER RECORD C1CSRF Closing Section Reference *PACKED 3 (0 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1CTCD Catastrophe Code *CHAR 4USC1REP CLOSINGS LOG - HEADER RECORD C1DBAM DEFD BALANCE B/FWD *PACKED 15 (2 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1DCAM DEFD BALANCE C/FWD *PACKED 15 (2 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1DCRF DCF Signing Reference *CHAR 13USC1REP CLOSINGS LOG - HEADER RECORD C1DRCD Derived Audit/Risk Code *CHAR 2USC1REP CLOSINGS LOG - HEADER RECORD C1DTCD Audit/DTI Code *CHAR 2USC1REP CLOSINGS LOG - HEADER RECORD C1ENTY Entry Type *CHAR 3USC1REP CLOSINGS LOG - HEADER RECORD C1F1CD FIL Code 1 *CHAR 4USC1REP CLOSINGS LOG - HEADER RECORD C1F2CD FIL Code 2 *CHAR 4USC1REP CLOSINGS LOG - HEADER RECORD C1FARF Financial Account Reference *CHAR 9USC1REP CLOSINGS LOG - HEADER RECORD C1FECD Type of Payment Indicator *CHAR 1USC1REP CLOSINGS LOG - HEADER RECORD C1FICD Lloyd's FIL Market Code *CHAR 2USC1REP CLOSINGS LOG - HEADER RECORD C1FLMB FILE MEMBER NAME *CHAR 10USC1REP CLOSINGS LOG - HEADER RECORD C1INRF Invoice Reference *CHAR 50USC1REP CLOSINGS LOG - HEADER RECORD C1LCAM Syndicate LOC Outstanding Amount *PACKED 15 (2 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1LCRF LCO Reference *CHAR 12USC1REP CLOSINGS LOG - HEADER RECORD C1LLAC Lloyd's Accouting Type *CHAR 1USC1REP CLOSINGS LOG - HEADER RECORD C1LLPC Lloyd's Total Line *PACKED 12 (7 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1LLTY Lloyd's Line Type *PACKED 1 (0 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1LRAM Loss Reserve Interest Amount *PACKED 15 (0 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1MACD Lloyd's Marine Audit Code *CHAR 2



File File Description Field Field Description Type LengthUSC1REP CLOSINGS LOG - HEADER RECORD C1MKKF MARKET CLAIM REF *CHAR 15USC1REP CLOSINGS LOG - HEADER RECORD C1MKTY LPSO Market Type *CHAR 2USC1REP CLOSINGS LOG - HEADER RECORD C1MVRF Movement Reference *CHAR 6USC1REP CLOSINGS LOG - HEADER RECORD C1NACD Lloyd's Non-Marine Audit Code *CHAR 2USC1REP CLOSINGS LOG - HEADER RECORD C1OBNO Originating Broker *CHAR 4USC1REP CLOSINGS LOG - HEADER RECORD C1OBPS Originating Broker Pseudonym *CHAR 4USC1REP CLOSINGS LOG - HEADER RECORD C1OBRF Original Bureau Signing Reference *CHAR 13USC1REP CLOSINGS LOG - HEADER RECORD C1OCIN LPSO OCA Contra Indcator *CHAR 1USC1REP CLOSINGS LOG - HEADER RECORD C1ORRF Outward Reinsurance Reference *CHAR 13USC1REP CLOSINGS LOG - HEADER RECORD C1PPDT Policy From Date *PACKED 7 (0 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1PRCD Lloyd's Processing Code *CHAR 3USC1REP CLOSINGS LOG - HEADER RECORD C1PSDT Planned Settlement Date *PACKED 8 (0 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1PTAM Amount Paid This Time *PACKED 15 (0 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1PTDT Policy To Date *PACKED 7 (0 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1PTTX Period of Transaction *CHAR 20USC1REP CLOSINGS LOG - HEADER RECORD C1PYIN Payment Indicator *CHAR 1USC1REP CLOSINGS LOG - HEADER RECORD C1PYRF Payment Reference *CHAR 2USC1REP CLOSINGS LOG - HEADER RECORD C1QCCD Lloyd's CA Qualifying Category

Code*CHAR 1

USC1REP CLOSINGS LOG - HEADER RECORD C1RBAM RESV BALANCE B/FWD *PACKED 15 (2 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1RCAM RESV BALANCE C/FWD *PACKED 15 (2 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1RIAM Syndiate R/I Ceded to Lloyd's

Amount*PACKED 15 (2 d.p.)

USC1REP CLOSINGS LOG - HEADER RECORD C1RSCD Risk Code *CHAR 2USC1REP CLOSINGS LOG - HEADER RECORD C1RSRF Risk Section Reference *PACKED 2 (0 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1RXRF Rate of Exchange Original Bureau

Signing Reference*CHAR 13

USC1REP CLOSINGS LOG - HEADER RECORD C1SARF Sub Account Reference *PACKED 2 (0 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1SDDT Settlement Date *PACKED 8 (0 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1SDQU Settlement Date Qualifier *CHAR 3USC1REP CLOSINGS LOG - HEADER RECORD C1SLNO Syndicate Line Number *PACKED 3 (0 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1SLRF System Line Reference *CHAR 6USC1REP CLOSINGS LOG - HEADER RECORD C1SMCD Syndicate Market Code *CHAR 1USC1REP CLOSINGS LOG - HEADER RECORD C1SRBI Syndicate R/I Broker Infomation *CHAR 12USC1REP CLOSINGS LOG - HEADER RECORD C1SRFG Stats Reversal Flag *CHAR 2USC1REP CLOSINGS LOG - HEADER RECORD C1SRSQ Stats Reversal Header Sequence *PACKED 9 (0 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1SSIN Source System Indicator *CHAR 1USC1REP CLOSINGS LOG - HEADER RECORD C1SYRF Company/Syndicate Secondary

Reference*CHAR 12

USC1REP CLOSINGS LOG - HEADER RECORD C1TARF Technical Account Reference *CHAR 9USC1REP CLOSINGS LOG - HEADER RECORD C1TDPC Total Discount *PACKED 12 (7 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1TFCD Trust Fund Code *CHAR 2USC1REP CLOSINGS LOG - HEADER RECORD C1TYNO Bureau Treaty Number *CHAR 9USC1REP CLOSINGS LOG - HEADER RECORD C1TYSN Lloyd's Treaty Serial Number *CHAR 3USC1REP CLOSINGS LOG - HEADER RECORD C1UCRF Unique Claim Reference *CHAR 17USC1REP CLOSINGS LOG - HEADER RECORD C1UMRF Unique Market Reference *CHAR 17USC1REP CLOSINGS LOG - HEADER RECORD C1UTRF Unique Transaction Reference *CHAR 17USC1REP CLOSINGS LOG - HEADER RECORD C1VTAM Syndiate VAT Amount *PACKED 15 (2 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1WRAM Syndiate War Amount *PACKED 15 (2 d.p.)USC1REP CLOSINGS LOG - HEADER RECORD C1YPID Claim Payee ID *PACKED 6 (0 d.p.)USC2REP Closings Section log - Physical file C2#TSC TREATY SECTION CODE *CHAR 2USC2REP Closings Section log - Physical file C2HAMT 100% AMOUNT *PACKED 15 (2 d.p.)USC2REP Closings Section log - Physical file C2WRAM Syndiate War Amount *PACKED 15 (2 d.p.)USC3REP TITLE C3: CLOSINGS LOG - AMOUNTS

FILEC3EM@A Extension Trans Amnt Clsd A/C *PACKED 15 (2 d.p.)

USC3REP TITLE C3: CLOSINGS LOG - AMOUNTS FILE

C3EM@B Extension Trans Amnt Clsd Base *PACKED 15 (2 d.p.)

USC3REP TITLE C3: CLOSINGS LOG - AMOUNTS FILE

C3EM@O Extension Trans Amnt Clsd Orig *PACKED 15 (2 d.p.)

USCIP0P5 P4: USCIP0P5 (*NONE) P4AUV1 REVERSING AUDIT NOS 1 *CHAR 240USCIP0P5 P4: USCIP0P5 (*NONE) P4AUV2 REVERSING AUDIT NOS 2 *CHAR 240USCIP0P5 P4: USCIP0P5 (*NONE) P4AUV3 REVERSING AUDIT NOS 3 *CHAR 120USCIP0P5 P4: USCIP0P5 (*NONE) P4BTV1 REVERSING BATCH NOS 1 *CHAR 250USCIP0P5 P4: USCIP0P5 (*NONE) P4BTV2 REVERSING BATCH NOS 2 *CHAR 250USCIP0P5 P4: USCIP0P5 (*NONE) P4DAA1 OUT DECLARATIONS ARRAY 1 *CHAR 240USCIP0P5 P4: USCIP0P5 (*NONE) P4DAA2 OUT DECLARATIONS ARRAY 2 *CHAR 57USCIP0P5 P4: USCIP0P5 (*NONE) P4EDA1 OUT ENDORSEMENTS ARRAY 1 *CHAR 240



File File Description Field Field Description Type LengthUSCIP0P5 P4: USCIP0P5 (*NONE) P4EDA2 OUT ENDORSEMENTS ARRAY 2 *CHAR 57USCIP0P5 P4: USCIP0P5 (*NONE) P4ETV1 REVERSING ENTRY DATES 1 *CHAR 245USCIP0P5 P4: USCIP0P5 (*NONE) P4ETV2 REVERSING ENTRY DATES 2 *CHAR 245USCIP0P5 P4: USCIP0P5 (*NONE) P4ETV3 REVERSING ENTRY DATES 3 *CHAR 210USCIP0P5 P4: USCIP0P5 (*NONE) P4INRF Invoice Reference *CHAR 50USCIP0P5 P4: USCIP0P5 (*NONE) P4PCA1 R/I %AGES ARRAY 1 *CHAR 220USCIP0P5 P4: USCIP0P5 (*NONE) P4PCA2 R/I %AGES ARRAY 2 *CHAR 220USCIP0P5 P4: USCIP0P5 (*NONE) P4PCA3 R/I %AGES ARRAY 3 *CHAR 220USCIP0P5 P4: USCIP0P5 (*NONE) P4PCA4 R/I %AGES ARRAY 4 *CHAR 220USCIP0P5 P4: USCIP0P5 (*NONE) P4PCA5 R/I %AGES ARRAY 5 *CHAR 209USCIP0P5 P4: USCIP0P5 (*NONE) P4POA1 OUT POLICY NO ARRAY 1 *CHAR 240USCIP0P5 P4: USCIP0P5 (*NONE) P4POA2 OUT POLICY NO ARRAY 2 *CHAR 240USCIP0P5 P4: USCIP0P5 (*NONE) P4POA3 OUT POLICY NO ARRAY 1 *CHAR 114USCIP0P5 P4: USCIP0P5 (*NONE) P4PTA1 POSTING A/C ARRAY 1 *CHAR 200USCIP0P5 P4: USCIP0P5 (*NONE) P4PTA2 POSTING A/C ARRAY 2 *CHAR 200USCIP0P5 P4: USCIP0P5 (*NONE) P4RIA1 R/I CODES ARRAY 1 *CHAR 200USCIP0P5 P4: USCIP0P5 (*NONE) P4RIA2 R/I CODES ARRAY 2 *CHAR 196USCIP0P5 P4: USCIP0P5 (*NONE) P4TMA1 DEDUCTION TERMS ONR/OGR

1*CHAR 240

USCIP0P5 P4: USCIP0P5 (*NONE) P4TMA2 DEDUCTION TERMS ONR/OGR 2

*CHAR 57

USCIP0P5 P4: USCIP0P5 (*NONE) P4UPA1 UNPLACED R/I %AGES ARRAY 1

*CHAR 220


*CHAR 220


*CHAR 220


*CHAR 220


*CHAR 209

USCIP0P5 P4: USCIP0P5 (*NONE) P4YPID Claim Payee ID *PACKED 6 (0 d.p.)USCIP0P8 PJ: USCIP0P8 Amounts PJAUV1 REVERSING AUDIT NOS 1 *CHAR 240USCIP0P8 PJ: USCIP0P8 Amounts PJAUV2 REVERSING AUDIT NOS 2 *CHAR 240USCIP0P8 PJ: USCIP0P8 Amounts PJAUV3 REVERSING AUDIT NOS 3 *CHAR 120USCIP0P8 PJ: USCIP0P8 Amounts PJBTV1 REVERSING BATCH NOS 1 *CHAR 250USCIP0P8 PJ: USCIP0P8 Amounts PJBTV2 REVERSING BATCH NOS 2 *CHAR 250USCIP0P8 PJ: USCIP0P8 Amounts PJDAA1 OUT DECLARATIONS ARRAY 1 *CHAR 240USCIP0P8 PJ: USCIP0P8 Amounts PJDAA2 OUT DECLARATIONS ARRAY 2 *CHAR 57USCIP0P8 PJ: USCIP0P8 Amounts PJEDA1 OUT ENDORSEMENTS ARRAY 1 *CHAR 240USCIP0P8 PJ: USCIP0P8 Amounts PJEDA2 OUT ENDORSEMENTS ARRAY 2 *CHAR 57USCIP0P8 PJ: USCIP0P8 Amounts PJETV1 REVERSING ENTRY DATES 1 *CHAR 245USCIP0P8 PJ: USCIP0P8 Amounts PJETV2 REVERSING ENTRY DATES 2 *CHAR 245USCIP0P8 PJ: USCIP0P8 Amounts PJETV3 REVERSING ENTRY DATES 3 *CHAR 210USCIP0P8 PJ: USCIP0P8 Amounts PJPCA1 R/I %AGES ARRAY 1 *CHAR 220USCIP0P8 PJ: USCIP0P8 Amounts PJPCA2 R/I %AGES ARRAY 2 *CHAR 220USCIP0P8 PJ: USCIP0P8 Amounts PJPCA3 R/I %AGES ARRAY 3 *CHAR 220USCIP0P8 PJ: USCIP0P8 Amounts PJPCA4 R/I %AGES ARRAY 4 *CHAR 220USCIP0P8 PJ: USCIP0P8 Amounts PJPCA5 R/I %AGES ARRAY 5 *CHAR 209USCIP0P8 PJ: USCIP0P8 Amounts PJPOA1 OUT POLICY NO ARRAY 1 *CHAR 240USCIP0P8 PJ: USCIP0P8 Amounts PJPOA2 OUT POLICY NO ARRAY 2 *CHAR 240USCIP0P8 PJ: USCIP0P8 Amounts PJPOA3 OUT POLICY NO ARRAY 1 *CHAR 114USCIP0P8 PJ: USCIP0P8 Amounts PJPTA1 POSTING A/C ARRAY 1 *CHAR 200USCIP0P8 PJ: USCIP0P8 Amounts PJPTA2 POSTING A/C ARRAY 2 *CHAR 200USCIP0P8 PJ: USCIP0P8 Amounts PJRIA1 R/I CODES ARRAY 1 *CHAR 200USCIP0P8 PJ: USCIP0P8 Amounts PJRIA2 R/I CODES ARRAY 2 *CHAR 196USCIP0P8 PJ: USCIP0P8 Amounts PJTMA1 DEDUCTION TERMS ONR/OGR

1*CHAR 240

USCIP0P8 PJ: USCIP0P8 Amounts PJTMA2 DEDUCTION TERMS ONR/OGR 2

*CHAR 57

USCIP0P8 PJ: USCIP0P8 Amounts PJUPA1 UNPLACED R/I %AGES ARRAY 1

*CHAR 220


*CHAR 220


*CHAR 220



File File Description Field Field Description Type LengthUSCIP0P8 PJ: USCIP0P8 Amounts PJUPA4 UNPLACED R/I %AGES ARRAY

4*CHAR 220


*CHAR 209

USCIWAP5 WA: USCIWAP5 (*NONE) WAAUV1 REVERSING AUDIT NOS 1 *CHAR 240USCIWAP5 WA: USCIWAP5 (*NONE) WAAUV2 REVERSING AUDIT NOS 2 *CHAR 240USCIWAP5 WA: USCIWAP5 (*NONE) WAAUV3 REVERSING AUDIT NOS 3 *CHAR 120USCIWAP5 WA: USCIWAP5 (*NONE) WABTV1 REVERSING BATCH NOS 1 *CHAR 250USCIWAP5 WA: USCIWAP5 (*NONE) WABTV2 REVERSING BATCH NOS 2 *CHAR 250USCIWAP5 WA: USCIWAP5 (*NONE) WADAA1 OUT DECLARATIONS ARRAY 1 *CHAR 240USCIWAP5 WA: USCIWAP5 (*NONE) WADAA2 OUT DECLARATIONS ARRAY 2 *CHAR 57USCIWAP5 WA: USCIWAP5 (*NONE) WAEDA1 OUT ENDORSEMENTS ARRAY 1 *CHAR 240USCIWAP5 WA: USCIWAP5 (*NONE) WAEDA2 OUT ENDORSEMENTS ARRAY 2 *CHAR 57USCIWAP5 WA: USCIWAP5 (*NONE) WAETV1 REVERSING ENTRY DATES 1 *CHAR 245USCIWAP5 WA: USCIWAP5 (*NONE) WAETV2 REVERSING ENTRY DATES 2 *CHAR 245USCIWAP5 WA: USCIWAP5 (*NONE) WAETV3 REVERSING ENTRY DATES 3 *CHAR 210USCIWAP5 WA: USCIWAP5 (*NONE) WAINRF Invoice Reference *CHAR 50USCIWAP5 WA: USCIWAP5 (*NONE) WAPCA1 R/I %AGES ARRAY 1 *CHAR 220USCIWAP5 WA: USCIWAP5 (*NONE) WAPCA2 R/I %AGES ARRAY 2 *CHAR 220USCIWAP5 WA: USCIWAP5 (*NONE) WAPCA3 R/I %AGES ARRAY 3 *CHAR 220USCIWAP5 WA: USCIWAP5 (*NONE) WAPCA4 R/I %AGES ARRAY 4 *CHAR 220USCIWAP5 WA: USCIWAP5 (*NONE) WAPCA5 R/I %AGES ARRAY 5 *CHAR 209USCIWAP5 WA: USCIWAP5 (*NONE) WAPOA1 OUT POLICY NO ARRAY 1 *CHAR 240USCIWAP5 WA: USCIWAP5 (*NONE) WAPOA2 OUT POLICY NO ARRAY 2 *CHAR 240USCIWAP5 WA: USCIWAP5 (*NONE) WAPOA3 OUT POLICY NO ARRAY 1 *CHAR 114USCIWAP5 WA: USCIWAP5 (*NONE) WAPTA1 POSTING A/C ARRAY 1 *CHAR 200USCIWAP5 WA: USCIWAP5 (*NONE) WAPTA2 POSTING A/C ARRAY 2 *CHAR 200USCIWAP5 WA: USCIWAP5 (*NONE) WARIA1 R/I CODES ARRAY 1 *CHAR 200USCIWAP5 WA: USCIWAP5 (*NONE) WARIA2 R/I CODES ARRAY 2 *CHAR 196USCIWAP5 WA: USCIWAP5 (*NONE) WATMA1 DEDUCTION TERMS ONR/OGR

1*CHAR 240

USCIWAP5 WA: USCIWAP5 (*NONE) WATMA2 DEDUCTION TERMS ONR/OGR 2

*CHAR 57

USCIWAP5 WA: USCIWAP5 (*NONE) WAUPA1 UNPLACED R/I %AGES ARRAY 1

*CHAR 220


*CHAR 220


*CHAR 220


*CHAR 220


*CHAR 209

USCIWAP5 WA: USCIWAP5 (*NONE) WAYPID Claim Payee ID *PACKED 6 (0 d.p.)USCIWAP8 WA: USCIWAP8 Amounts work fields WAAUV1 REVERSING AUDIT NOS 1 *CHAR 240USCIWAP8 WA: USCIWAP8 Amounts work fields WAAUV2 REVERSING AUDIT NOS 2 *CHAR 240USCIWAP8 WA: USCIWAP8 Amounts work fields WAAUV3 REVERSING AUDIT NOS 3 *CHAR 120USCIWAP8 WA: USCIWAP8 Amounts work fields WABTV1 REVERSING BATCH NOS 1 *CHAR 250USCIWAP8 WA: USCIWAP8 Amounts work fields WABTV2 REVERSING BATCH NOS 2 *CHAR 250USCIWAP8 WA: USCIWAP8 Amounts work fields WADAA1 OUT DECLARATIONS ARRAY 1 *CHAR 240USCIWAP8 WA: USCIWAP8 Amounts work fields WADAA2 OUT DECLARATIONS ARRAY 2 *CHAR 57USCIWAP8 WA: USCIWAP8 Amounts work fields WAEDA1 OUT ENDORSEMENTS ARRAY 1 *CHAR 240USCIWAP8 WA: USCIWAP8 Amounts work fields WAEDA2 OUT ENDORSEMENTS ARRAY 2 *CHAR 57USCIWAP8 WA: USCIWAP8 Amounts work fields WAETV1 REVERSING ENTRY DATES 1 *CHAR 245USCIWAP8 WA: USCIWAP8 Amounts work fields WAETV2 REVERSING ENTRY DATES 2 *CHAR 245USCIWAP8 WA: USCIWAP8 Amounts work fields WAETV3 REVERSING ENTRY DATES 3 *CHAR 210USCIWAP8 WA: USCIWAP8 Amounts work fields WAPCA1 R/I %AGES ARRAY 1 *CHAR 220USCIWAP8 WA: USCIWAP8 Amounts work fields WAPCA2 R/I %AGES ARRAY 2 *CHAR 220USCIWAP8 WA: USCIWAP8 Amounts work fields WAPCA3 R/I %AGES ARRAY 3 *CHAR 220USCIWAP8 WA: USCIWAP8 Amounts work fields WAPCA4 R/I %AGES ARRAY 4 *CHAR 220USCIWAP8 WA: USCIWAP8 Amounts work fields WAPCA5 R/I %AGES ARRAY 5 *CHAR 209USCIWAP8 WA: USCIWAP8 Amounts work fields WAPOA1 OUT POLICY NO ARRAY 1 *CHAR 240USCIWAP8 WA: USCIWAP8 Amounts work fields WAPOA2 OUT POLICY NO ARRAY 2 *CHAR 240USCIWAP8 WA: USCIWAP8 Amounts work fields WAPOA3 OUT POLICY NO ARRAY 1 *CHAR 114USCIWAP8 WA: USCIWAP8 Amounts work fields WAPTA1 POSTING A/C ARRAY 1 *CHAR 200USCIWAP8 WA: USCIWAP8 Amounts work fields WAPTA2 POSTING A/C ARRAY 2 *CHAR 200USCIWAP8 WA: USCIWAP8 Amounts work fields WARIA1 R/I CODES ARRAY 1 *CHAR 200



File File Description Field Field Description Type LengthUSCIWAP8 WA: USCIWAP8 Amounts work fields WARIA2 R/I CODES ARRAY 2 *CHAR 196USCIWAP8 WA: USCIWAP8 Amounts work fields WATMA1 DEDUCTION TERMS ONR/OGR

1*CHAR 240

USCIWAP8 WA: USCIWAP8 Amounts work fields WATMA2 DEDUCTION TERMS ONR/OGR 2

*CHAR 57

USCIWAP8 WA: USCIWAP8 Amounts work fields WAUPA1 UNPLACED R/I %AGES ARRAY 1

*CHAR 220


*CHAR 220


*CHAR 220


*CHAR 220


*CHAR 209

USCNREP Closings log - narrative file CNS2SQ Section Record Seq *PACKED 3 (0 d.p.)USCNREP Closings log - narrative file CNTXL# Lloyds Narrative Number *PACKED 1 (0 d.p.)USCNREP Closings log - narrative file CNTXLN Lloyds Line Number *CHAR 1USCNREP Closings log - narrative file CNTXTP Lloyds Text Type *CHAR 1USCUQYP1 QY: Closings Updates query file C1INRF Invoice Reference *CHAR 50USCUQYP1 QY: Closings Updates query file C1YPID Claim Payee ID *PACKED 6 (0 d.p.)USF1REP F1: Participant Statistics Header Record F1INRF Invoice Reference *CHAR 50USF1REP F1: Participant Statistics Header Record F1YPID Claim Payee ID *PACKED 6 (0 d.p.)USHRQYP0 TITLE SH: DUMMY FILE FOR HISTORY

REBUILDS4ALDT ALLOCATION DATE *PACKED 7 (0 d.p.)

USHRQYP2 Query file for history rebuild - part stats F4ALDT ALLOCATION DATE *PACKED 7 (0 d.p.)USRAQYP Reinsurers Aged Debt - Query file F1PSID Policy (Dec) Sub-Type ID *PACKED 9 (0 d.p.)USRAQYP Reinsurers Aged Debt - Query file F1SYID Syndicate ID *PACKED 9 (0 d.p.)USRAQYP Reinsurers Aged Debt - Query file F1SYSQ Syndicate sequence *PACKED 3 (0 d.p.)USS1REP Statistics header file S1AACD Lloyd's Aviation Audit Code *CHAR 2USS1REP Statistics header file S1ACRF Associated closing Section


USS1REP Statistics header file S1ADIN Lloyd's Adjustable Indcator *CHAR 1USS1REP Statistics header file S1ASRF Associated Sub Account Reference *PACKED 2 (0 d.p.)USS1REP Statistics header file S1ATIN Attachment Indcator *CHAR 1USS1REP Statistics header file S1ATRF Associated Technical Account

Reference*CHAR 9

USS1REP Statistics header file S1BCAM Syndiate's Balance of Cash Amount *PACKED 15 (2 d.p.)USS1REP Statistics header file S1BCCD Business Category *CHAR 3USS1REP Statistics header file S1BLIN Bulk Settlement Indicator *CHAR 1USS1REP Statistics header file S1BRPS Broker Pseudonym *CHAR 4USS1REP Statistics header file S1BRRF BROKER/THEIR REF *CHAR 12USS1REP Statistics header file S1CACD Lloyd's CA Category Code *CHAR 1USS1REP Statistics header file S1CKKY Currency Key *PACKED 1 (0 d.p.)USS1REP Statistics header file S1CNRF Collection Note Reference *CHAR 17USS1REP Statistics header file S1COOR Country of Origin *CHAR 2USS1REP Statistics header file S1CORS Country of Risk *CHAR 2USS1REP Statistics header file S1CPIN Claims Payable Abroad Indicator *CHAR 1USS1REP Statistics header file S1CSRF Closing Section Reference *PACKED 3 (0 d.p.)USS1REP Statistics header file S1CTCD Catastrophe Code *CHAR 4USS1REP Statistics header file S1DBAM DEFD BALANCE B/FWD *PACKED 15 (2 d.p.)USS1REP Statistics header file S1DCAM DEFD BALANCE C/FWD *PACKED 15 (2 d.p.)USS1REP Statistics header file S1DCRF DCF Signing Reference *CHAR 13USS1REP Statistics header file S1DRCD Derived Audit/Risk Code *CHAR 2USS1REP Statistics header file S1DTCD Audit/DTI Code *CHAR 2USS1REP Statistics header file S1ENTY Entry Type *CHAR 3USS1REP Statistics header file S1F1CD FIL Code 1 *CHAR 4USS1REP Statistics header file S1F2CD FIL Code 2 *CHAR 4USS1REP Statistics header file S1FARF Financial Account Reference *CHAR 9USS1REP Statistics header file S1FECD Type of Payment Indicator *CHAR 1USS1REP Statistics header file S1FICD Lloyd's FIL Market Code *CHAR 2USS1REP Statistics header file S1FLMB FILE MEMBER NAME *CHAR 10USS1REP Statistics header file S1INRF Invoice Reference *CHAR 50USS1REP Statistics header file S1LCAM Syndicate LOC Outstanding Amount *PACKED 15 (2 d.p.)USS1REP Statistics header file S1LCRF LCO Reference *CHAR 12USS1REP Statistics header file S1LLAC Lloyd's Accouting Type *CHAR 1USS1REP Statistics header file S1LLPC Lloyd's Total Line *PACKED 12 (7 d.p.)



File File Description Field Field Description Type LengthUSS1REP Statistics header file S1LLTY Lloyd's Line Type *PACKED 1 (0 d.p.)USS1REP Statistics header file S1LRAM Loss Reserve Interest Amount *PACKED 15 (0 d.p.)USS1REP Statistics header file S1MACD Lloyd's Marine Audit Code *CHAR 2USS1REP Statistics header file S1MKKF MARKET CLAIM REF *CHAR 15USS1REP Statistics header file S1MKTY LPSO Market Type *CHAR 2USS1REP Statistics header file S1MVRF Movement Reference *CHAR 6USS1REP Statistics header file S1NACD Lloyd's Non-Marine Audit Code *CHAR 2USS1REP Statistics header file S1OBNO Originating Broker *CHAR 4USS1REP Statistics header file S1OBPS Originating Broker Pseudonym *CHAR 4USS1REP Statistics header file S1OBRF Original Bureau Signing Reference *CHAR 13USS1REP Statistics header file S1OCIN LPSO OCA Contra Indcator *CHAR 1USS1REP Statistics header file S1ORRF Outward Reinsurance Reference *CHAR 13USS1REP Statistics header file S1PPDT Policy From Date *PACKED 7 (0 d.p.)USS1REP Statistics header file S1PRCD Lloyd's Processing Code *CHAR 3USS1REP Statistics header file S1PSDT Planned Settlement Date *PACKED 8 (0 d.p.)USS1REP Statistics header file S1PTAM Amount Paid This Time *PACKED 15 (0 d.p.)USS1REP Statistics header file S1PTDT Policy To Date *PACKED 7 (0 d.p.)USS1REP Statistics header file S1PTTX Period of Transaction *CHAR 20USS1REP Statistics header file S1PYIN Payment Indicator *CHAR 1USS1REP Statistics header file S1PYRF Payment Reference *CHAR 2USS1REP Statistics header file S1QCCD Lloyd's CA Qualifying Category

Code*CHAR 1

USS1REP Statistics header file S1RBAM RESV BALANCE B/FWD *PACKED 15 (2 d.p.)USS1REP Statistics header file S1RCAM RESV BALANCE C/FWD *PACKED 15 (2 d.p.)USS1REP Statistics header file S1RIAM Syndiate R/I Ceded to Lloyd's


USS1REP Statistics header file S1RSCD Risk Code *CHAR 2USS1REP Statistics header file S1RSRF Risk Section Reference *PACKED 2 (0 d.p.)USS1REP Statistics header file S1RXRF Rate of Exchange Original Bureau


USS1REP Statistics header file S1SARF Sub Account Reference *PACKED 2 (0 d.p.)USS1REP Statistics header file S1SDDT Settlement Date *PACKED 8 (0 d.p.)USS1REP Statistics header file S1SDQU Settlement Date Qualifier *CHAR 3USS1REP Statistics header file S1SLNO Syndicate Line Number *PACKED 3 (0 d.p.)USS1REP Statistics header file S1SLRF System Line Reference *CHAR 6USS1REP Statistics header file S1SMCD Syndicate Market Code *CHAR 1USS1REP Statistics header file S1SRBI Syndicate R/I Broker Infomation *CHAR 12USS1REP Statistics header file S1SRFG Stats Reversal Flag *CHAR 2USS1REP Statistics header file S1SRSQ Stats Reversal Header Sequence *PACKED 9 (0 d.p.)USS1REP Statistics header file S1SSIN Source System Indicator *CHAR 1USS1REP Statistics header file S1SYRF Company/Syndicate Secondary

Reference*CHAR 12

USS1REP Statistics header file S1TARF Technical Account Reference *CHAR 9USS1REP Statistics header file S1TDPC Total Discount *PACKED 12 (7 d.p.)USS1REP Statistics header file S1TFCD Trust Fund Code *CHAR 2USS1REP Statistics header file S1TYNO Bureau Treaty Number *CHAR 9USS1REP Statistics header file S1TYSN Lloyd's Treaty Serial Number *CHAR 3USS1REP Statistics header file S1UCRF Unique Claim Reference *CHAR 17USS1REP Statistics header file S1UMRF Unique Market Reference *CHAR 17USS1REP Statistics header file S1UTRF Unique Transaction Reference *CHAR 17USS1REP Statistics header file S1VTAM Syndiate VAT Amount *PACKED 15 (2 d.p.)USS1REP Statistics header file S1WRAM Syndiate War Amount *PACKED 15 (2 d.p.)USS1REP Statistics header file S1YPID Claim Payee ID *PACKED 6 (0 d.p.)USS2REP Statistics section/code file S2#TSC TREATY SECTION CODE *CHAR 2USS2REP Statistics section/code file S2HAMT 100% AMOUNT *PACKED 15 (2 d.p.)USS2REP Statistics section/code file S2WRAM Syndiate War Amount *PACKED 15 (2 d.p.)USS3REP TITLE S3: STATISTICS FILE AMOUNTS S3ALFL USM Allocation Flag *CHAR 1USS3REP TITLE S3: STATISTICS FILE AMOUNTS S3ALTM SYSTEM TIME *CHAR 6USS3REP TITLE S3: STATISTICS FILE AMOUNTS S3AOID USM Allocation Operator ID *CHAR 4USS3REP TITLE S3: STATISTICS FILE AMOUNTS S3AWID USM Allocation Workstation *CHAR 2USS3REP TITLE S3: STATISTICS FILE AMOUNTS S3EM@A Extension Trans Amnt Clsd A/C *PACKED 15 (2 d.p.)USS3REP TITLE S3: STATISTICS FILE AMOUNTS S3EM@B Extension Trans Amnt Clsd Base *PACKED 15 (2 d.p.)USS3REP TITLE S3: STATISTICS FILE AMOUNTS S3EM@O Extension Trans Amnt Clsd Orig *PACKED 15 (2 d.p.)USS3REP TITLE S3: STATISTICS FILE AMOUNTS S3SSCD STATUS CODE *CHAR 1USS3REP TITLE S3: STATISTICS FILE AMOUNTS S3UADT DATE STORAGE - CYYMMDD *PACKED 7 (0 d.p.)USSFREP Stats Premium/Claim/Outstanding SFLBRC Long Broker code *CHAR 5USSNREP Statistics - Narrative file SNS2SQ Section Record Seq *PACKED 3 (0 d.p.)



File File Description Field Field Description Type LengthUSSNREP Statistics - Narrative file SNTXL# Lloyds Narrative Number *PACKED 1 (0 d.p.)USSNREP Statistics - Narrative file SNTXLN Lloyds Line Number *CHAR 1USSNREP Statistics - Narrative file SNTXTP Lloyds Text Type *CHAR 1USTIREP Cash Taxation Log File TIAMCD AMOUNT CODE *CHAR 3USTIREP Cash Taxation Log File TIEDID Endorsement ID *PACKED 9 (0 d.p.)USTIREP Cash Taxation Log File TIPHID Policy (Dec) Header ID *PACKED 9 (0 d.p.)USTIREP Cash Taxation Log File TIPSID Policy (Dec) Sub-Type ID *PACKED 9 (0 d.p.)USTIREP Cash Taxation Log File TIRCIN Collected/Recorded Flag *CHAR 1USTIREP Cash Taxation Log File TISYID Syndicate ID *PACKED 9 (0 d.p.)USTIREP Cash Taxation Log File TISYSQ Syndicate sequence *PACKED 3 (0 d.p.)USTIREP Cash Taxation Log File TITXCY Country Code *CHAR 5USTIREP Cash Taxation Log File TITXPC Tax Rate - Percentage *PACKED 11 (7 d.p.)USTIREP Cash Taxation Log File TIWHIN Part/Whole Flag *CHAR 1UTD2F0P0 PSAC D02 Premium Signings - data

structureD2F021 1 CHAR FILLER *CHAR 1

UTD2F0P0 PSAC D02 Premium Signings - data structure

D2IPCY IPT - COUNTRY OF ORIGIN *CHAR 2


D2IPOG IPT - ORIGINAL CURRENCY *ZONED 15 (2 d.p.)


D2IPPC IPT - PERCENTAGE *ZONED 10 (7 d.p.)


D2IPRC IPT - COLLECTED/RECORDED *CHAR 1


D2IPWH IPT - PART/WHOLE FLAG *CHAR 1

UTD2F0P1 PSAC D02 Premium Signings - data structure alpha

D2F021 1 CHAR FILLER *CHAR 1


D2IPCY IPT - COUNTRY OF ORIGIN *CHAR 2


D2IPOG IPT - ORIGINAL CURRENCY *CHAR 15


D2IPPC IPT - PERCENTAGE *CHAR 10


D2IPRC IPT - COLLECTED/RECORDED *CHAR 1


D2IPWH IPT - PART/WHOLE FLAG *CHAR 1

UTD2REP LIRMA D02 Premium Signings D2F021 1 CHAR FILLER *CHAR 1UTD2REP LIRMA D02 Premium Signings D2IPCY IPT - COUNTRY OF ORIGIN *CHAR 2UTD2REP LIRMA D02 Premium Signings D2IPOG IPT - ORIGINAL CURRENCY *ZONED 15 (2 d.p.)UTD2REP LIRMA D02 Premium Signings D2IPPC IPT - PERCENTAGE *ZONED 10 (7 d.p.)UTD2REP LIRMA D02 Premium Signings D2IPRC IPT - COLLECTED/RECORDED *CHAR 1UTD2REP LIRMA D02 Premium Signings D2IPWH IPT - PART/WHOLE FLAG *CHAR 1UTH1REP ILUCSM Signing Details H1IPRC IPT - Collected/Recorded *CHAR 1UTH1REP ILUCSM Signing Details H1IPWH IPT - Part/Whole Flag *CHAR 1UTKJREP Bureau Claims - Core SCM Transaction KJSLNO Syndicate Line Number *CHAR 3UTKJREP Bureau Claims - Core SCM Transaction KJSYN Syndicate Number *CHAR 4UTO1REP Bureau closings log - Header file O1AACD Lloyd's Aviation Audit Code *CHAR 2UTO1REP Bureau closings log - Header file O1ACRF Associated closing Section


UTO1REP Bureau closings log - Header file O1ADIN Lloyd's Adjustable Indcator *CHAR 1UTO1REP Bureau closings log - Header file O1ASRF Associated Sub Account Reference *PACKED 2 (0 d.p.)UTO1REP Bureau closings log - Header file O1ATIN Attachment Indcator *CHAR 1UTO1REP Bureau closings log - Header file O1ATRF Associated Technical Account

Reference*CHAR 9

UTO1REP Bureau closings log - Header file O1BCAM Syndiate's Balance of Cash Amount *PACKED 15 (2 d.p.)UTO1REP Bureau closings log - Header file O1BCCD Business Category *CHAR 3UTO1REP Bureau closings log - Header file O1BLIN Bulk Settlement Indicator *CHAR 1UTO1REP Bureau closings log - Header file O1BRPS Broker Pseudonym *CHAR 4UTO1REP Bureau closings log - Header file O1BRRF BROKER/THEIR REF *CHAR 12UTO1REP Bureau closings log - Header file O1CACD Lloyd's CA Category Code *CHAR 1UTO1REP Bureau closings log - Header file O1CKKY Currency Key *PACKED 1 (0 d.p.)UTO1REP Bureau closings log - Header file O1CNRF Collection Note Reference *CHAR 17UTO1REP Bureau closings log - Header file O1COOR Country of Origin *CHAR 2UTO1REP Bureau closings log - Header file O1CORS Country of Risk *CHAR 2UTO1REP Bureau closings log - Header file O1CPIN Claims Payable Abroad Indicator *CHAR 1UTO1REP Bureau closings log - Header file O1CSRF Closing Section Reference *PACKED 3 (0 d.p.)



File File Description Field Field Description Type LengthUTO1REP Bureau closings log - Header file O1CTCD Catastrophe Code *CHAR 4UTO1REP Bureau closings log - Header file O1DBAM DEFD BALANCE B/FWD *PACKED 15 (2 d.p.)UTO1REP Bureau closings log - Header file O1DCAM DEFD BALANCE C/FWD *PACKED 15 (2 d.p.)UTO1REP Bureau closings log - Header file O1DCRF DCF Signing Reference *CHAR 13UTO1REP Bureau closings log - Header file O1DRCD Derived Audit/Risk Code *CHAR 2UTO1REP Bureau closings log - Header file O1DTCD Audit/DTI Code *CHAR 2UTO1REP Bureau closings log - Header file O1ENTY Entry Type *CHAR 3UTO1REP Bureau closings log - Header file O1F1CD FIL Code 1 *CHAR 4UTO1REP Bureau closings log - Header file O1F2CD FIL Code 2 *CHAR 4UTO1REP Bureau closings log - Header file O1FARF Financial Account Reference *CHAR 9UTO1REP Bureau closings log - Header file O1FECD Type of Payment Indicator *CHAR 1UTO1REP Bureau closings log - Header file O1FICD Lloyd's FIL Market Code *CHAR 2UTO1REP Bureau closings log - Header file O1INRF Invoice Reference *CHAR 50UTO1REP Bureau closings log - Header file O1LCAM Syndicate LOC Outstanding Amount *PACKED 15 (2 d.p.)UTO1REP Bureau closings log - Header file O1LCRF LCO Reference *CHAR 12UTO1REP Bureau closings log - Header file O1LLAC Lloyd's Accouting Type *CHAR 1UTO1REP Bureau closings log - Header file O1LLPC Lloyd's Total Line *PACKED 12 (7 d.p.)UTO1REP Bureau closings log - Header file O1LLTY Lloyd's Line Type *PACKED 1 (0 d.p.)UTO1REP Bureau closings log - Header file O1LRAM Loss Reserve Interest Amount *PACKED 15 (0 d.p.)UTO1REP Bureau closings log - Header file O1MACD Lloyd's Marine Audit Code *CHAR 2UTO1REP Bureau closings log - Header file O1MKTY LPSO Market Type *CHAR 2UTO1REP Bureau closings log - Header file O1MVRF Movement Reference *CHAR 6UTO1REP Bureau closings log - Header file O1NACD Lloyd's Non-Marine Audit Code *CHAR 2UTO1REP Bureau closings log - Header file O1OBNO Originating Broker *CHAR 4UTO1REP Bureau closings log - Header file O1OBPS Originating Broker Pseudonym *CHAR 4UTO1REP Bureau closings log - Header file O1OBRF Original Bureau Signing Reference *CHAR 13UTO1REP Bureau closings log - Header file O1OCIN LPSO OCA Contra Indcator *CHAR 1UTO1REP Bureau closings log - Header file O1ORRF Outward Reinsurance Reference *CHAR 13UTO1REP Bureau closings log - Header file O1PPDT Policy From Date *PACKED 7 (0 d.p.)UTO1REP Bureau closings log - Header file O1PRCD Lloyd's Processing Code *CHAR 3UTO1REP Bureau closings log - Header file O1PSDT Planned Settlement Date *PACKED 8 (0 d.p.)UTO1REP Bureau closings log - Header file O1PTAM Amount Paid This Time *PACKED 15 (0 d.p.)UTO1REP Bureau closings log - Header file O1PTDT Policy To Date *PACKED 7 (0 d.p.)UTO1REP Bureau closings log - Header file O1PTTX Period of Transaction *CHAR 20UTO1REP Bureau closings log - Header file O1PYIN Payment Indicator *CHAR 1UTO1REP Bureau closings log - Header file O1PYRF Payment Reference *CHAR 2UTO1REP Bureau closings log - Header file O1QCCD Lloyd's CA Qualifying Category

Code*CHAR 1

UTO1REP Bureau closings log - Header file O1RBAM RESV BALANCE B/FWD *PACKED 15 (2 d.p.)UTO1REP Bureau closings log - Header file O1RCAM RESV BALANCE C/FWD *PACKED 15 (2 d.p.)UTO1REP Bureau closings log - Header file O1RIAM Syndiate R/I Ceded to Lloyd's


UTO1REP Bureau closings log - Header file O1RSCD Risk Code *CHAR 2UTO1REP Bureau closings log - Header file O1RSRF Risk Section Reference *PACKED 2 (0 d.p.)UTO1REP Bureau closings log - Header file O1RXRF Rate of Exchange Original Bureau


UTO1REP Bureau closings log - Header file O1SARF Sub Account Reference *PACKED 2 (0 d.p.)UTO1REP Bureau closings log - Header file O1SDDT Settlement Date *PACKED 8 (0 d.p.)UTO1REP Bureau closings log - Header file O1SDQU Settlement Date Qualifier *CHAR 3UTO1REP Bureau closings log - Header file O1SLNO Syndicate Line Number *PACKED 3 (0 d.p.)UTO1REP Bureau closings log - Header file O1SLRF System Line Reference *CHAR 6UTO1REP Bureau closings log - Header file O1SMCD Syndicate Market Code *CHAR 1UTO1REP Bureau closings log - Header file O1SRBI Syndicate R/I Broker Infomation *CHAR 12UTO1REP Bureau closings log - Header file O1SSIN Source System Indicator *CHAR 1UTO1REP Bureau closings log - Header file O1SYRF Company/Syndicate Secondary

Reference*CHAR 12

UTO1REP Bureau closings log - Header file O1TARF Technical Account Reference *CHAR 9UTO1REP Bureau closings log - Header file O1TDPC Total Discount *PACKED 12 (7 d.p.)UTO1REP Bureau closings log - Header file O1TFCD Trust Fund Code *CHAR 2UTO1REP Bureau closings log - Header file O1TYNO Bureau Treaty Number *CHAR 9UTO1REP Bureau closings log - Header file O1TYSN Lloyd's Treaty Serial Number *CHAR 3UTO1REP Bureau closings log - Header file O1UCRF Unique Claim Reference *CHAR 17UTO1REP Bureau closings log - Header file O1UMRF Unique Market Reference *CHAR 17UTO1REP Bureau closings log - Header file O1UTRF Unique Transaction Reference *CHAR 17UTO1REP Bureau closings log - Header file O1VTAM Syndiate VAT Amount *PACKED 15 (2 d.p.)UTO1REP Bureau closings log - Header file O1WRAM Syndiate War Amount *PACKED 15 (2 d.p.)UTO1REP Bureau closings log - Header file O1YPID Claim Payee ID *PACKED 6 (0 d.p.)



File File Description Field Field Description Type LengthUTO1WKP0 Bureau closings - Dummy header for

valdationO1AACD Lloyd's Aviation Audit Code *CHAR 2

UTO1WKP0 Bureau closings - Dummy header for valdation

O1ACRF Associated closing Section Reference

*PACKED 3 (0 d.p.)


O1ADIN Lloyd's Adjustable Indcator *CHAR 1


O1ASRF Associated Sub Account Reference *PACKED 2 (0 d.p.)


O1ATIN Attachment Indcator *CHAR 1


O1ATRF Associated Technical Account Reference

*CHAR 9


O1BCAM Syndiate's Balance of Cash Amount *PACKED 15 (2 d.p.)


O1BCCD Business Category *CHAR 3


O1BLIN Bulk Settlement Indicator *CHAR 1


O1BRPS Broker Pseudonym *CHAR 4


O1BRRF BROKER/THEIR REF *CHAR 12


O1CACD Lloyd's CA Category Code *CHAR 1


O1CKKY Currency Key *PACKED 1 (0 d.p.)


O1CNRF Collection Note Reference *CHAR 17


O1COOR Country of Origin *CHAR 2


O1CORS Country of Risk *CHAR 2


O1CPIN Claims Payable Abroad Indicator *CHAR 1


O1CSRF Closing Section Reference *PACKED 3 (0 d.p.)


O1CTCD Catastrophe Code *CHAR 4


O1DBAM DEFD BALANCE B/FWD *PACKED 15 (2 d.p.)


O1DCAM DEFD BALANCE C/FWD *PACKED 15 (2 d.p.)


O1DCRF DCF Signing Reference *CHAR 13


O1DRCD Derived Audit/Risk Code *CHAR 2


O1DTCD Audit/DTI Code *CHAR 2


O1ENTY Entry Type *CHAR 3


O1F1CD FIL Code 1 *CHAR 4


O1F2CD FIL Code 2 *CHAR 4


O1FARF Financial Account Reference *CHAR 9


O1FECD Type of Payment Indicator *CHAR 1


O1FICD Lloyd's FIL Market Code *CHAR 2


O1INRF Invoice Reference *CHAR 50


O1LCAM Syndicate LOC Outstanding Amount *PACKED 15 (2 d.p.)


O1LCRF LCO Reference *CHAR 12


O1LLAC Lloyd's Accouting Type *CHAR 1




valdationO1LLPC Lloyd's Total Line *PACKED 12 (7 d.p.)


O1LLTY Lloyd's Line Type *PACKED 1 (0 d.p.)


O1LRAM Loss Reserve Interest Amount *PACKED 15 (0 d.p.)


O1MACD Lloyd's Marine Audit Code *CHAR 2


O1MKTY LPSO Market Type *CHAR 2


O1MVRF Movement Reference *CHAR 6


O1NACD Lloyd's Non-Marine Audit Code *CHAR 2


O1OBNO Originating Broker *CHAR 4


O1OBPS Originating Broker Pseudonym *CHAR 4


O1OBRF Original Bureau Signing Reference *CHAR 13


O1OCIN LPSO OCA Contra Indcator *CHAR 1


O1ORRF Outward Reinsurance Reference *CHAR 13


O1PPDT Policy From Date *PACKED 7 (0 d.p.)


O1PRCD Lloyd's Processing Code *CHAR 3


O1PSDT Planned Settlement Date *PACKED 8 (0 d.p.)


O1PTAM Amount Paid This Time *PACKED 15 (0 d.p.)


O1PTDT Policy To Date *PACKED 7 (0 d.p.)


O1PTTX Period of Transaction *CHAR 20


O1PYIN Payment Indicator *CHAR 1


O1PYRF Payment Reference *CHAR 2


O1QCCD Lloyd's CA Qualifying Category Code

*CHAR 1


O1RBAM RESV BALANCE B/FWD *PACKED 15 (2 d.p.)


O1RCAM RESV BALANCE C/FWD *PACKED 15 (2 d.p.)


O1RIAM Syndiate R/I Ceded to Lloyd's Amount

*PACKED 15 (2 d.p.)


O1RSCD Risk Code *CHAR 2


O1RSRF Risk Section Reference *PACKED 2 (0 d.p.)


O1RXRF Rate of Exchange Original Bureau Signing Reference

*CHAR 13


O1SARF Sub Account Reference *PACKED 2 (0 d.p.)


O1SDDT Settlement Date *PACKED 8 (0 d.p.)


O1SDQU Settlement Date Qualifier *CHAR 3


O1SLNO Syndicate Line Number *PACKED 3 (0 d.p.)


O1SLRF System Line Reference *CHAR 6


O1SMCD Syndicate Market Code *CHAR 1


O1SRBI Syndicate R/I Broker Infomation *CHAR 12




valdationO1SSIN Source System Indicator *CHAR 1


O1SYRF Company/Syndicate Secondary Reference

*CHAR 12


O1TARF Technical Account Reference *CHAR 9


O1TDPC Total Discount *PACKED 12 (7 d.p.)


O1TFCD Trust Fund Code *CHAR 2


O1TYNO Bureau Treaty Number *CHAR 9


O1TYSN Lloyd's Treaty Serial Number *CHAR 3


O1UCRF Unique Claim Reference *CHAR 17


O1UMRF Unique Market Reference *CHAR 17


O1UTRF Unique Transaction Reference *CHAR 17


O1VTAM Syndiate VAT Amount *PACKED 15 (2 d.p.)


O1WRAM Syndiate War Amount *PACKED 15 (2 d.p.)


O1YPID Claim Payee ID *PACKED 6 (0 d.p.)

UTO2REP TITLE O2: BUREAU CLOSINGS LOG - SECTION/CODE FILE

O2#TSC TREATY SECTION CODE *CHAR 2


O2HAMT 100% AMOUNT *PACKED 15 (2 d.p.)


O2WRAM Syndiate War Amount *PACKED 15 (2 d.p.)

UTO3REP Bureau closings log - Amounts file O3EM@A Extension Trans Amnt Clsd A/C *PACKED 15 (2 d.p.)UTO3REP Bureau closings log - Amounts file O3EM@B Extension Trans Amnt Clsd Base *PACKED 15 (2 d.p.)UTO3REP Bureau closings log - Amounts file O3EM@O Extension Trans Amnt Clsd Orig *PACKED 15 (2 d.p.)UTOIREP Bureau Closings Log - Taxation File OIAM@O Tax Amount Orig *PACKED 15 (2 d.p.)UTOIREP Bureau Closings Log - Taxation File OIAM@Q Tax Amount Sett *PACKED 15 (2 d.p.)UTOIREP Bureau Closings Log - Taxation File OIAMCD AMOUNT CODE *CHAR 3UTOIREP Bureau Closings Log - Taxation File OIINNO INSTALMENT NUMBER *PACKED 2 (0 d.p.)UTOIREP Bureau Closings Log - Taxation File OIRCIN Collected/Recorded Flag *CHAR 1UTOIREP Bureau Closings Log - Taxation File OIS1SQ STATS HEADER SEQUENCE

NUMBER*PACKED 9 (0 d.p.)

UTOIREP Bureau Closings Log - Taxation File OIS4SQ POSTING RECORD SEQUENCE *PACKED 3 (0 d.p.)UTOIREP Bureau Closings Log - Taxation File OITXCY Country Code *CHAR 5UTOIREP Bureau Closings Log - Taxation File OITXPC Tax Rate - Percentage *PACKED 11 (7 d.p.)UTOIREP Bureau Closings Log - Taxation File OIWHIN Part/Whole Flag *CHAR 1UTONREP Bureau Closings log - Narrative file ONS2SQ Section Record Seq *PACKED 3 (0 d.p.)UTONREP Bureau Closings log - Narrative file ONTXL# Lloyds Narrative Number *PACKED 1 (0 d.p.)UTONREP Bureau Closings log - Narrative file ONTXLN Lloyds Line Number *CHAR 1UTONREP Bureau Closings log - Narrative file ONTXTP Lloyds Text Type *CHAR 1UTPSP0PP Parameter list for bureau closings edit PPDAA1 Out Declarations Array 1 *CHAR 240UTPSP0PP Parameter list for bureau closings edit PPDAA2 Out Declarations Array 2 *CHAR 57UTPSP0PP Parameter list for bureau closings edit PPEDA1 Out Endorsements Array 1 *CHAR 240UTPSP0PP Parameter list for bureau closings edit PPEDA2 Out Endorsements Array 2 *CHAR 57UTPSP0PP Parameter list for bureau closings edit PPPCA1 R/I %ages Array 1 *CHAR 220UTPSP0PP Parameter list for bureau closings edit PPPCA2 R/I %ages Array 2 *CHAR 220UTPSP0PP Parameter list for bureau closings edit PPPCA3 R/I %ages Array 3 *CHAR 220UTPSP0PP Parameter list for bureau closings edit PPPCA4 R/I %ages Array 4 *CHAR 220UTPSP0PP Parameter list for bureau closings edit PPPCA5 R/I %ages Array 5 *CHAR 209UTPSP0PP Parameter list for bureau closings edit PPPOA1 Out Policy No Array 1 *CHAR 240UTPSP0PP Parameter list for bureau closings edit PPPOA2 Out Policy No Array 2 *CHAR 240UTPSP0PP Parameter list for bureau closings edit PPPOA3 Out Policy No Array 1 *CHAR 114UTPSP0PP Parameter list for bureau closings edit PPPTA1 Out Posting A/Cs Array 1 *CHAR 200UTPSP0PP Parameter list for bureau closings edit PPPTA2 Out Posting A/Cs Array 2 *CHAR 200UTPSP0PP Parameter list for bureau closings edit PPRIA1 R/I Codes Array 1 *CHAR 200UTPSP0PP Parameter list for bureau closings edit PPRIA2 R/I Codes Array 2 *CHAR 196UTPSP0PP Parameter list for bureau closings edit PPTMA1 R/I Deduction Terms ONR/OGR1 *CHAR 240UTPSP0PP Parameter list for bureau closings edit PPTMA2 R/I Deduction Terms ONR/OGR2 *CHAR 57



File File Description Field Field Description Type LengthUTPSP0PP Parameter list for bureau closings edit PPUPA1 Unplaced R/I %ages Array 1 *CHAR 220UTPSP0PP Parameter list for bureau closings edit PPUPA2 Unplaced R/I %ages Array 2 *CHAR 220UTPSP0PP Parameter list for bureau closings edit PPUPA3 Unplaced R/I %ages Array 3 *CHAR 220UTPSP0PP Parameter list for bureau closings edit PPUPA4 Unplaced R/I %ages Array 4 *CHAR 220UTPSP0PP Parameter list for bureau closings edit PPUPA5 Unplaced R/I %ages Array 5 *CHAR 209UTXAREP Bureau Revenue code X-ref XATXCY Country Code *CHAR 5UXEXREP Extract Log Details EXEF01 Extract Field 01 *CHAR 30UXEXREP Extract Log Details EXEF02 Extract Field 02 *CHAR 30UXEXREP Extract Log Details EXEF03 Extract Field 03 *CHAR 30UXEXREP Extract Log Details EXEF04 Extract Field 04 *CHAR 30UXEXREP Extract Log Details EXEF05 Extract Field 05 *CHAR 30UXEXREP Extract Log Details EXEF06 Extract Field 06 *CHAR 30UXEXREP Extract Log Details EXEF07 Extract Field 07 *CHAR 30UXEXREP Extract Log Details EXEF08 Extract Field 08 *CHAR 30UXEXREP Extract Log Details EXEF09 Extract Field 09 *CHAR 30UXEXREP Extract Log Details EXEF10 Extract Field 10 *CHAR 30UXEXREP Extract Log Details EXEF11 Extract Field 11 *CHAR 30UXEXREP Extract Log Details EXEF12 Extract Field 12 *CHAR 30UXEXREP Extract Log Details EXEF13 Extract Field 13 *CHAR 30UXEXREP Extract Log Details EXEF14 Extract Field 14 *CHAR 30UXEXREP Extract Log Details EXEF15 Extract Field 15 *CHAR 30UXEXREP Extract Log Details EXEF16 Extract Field 16 *CHAR 30UXEXREP Extract Log Details EXEF17 Extract Field 17 *CHAR 30UXEXREP Extract Log Details EXEF18 Extract Field 18 *CHAR 30UXEXREP Extract Log Details EXEF19 Extract Field 19 *CHAR 30UXEXREP Extract Log Details EXEF20 Extract Field 20 *CHAR 30UXEXREP Extract Log Details EXEF21 Extract Field 21 *CHAR 30UXEXREP Extract Log Details EXEF22 Extract Field 22 *CHAR 30UXEXREP Extract Log Details EXEF23 Extract Field 23 *CHAR 30UXEXREP Extract Log Details EXEF24 Extract Field 24 *CHAR 30UXEXREP Extract Log Details EXEF25 Extract Field 25 *CHAR 30UXEXREP Extract Log Details EXEF26 Extract Field 26 *CHAR 30UXEXREP Extract Log Details EXEF27 Extract Field 27 *CHAR 30UXEXREP Extract Log Details EXEF28 Extract Field 28 *CHAR 30UXEXREP Extract Log Details EXEF29 Extract Field 29 *CHAR 30UXEXREP Extract Log Details EXEF30 Extract Field 30 *CHAR 30UXEXREP Extract Log Details EXEF31 Extract Field 31 *CHAR 50UXEXREP Extract Log Details EXEF32 Extract Field 32 *CHAR 50UXEXREP Extract Log Details EXEK01 Extract Record Key 01 *CHAR 25UXEXREP Extract Log Details EXEK02 Extract Record Key 02 *CHAR 25UXEXREP Extract Log Details EXEK03 Extract Record Key 03 *CHAR 25UXEXREP Extract Log Details EXEK04 Extract Record Key 04 *CHAR 25UXEXREP Extract Log Details EXEK05 Extract Record Key 05 *CHAR 25UXEXREP Extract Log Details EXEXSQ Extract Seq No *PACKED 15 (0 d.p.)UXEXREP Extract Log Details EXLGID Extract Log ID *PACKED 15 (0 d.p.)UXEXREP Extract Log Details EXNAME Extract Name *CHAR 30UXEXREP Extract Log Details EXRCSQ Extract Record Seq *PACKED 15 (0 d.p.)UXEXREP Extract Log Details EXRPDT Receipt Date *PACKED 7 (0 d.p.)UXEXREP Extract Log Details EXSK01 Source Records Key 01 *CHAR 25UXEXREP Extract Log Details EXSK02 Source Records Key 02 *CHAR 25UXEXREP Extract Log Details EXSK03 Source Records Key 03 *CHAR 25UXEXREP Extract Log Details EXSK04 Source Records Key 04 *CHAR 25UXEXREP Extract Log Details EXSK05 Source Records Key 05 *CHAR 25UXEXREP Extract Log Details EXSRHS Source Hash *PACKED 15 (0 d.p.)UXEXREP Extract Log Details EXTMDT Transmission Date *PACKED 7 (0 d.p.)UXEXREP Extract Log Details EXTMST Transmission Statys *CHAR 1UXEXREP Extract Log Details EXUPDT Last Update Date *PACKED 7 (0 d.p.)UXFSWKP Unused References Workfile (TYPE!

UGYR!RFKY!SLID)FSRFKY Reference Key *CHAR 20

UXFSWKP Unused References Workfile (TYPE!UGYR!RFKY!SLID)

FSSLID Reference *CHAR 15


FSTYPE Reference Type *CHAR 20


FSUGYR U/W YEAR *PACKED 4 (0 d.p.)

UXIRREP Initial Reference Ranges (TYPE!UGYR!RFKY)

IRLWRG Lower Reference Limit *CHAR 15



File File Description Field Field Description Type LengthUXIRREP Initial Reference Ranges (TYPE!UGYR!

RFKY)IRRFKY Reference Key *CHAR 20


IRTYPE Reference Type *CHAR 20


IRUGYR U/W YEAR *PACKED 4 (0 d.p.)


IRUPRG Upper Reference Limit *CHAR 15

UXIRWKP Initial Reference Ranges Workfile (TYPE!UGYR!RFKY)

IRLWRG Lower Reference Limit *CHAR 15


IRRFKY Reference Key *CHAR 20


IRTYPE Reference Type *CHAR 20


IRUGYR U/W YEAR *PACKED 4 (0 d.p.)


IRUPRG Upper Reference Limit *CHAR 15

UXISREP Reference Formats (TYPE!YRFL!RFKY) ISAUCF Addnl Unique Check Fields *CHAR 20UXISREP Reference Formats (TYPE!YRFL!RFKY) ISDESC Reference Description *CHAR 150UXISREP Reference Formats (TYPE!YRFL!RFKY) ISRFFT Reference Format *CHAR 15UXISREP Reference Formats (TYPE!YRFL!RFKY) ISRGDP Range Dependent *CHAR 1UXISREP Reference Formats (TYPE!YRFL!RFKY) ISUQCK Unique Check Field *CHAR 4UXMFREP MID Interface Header Audit File MFENDT ENTRY DATE *PACKED 7 (0 d.p.)UXMFREP MID Interface Header Audit File MFENQT ENTRY TIME *CHAR 6UXMFREP MID Interface Header Audit File MFERCD FILE ERROR CODES *CHAR 80UXMFREP MID Interface Header Audit File MFHDTY HEADER RECORD TYPE *CHAR 1UXMFREP MID Interface Header Audit File MFMFSQ FILE SEQ *PACKED 6 (0 d.p.)UXMFREP MID Interface Header Audit File MFMFVR FILE VERSION *PACKED 4 (0 d.p.)UXMFREP MID Interface Header Audit File MFRCNT DATA RECORD COUNT *PACKED 9 (0 d.p.)UXMFREP MID Interface Header Audit File MFSSCD FILE STATUS *CHAR 1UXMFREP MID Interface Header Audit File MFSTNO SITE NUMBER *CHAR 3UXMFREP MID Interface Header Audit File MFSUID SUPPLIER ID *CHAR 3UXMFREP MID Interface Header Audit File MFSUTY SUPPLIER TYPE *CHAR 1UXMFREP MID Interface Header Audit File MFTRTY TRAILER RECORD TYPE *CHAR 1UXMFREP MID Interface Header Audit File MFTSIN TEST INDICATOR *PACKED 1 (0 d.p.)UXMTREP MID Interface Policy Details Audit File MTADA1 ADDRESS LINE 1 *CHAR 40UXMTREP MID Interface Policy Details Audit File MTADA2 ADDRESS LINE 2 *CHAR 40UXMTREP MID Interface Policy Details Audit File MTADA3 ADDRESS LINE 3 *CHAR 40UXMTREP MID Interface Policy Details Audit File MTADA4 ADDRESS LINE 4 *CHAR 40UXMTREP MID Interface Policy Details Audit File MTADA5 ADDRESS LINE 5 *CHAR 40UXMTREP MID Interface Policy Details Audit File MTADA6 ADDRESS LINE 6 *CHAR 40UXMTREP MID Interface Policy Details Audit File MTADDR ADDITIONAL DRIVER

INDICATOR*CHAR 1

UXMTREP MID Interface Policy Details Audit File MTASDL POLICY HOLDER CONTCT DETAILS

*CHAR 54

UXMTREP MID Interface Policy Details Audit File MTASNM POLICY HOLDER NAME *CHAR 70UXMTREP MID Interface Policy Details Audit File MTDAID DELEGATE AUTHORITY ID *CHAR 3UXMTREP MID Interface Policy Details Audit File MTDBID DELEGATE AUTHORITY

BRANCH ID*CHAR 20

UXMTREP MID Interface Policy Details Audit File MTDTTY RECORD TYPE *CHAR 1UXMTREP MID Interface Policy Details Audit File MTEDID Endorsement ID *PACKED 9 (0 d.p.)UXMTREP MID Interface Policy Details Audit File MTEHJF EFFECTIVE FROM DATE *PACKED 7 (0 d.p.)UXMTREP MID Interface Policy Details Audit File MTEHJT EFFECTIVE TO DATE *PACKED 7 (0 d.p.)UXMTREP MID Interface Policy Details Audit File MTENDT ENTRY DATE *PACKED 7 (0 d.p.)UXMTREP MID Interface Policy Details Audit File MTENQT ENTRY TIME *CHAR 6UXMTREP MID Interface Policy Details Audit File MTERCD FILE ERROR CODES *CHAR 80UXMTREP MID Interface Policy Details Audit File MTIBID INSURER BRANCH ID *CHAR 10UXMTREP MID Interface Policy Details Audit File MTINID INSURER ID *CHAR 3UXMTREP MID Interface Policy Details Audit File MTMFSQ FILE SEQ *PACKED 6 (0 d.p.)UXMTREP MID Interface Policy Details Audit File MTNDR1 NAMED DRIVER 1 *CHAR 70UXMTREP MID Interface Policy Details Audit File MTNDR2 NAMED DRIVER 2 *CHAR 70UXMTREP MID Interface Policy Details Audit File MTNDR3 NAMED DRIVER 3 *CHAR 70UXMTREP MID Interface Policy Details Audit File MTNDR4 NAMED DRIVER 4 *CHAR 70UXMTREP MID Interface Policy Details Audit File MTNDR5 NAMED DRIVER 5 *CHAR 70UXMTREP MID Interface Policy Details Audit File MTNDR6 NAMED DRIVER 6 *CHAR 70UXMTREP MID Interface Policy Details Audit File MTNMDR NO OF NAMED DRIVERS *PACKED 1 (0 d.p.)



File File Description Field Field Description Type LengthUXMTREP MID Interface Policy Details Audit File MTPCNT POLICY CONTROL COUNT *PACKED 4 (0 d.p.)UXMTREP MID Interface Policy Details Audit File MTPHID Policy (Dec) Header ID *PACKED 9 (0 d.p.)UXMTREP MID Interface Policy Details Audit File MTPOAC POLICY ACCESS *PACKED 6 (0 d.p.)UXMTREP MID Interface Policy Details Audit File MTPONO POLICY NUMBER *CHAR 20UXMTREP MID Interface Policy Details Audit File MTPOST CANCELLATN/LAPSED

INDICATOR*CHAR 1

UXMTREP MID Interface Policy Details Audit File MTPRDR PERMITTED DRIVER *CHAR 2UXMTREP MID Interface Policy Details Audit File MTPSID Policy (Dec) Sub-Type ID *PACKED 9 (0 d.p.)UXMTREP MID Interface Policy Details Audit File MTRNIN RENEWAL INDICATOR *CHAR 2UXMTREP MID Interface Policy Details Audit File MTRPIN REPORT INDICATOR *CHAR 1UXMTREP MID Interface Policy Details Audit File MTSSCD FILE STATUS *CHAR 1UXMTREP MID Interface Policy Details Audit File MTTRIN MOTOR TRADE POLICY

INDICATOR*CHAR 1

UXMTREP MID Interface Policy Details Audit File MTUPTY UPDATE TYPE *CHAR 1UXMTREP MID Interface Policy Details Audit File MTUSCL CLASS OF USE *CHAR 3UXMTREP MID Interface Policy Details Audit File MTUSRF QUOTE BACK *CHAR 35UXMTREP MID Interface Policy Details Audit File MTVRIN VEHICLE RECORD INDICATOR *CHAR 1UXMTREP MID Interface Policy Details Audit File MTXDR1 EXCLUDE DRIVER 1 *CHAR 1UXMTREP MID Interface Policy Details Audit File MTXDR2 EXCLUDE DRIVER 2 *CHAR 1UXMTREP MID Interface Policy Details Audit File MTXDR3 EXCLUDE DRIVER 3 *CHAR 1UXMTREP MID Interface Policy Details Audit File MTXDR4 EXCLUDE DRIVER 4 *CHAR 1UXMTREP MID Interface Policy Details Audit File MTXDR5 EXCLUDE DRIVER 5 *CHAR 1UXMTREP MID Interface Policy Details Audit File MTXDR6 EXCLUDE DRIVER 6 *CHAR 1UXMTREP MID Interface Policy Details Audit File MTZTCD POST CODE *CHAR 8UXURQYP0 Populate Used & Unused Refs and Ref.

Ranges-QRYF1POBHCD Branch Code *CHAR 6

UXURQYP0 Populate Used & Unused Refs and Ref. Ranges-QRYF1

POCOCD COMPANY CODE *PACKED 1 (0 d.p.)


POIWFG INWARDS/OUTWARDS FLAG *CHAR 1


POPONO POLICY NO *PACKED 6 (0 d.p.)


POPOTY Policy Type (Q/F) *CHAR 1


POQPMU QPM Unique Number *PACKED 6 (0 d.p.)


POQPMY QPM U/W Year *PACKED 4 (0 d.p.)


POUGTY UNDERWRITING TYPE *CHAR 1


POUGYR U/W YEAR *PACKED 4 (0 d.p.)


POBHCD Branch Code *CHAR 6


POCOCD COMPANY CODE *PACKED 1 (0 d.p.)


POIWFG INWARDS/OUTWARDS FLAG *CHAR 1


POPONO POLICY NO *PACKED 6 (0 d.p.)


POPOTY Policy Type (Q/F) *CHAR 1


POQPMU QPM Unique Number *PACKED 6 (0 d.p.)


POQPMY QPM U/W Year *PACKED 4 (0 d.p.)


POUGTY UNDERWRITING TYPE *CHAR 1


POUGYR U/W YEAR *PACKED 4 (0 d.p.)

UXURREP Used References (UQCK!AUCV!SLID) URAUCV Addnl Unique Check Fields Values *CHAR 20UXURREP Used References (UQCK!AUCV!SLID) UREGRF Externally Generated Reference Flag *CHAR 1UXURREP Used References (UQCK!AUCV!SLID) URRFKY Reference Key *CHAR 20UXURREP Used References (UQCK!AUCV!SLID) URSLID Slip Identifier *CHAR 15UXURREP Used References (UQCK!AUCV!SLID) URTYPE Reference Type *CHAR 20UXURREP Used References (UQCK!AUCV!SLID) URUGYR U/W YEAR *PACKED 4 (0 d.p.)UXURREP Used References (UQCK!AUCV!SLID) URUQCK Unique Check Field *CHAR 4



File File Description Field Field Description Type LengthUXURWKP Used References Workfile (UQCK!AUCV!

SLID)URAUCV Addnl Unique Check Fields Values *CHAR 20

UXURWKP Used References Workfile (UQCK!AUCV!SLID)

UREGRF Externally Generated Reference Flag *CHAR 1


URRFKY Reference Key *CHAR 20


URSLID Slip Identifier *CHAR 15


URTYPE Reference Type *CHAR 20


URUGYR U/W YEAR *PACKED 4 (0 d.p.)


URUQCK Unique Check Field *CHAR 4

UXUSWKP Next available Reference Workfile (UGYR!TYPE!RFKY)

USRFKY Reference Key *CHAR 20


USSLID Next Available Reference *CHAR 15


USTYPE Reference Type *CHAR 20


USUGYR U/W YEAR *PACKED 4 (0 d.p.)

UZDYREP DY: Number of Days In Year DYDINY Days In Year *PACKED 3 (0 d.p.)UZDYREP DY: Number of Days In Year DYUGYR Year *PACKED 4 (0 d.p.)XSD2REP Limit RISYS 2000 Accurals Download File D2CNDT *CHAR 10XSD2REP Limit RISYS 2000 Accurals Download File D2EVCD *CHAR 6XSD2REP Limit RISYS 2000 Accurals Download File D2ORAM *PACKED 15 (2 d.p.)XSD2REP Limit RISYS 2000 Accurals Download File D2RIOS *PACKED 15 (2 d.p.)XSD2REP Limit RISYS 2000 Accurals Download File D2RIPR *PACKED 15 (2 d.p.)XSD2REP Limit RISYS 2000 Accurals Download File D2RIRE *PACKED 15 (2 d.p.)XSD2REP Limit RISYS 2000 Accurals Download File D2RSCD *CHAR 2XSD2REP Limit RISYS 2000 Accurals Download File D2SCCD *CHAR 3XSD2REP Limit RISYS 2000 Accurals Download File D2STAT *CHAR 49XSD2REP Limit RISYS 2000 Accurals Download File D2TFCD *CHAR 2XSD2REP Limit RISYS 2000 Accurals Download File D2USRF *CHAR 12XSD2REP Limit RISYS 2000 Accurals Download File D2VBCD *CHAR 4XSD2REP Limit RISYS 2000 Accurals Download File D2YRAC *CHAR 4XSD2REP Limit RISYS 2000 Accurals Download File D2ZMCD *CHAR 4XSD2WKP0 Limit RISYS 2000 Download FTP Script D2FTPC *CHAR 80XSD2WKP1 Limit RISYS 2000 Download FTP Error

LogD2FTPE *CHAR 80

XSD2WKP2 Limit RISYS 2000 Accruals Pipe Delimited FTP File

D2FIELD *CHAR 250

XSD3REP Limit RISYS 2000 Claims Download File D3ASNM *CHAR 80XSD3REP Limit RISYS 2000 Claims Download File D3BCCY *CHAR 4XSD3REP Limit RISYS 2000 Claims Download File D3BKR *CHAR 4XSD3REP Limit RISYS 2000 Claims Download File D3BLNK *CHAR 10XSD3REP Limit RISYS 2000 Claims Download File D3BPR *CHAR 40XSD3REP Limit RISYS 2000 Claims Download File D3BRKF *CHAR 12XSD3REP Limit RISYS 2000 Claims Download File D3BRRF *CHAR 12XSD3REP Limit RISYS 2000 Claims Download File D3CSL *PACKED 15 (8 d.p.)XSD3REP Limit RISYS 2000 Claims Download File D3CTCD *CHAR 8XSD3REP Limit RISYS 2000 Claims Download File D3DANO *CHAR 12XSD3REP Limit RISYS 2000 Claims Download File D3ECCY *CHAR 11XSD3REP Limit RISYS 2000 Claims Download File D3EVCD *CHAR 8XSD3REP Limit RISYS 2000 Claims Download File D3EVDS *CHAR 40XSD3REP Limit RISYS 2000 Claims Download File D3EVF2 *CHAR 14XSD3REP Limit RISYS 2000 Claims Download File D3EVFR *CHAR 14XSD3REP Limit RISYS 2000 Claims Download File D3EVTO *CHAR 14XSD3REP Limit RISYS 2000 Claims Download File D3F1CD *CHAR 20XSD3REP Limit RISYS 2000 Claims Download File D3FICD *CHAR 20XSD3REP Limit RISYS 2000 Claims Download File D3GROS *PACKED 15 (2 d.p.)XSD3REP Limit RISYS 2000 Claims Download File D3GRPD *PACKED 15 (2 d.p.)XSD3REP Limit RISYS 2000 Claims Download File D3GULO *CHAR 32XSD3REP Limit RISYS 2000 Claims Download File D3INTR *CHAR 5XSD3REP Limit RISYS 2000 Claims Download File D3ITID *CHAR 12XSD3REP Limit RISYS 2000 Claims Download File D3ITNO *CHAR 4



File File Description Field Field Description Type LengthXSD3REP Limit RISYS 2000 Claims Download File D3LMDT *CHAR 20XSD3REP Limit RISYS 2000 Claims Download File D3LOIS *CHAR 50XSD3REP Limit RISYS 2000 Claims Download File D3MVRF *CHAR 4XSD3REP Limit RISYS 2000 Claims Download File D3NRNR *CHAR 200XSD3REP Limit RISYS 2000 Claims Download File D3NTIC *PACKED 15 (2 d.p.)XSD3REP Limit RISYS 2000 Claims Download File D3NTOS *PACKED 15 (2 d.p.)XSD3REP Limit RISYS 2000 Claims Download File D3NTPD *PACKED 15 (2 d.p.)XSD3REP Limit RISYS 2000 Claims Download File D3OGCU *CHAR 4XSD3REP Limit RISYS 2000 Claims Download File D3RCTY *CHAR 4XSD3REP Limit RISYS 2000 Claims Download File D3RIDF *CHAR 20XSD3REP Limit RISYS 2000 Claims Download File D3RIOS *PACKED 15 (2 d.p.)XSD3REP Limit RISYS 2000 Claims Download File D3RIPD *PACKED 15 (2 d.p.)XSD3REP Limit RISYS 2000 Claims Download File D3RSCD *CHAR 4XSD3REP Limit RISYS 2000 Claims Download File D3RXS *PACKED 15 (8 d.p.)XSD3REP Limit RISYS 2000 Claims Download File D3SCCD *CHAR 4XSD3REP Limit RISYS 2000 Claims Download File D3SLNO *CHAR 6XSD3REP Limit RISYS 2000 Claims Download File D3STAT *CHAR 100XSD3REP Limit RISYS 2000 Claims Download File D3TFCD *CHAR 4XSD3REP Limit RISYS 2000 Claims Download File D3TWCD *CHAR 12XSD3REP Limit RISYS 2000 Claims Download File D3UGY2 *CHAR 4XSD3REP Limit RISYS 2000 Claims Download File D3UGYR *CHAR 4XSD3REP Limit RISYS 2000 Claims Download File D3USRF *CHAR 12XSD3REP Limit RISYS 2000 Claims Download File D3VBN1 *CHAR 80XSD3REP Limit RISYS 2000 Claims Download File D3VBN2 *CHAR 80XSD3REP Limit RISYS 2000 Claims Download File D3VBN3 *CHAR 80XSD3REP Limit RISYS 2000 Claims Download File D3VBN4 *CHAR 80XSD3REP Limit RISYS 2000 Claims Download File D3WARL *CHAR 2XSD3REP Limit RISYS 2000 Claims Download File D3YRLO *CHAR 4XSD3REP Limit RISYS 2000 Claims Download File D3ZMCD *CHAR 4XSD3WKP2 Limit RISYS 2000 Claims Pipe Delimited

FTP FileD3FIELD *CHAR 1400

ZZDRREP Database Reconciliation Results DRERCN Error Count *PACKED 10 (0 d.p.)ZZDRREP Database Reconciliation Results DRERFG SQL Syntax Error Flg *CHAR 1ZZDRREP Database Reconciliation Results DRTSNM Test Name *CHAR 50ZZDTREP Database Reconciliation Tests DTSQL1 SQL 1 *CHAR 250ZZDTREP Database Reconciliation Tests DTSQL2 SQL 2 *CHAR 250ZZDTREP Database Reconciliation Tests DTSQL3 SQL 3 *CHAR 250ZZDTREP Database Reconciliation Tests DTSQL4 SQL 4 *CHAR 250ZZDTREP Database Reconciliation Tests DTSQL5 SQL 5 *CHAR 250ZZDTREP Database Reconciliation Tests DTTSDS Test Description *CHAR 250ZZDTREP Database Reconciliation Tests DTTSNM Test Name *CHAR 50

Changed Fields

File File Description Field Field Description Type LengthUSCIP0P5 P4: USCIP0P5 (*NONE) P4TYAY R/I TYPES ARRAY *CHAR 99USCIP0P5 P4: USCIP0P5 (*NONE) P4SQAY OUT POLICY SEQS ARRAY *CHAR 198USCIP0P5 P4: USCIP0P5 (*NONE) P4UYAY OUT U/W YEARS ARRAY *CHAR 198USCIP0P5 P4: USCIP0P5 (*NONE) P4UGAY UNDERWRITING TYPE ARRAY *CHAR 99USCIP0P5 P4: USCIP0P5 (*NONE) P4UTAY RESERVE TRACKING ARRAY *CHAR 99USCIP0P5 P4: USCIP0P5 (*NONE) P4LEAY LEDGERS ARRAY *CHAR 100USCIP0P8 PJ: USCIP0P8 Amounts PJRIQY NUMBER OF R/Is ATTACHED *PACKED 2 (0 d.p.)USCIP0P8 PJ: USCIP0P8 Amounts PJUTAY RESERVE TRACKING ARRAY *CHAR 99USCIP0P8 PJ: USCIP0P8 Amounts PJTYAY R/I TYPES ARRAY *CHAR 99USCIP0P8 PJ: USCIP0P8 Amounts PJSQAY OUT POLICY SEQS ARRAY *CHAR 198USCIP0P8 PJ: USCIP0P8 Amounts PJUYAY OUT U/W YEARS ARRAY *CHAR 198USCIP0P8 PJ: USCIP0P8 Amounts PJUGAY UNDERWRITING TYPE ARRAY *CHAR 99USCIP0P8 PJ: USCIP0P8 Amounts PJLEAY LEDGERS ARRAY *CHAR 100USCIWAP5 WA: USCIWAP5 (*NONE) WATYAY R/I TYPES ARRAY *CHAR 99USCIWAP5 WA: USCIWAP5 (*NONE) WASQAY OUT POLICY SEQS ARRAY *CHAR 198USCIWAP5 WA: USCIWAP5 (*NONE) WAUYAY OUT U/W YEARS ARRAY *CHAR 198USCIWAP5 WA: USCIWAP5 (*NONE) WAUGAY UNDERWRITING TYPE ARRAY *CHAR 99USCIWAP5 WA: USCIWAP5 (*NONE) WAUTAY RESERVE TRACKING ARRAY *CHAR 99USCIWAP5 WA: USCIWAP5 (*NONE) WALEAY LEDGERS ARRAY *CHAR 100USCIWAP8 WA: USCIWAP8 Amounts work fields WARIQY NUMBER OF R/Is ATTACHED *PACKED 2 (0 d.p.)



File File Description Field Field Description Type LengthUSCIWAP8 WA: USCIWAP8 Amounts work fields WAUTAY RESERVE TRACKING ARRAY *CHAR 99USCIWAP8 WA: USCIWAP8 Amounts work fields WATYAY R/I TYPES ARRAY *CHAR 99USCIWAP8 WA: USCIWAP8 Amounts work fields WASQAY OUT POLICY SEQS ARRAY *CHAR 198USCIWAP8 WA: USCIWAP8 Amounts work fields WAUYAY OUT U/W YEARS ARRAY *CHAR 198USCIWAP8 WA: USCIWAP8 Amounts work fields WAUGAY UNDERWRITING TYPE ARRAY *CHAR 99USCIWAP8 WA: USCIWAP8 Amounts work fields WALEAY LEDGERS ARRAY *CHAR 100UTD2F0P0 PSAC D02 Premium Signings - data

structureD2F007 152 CHAR FILLER *CHAR 152


D2F007 152 CHAR FILLER *CHAR 152

UTD2REP LIRMA D02 Premium Signings D2F007 152 CHAR FILLER *CHAR 152UTLRCPP Bureau Message Receipt Log File LRSEQN Log sequence splitter *PACKED 3 (0 d.p.)UTPSP0PP Parameter list for bureau closings edit PPTYAY R/I Types Array *CHAR 99UTPSP0PP Parameter list for bureau closings edit PPSQAY Out Policy Seqs Array *CHAR 198UTPSP0PP Parameter list for bureau closings edit PPUYAY Out U/W Years Array *CHAR 198UTPSP0PP Parameter list for bureau closings edit PPLEAY Out Ledgers Array *CHAR 100UTPSP0PP Parameter list for bureau closings edit PPUGAY R/I Underwriting Type Array *CHAR 99XSD1REP Limit Stats 2000 Download File D1STCD Statistical Code Length 22 *CHAR 22



17. SERVICE NOTIFICATIONS ADDRESSED

The Service Notifications addressed in this release can be found in the separate Release Note documentation ‘IRIS 9.15-ENH-Release Notes.01.doc’.



18. IR RELEASE NOTES

The Release notes can be found in a separate document called ‘IRIS 9.15-ENH-Release Notes.01.doc’.



19. FIX PROGRAMS

The following is a list of all fix programs included in version 9.15-ENH of IRIS that are run automatically as part of the upgrade. You do not need to do anything for those listed below; the detail is purely for your information.

Program TextFUTO6R00 Populate O6SMDT on UTO6REPFUTKBR00 Fix Member Response DateFUTKJR00 Populate KJSYN & KJSLNOFUKKMR03 Update EDID on UKKMREP with EDID from UPEDREPFUSSAR00 Fix Stats data formatting YYYYMMDD to CYYMMDDZZDYZZR0 DY: Data Population of UZDYREP Days In YearFUPINR01 Initialise UPINREP.INKHDZ & .INKHQT

The above programs have been written to deal with the following changes:

SN300060370/5537 Bureau Closings Settlement Dates

Fix program FUTO6R00 populates O6SMDT on UTO6REP from the settlement date on UTO1REP or the instalment due date on UTO6REP, depending on whether the closing is for an instalment or not.

The program is called as follows:CALL PGM(FUTO6R00)

300079270/5596 Member Response Date is incorrect

The Member Response Date on Bureau Claims was being translated incorrectly from the message, e.g. a date of 10/03/2005 was being translated as 10/03/1905.

The fix program has been created to correct any invalid Member Response Dates on the Bureau Claims log files.

This program is called as follows: CALL PGM(FUTKBR00)

SN:300083959/5623 Outstanding Qualifier reformat Problem

This SN includes some new fields on the Bureau SCM file UTKJREP. Fix program FUTKJR00 has therefore been written to set these new fields.

This program is called as follows:CALL PGM(FUTKJR00)

It can be re-run as it only changes UTKJREP records where the new fields have not already been populated.



SN 300091662/5658/#2544 Update Endorsement ID on Claim Master Records

This fix program corrects the situation where claims on UKKMREP have the incorrect Endorsement ID KMEDID.

The program can be run as follows:CALL PGM(FUKKMR03)

This program can be rerun.

SN:300098153/5700 vrPSDT is not in correct format

The Settlement Date (vrPSDT) and Planned Settlement Date (vrSDDT) from the Lloyd's Underwriter Signing Message (USM) were being held on the relevant files incorrectly in 8 digit CCYYMMDD format, whereas the correct format for storing dates on IRIS files is 7 digit CYYMMDD (where C is a century indicator - 0 for 1900 years and 1 for 2000 years). This had the effect that these dates were being displayed incorrectly on screen.

The fix program will correct any existing invalid dates on the relevant files.

To run this fix program, enter the following on a command line:CALL PGM(FUSSAR00)

This program can be re-run as it does not change any dates which are already in the correct format.

SN 300092686/5678 Data Population of UZDYREP Days In Year

The data population CLP will require running when this enhancement is delivered. This will accept From Year & To Year parameters. For these years, inclusive, the UZDYREP file will be populated with the number of days in the year. Existing data will be overwritten. It is recommended that these parameters are From 1900 To 2100.

The program is called (for the above year range) as follows:

CALL ZZDYXZC0 PARM(X'01900F' X'02100F')

It can be rerun as any existing data is overwritten.

This program was created in 8.14-PTF-010 and to cater for the possibility that it may have therefore already been run for a non-default range of dates it is only run automatically if there are currently no records in the file.

If you think it may be necessary to re-run it anyway then it may be run manually. See manual fix programs below for further details.



SN:300095692/5681 UPINREP Last Change Time

Previously, errors were occurring when attempting to update Credit Control information (from the instalment enquiry) if the policy had been opened/edited/saved/re-opened.

A new fix program has been created which is called FUPINR01. It is responsible for initialising the newly added last change date and time on UPINREP to the entry date and time where applicable. There are no entry parameters.

This program can be called from a command line as follows:

CALL PGM(FUPINR01)




The following fix programs are not run automatically, and the decision whether to run them or not is dependent on the circumstances of the client.

Note that to run these programs, you will have to add your data library (e.g. XUNMDTA) and the newly delivered system library (XUNMSYSnnn) into your library list.

Program TextFUTHCR00 Fix UTHCREP & UTSTREP-Mark as reconciled where rqdFUPEDR02 Endorsement Log File - Populate EDSSFUCZMR00 Syndicate File PopulationFUKKMR01 Fix UKKMREP.KMF1CDUXURXZC0 Populate Used & Unused References and Ref. RangesFUSTIR01 Populate new Taxation Log fieldsFXEXBZR0 Transfer Closings Extension Data for LloydsZZDYZZR0 DY: Data Population of UZDYREP Days In YearUKORBZR0 OCR Summary RebuildFUXURR00 Populate UXURREP with used INCAS Audit Numbers

It is also recommended that the Movement and History rebuilds are both run.

SN:300050588/5556 Auto-allocate doesn't match items

The fix program FUTHCR00 was created to fix UTHCREP (Bureau Settlement Details) & UTSTREP (Bureau Settlement Status). The fix is required if GUI Manual Allocations is used, since this function was missing some processing to update the files. The fix marks Bureau generated cash as reconciled if it has been fully allocated.

To run the fix, enter the command 'CALL PGM(FUTHCR00)'

This program was previously included in 8.14-PTF-001 and so it may not be necessary to run it if it has already been run as a result of upgrading to 8.14-PTF-001.

SN 300077259/5619 Populate EDSS for endorsements

GUI Policy Enquiries at Great Lakes were showing all endorsements when the Latest Endorsement Only check box was ticked. This was due to a conversion issue where the field Endorsement Status (EDEDSS) on the Endorsement File (UPEDREP) was not set to 'E' when a policy had been endorsed. Only the latest record should have a blank Endorsement Status. A fix program is provided to update the Endorsement Status for all policies on the Endorsement file from the Endorsement Status on the Policy file.

This program can be run as follows:CALL PGM(FUPEDR02)

This program can be run at any client site, i.e. it is not restricted to Great Lakes, and it can be re-run.



This program was introduced in 8.14-PTF-003 and so it may not be necessary to run it if it has already been run as a result of upgrading to 8.14-PTF-003.

SN 300056527/5638/#1970 Enh: Syndicate Group Month End Dates

If Syndicate Group Month End Date processing is to be used, the fix program FUCZMR00 should be run to populate the new Syndicates file, UCZMREP. For each unique syndicate on UCZLREP, a record will be written to UCZMREP (as long as the syndicate does not already exist) as follows:ZMZMCD - populated with ZLZMCDZMZMDS - populated with ZLZMDSZMZMSD - populated with ZLZMDSZMZHCD - blankZMRCFD - blank

Note that ZMZHCD will subsequently require manual population by the user.

The program can be run as follows:CALL PGM(FUCZMR00)

This program was introduced in 8.14-PTF-005 and so it may not be necessary to run it if it has already been run as a result of upgrading to 8.14-PTF-005.

SN 300091660/5659/#2690 FIL Code Overwritten By SCM Load

This fix program populates the FIL code 1 (KMF1CD) on the claims master file UKKMREP for SCM claims from the latest value advised for the FIL code (FFL) from the bureau.

This program is only relevant for SCM claims and does not need to be run by any user that does not receive such claims. It will only update Lloyd’s claims and only if the latest FIL code from the SCM is not blank.The program can be run as follows:CALL PGM(FUKKMR01)


This program was last updated in 8.14-PTF-005 and so it may not be necessary to run it if it has already been run as a result of upgrading to 8.14-PTF-005.

SN 300062178/5576 - 707-Policy Number Generation

This enhancement was designed to modify the policy number generation so that if a number is left unused it can automatically be reused by the system.



Similarly for quote number generation.

Also controls put in place to enable or disable individual user’s access to Auto-Generation of Policy numbers.

The fix program will populate the additional files created to support this enhancement to policy number generation. It must be run twice: once to populate the files with data for policy number generation; and once to populate the files with data for Quote/Promise number generation. It can additionally be run in report mode, to populate work files rather than permanent files, allowing the user to check the results before committing them to the database.

The fix program has two parameters:

Parameter 1: ModeY - write to the permanent filesN - write the data to temporary work files

Parameter 2: Generation MethodPolicyRefPONOCS - Policy numbers are treated as one rangePolicyRefPONOCO - Policy number ranges by companyPolicyRefPONOCD - Policy number ranges by company and inwards/outwardsPolicyRefPONOCF - Policy number ranges by COCD/IWFG/UGTYPolicyRefPONOBF - Policy number ranges by COCD/BHCD/IWFG/UGTYQPMRefPONOOU - Quote/Promise range

CALL PGM(UXURXZC0) PARM(‘Mode’ ‘Gen-Method’)

This program can be rerun. It will add records, but will not change records which have already been created.

This program must be run manually, using generation methods appropriate for the customer, when this enhancement is installed.

This program is new in 9.15-ENH.

SN:300067243/5622 IPT & Foreign Taxation

FUSTIR01 allows the population of new fields on USTIREP: TITXPC, TIWHIN, TIRCIN, TITXCY and TIAMCD.

This program has to be run manually as it has a screen that allows the user to specify which country code to use as the Tax Country of Origin in TITXCY above.

This program can be called from a command line on the AS/400 as follows:CALL PGM(FUSTIR01)



The easiest way to decide whether this needs to be run is to look at the revenue code set up and see if there are any revenue codes set up with an old array name of IPT. If there are then see if this revenue code has ever been used on any closings (on S3, C3 or F3).


SN:300067241/5667 0504-View All Lloyds Prm/Clm Info

When the IRIS system was enhanced to handle Lloyd’s syndicate data, not all of the new data could be mapped directly to existing fields on the IRIS statistics and claims files, so some of it was written to statistics and claims extension files. The only way that the data in these extension files could be viewed was by using third party tools such as AS/400 Query.

As a result of this enhancement, the data held in these extension files is now held on the main IRIS files and the data is now viewable within the IRIS system by means of existing enquiries.

A one off data transfer program must be run on the iSeries to populate historic Lloyds data on to the main closing files. The program can be run by issuing the following command:

CALL FXEXBZR0

It should only ever be run once. This is because it writes new records to UTONREP, USCNREP and USSNREP based on the existing UTOCREP, USCCREP and USSCREP.

This program populates Lloyd's data but there is no reason why it can't be run for all users and in all situations.


SN 300092686/5678 Data Population of UZDYREP Days In Year

This program is run automatically in this PTF with the recommended year range as described above. However, if a different year range is required then the program can simply be rerun manually with the desired range specified.

See above for details of how to run the program.

This program was created in 8.14-PTF-010 so it may not be desirable to run it again if it has already been run as a result of upgrading to 8.14-PTF-010.

SN:300079753/5605 OSPHIO incorrectly populated andSN:300097826/5692 - Broker Code on UKOSREP not populated

Under some circumstances the outwards policy header key OSPHIO on the OCR file was being populated even if there was no outwards policy on the OCR.



Also the OCR Summary Rebuild itself was not populating the Long Broker Code OSLBRC.

These can both be corrected by running the OCR Summary Rebuild function from the REBUILD menu as part of this upgrade.

It would be recommended to run this at any site where OCRs are processed for outwards policies.

SN:300100419/5706 Allocation issue - duplicate audit no

Fix program FUXURR00 has been created to populate UXURREP with all usedINCAS audit numbers on the system.

Prior to running the program all entered Cash and Journals must be posted to the ledger.

The fix program can be called from a command line as follows:CALL PGM(FUXURR00)



20. APPENDIX

Library Naming Convention

The following explanation provides details of the standard IRIS naming conventions. Variation does occur owing to clients’ requirements. There may be more than one ‘live’ environment for example

The naming convention is based on the MODE parameter of the conversion. The options available for MODE are TST, TRN and LVE.

All library names can be broken down into 3 distinct parts; the prefix, the middle and the extension.

The IRIS module being converted determines the library prefix. The prefixes are:

XUNM for IRIS,

XXOS for statements

The type of library and the environment determines the middle part of the library name

For the program source libraries the middle three letters are for example:

SRC equates to the ‘Live’ environment source

For data libraries:

DTA equates to the ‘Live’ environment data

For the system library the middle three letters are

SYS equates to the ‘Live’ environment

In all instances the last letter of the three indicates the environment:

T equates to the ‘Test’ environment

R equates to the ‘Training’ environment

Please note that ‘Test‘ and ‘Training’ environments are optional and may not exist on your AS/400.

A slightly different convention follows for a journal library. The middle 3 characters are:

AJN If it is for the live environment LVE.

AJT If the mode is TST

AJR If it is TRN

Note that if you rename a data library after the conversion, then certain data areas require resetting to reflect the new library name. See the data area manual for further details



21. SUPPLEMENT

Progress Flow Sheets Four Copies of the Progress Flow sheets are enclosed.



Progress Flow SheetIRIS Version 9.15-ENH Upgrade Installation

General Information

Section 6.2.1 - Environment (e.g. LVE, TST, TRN) -----------

IRIS (General Information)

IRIS Data Library -------------------

IRIS System Library -------------------

IRIS Source Library -------------------

Statements Module

Statements Data Library --------------------

Statements System Library --------------------

Statements Source Library --------------------

____________________________________________________________________________________________________________________________________________________



Installation Steps

SectionDate

Completed

6.3 Pre-Installation Procedures6.3.1 Integrity Checks --------------

6.3.2 IRIS Preparation --------------

6.3.3 IRIS System Back-up --------------

6.4 Installation Procedures6.4.1 System Preparation --------------

6.4.2 Restore XUNMTOOLS from tape --------------

6.5 Applying the Installation --------------

6.6 Installation Steps

Set Parameters / Data Areas --------------

Restore Upgrade Libraries --------------

End Journalling on Data Libraries --------------

Re-size Upgrade Libraries --------------

Upgrade Data Libraries --------------

Run Fix Programs --------------

Restart Journalling --------------

Update Bureau Message Severities --------------

Print Update Messages --------------

7. System Library Changes --------------

8. APD Menu System --------------

9. User Defined Queries --------------

10. Post Upgrade Procedures --------------

11 Data Areas --------------

Notes / Comments




General Information






Statements Module




____________________________________________________________________________________________________________________________________________________



Installation Steps

SectionDate

Completed


















8. APD Menu System --------------



11 Data Areas --------------

Notes / Comments




General Information






Statements Module




____________________________________________________________________________________________________________________________________________________



Installation Steps

SectionDate

Completed


















8. APD Menu System --------------



11 Data Areas --------------

Notes / Comments




General Information






Statements Module




____________________________________________________________________________________________________________________________________________________



Installation Steps

SectionDate

Completed

















8. APD Menu System --------------



11 Data Areas --------------

Notes / Comments
