Download ECF2: Claims Data Warehouse (CDW) User Guide

Contents
INTRODUCTION .................................................................................................................................. 5
1.
1.1.
1.2.
1.3.
1.4.
1.5.
1.6.
2.
Claims Data Warehouse (CDW) Product ...................................................................................... 5
Document Purpose ........................................................................................................................ 5
CDW Components ......................................................................................................................... 5
Report Coverage ........................................................................................................................... 7
Report Distribution ......................................................................................................................... 7
Ad Hoc Process for retrieval of previous versions ......................................................................... 7
COMPANIES VOLUMES – ECF WORKFLOW 001 REPORT ............................................................ 9
2.1.
2.2.
2.3.
2.4.
3.
Content .......................................................................................................................................... 9
Benefits ........................................................................................................................................ 10
Report Availability ........................................................................................................................ 10
Usage Notes ................................................................................................................................ 10
LLOYD’S VOLUMES – ECF WORKFLOW 002 REPORT................................................................. 11
3.1.
3.2.
3.3.
3.4.
4.
Content ........................................................................................................................................ 11
Benefits ........................................................................................................................................ 11
Report Availability ........................................................................................................................ 11
Usage Notes ................................................................................................................................ 12
LLOYD’S NON-ECF DETAILS – ECF WORKFLOW 003 REPORT .................................................. 13
4.1.
4.2.
4.3.
4.4.
5.
Content ........................................................................................................................................ 13
Benefits ........................................................................................................................................ 13
Report Availability ........................................................................................................................ 13
Usage Notes ................................................................................................................................ 13
INCOMPLETE TRANSACTIONS – ECF WORKFLOW 004 REPORT ............................................. 15
5.1.
5.2.
5.3.
5.4.
6.
Content ........................................................................................................................................ 15
Benefits ........................................................................................................................................ 15
Report Availability ........................................................................................................................ 15
Usage Notes ................................................................................................................................ 16
TRANSACTION CYCLE TIMES – ECF WORKFLOW 005 REPORT ............................................... 17
6.1.
6.2.
6.3.
6.4.
7.
Content ........................................................................................................................................ 17
Benefits ........................................................................................................................................ 18
Report Availability ........................................................................................................................ 18
Usage Notes ................................................................................................................................ 19
LLOYD’S CLAIMS REFERENCE AND FINANCIALS RECONCILIATION (LREC) ........................... 21
7.1.
7.2.
7.3.
8.
Content ........................................................................................................................................ 21
Benefits ........................................................................................................................................ 21
Report Availability ........................................................................................................................ 22
XCS ADDITIONAL DATA FOR LLOYDS (LADD) .............................................................................. 23
8.1.
Content ........................................................................................................................................ 23
© Xchanging 2012 – Confidential
Document uncontrolled once printed
Page 2 of 54