The Vehicles area enables you to enter information for vehicles that is used when issuing Vehicle Liability Cards.
To access this area:
To make the updating of multiple vehicles faster and easier, you can export vehicle data to an external Microsoft Excel or tab delimited text file, make updates to the information as necessary, and then import the updated information into the system.
If you have vehicle data saved in an external Excel or tab delimited text file, you can use the import feature to automatically create the vehicles in your system. The Import Vehicles feature must be enabled for your organization. Only XLS/XLSX file types are supported with the vehicle import.
The file must contain the following columns, in this exact order.
Column Name | Character Limit | Other Notes |
Vehicle Specific Fields | ||
AgencyID | 50 | The AgencyID field is not required if this represents a new
vehicle. When updating existing vehicles, the system first looks
at the AgencyID, then at the VIN. If a match cannot be found with
the AgencyID or the VIN, a new vehicle is added. You can determine a vehicle's AgencyID by looking at a vehicle export file. |
VIN | 25 | The VIN field is not required if this represents a new vehicle. When updating existing vehicles, the system first looks at the AgencyID, then at the VIN. If a match cannot be found with the AgencyID or the VIN, a new vehicle is added. |
Year | 4 | Required field. |
Make | 25 | Required field. |
Model | 25 | |
BodyType | 25 | |
PolicyNumb | 30 | |
VehicleNumb | 10 | |
AgencyVehNumb | 10 | |
PlateNumb | 10 | |
ID Issue State/Province | 2 | Required field. ID Issue State is supported by previous version of the import, and it can be used as an alternate Column Name for this field. |
Location | 20 | |
LocationName | 50 | |
Registration Fields | ||
RegistrationID1 | 10 | |
RegistrationFirstName1 | 20 | |
RegistrationMidName1 | 20 | |
RegistrationLastName1 | 50 | |
RegistrationSuffix1 | 4 | |
RegistrationID2 | 10 | |
RegistrationFirstName2 | 20 | |
RegistrationMidName2 | 20 | |
RegistrationLastName2 | 50 | |
RegistrationSuffix2 | 4 | |
RegistrationOrganization1 | 25 | |
RegistrationOrganization2 | 25 | |
RegistrationFEIN | 10 | |
RegistrationAddr1 | 50 | |
RegistrationAddr2 | 50 | |
RegistrationCity | 25 | |
Reg. State/Province | 2 | Reg. State is supported by previous versions of the import, and it can be used as an alternate Column Name for this field. |
Reg. Zip/Postal Code | 10 | Reg. Zip and RegistrationZip is supported by previous versions of the import, it can be used as an alternate Column Name for this field. |
Optional Coverages | (Policy number is required to import coverages.) | |
PIP | Personal Injury Protection | |
APIP | Additional Personal Injury Protection | |
PIP_AD | Personal Injury Protection Death | |
PIP_TD |
Personal Injury Protection Disability | |
CSL | Combined Single Limit Liability | |
PD | Property Damage | |
PD_DED | Property Damage Deductible | |
BI | Bodily Injury - Single Limit | |
BISPL |
Bodily Injury - Split Limit | |
ACVCD_OPTBI |
Optional Bodily Injury | |
MP | Medical Payments | |
COMP_DED |
Comprehensive Deductible | |
COLL |
Collision | |
OTC | Other than Collision | |
CMICS_FG |
Full Glass | |
ACV | Actual Cash Value | |
TL | Towing and Labor | |
RREIM | Rental Reimbursement | |
UMISP | Uninsured Motorist BI Single Limit | |
UMISG | Uninsured Motorist BI Split Limit | |
UMCSL | Uninsured Motorist Combined Single Limit | |
UMPD | Uninsured Motorist Property Damage | |
UMPD_DED |
Uninsured Motorist Property Damage Deductible | |
UNDSP | Underinsured Motorist BI Split Limit | |
UNDSG | Underinsured Motorist BI Single Limit | |
UNCSL | Underinsured Combined Single Limit Liability | |
UNDPD | Underinsured Motorist Property Damage | |
UNDPD_DED |
Underinsured Motorist Property Damage Deductible | |
NONOW | Y/N | NonOwned Autos |
HIRAU | Y/N | Hired Autos |
SCHAU | Y/N | Scheduled Autos |
ALLOW | Y/N | All owned Autos |
ANYAU | Y/N | Any Auto |
You have the option of downloading an import template that you can fill out. (See instructions below.)
To import vehicles:
Column Name | Character Limit | Other Notes |
AgencyID | 50 | The AgencyID field is not required if this represents a new
vehicle. When updating existing vehicles, the system first looks
at the AgencyID, then at the VIN. If a match cannot be found with
the AgencyID or the VIN, a new vehicle is added. You can determine a vehicle's AgencyID by looking at a vehicle export file. |
Ins Vehicle # | 10 | |
Agcy. Vehicle # | 10 | |
Policy Number | 30 | |
Year | 4 | Required Field. |
Make |
25 | Required Field. |
Model |
25 | |
Body Type | 25 | |
VIN | 25 | The VIN field is not required if this represents a new vehicle. When updating existing vehicles, the system first looks at the AgencyID, then at the VIN. If a match cannot be found with the AgencyID or the VIN, a new vehicle is added. |
Radius | 9 | |
Annual Mileage | 9 | |
Cost New | 9 | |
Valuation | 12 | |
Purchase Date | mm/dd/yyyy | |
GVW/GCW | 9 | Commercial vehicles only. |
License Plate | 10 | |
Hired Vehicle | Y/N | Commercial vehicles only. |
Seats | 3 | Commercial vehicles only. |
Revenue | Y/N | Commercial vehicles only. |
New Vehicle | Y/N | |
Replacement Vehicle | Y/N | |
Historic Vehicle | Y/N | |
Tow Truck | Y/N | Commercial vehicles only. |
Rating Territory | 10 | Commercial vehicles only. |
Rate Class | 10 | Commercial vehicles only. |
PD Rate Class | 10 | Commercial vehicles only. |
Primary SIC | 10 | Commercial vehicles only. |
Secondary SIC | 10 | Commercial vehicles only. |
Factor | 10 | Commercial vehicles only. |
Primary Class | 9 | Commercial vehicles only. |
Secondary Class | 9 | Commercial vehicles only. |
Effective Date | mm/dd/yyyy | |
Date Off | mm/dd/yyyy | |
License #1 | 10 | |
Reg. First Name 1 | 20 | |
Reg. Mid Name 1 | 20 | |
Reg. Last Name 1 | 50 | |
Reg. Suffix 1 | 4 | |
License #2 | 10 | |
Reg. First Name 2 | 20 | |
Reg. Mid Name 2 | 20 | |
Reg. Last Name 2 | 50 | |
Reg. Suffix 2 | 4 | |
Reg. Addr 1 | 50 | |
Reg. Addr 2 | 50 | |
Reg. City | 25 | |
Reg. State/Providence | 2 | Reg. State is supported by previous versions of the import, and it can be used as an alternate Column Name for this field. |
Reg. Zip/Postal Code | 10 | Reg. Zip and RegistrationZip is supported by previous versions of the import, and it can be used as an alternate Column Name for this field. |
Reg. Org. 1 | 25 | |
Reg. Org. 2 | 25 | |
Reg. Org. FEIN | 10 | |
ID Issue State/Province | 2 | Required field. ID Issue State is supported by previous version of the import, and it can be used as an alternate Column Name for this field. |
Effective Date | mm/dd/yyyy | |
Date Off | mm/dd/yyyy | |
Garage Address | 25 | |
Garage City | 25 | |
Garage State/Province | 2 | Garage State is supported by previous versions of the import, and it can be used as an alternate Column Name for this field. |
Garage Zip/Postal Code | 10 | Garage Zip Code is supported by previous versions of the import, and it can be used as an alternate Column Name for this field. |
Has Loan? | Y/N | |
Leased? | Y/N | |
AOI | ||
Comprehensive Deductible | Policy Number is required to import coverages. | |
Collision Deductible | Policy Number is required to import coverages. | |
Rental Reimbursement | Policy Number is required to import coverages. | |
State Amount | Policy Number is required to import coverages. |