Adding DVLA Lookup to your Questions and Rating

From SchemeServe Help
Revision as of 06:12, 6 June 2011 by Arbishop (talk | contribs)
Jump to: navigation, search


For motor insurance it is common to base rating and underwriting rules to at least some extent on the details of the vehicle(s) being insured, e.g. size of engine, number of seats etc.

It is usually not practicable to ask for these details in full from the insured, which is where DVLA Lookup can be useful.

With DVLA Lookup, we can determine the full details of an insured vehicle from it's UK Registration Mark (i.e. number plate). The following article will show you how to do this and furthermore, to attach rating factors and referral rules to this information.

Including DVLA Lookup in your Questions

Seasoned SchemeServe users will be accustomed to building question sets. If you are not familiar with this process, please see: Editing Questions.

From within Admin > Questions, Add a new Question with the Answer Type "DVLA Lookup".

Adding a DVLA Lookup question

As normal, give your new question a sensible SystemID in order to make document construction and rating easier later, and enter the Text and Optional Description you'd like to use.

For the purposes of this example, we've used a SystemID for our question of 'CarRegistrationMark'.

Now, Publish your questions to save your changes.

Rating based on vehicle data

There are the following system fields which may be addressed in your rating:

  • CarRegistrationMark_Registration
  • CarRegistrationMark_CleanRegistration
  • CarRegistrationMark_Make
  • CarRegistrationMark_Model
  • CarRegistrationMark_Year
  • CarRegistrationMark_EngineCC
  • CarRegistrationMark_NumberOfSeats
NB: Field names are based on a DVLA Lookup question with the SystemID 'CarRegistrationMark'.  If your SystemID is different, the fieldnames above will change accordingly.

You may use any of the fields above in your rating matrix as normal. For more information on how to do this see the full article on Rating with SchemeServe.

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.

Rules & Referral Rules

At time of writing, the DVLA variables detailed above (see Rating) are not available directly in Admin > Rules Builder.

If you would like to create Referral or other Rules based on DVLA Lookup data, you will need to do the following:

Create a hidden field in your questions (see this article on how to do this: Creating hidden fields in your questions) for each of the DVLA Lookup fields you are interested in.

In your rating matrix, set the Cover value for each of the hidden questions to the system variable value returned by the DVLA Lookup, as per the following example:


After doing this, create referral or other rules in Admin > Rules Builder which use the new questions to trigger the rules. So, following on from my example above, I could have a rule which reads:

IF GetCover MyHiddenDVLASeats EQUAL TO 5    THEN CreateReferral "Too many seats"