Adding DVLA Lookup to your Questions and Rating

From SchemeServe Help
Revision as of 05:55, 6 June 2011 by Arbishop (talk | contribs) (Created page with "== Introduction == 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 eng...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Introduction

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...

1.Answer:CarRegistrationMark_NumberOfSeatsSetFee:PolicyFee
2.4100
3.5150

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).