Adding DVLA Lookup to your Questions and Rating

From SchemeServe Help
Jump to: navigation, search


For motor insurance it is usual to base the rating and underwriting of policies on the details of the vehicle being insured. For example, the size of the engine, or the number of seats in the vehicle, etc.

It may not always be possible to rely on the insured party to provide these details accurately. This is where the use of DVLA lookup comes in handy – you can determine the details of a vehicle from the registration number provided (e.g. the licence plate number).

Including DVLA Lookup in Questions

  1. Follow the process for creating questions in SchemeServe
  2. Add a new question with the answer type; “DVLA Lookup”
  3. Give your new question a System ID (Note: In our example we've used CarRegistrationMark throughout this section of the help guide. If you want to use a different SystemID for your question that's no problem but remember to change “CarRegistrationMark” to the SystemID of your question in all the rating fields shown below.)
  4. Save your Changes
  5. Publish your questions

You can see this process in the video tutorial below.

Rating based on Vehicle Data

You can use the following system fields to refer to DVLA lookup:

  • CarRegistrationMark_Registration
  • CarRegistrationMark_CleanRegistration
  • CarRegistrationMark_Make
  • CarRegistrationMark_Model
  • CarRegistrationMark_Year
  • CarRegistrationMark_EngineCC
  • CarRegistrationMark_NumberOfSeats

Note: Don't forget if your SystemID is different to “CarRegistrationMark” you'll need to substitute it in these fields.

You may use any of the fields above in your rating matrix as normal.

An Example Rating Matrix

An example rating matrix which modifies Policy Fee based on the number of seats in the vehicle, might look something like the following. In this example, the Policy Fee is £100 for a car with 4 seats and £150 for a car with 5 seats...


Note: the first column contains the line numbers in the CSV file and would be omitted in the real file: you don't need to create it.

Video Tutorial