Difference between revisions of "Adding DVLA Lookup to your Questions and Rating"

From SchemeServe Help
Jump to: navigation, search
m (Protected "Adding DVLA Lookup to your Questions and Rating": Excessive vandalism ([edit=sysop] (indefinite) [move=sysop] (indefinite)) [cascading])
Line 1: Line 1:
 
== Introduction ==
 
== 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.
+
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 your Questions ==
 
  
Seasoned SchemeServe users will be accustomed to building question sets.  If you are not familiar with this process, please see: [[Editing_Questions/Proposals|Editing Questions]].
+
== Including DVLA Lookup in Questions ==
  
From within Admin > Questions, Add a new Question with the Answer Type "DVLA Lookup".
 
  
[[image:AddingDVLALookup.png|thumb|Adding a DVLA Lookup question]]
+
#Follow the process for [[Adding or Editing Questions for a Scheme|creating questions in SchemeServe]]
 +
#Add a new question with the answer type; '''“DVLA Lookup”'''
 +
#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.)
 +
#Save your Changes
 +
#Publish your questions
  
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'.
+
You can see this process in the video tutorial below.
  
Now, Publish your questions to save your changes.
 
  
 +
== Rating based on Vehicle Data ==
  
== Rating based on vehicle data ==
 
  
There are the following system fields which may be addressed in your rating:
+
You can use the following system fields to refer to DVLA lookup:
  
 
* CarRegistrationMark_Registration
 
* CarRegistrationMark_Registration
Line 34: Line 33:
 
* CarRegistrationMark_NumberOfSeats
 
* 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 [[Editing_Rates|Rating with SchemeServe]].
+
'''Note:''' Don't forget if your SystemID is different to “CarRegistrationMark” you'll need to substitute it in these fields.
  
  
=== Example Rating Matrix ===
+
[[Editing_Rates|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...
 
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...
 +
  
 
<table style="border-collapse:collapse;" cellpadding="4" border=1>
 
<table style="border-collapse:collapse;" cellpadding="4" border=1>
Line 49: Line 51:
 
</table>
 
</table>
  
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.
+
'''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.
  
If you would like to create [[Editing_Rules|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.
+
== Video Tutorial ==
 
 
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:
 
 
 
<table style="border-collapse:collapse;" cellpadding="4" border=1>
 
<tr><td>1.</td><td>Answer:CarRegistrationMark_NumberOfSeats</td><td>SetCover:MyHiddenDVLASeats</td></tr>
 
<tr><td>2.</td><td>4</td><td>4</td></tr>
 
<tr><td>3.</td><td>5</td><td>5</td></tr>
 
</table>
 
  
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"
+
<html>
 +
<iframe width="640" height="360" src="http://www.youtube.com/embed/JMUeN-ej6gI" frameborder="0" allowfullscreen></iframe>
 +
</html>

Revision as of 09:11, 17 December 2012

Introduction

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


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.


Video Tutorial