|
Introduction
Logging on to the web site
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 "QBEMID"
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 QBEMID 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
The QBE MID 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. QBE'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 "QBEMID". 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)
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
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 QBE 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
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
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.
QBE MID 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.
|
