PMD – User Acceptance testing
Contents
1. 01 Yersion1 kevin harker faraday com Received History View 0435 May 2008 01 Yersion1 kevin harker faraday com Received History View 0435 April 2008 01 version 1 kevin harker taraday com Received History View Printed 19 12 2008 Page 6 of 19 inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS The history function will be available from the home page of a return alongside a specific return The history of a return will show the date and time of each status change and the e mail address of the user who made the change This will include changes to status by Lloyd s users PMD HELP PERSONAL DETAILS LOGOU Performance Mangement Data Mn History 0435 August 2008 14 08 2008 11 34 N A Le 0435 August 2008 14 08 2008 11 33 N A V 0435 August 2008 14 08 2008 11 32 N A o Back The search facility available from the Home page will allow users to search by syndicate year month status and submission month The Submission field is included as search criteria Submission field is required to support the Submission month 18 requirement whereby December data is submitted in January and following July PMD Homepage Create New Return Syndicate Flease Select Reporting Year Please Select s Reporting Month Please Select y vl Status Please Select i Submission Please Select x It will be possible for an Editor to download a CSV template for the PMD return The2. be displayed in the Validation results page The user will be able to use the scroll bar to scroll up and down the page A totals banner will be displayed on the Status bar showing the total errors or warnings displayed on the page and total number of occurrences e g 500 of 1500 45 of 45 The user will be able to print the validation results A different Validation error or Warning message label will be displayed depending if validation result is an Error or Warning ET http InvdmfiissysO 1 CoreReturns General ValidationErrorsPrint aspx ReturnTI uml Ega File Edit view Favorites Tools Help a Validation Error Results The return has rejected data in the following location S in the CS file This screen displays up to 500 instances of the error occurring in the CS file Error Current Syndicate Risk ID gt should not be Blank Total Occurrences 1500 Form PMD 186 Print Close window Error occurs on lines nnnnn nnnnn nnnnnm rarer nnnmnrmin nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnrm nnnnrm nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnrm nnnnn nnnmnrm nnnnn nnnnn nnnnn nnnnn nnnnrmn nnnnrmn nnnnrmn nnnnmn nnnnn nnnnrmn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnrm nnnnrmn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn nnnnn Printed 19 1
3. ng 100 Gross Net Premium Written 1500 ap n Continue Summ Validation Summary Syndicate 0435 Return Type PMD Return Period July 2008 Printer Friendly Version Submission Status vvarnings Edition 1 Warnina Message Summarv The return has encountered warnings for the following fields but can still be submitted PMD 136 Warning lt Current 100 Gross Het Premium Written gt is greater than 500 000 467 PMD 137 Warning lt Change in Expiring 100 Gross Het Premium Written Due to Change in Deductible Attachment Point gt is less than 75 of the Expiring 100 Gross Net Premium Written 1500 Please confirm that you have reviewed the warning messages Confirm arnings Continue Printed 19 12 2008 Page 12 of 19 Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS Validation Summary Syndicate 0435 Return Type PMD Submission Status Validated Edition 1 The return has passed validation without errors or warnings and can be submitted Return Period July 2008 Printer Friendly Version Continue The Validation Results page will be displayed upon clicking the hyperlink of an error or warning on the Validation Summary page This page will display the first 500 instances of that error or warning and identify the location of each line in the CSV file The Total occurrences and the Form will
4. on the client desktop the Managing Agent can proceed to load a PMD file and run the validation On completion of the validation the results can be exported as a CSV file and analysed A User Manual will be available via CMR from January The system is a web based collection mechanism that will be used by Managing Agents to submit returns to Lloyd s Further details to follow via email in the New Year A username and password is required to logon to the system These are set when the user s profile is created by the administrator The password can be changed by the user at any time Upon logging onto the system access will be granted according to the role s that the user has been allocated Three failed logons for the same username will lock the account and resetting the password must be carried out by the Managing Agent Administrator or by the Lloyd s Market Returns helpdesk Printed 19 12 2008 Page 4 of 19 Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS After logon if the system is left inactive for more than 1 hour then the session will timeout and the user will need to log in again Managing Agents will be required to set up role profiles within Core Market Returns Login details during UAT are the same as within production Administrators will be required to add PMD return to User profiles For more information please refer to CMR manual Section 4 The following statuses will be available for the PMD R
5. should not appear Printed 19 12 2008 Page 11 of 19 Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS Page Failed a Validation Summary Syndicate 0435 Return Type PMD Return Period July 2008 Printer Friendly Version Submission Status Failed Edition 1 Error Message Summary The return has encountered errors in the data for the following fields You must correct this data before the return can be submitted The data has not been saved PMD 163 Format Error Currency Code gt should match the specified reference data 50 Error lt Bonuses and Rebates Gross of Reinsurance gt should be a valid decimal value 100 PMD 136 Error Current Syndicate Risk ID gt should not be Blank 1500 PMD 137 Format Error lt Single Risk Flag should be Y or HW 10 Error Distribution Channel should match the specified reference data 45 Error lt Method of Placement code gt should match the specified reference data 76 PMD 138 Format Error lt Expiring UMR gt should be in the specified format 200 Warning Message Summary The return has encountered warnings in the data for the following fields PMD 136 Warning lt Current 100 Gross Het Premium Written gt is greater than 500 000 367 PMD 187 Warnin than 75 of the Exp lt Change in Expiring 100 Gross Het Premium Written Due to Change in Deductible Attachment Point gt is less
6. submission is as at December month 12 or is the final December submission as at month 18 If a user selects Reporting Month December then the Submission field is enabled The ability to create a return for a previous calendar year will only be available for month December New Return Syndicate Please Select v Year of Account Month Submission Name optional To upload a completed ZIP file Browse Upload Extract reference data If you wish to extract reference data iher ues tha Oh Extract Reference Data Download CSV template If you wish to download the CSV Download CSV Template template then use the following Form 163 186 187 and 188 will need to be prepared as 4 separate CSV files and zipped into 1 file The forms cannot be manually edited using online screens The 4 CSV files will need to be submitted at the same time Each CSV file should have a header which identifies the return form version syndicate year and period the PMD return cannot be validated unless the 4 CSV files are uploaded Printed 19 12 2008 Page 8 of 19 Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS An email will be automatically sent to the Managing Agent User who has uploaded the file to indicate whether the validation has passed or failed e The following sections describe the layout of the email that is sent to the Managing Agent with notification of the validati
7. 2 2008 Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc Page 13 of 19 LLOYDS The Control page provides the Managing Agent user with access to key functionality to enable validation print lock sign off upload and submission of the PMD return The following features are new for PMD Submission field will display as a concatenated field in the return date field This is required to support the Submission month 18 requirement whereby December data is submitted in December and following July A new field Reason that will display any Reason comments captured in the Data Review process will be available Extract CSV function will not be available because of security implications Validation will automatically take place in the database The Control page cannot be accessed when a return has a status of Pending because the offline validation will not have been completed A new button View Validation will allow the user to view validation results This function will only be available when status is Validated Failed Warnings Locked Signed Off and Submitted View Validation button will be disabled when status is Pending This indicates that the database validation process is in place and the return is automatically in a system lock The ability to Print return or individual forms will be available for status of Warnings Validated Locked Signed Off and Submitted The Print return function and printing of indivi
8. LLOYDS PMD USER ACCEPTANCE TESTING Printed 19 12 2008 Page 1 of 19 Insentfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc 1 PURPOSE OF THIS DOCUMENT 2 INTRODUCTION 3 USER ACCEPTANCE TASKS 3 1 General Information 3 2 Offline Validator 3 3 CMR 3 3 1 How to get to the system 3 3 2 Logging on 3 3 8 Status Listing 3 3 4 PMD Home page 3 3 5 PMD History page 3 3 6 PMD Search 3 3 7 PMD Download CSV template 3 3 8 PMD Extract Reference data 3 3 9 Other 3 3 10 PMD New Return 3 3 11 File Submission 3 3 12 Validation Notification 3 3 13 Email 3 3 14 PMD Summary Validation page 3 3 14 1 Summary Validation Page Failed 3 3 14 2 Summary Validation Page Warnings 3 3 14 3 Summary Validation Page Validated 3 3 15 PMD Validation Results page 3 3 16 PMD Control Page 3 3 16 1 Control Page 3 3 16 2 Validation 3 3 16 3 Print Return 3 3 16 4 Upload 3 3 16 5 Lock 3 3 16 6 Sign Off 3 3 16 7 Submission 3 3 17 Print Return Page 3 3 17 1 PMD Print Return Page 3 3 17 2 PMD 163 Premium Summary 3 3 17 3 PMD 189a Return Totals 3 3 17 4 PMD 189b Premium Summary 3 3 17 5 PMD 189c Price Movement Summary 3 3 17 6 PMD 990 Syndicate Comments 3 3 17 7 Help 4 CONTACT DETAILS Printed 19 12 2008 Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS WUD c0 0 co N NONE PPP FoU UJ 2 2 l3 1 1 1 1 l1 l1 1 l1 l1 l1 l1 l1 l1 l1 l1 l1 la WAPMOONN O1 OYiUIL Ul Ul SF FRoEREE ERRUuunN wMc Page 2
9. Return Supplementary information Browse Upload View Add any return comments Add New Item There are no comments to display As per current CMR functionality a Help function is available from all menus The following features are new for PMD e CSV Field Names as per the PMD form can be entered for search purposes A Base Element definition will not be displayed as these are not used when preparing the PMD forms e Validation Rules will be available for download in a csv format e All validation rules will be displayed for all PMD forms as a default HELP Form Name n 63 Premium Volume Summary v Field Name Currency Code Validation Errors Only Fi Search Reset Download Validation Rules Form E ee showing page 1 of 1 1 163 Premium Volume Summary 10 Currency Code Error Currency code should match the specified reterence data 463 Premium Volume Summary 10 Currency Code Error A record should be submitted for each of CNY GBP USD showing page 1 of 1 1 Download Validation Rules Printed 19 12 2008 Page 18 of 19 Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS 4 CONTACT DETAILS Any queries regarding the completion of the PMD forms excluding IT issues should be directed to the PMD team at e Email Lloyds_PMD lloyds com e PMD helpdesk number 020 7327 5100 All queries will be r
10. bmit Submitting the return will result in notification to Lloyd s that the Submit the return has been submitted and will lock the return from further editina Print vvill navigate you to the Print Return page Print Return Remove Sign Off 47 3 3 1 Print Heturn Page 3 3 17 1 PMD Print Return Page e Print Return function will only be available after a successful validation e It will not be possible to print a return with status Failed or Pending e User has option to print individual forms that provide a playback summary of the data they have supplied for a return Form 189a 189b 189c LLOYDS System Test LNSD BIYS MENU HELP PERSONALDETAILS LOGOUT ADMIN PERFORMANCE MANAGEMENT DATA Syndicate 0435 Print Return Return September Date 2008 Download the free Adobe Acrobat Reader if you do not already have it from www adobe com Generate PDF C Print rounded thousands 010 Control P 163 Premium Summary 010 Control Page O 189a Return Totals 163 Premium Summary l 189b Premium Summary 189a Return Totals E 189c Price Movement 1696 Premium Summary O Summary 189c Price Movement Summary FI 990 Syndicate Comments 9930 Syndicate Comments al Sign Off E Generate PDF Printed 19 12 2008 Page 15 of 19 inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT_v0 5 doc LLOYDS This function provides the ability to print Form 163 Premium Summary in all three cur
11. dual forms will be disabled when status is Pending or Failed or while upload is in progress When a user selects to Upload Reload a ZIP file then a system lock will be applied while the file is being processed The status column in the PMD Homepage will display Pending to indicate that a reload is taking place This return status will remain unchanged until the validation has been completed As per current PIM a Lock status button will be available after a return has been validated and return status is Validated The Sign Off button will be available to Sign off users if the following conditions have been met 1 Return has passed validation 2 Return is in Locked status Printed 19 12 2008 Page 14 of 19 Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS 3 3 1 o As per current PIM a return can be submitted after it has been signed off An email is automatically sent to Lloyd s to inform them a return has been submitted Control Syndicate 0435 Faraday Return September 2008 Submission Field value Status Signed Off 18 12 2008 16 52 Edition o3 Name Contact Details Contact username Test User Contact name Contact telephone number Contact e mail address TestUsen Lloyds com Remove Sign Off Selecting Remove Sign Off will change its status back to open and allow further editing The return must then be validated and signed off before it can be submitted Su
12. emium Suma 187 Renewed 189a Return Totals Form 188 Not Renewed 188b Premium Summary 189c Price Movement Summary o Cour DT a CAE ET SL UMIUSD 01 7641 L 99N Svndirate Comments Printed 19 12 2008 Page 16 of 19 Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS This Form will auto summarise current syndicate premium collected in Form 186 and Form 187 and expiring syndicate premium in Form 188 as an aggregated total per COB for the month and as an YTD value The premium will be converted to CNV using the mandated exchange rate displayed in form 189a 189b Premium Summary Print Form Expiring Expiring Syndicate Syndicate Gross Gross Net Current Syndicate Gross Net Net Premium Current Syndicate Gross Net Premium Class of Business Premium Written Written Premium Written Written For the Month CNV YTD CNV New Renewed Not Renewed New Renewed Not Renewed 10 Liability 20 Cargo 30 Catastrophe 40 Airports 50 US Binders 60 International Binders This Form will auto summarise the rate movements collected in Form 187 for Renewed business only by COB for the month and YTD The premium will be converted to CNV using the mandated exchange rate displayed in form 189a LLL EEE 189c Price Movement Summary Print Form Price Movements For the Month CNV YTD CNV Change in Expiring Change in Change in Change in 100 Gross Expiring Change in Expiring 100 Change in C
13. esponded to by the end of the following working day Please contact Stuart Scott Stuart Scott lloyds com via e mail if a response remains outstanding at that time Any queries regarding IT issues including the upload of data files via the CMR website should be directed to the Information Technology Group at e Email ITGDataManagement lloyds com e ITG helpdesk number 020 7327 5252 All queries will be responded to by the end of the following working day Please contact Sarah Smith Sarah Smith lloyds com via email if a response remains outstanding at that time Any queries regarding Core Market Returns User set up password resets should be directed to the Market Returns Helpdesk Market Returns Helpdesk Tel 020 7327 5021 Email Lloyds market returns lloyds com Printed 19 12 2008 Page 19 of 19 Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc
14. eturn Pending a new status of Pending will appear while validation processing is taking place A return will not be displayed on the Home Page until the upload header check is completed and validation process is commenced Warnings a new status Warnings will display when a return is validated with warnings only and no error messages Validated a return is validated when it returns no error messages Failed a return is failed when it returns error messages Locked a return can only be locked after it has been validated Signed Off authorisation from a sign off user required prior to submission Submitted sends return through to Lloyd s for analysis Rejected a Lloyds Editor can reject a submitted return resubmission required Withdrawn a Managing Agent contacts Lloyds and requests a return to be withdrawn resubmission required Received indicates that a return has been checked by a Lloyds Editor and is received into the Data Warehouse for further data quality checks Superseded indicates that an edition of a Received or Accepted return has been replaced and superseded by another Received or Accepted return Accepted indicates that a return has been approved for data quality purposes Declined indicates that a received return has been declined for data quality purposes resubmission required Approved indicates that a return has been approved for Management Reporting pur
15. hange in Expiring Net 100 Change in Expiring Gross Net Expiring 100 Expiring 100 Premium Gross Net Expiring 100 Gross Premium Gross Net 100 Gross Gross Net Written Premium 100 Net Expiring Current Written Due to Premium Net Premium Ezpiring Current Due to Due to GrossNet Premium Syndicate Syndicate Change in Due to Premium Written Sgndicate Syndicate Changein Changein Premium Written Due Gross Net Gross Net Deductible Change in Due to Due to Gross Net Gross Net Deductible Breadth Due to to Pure Premium Premium Attachement Breadth of Other Pure Rate Premium Premium Attacheme of Cover Other Rate Class of Business Written Written Point x Cover x Factors X Change x Written Written nt Point x Factors Change x 60 150 160 180 190 200 210 150 160 180 190 200 210 10 Liability 20 Cargo 30 Catastrophe 40 Airports 50 US Binders 60 International Bing Printed 19 12 2008 Page 17 of 19 Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS 3 3 17 6 PMD 990 Syndicate Comments Form 990 is an existing form in CMR and provides functionality to enable the Managing Agent user Editor to attach supporting documents and comments to a return The following features are new for PMD e It will be possible to upload attachments or add comments when return status is Validated e If status is Locked or Signed Off then no changes can be made to upload documents or add comments 990 Syndicate Comments Save
16. layout of the CSV Template describes the data collection requirements for the PMD forms PMD 163 PMD 186 PMD 187 PMD 188 As per existing CMR returns all reference codes are available for download in a CSV format The additional codes required for the PMD return are Risk Exposure Location code Method of Placement code Distribution Channel code Original Currency Code Printed 19 12 2008 Page 7 of 19 Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS The following will all remain available from the return homepage as per the existing functionality FAQ s Archive Instructions Specifications The ability to create a New Return is accessed via New Return Homepage Only Editors are able to create and edit returns The following features are new for PMD User cannot Create New Return without uploading a ZIP file A zip file must contain 4 CSV files Form 163 186 187 188 When upload is clicked then a message will be displayed on the screen Upload in progress If upload fails then an error message Upload failed File s do not match specified format will be displayed to advise user that the upload has not completed Once upload has been completed then a message will display File Upload complete Validation stage now in progress Email notification will be sent on completion of validation stage Users can then exit CMR A new field Submission will allow the user to indicate if a December
17. of 19 LLOYDS 1 PURPOSE OF THIS DOCUMENT This document provides information about the Managing Agent User Acceptance Testing UAT Phase and has been developed to define the scope and deliverables of UAT for the Performance Management Data Project PMDP Abbreviations used in this document are UAT User Acceptance Testing MA Managing Agents CSV Comma Separated Value a common data file type CMR Core Market Returns 2 INTRODUCTION User Acceptance Testing UAT will be mandatory for all Managing Agents and will be available as follows e PMD offline validator from 05 01 09 CMR PMD file submission from 19 01 09 The UAT phase will allow Agents to resolve potential issues in relation to their data submissions prior to going live Minimum Requirements UAT will commence on 05 January 2009 when the full version of the offline validator tool will be made available The PMD return will be available via CMR from 19 January 2009 onwards All Managing Agents are required to submit a valid PMD return containing details of all risks incepting expiring during January 2009 by 28 February 2009 This document deals with the UAT requirements for the following key stages of the PMD Project Initial Set Up Data Collection Data Upload Data Validation File Submission Printed 19 12 2008 Page 3 of 19 Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS 3 USER ACCEPTANCE TASKS This section sets out the proce
18. on status Validated Status email The following email is sent when the return status is Validated From CoreReturns Sent DD Month YYYY HH MM To lt Managing Agent Contact gt Subject Validation Status 0435 PMD September 2008 VALIDATED Core Market Returns This is an auto generated email Please do not reply Return Type PMD Agent 1185A Syndicate 0435 Calendar Year 2008 Month September Edition No 2 Status VALIDATED Status Date DD MM YYYY HH MM PMD Validation Notification Please be aware that the files submitted for the PMD Return have validated successfully Action required You can now proceed to submit the return Printed 19 12 2008 Page 9 of 19 inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS Warnings Status email The following email is sent when the return status is Warnings From CoreReturns Sent DD Month YYYY HH MM To lt Managing Agent Contact gt Subject Validation Status 0435 PMD September 2008 WARNINGS Core Market Returns This is an auto generated email Please do not reply Return Type PMD Agent 1185A Syndicate 0435 Calendar Year 2008 Month September Edition No 2 Status WARNINGS Status Date DD MM YYYY HH MM PMD Validation Notification Please be aware that the files submitted for the PMD Return have passed validation but with warnings Action required Please confirm that y
19. ou have reviewed the warnings or upload a corrected return Failed Status email The following email is sent when the return status is Failed From CoreReturns Sent DD Month YYYY HH MM To lt Managing Agent Contact gt Subject Validation Status 0435 PMD September 2008 FAILED Core Market Returns This is an auto generated email Please do not reply Return Type PMD Agent 1185A Syndicate 0435 Calendar Year 2008 Month September Edition No 2 Status FAILED Status Date DD MM YYYY HH MM Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS PMD Validation Notification Please be aware that the files submitted for the PMD Return have not validated successfully Action required Please view the validation results and upload a corrected return The Summary Validation page will be displayed upon pressing the View Validation button on the Control page of the return The results will be grouped by unique instances of Validation Errors or Warnings and displayed as hyperlinked messages with a total count of the occurrences of the error or warning The errors and warnings are separated into the respective forms e g PMD 163 PMD 186 Validation errors include Format and Hard errors and would only appear after a failed data upload If format or hard errors exist then the user can click on the hyperlinked message and view the top 500 occurrences of the erro
20. poses Printed 19 12 2008 Page 5 of 19 Inscntfs02 fpdhome KirkpatM Desktop PMDP_MA UAT v0 5 doc LLOYDS A key change for the PMD return is that an Open status will not exist and the new status of Pending has been introduced The status of Pending indicates that a file has been uploaded and the validation process is running and has not completed the validation stage When a return has successfully uploaded the validation step is automatically performed At logon the following screen will be seen by Reviewer Editor and Signoff user types However only the Editor will be able to create or edit new returns The following features are new for PMD e When a return is created it will be mandatory to upload return files as forms are not editable on screen In order to minimise performance delays due to the larger volume of data collected in PMD validation will be automatically performed in the database A key difference between PMD and other CMR returns is that the open status will not exist Instead a new status of Pending will appear while the validation processing is taking place e When a return has a status of Validated this indicates that the validation has been successful and the return can be submitted It will be possible for an editor to view edit delete a Validated return e Anew status Failed has been introduced to indicate where the validation has been unsuccessful It will be possible for an editor
21. r Format errors will display first in the validation error list before any validation errors to allow the users to initially address any format and reference data related errors Warning messages would appear after a failed data upload or a successful upload If warning messages exist then the user can click on the hyperlinked message and view the top 500 occurrences of the error A different Warning message label will be displayed depending if the status is Failed Validated or Warnings A count of the total occurrences of the error or warning in a particular form will be displayed as text in brackets at the end of the validation message and will not be hyperlinked E g Format Error Single Risk flag should be Y or N 10 A Confirm Warnings button will be displayed in the validation summary page if the return has warnings and status is Warnings This function requires that the user clicks the button to indicate that the user has viewed the warnings on the screen When the Confirm Warnings button is clicked then the Warnings status is changed to Validated If the Confirm Warnings button is not clicked then the user cannot change status to Signed Off and proceed to submit the return If no errors or warnings exist then display will read Validation has passed without errors or warnings and the return can be submitted The return status is Validated and the error and warning headings
22. rencies CNV GBP USD The following features are new for PMD e Form 163 is non editable and will be automatically populated from the CSV file following a successful validation e The currency tabs displayed in existing PIM 163 will be removed Currency will be displayed on a single page in separate columns for CNV GBP USD e Save Recalculate and Reset form functions will not be available Syndicate 0435 163 Premium Summary co a ae Sanna ate 010 Control Page Form 163 Help Print Return Gross Premium Written 163 Premium Summary Bonuses and Rebates Gross of Reinsurance 189a Retur Totals Premiums Ceded to QQS Gross of Reinsurers Share of 189b Premium Summary Acquisition Costs Acquisition Costs Brokerage Commissions and Business Arrangement Fees 189c Price Movement Summary Inception Date Accounting Premiums Met of Acquisition Costs 990 Syndicate Comments Gross Net Premium Written This form will summarise the 3 forms 186 187 188 by Current Syndicate Premium in GBP USD and CNV It will also provide a count of the records supplied in the CSV files forms 186 187 188 The mandated conversion rate from USD to CNV GBP will always be displayed Syndicate 0435 Return August PrntF Date 2008 189a Return Totals int Form 010 Control Page Total no of Form rows Current Syndicate Premium 160 GBP n CNV Help Print Return Form 186 New MAGS Pr
23. ss needed to participate in the PMD User Acceptance Testing exercise e UAT will be available to Managing Agents from the 05 January 2009 onwards e The submission of PMD files to Lloyd s is mandatory for all Managing Agents during the UAT phase e Agents are expected to successfully submit a January submission by 28 02 09 e Agents can continue to submit at any time in the UAT window from January until the first live submission due 15 04 09 e Managing Agents will receive relevant support and feedback from both Lloyd s ITG and FPD throughout UAT An offline validation facility is available to the Managing Agents and can be downloaded to the users PC and installed locally as a standalone application This facility will allow Managing Agents to validate and edit CSV files locally before submitting a return via Core Market Returns The Offline Validator tool is a MS Windows application that is deployed using Microsoft Click Once technology It will enable Managing Agents to check the validity of the PMD files for forms 163 186 187 and 188 prior to submitting a PMD return to Lloyd s Managing Agent users will initially need to install the application and access the download Offline Validator link from the existing Core Market Returns web site Once logged into CMR the Offline Validator download link can be located on the CMR return homepage and the installation completed Once the application has been installed and saved to an appropriate location
24. to view edit delete a Failed return e Anew status Warnings has been introduced to indicate that the validation has passed with warnings and any warnings that exist should be confirmed before the return can be submitted It will be possible for an editor to view edit delete a Warnings return e Inthe case of a Reload the return status will change to Pending to indicate that the database process is running and the return has not completed the validation stage e When a return is Pending the view edit delete functions will be disabled e Submission field is included as search criteria The Submission field is required to support the Submission month 18 requirement whereby December data is submitted in January and following July e Copy return function will not be available for PMD return e Comparison report functionality will not be available for the PMD return PMD Homepage Create New Return Syndicate Please Select Reporting Year Please Select Reporting Month Please Select N Status Please Select Submission Please Select __ Search Reset showing page 1 of 4 123 4 Next gt Last gt 0435 August 2008 01 EB Test N A Pending History Views Edit Delete 0435 July 2008 o3 Locked Unlock History View Edit Delete 0435 July 2008 02 test NA Validated Unlock History View Edit Delete 0435 July 2008 01 Failed History View Edit Delete 0435 June 2008
Download Pdf Manuals
Related Search