ensign - click for Home Page European Operations
Print this page
 
QBE Group Australia Pacific Asia Central Europe the Americas Europe
 :: Ensign Home:: About Us:: Wordings:: Contacts:: Financials:: LinksThu 20 Nov 2008  
 
 Motor Ins Database
:: Introduction
 
:: Help Desk
 
:: Background
 
:: Errors
 
:: User Guide
 
:: FAQ
 
 
 
 :: Introduction « BACK 
 
Contents
Logging on to the web site
About your Login details
Uploading via the web site (Interactive)
Uploading via Standard Template Spreadsheet
Keeping the schedule up to date
Troubleshooting vehicle uploads
 
 Logging on to the web site   Top of page  

To log onto the Motor Insurance Database (MID)
visit www.midupdate.com

Click the Policyholder button to bring up the logon box.

User ID
In the first box put 036 and in the second box put your 'EN' number, eg. EN100000

Password
Initially, this is set to "ensign"


Pass Phrase
Enter the required characters from your chosen pass phrase.  In the example here, if the pass phrase is vehicle, you would enter "e" in the first box and "c" in the second box.
 
  When you have entered all your logon details, click submit to take you to the ‘Change Password screen’
  Enter ensign in the current password box. Create a new password and confirm it, then click submit
  The next screen asks for the validation code (see notes below)
 
 
 About your login details   Top of page  

The Ensign Helpdesk will issue you with your logon details. 
If you have not received these, please contact the team on 0800 389 2674.

User ID  - This is in two parts (not case-sensitive).
 
  The first three digits are the Insurer ID.  Ensign’s ID is 036.  So the first part of everyone’s ID is 036.
  The second part is your unique ID number and will begin with EN followed by six digits.
 
Password - (not case-sensitive)
 
  Your very first password is set to "ensign". You will be asked to change this as soon as you log in.
  Passwords expire every 30 days and you must not re-use old passwords.
 
Pass Phrase - (not case-sensitive)
 
  You choose the pass phrase and it will always stay the same.
 
Validation Code - (This is case-sensitive)
 
  Your validation code will arrive as an attachment to an e-mail from MID CONTROL.
  You only need the validation code the first time you log in.
 
 
 Uploading via the web site (Interactive)   Top of page  

This is the simplest method of supplying your vehicle data.  It is recommended for small fleets of around 30 or less, or if you seldom make changes to the fleet.
 
  Once you have logged on (described above), you will be taken to the policy screen.
  Just click the ‘Add Vehicle’ button and complete the on-line form.
  By law, you must supply the following as a minimum requirement: 
1) Vehicle on date The first day the vehicle comes on cover in the current policy year.
2) Vehicle off date The last day the vehicle is on cover or the renewal date – which ever is the sooner
3) VRM (Vehicle Registration Mark)  Enter the Vehicle Registration Number – do not leave spaces
 
Note: There is space to provide additional data such as Make, Model, Derivative (vehicle trim) but these are not mandatory.  However it is preferable to include this information in case the legislation calls for it in the future.  Providing as much information as possible also eases the process of checking data.
 
 Uploading via Standard Template Spreadsheet   Top of page  

This method is best if you have a large fleet and / or make a large number of changes.  It involves completing a spreadsheet, saving it as a csv (Comma Separated Variable) file and uploading it to the MID website.

If you want to make minor additions or changes to the schedule at a later date, it is possible to do this via the web site – you do not need to send another csv file.

You can download an Excel version of the Standard template from this site.  Save the file to your local drive.

Columns with blue backgrounds are mandatory and are formatted as follows:

Record type
Always set to ‘V’ for vehicle records 

Update Type
Either ‘N’ for New record, ‘A’ for amend, ‘D’ for Delete or ‘O’ Delete.
The initial upload will require all records to be set to ‘N’.

Insurer ID
For Ensign this is 036

Policy Number
Do not include the ‘FP/’ or ‘FC/’ prefix – just put in the number and the final letter e.g. 0601811B.
If your policy number has a unique identifier added to it, include that as well e.g. 0601122B/23.

Foreign Registration
Set the indicator to ‘U’

VRM (Vehicle Registration Mark)
Enter the Vehicle Registration Number – do not leave spaces.

Trade Plate Indicator
Set the indicator to ‘U’

Vehicle on date
The first day the vehicle comes on cover in the current policy year**

Vehicle off date
The last day the vehicle is on cover or the renewal date – which ever is the sooner**

**All dates should be in the format: dd/mm/yyyy eg. 04/06/2003.  The spreadsheet will re-format the dates itself.  Users should allow the spreadsheet to do this and not attempt to tamper with the formatting.

The upload will fail if the dates fall outside the current policy period.  You can check the current policy dates by searching for that policy on the MID.

When you have completed all the fields, click the ‘save’ button in column A.  This ensures that the file is saved with a csv extension – the correct format for uploading.

To upload the file, logon to the MID website and click on the ‘Attended File Transfer’ button at the bottom of the policy page.

From the dialogue box, make sure that the Standard option is checked and then browse to search for your saved file.

You will receive a results file by e-mail from MID CONTROL.  Open the spreadsheet attachment to view the result of the upload.  If there are errors with any of the submissions, compare the code in the final column with the error list here to determine what the problem is.
 
 Keeping the schedule up to date   Top of page  

Once you have populated the MID with the initial schedule, you will need to keep the data up to date.  That means that every time a vehicle is taken on or off cover, you need to log in and make that alteration.  Changes must be made within 14 calendar days of the change having taken place.

Policy Renewals
All vehicles on cover at the date of expiry will roll-over automatically to the subsequent cover dates.  It will still be possible to view the previous cover schedule, but you will not be permitted to amend the data.

Taking a vehicle off cover
If a vehicle comes off cover, simply find the record using the ‘Individual Vehicle Search’ and alter the ‘off’ date to reflect the change.  You do not need to delete the record.

Taking a vehicle off cover using the template
To take a vehicle off cover, submit an ‘O’ delete record with the original on and off dates.  Then submit a second record with the update type set to ‘N’ with the revised on and off dates.

Temporary Vehicles
Any temporary vehicles held under the policies for 14 days or less do not need to be advised to the MID.  If a vehicle is on cover for more than 14 days, the vehicle must be input on to the MID Website.

Deleting a Record
The only instance where you need to delete a record is if the details have been inputted incorrectly.  To delete the record, change the ‘off’ date to match the ‘on’ date.  Confirm the deletion in the pop-up box.

 
 Troubleshooting vehicle uploads   Top of page  

There are a number of resources available to assist you with any problems you have either connecting to the MID or uploading your vehicle schedule:

Frequently Asked Questions
You can view answers to commonly asked questions on our FAQ page.

Ensign Helpdesk
Visit our Helpdesk page to find out how to contact our MID Helpdesk.

MID Help file
View the Help file from the menu bar on the MID website.

MIIC
Visit the Motor Insurance Database website to find out about both general and technical information regarding the legislation and your options for complying with it.

 
 
 



 
 
Privacy Legal Home Print   © 2008 QBE Insurance Group Limited  
 
 
Log