Feature |
Source |
Comment |
acci_driverpointsnumbercountterm |
dim_driver |
Count accident driver
points in a current term |
acci_infractioncdcountterm |
dim_driver |
Count accident
infractions active in a current term |
acci_last_convictionage |
dim_driver |
Years since last accident conviction |
acci_last_infractionage |
dim_driver |
Years since last acciodent infraction |
acci_pointschargedterm |
dim_driver |
Count accident points charged in a current term |
accidentpreventioncourseind |
dim_driver |
|
carpoolind |
dim_driver |
|
driverage |
dim_driver |
|
drivernumber |
dim_driver |
|
driverstatuscd |
dim_driver |
|
drivertrainingind |
dim_driver |
|
gendercd |
dim_driver |
|
gooddriverind |
dim_driver |
|
havelicenseage |
dim_driver |
The age when the driver received his/her driver license based on
Driver License Date and Driver Birth Date in the data base |
licensedstateprovcd |
dim_driver |
|
maritalstatuscd |
dim_driver |
|
maturedriverind |
dim_driver |
|
mvrstatus |
dim_driver |
|
mvrstatusage |
dim_driver |
|
persontypecd |
dim_driver |
|
registrationstateprovcd |
dim_driver |
|
relationshiptoinsuredcd |
dim_driver |
|
scholasticdiscountind |
dim_driver |
|
viol_driverpointsnumbercountterm |
dim_driver |
Count violation driver
points in a current term |
viol_infractioncdcountterm |
dim_driver |
Count violation
infractions active in a current term |
viol_last_convictionage |
dim_driver |
Years since last violation conviction |
viol_last_infractionage |
dim_driver |
Years since last violation infraction |
viol_pointschargedterm |
dim_driver |
|
antitheftcd |
dim_vehicle |
|
classcd |
dim_vehicle |
Classification code combining licenge age, sex, marital status
or vehicle age and type. Looks like it is different in different states and
changed overtimes. |
daylightrunninglightsind |
dim_vehicle |
|
daysperweekdriven |
dim_vehicle |
|
enginecylinders |
dim_vehicle |
|
enginehorsepower |
dim_vehicle |
|
enginesize |
dim_vehicle |
|
estimatedannualdistance |
dim_vehicle |
|
garageterritory |
dim_vehicle |
|
manufacturer |
dim_vehicle |
The names are not standartized and inconsistant |
model |
dim_vehicle |
The names are not standartized and inconsistant |
occupationclasscd |
dim_vehicle |
|
odometerreading |
dim_vehicle |
|
passiveseatbeltind |
dim_vehicle |
|
performancecd |
dim_vehicle |
|
programtypecd |
dim_vehicle |
|
ratingvalue |
dim_vehicle |
ISO Rating Value. It's populated in ~75% of vehicles. It may be
populated in an other table column for the rest. Needs more investigation. |
restraintcd |
dim_vehicle |
|
vehbodytypecd |
dim_vehicle |
|
vehicleage |
dim_vehicle |
|
vehnumber |
dim_vehicle |
|
vehusecd |
dim_vehicle |
|
external_engine |
external |
|
external_height_in |
external |
|
external_length_in |
external |
|
external_make |
external |
|
external_model |
external |
|
external_vehicleage |
external |
|
external_width_in |
external |
|
modelscore |
external |
|
modelyr |
external |
|
|
|
|