Final Report Layout

Reports Layout Specification - Insurers - agreed v1_0.doc

Management Information Reporting - Insurer Report Layout Formats

Introduction

This document describes the file layouts for the Management Information Reports that Insurers will be receiving to monitor their supply of data to the Motor Insurance Database (MID).

The layouts for each report detail the exact positioning of each item in the report. All of the reports will be produced in CSV format, in one single file per insurer. The specifications for Reports 13 and 25 are still outstanding, and the file layouts for these will follow in due course.

The report heading forms the first 7 rows of each report, and will be of standard format as described below. This will allow the recipient to identify where a new report begins by a Split Identifier (detailing the Insurer & Site information) followed by a Report Identifier (the short reference code for the particular report).

Within each report the appearance of the following rows and columns are described in detail. In cases where a row number is unknown (may depend upon the number of data filled rows that precede it) that row number is referred to as “N”, and any subsequent rows as “N+1” etc.

ReportHeader

ReportIdentifiers

Report 1 – VehicleData Supply Report

Report 2 –Compare and Amend Non-Activity Report

Report 3 – Policyholder Data Supply Error Report

Report 4 – Audit Trail Report

Report 5(S) – Excessive Deletions Report - Summary

Report 5(D) – Excessive Deletions Report - Detailed

Report 16-17-18 – Default Non-Activity Reports

Report 19 – Specified Non-Activity Report

Report 20 –Audit Report For Policy Deletions

Report 29–Non-Activity After Inception Report

Report Heading

Backtotop

The information in the following table is common to all reports and so as to avoid duplication is only described in this section.

Row(s) / Column(s) / Description
1 / 1 /

Split Identifier (SPLIT=ABBBCCC)

A= I for insurer, D for DA.
BBB= Supplier Id
CCC= Site Number
2 / 1 /

Report ID[YUN1]

3 / 2 / “MOTOR INSURANCE DATABASE”
4 / 2 / Report Titleinupper case
5 / 1 / “RUN DATE:”
5 / 2 / Run date (dd/mm/ccyy)
6 / 1 / “RUN TIME:”
6 / 2 / Run Time (HH:MM)
7 / Blank Line

Report Identifiers

Backtotop

Report # / Report Name / Report ID
1 / “Vehicle Data Supply Report” / FR01VS2
2 / “non-activity report – compare & amend – less than x files sent”
{where x = passed parameter} / FR02NAC
3 / “Policyholder Data Supply Error type Report” / FR03PE2
4 / “Audit Report – vehicle data” / FR04VAM
5S / “Excessive Deletions – summary report (over 99.9%)” / FR05ED1
5D / “Excessive Deletions – Detailed Report” / FR05ED2
16 / “Non-Activity Report – small policies” / FR16NAS
17 / “Non-Activity Report – large policies” / FR17NAL
18 / “Non-Activity Report – trade policies” / FR18NAT
19 / “Non-Activity Report – Insurer Defined” / FR19NAI
20 / “AUDIT REPORT – POLICY DELETIONS” / FR20POD
29 / “NON-ACTIVITY AFTER INCEPTION/RENEWAL REPORT” / FR29NAC

Report 1

Back totop

Row(s) / Column(s) / Description
1 to 7 / Refer to Report Heading section
8 / 1 /

“FOR SUPPLIER:”

8 / 2 /

Supplier Identifier (A BBB CCC DDDD…)

A = Supplier Type
BBB = Supplier ID
CCC = Site Number
DDDD… = Site Name
9 / 1 /

“PERIOD FROM:”

9 / 2 /

From Date (dd/mm/ccyy)

10 / 1 /

“PERIOD TO:”

10 / 2 /

To Date (dd/mm/ccyy)

11 /

Blank Line

12 / 3 / Column Heading - ”Interactive”
12 / 4 / Column Heading – “File Transfer”
12 / 5 / Column Heading “Batch”
12 / 6 / Column Heading “Total”
13 / 2 / Row Descriptor – “New”
13 / 3 / Number of Interactive records for row descriptor
13 / 4 / Number of File Transfer records for row descriptor
13 / 5 / Number of Batch records for row descriptor
13 / 6 / Total number received for row descriptor
14 / 2 / Row Descriptor – “Amend”
14 / 3 to 6 / Refer to row 13, columns 3 through 6
15 / 2 / Row Descriptor – “D-Delete”
15 / 3 to 6 / Refer to row 13, columns 3 through 6
16 / 2 / Row Descriptor – “O-Delete”
16 / 3 to 6 / Refer to row 13, columns 3 through 6
17 / 2 / Row Descriptor – “Accepted”
17 / 3 to 6 / Refer to row 13, columns 3 through 6
18 / 2 / Row Descriptor – “Rejected”
18 / 3 to 6 / Refer to row 13, columns 3 through 6
19 / 2 / Row Descriptor – “Total Received”
19 / 3 to 6 / Refer to row 13, columns 3 through 6
20 / 2 / Row Descriptor – “% Rejected”
20 / 3 / Percentage of Interactive records for row descriptor
20 / 4 / Percentage of File Transfer records for row descriptor
20 / 5 / Percentage of Batch records for row descriptor
20 / 6 / Percentage of Total number received for row descriptor
21 / Blank Row
22 / 2 / Row Descriptor – “CDC For Non-new”
22 / 3 to 6 / Refer to row 13, columns 3 through 6
23 / 2 / Row Descriptor – “CDC Warnings for Non-new”
23 / 3 to 6 / Refer to row 13, columns 3 through 6
24 / 2 / Row Descriptor – “% Warnings”
24 / 3 to 6 / Refer to row 20, columns 3 through 6
25 / Blank Row
26 / 2 / Row Descriptor – “CDC Delayed”
26 / 3 to 6 / Refer to row 13, columns 3 through 6
27 / Blank Row
28 / 2 / Row Descriptor – “Delayed CDC Sent”
28 / 3 to 6 / Refer to row 13, columns 3 through 6
29 / 2 / Row Descriptor – “Delayed CDC Warnings”
29 / 3 to 6 / Refer to row 13, columns 3 through 6
30 / 2 / Row Descriptor – “% Warnings For Delayed ”
30 / 3 to 6 / Refer to row 20, columns 3 through 6

Report 2

Backtotop

Row(s) / Column(s) / Description
1 to 7 /

Refer to Report Heading section

8 / 1 /

“FOR SUPPLIER:”

8 / 2 /

Supplier Identifier (A BBB DDDD…)

A= I for insurer, D for DA.
BBB= Supplier Id
DDDD… = Site Name
9 / 1 /

“PERIOD FROM:”

9 / 2 /

From Date (dd/mm/ccyy)

10 / 1 /

“PERIOD TO:”

10 / 2 /

To Date (dd/mm/ccyy)

11 /

Blank Line

12 / 5 /

Column Heading – “Insurer”

12 / 6 /

Column Heading – “Last Compare/Amend”

12 / 7 /

Column Heading – “Number of”

13 / 2 /

Column Heading – “Insurer ID”

13 / 3 /

Column Heading – “Policy”

13 / 4 /

Column Heading – “Policyholder”

13 / 5 /

Column Heading – “Contact Details”

13 / 6 /

Column Heading – “File Received”

13 / 7 /

Column Heading – “Files Received”

14 onwards / 2 / Insurer ID (EEE)
14 onwards / 3 / Policy Number (FFFF….)
14 onwards / 4 / Policyholder Name (GGGG…)
14 onwards / 5 / DA Branch ID (HHHH)
14 onwards / 6 / Date Received (dd/mm/ccyy)
14 onwards / 7 / Number of Files Received

Report 3

Backto top

Row(s) / Column(s) / Description
1-7 / Refer to Report Heading section
8 / 1 /

“FOR SUPPLIER:”

8 / 2 /

Supplier Identifier (A BBB DDDD…)

A= I for insurer, D for DA.
BBB= Supplier Id
DDDD… = Site Name
9 / 1 /

“PERIOD FROM:”

9 / 2 /

From Date (dd/mm/ccyy)

10 / 1 /

“PERIOD TO:”

10 / 2 /

To Date (dd/mm/ccyy)

11 /

Blank Line

12 / 8 /

Column Heading – “Compare”

12 / 9 /

Column Heading – “Total”

12 / 10 /

Column Heading – “Total”

12 / 11 /

Column Heading – “Total”

13 / 2 /

Column Heading – “Insurer ID”

13 / 3 /

Column Heading – “DA ID”

13 / 4 /

Column Heading – “Policy”

13 / 5 /

Column Heading – “Policyholder”

13 / 6 /

Column Heading – “User”

13 / 7 /

Column Heading – “Contact”

13 / 8 /

Column Heading – “& Amend”

13 / 9 /

Column Heading – “Sent”

13 / 10 /

Column Heading – “Errs”

13 / 11 /

Column Heading – “Warn”

13 / 12 onwards /

Column Headings – “E001” onwards followed by “W001” onwards

14 onwards / 2 / Insurer ID (EEE)
14 onwards / 3 / DA ID (FFF)
14 onwards / 4 / Policy Number (GGGG…)
14 onwards / 5 / Policyholder Name (HHHH…)
14 onwards / 6 / User ID (IIII….)
14 onwards / 7 / DA Branch ID (JJJJ)
14 onwards / 8 / Compare & Amend indicator - “Y” or “N” (K)
14 onwards / 9 / Total number of vehicles sent
14 onwards / 10 / Total number of errors received (Exxx)
14 onwards / 11 / Total number of warnings received(Wxxx)
14 onwards / 12 onwards / Specific totals for each error and warning code

Report 4

Back to top

Row(s) / Column(s) /

Description

1-7 / Refer to Report Heading section
8 / 1 / “FOR INSURER:”
8 / 2 / Insurer Identifier (DDD EEEE…)
DDD = Insurer ID
EEEE… = Insurer Name
9 / 1 / “FOR DA:”
9 / 2 / DA Identifier (FFF GGGG…)
FFF = DA ID – Where applicable
GGGG… = DA Name – Where applicable
10 / 1 / “POLICY NUMBER:”
10 / 2 / Policy Number (HHHH…)
11 / 1 / “PERIOD FROM:”
11 / 2 / From Date (dd/mm/ccyy)
12 / 1 / “PERIOD TO:”
12 / 2 / To Date (dd/mm/ccyy)
13 / Blank Line
14 / 5 / Column Heading – “Date”
14 / 6 / Column Heading – “Record”
14 / 7 / Column Heading – “User”
15 / 2 / Column Heading – “VRM”
15 / 3 / Column Heading – “On Date”
15 / 4 / Column Heading – “Off Date”
15 / 5 / Column Heading – “Submitted”
15 / 6 / Column Heading – “Type”
15 / 7 / Column Heading – “Prefix”
15 / 8 / Column Heading – “User ID”
16 onwards / 2 / VRM (IIII…)
16 onwards / 3 / On Date (dd/mm/ccyy)
16 onwards / 4 / Off Date (dd/mm/ccyy)
16 onwards / 5 / Date Submitted (dd/mm/ccyy)
16 onwards / 6 / Record Type - “New” or “Amend” (JJJJ…)
16 onwards / 7 / User Prefix (KKKKKK)
16 onwards / 8 / User ID (LLLL…)
N / Blank Line – to make a clear distinction between the first part of the report and the second part.
N+1 / 2 / “DELETIONS”
N+2 / 10 / Column Heading – “Orig User”
N+2 / 11 / Column Heading – “Orig User”
N+3 onwards / 2 / Column Heading – “VRM”
N+3 onwards / 3 / Column Heading – “Type”
N+3 onwards / 4 / Column Heading – “Date Actioned”
N+3 / 5 / Column Heading – “Delete User ID”
N+3 onwards / 6 / Column Heading – “Record Deleted”
N+3 onwards / 7 / Column Heading – “On Date”
N+3 onwards / 8 / Column Heading – “Off Date”
N+3 onwards / 9 / Column Heading – “Orig Rec Submitted”
N+3 / 10 / Column Heading – “Insurer ID”
N+3 / 11 / Column Heading – “DA ID”
N+3 onwards / 12 / Column Heading – “Orig User ID”
N+4 onwards / 2 / VRM (IIII…)
N+4 onwards / 3 / Delete Type - “D”, “O” or “I” (M)
N+4 onwards / 4 / Date Actioned (dd/mm/ccyy)
N+4 / 5 / User ID (NNN)
N+4 onwards / 6 / Record Type Deleted - “New” or “Amend” (OOOO…)
N+4 onwards / 7 / On Date (dd/mm/ccyy)
N+4 onwards / 8 / Off Date (dd/mm/ccyy)
N+4 onwards / 9 / Date Submitted (dd/mm/ccyy)
N+4 onwards / 10 / Original Insurer ID (PPP)
PPP = Insurer ID of Original User ID
N+4 / 11 / Original DA ID (QQQ)
QQQ = DA ID of Original User ID
N+4 / 12 / Original User ID (RRRR…)
RRRR… = Original User ID

Report 5S – Summary Report

Back to top

Row(s) / Column(s) /

Description

Report 5D – Detailed Report

Row(s) / Column(s) /

Description

Reports 16-17-18

Row(s) / Column(s) /

Description

1-7 / Refer to Report Heading section
8 / 1 / “FOR INSURER:”
8 / 2 / Insurer ID & Name (DDD EEEE…)
DDD = Insurer ID
EEEE… = Insurer Name
9 / 1 / “FOR DA:”
9 / 2 / DA ID & Name where applicable (FFF GGGG…)
FFF = DA ID
GGGG… = DA Name
10 / 1 / “PERIOD FROM:”
10 / 2 / From Date (dd/mm/ccyy)
11 / 1 / “PERIOD TO:”
11 / 2 / To Date (dd/mm/ccyy)
12 / Blank Line
13 / 4 / Column Heading – “Vehicles”
13 / 5 / Column Heading – “Insurer”
13 / 6 / Column Heading – “Last”
14 / 2 / Column Heading – “Policy Number”
14 / 3 / Column Heading – “Policyholder”
14 / 4 / Column Heading – “Currently On Cover”
14 / 5 / Column Heading – “Contact Details”
14 / 6 / Column Heading – “Updated”
15 onwards / 2 / Policy Number (HHHH…)
15 onwards / 3 / Policyholder Name (IIII…)
15 onwards / 4 / Number of vehicles currently on cover
15 onwards / 5 / DA Branch ID (JJJJ)
15 onwards / 6 / Date of last update (dd/mm/ccyy)

Report 19

Row(s) / Column(s) /

Description

1-7 / Refer to Report Heading section
8 / 1 / “FOR SUPPLIER:”
8 / 2 / Supplier Identifier (A BBB DDDD…)
A = “I” or “D”
BBB = Insurer or DA ID
DDDD… = Insurer or DA Name
9 / 1 / “1 MONTH PERIOD:”
9 / 2 / (dd/mm/ccyy) “ TO ” (dd/mm/ccyy)
10 / 1 / “3 MONTH PERIOD:”
10 / 2 / (dd/mm/ccyy) “ TO ” (dd/mm/ccyy)
11 / 1 / “6 MONTH PERIOD:”
11 / 2 / (dd/mm/ccyy) “ TO ” (dd/mm/ccyy)
12 / Blank Line
13 / 8 / Column Heading – “Vehicles”
14 / 5 / Column Heading – “Inactivity”
14 / 6 / Column Heading – “Original”
14 / 8 / Column Heading – “Currently”
14 / 9 / Column Heading – “Insurer”
14 / 10 / Column Heading – “Last”
15 / 2 / Column Heading – “Insurer ID”
15 / 3 / Column Heading – “Policy Number”
15 / 4 / Column Heading – “Policyholder”
15 / 5 / Column Heading – “Period Flag”
15 / 6 / Column Heading – “Effective Date”
15 / 7 / Column Heading – “Load Date”
15 / 8 / Column Heading – “On Cover”
15 / 9 / Column Heading – “Contact Details”
15 / 10 / Column Heading – “Updated”
16 onwards / 2 / Insurer ID (EEE)
16 onwards / 3 / Policy Number (FFFF…)
16 onwards / 4 / Policyholder Name (GGGG…)
16 onwards / 5 / Inactivity Flag - “1”, “3” or “6” (H)
16 onwards / 6 / Original Date (dd/mm/ccyy)
16 onwards / 7 / Load Date (dd/mm/ccyy)
16 onwards / 8 / Number of vehicles on cover
16 onwards / 9 / DA Branch ID (IIII)
16 onwards / 10 / Last Updated Date (dd/mm/ccyy)

Report 20

Row(s) / Column(s) /

Description

1-7 / Refer to Report Heading section
8 / 1 / “FOR SUPPLIER:”
8 / 2 / Supplier Identifier (A BBB CCC DDDD…)
A = “I” or “D”
BBB = Insurer or DA ID
CCC = Site ID
DDDD… = Site Name
9 / 1 / “PERIOD FROM:”
9 / 2 / From Date (dd/mm/ccyy)
10 / 1 / “PERIOD TO:”
10 / 2 / To Date (dd/mm/ccyy)
11 / Blank Line
12 / 2 / Column Heading – “Insurer ID”
12 / 3 / Column Heading – “DA ID”
12 / 4 / Column Heading – “Policy Number”
12 / 5 / Column Heading – “Start Date”
12 / 6 / Column Heading – “Expiry Date”
12 / 7 / Column Heading – “Date of Deletion”
13 onwards / 2 / Insurer ID of policy (EEE)
13 onwards / 3 / DA ID of policy where applicable (FFF)
13 onwards / 4 / Policy Number that was deleted (GGGG…)
13 onwards / 5 / Start Date (dd/mm/ccyy)
13 onwards / 6 / Expiry Date (dd/mm/ccyy)
13 onwards / 7 / Date Of Deletion (dd/mm/ccyy)

Report 29

Back ToTop

Row(s) / Column(s) /

Description

1-7 / Refer to Report Heading section
8 / 1 / “FOR INSURER:”
8 / 2 / Insurer ID (DDD EEEE…)
D = Insurer ID
E = Insurer Name
9 / 1 / “FOR DA:”
9 / 2 / DA Identifier (FFF GGGG…) if applicable
F = DA ID
G = DA Name
10 / 1 / “PERIOD FROM:”
10 / 2 / From Date (dd/mm/ccyy)
11 / 1 / “PERIOD TO:”
11 / 2 / To Date (dd/mm/ccyy)
12 / Blank Line
13 / 4 / Column Heading – “Insurer”
13 / 5 / Column Heading – “Start”
13 / 6 / Column Heading – “Date Policy”
14 / 2 / Column Heading – “Policy”
14 / 3 / Column Heading – “Policyholder”
14 / 4 / Column Heading – “Contact Details”
14 / 5 / Column Heading – “Date”
14 / 6 / Column Heading – “Loaded”
15 onwards / 2 / Policy Number (HHHH…)
15 onwards / 3 / Policyholder Name (IIII…)
15 onwards / 4 / DA Branch ID (JJJJ)
15 onwards / 5 / Start Date of Policy (dd/mm/ccyy)
15 onwards / 6 / Date Policy Loaded (dd/mm/ccyy)

09/06/2003 10:41Page 1 of 15

[YUN1]1They all need to be listed so that the user knows what ID refers to what report – Experian will need to do this.