Vehicle Class Code Import and Export

This program exports your Vehicle Class Code records into a delimited text file. This file can then be edited manually or via a spreadsheet program, and then re-imported into the RTA system to update any changes made.

Import Options:

   Create New
          Checked  - New records will be created
      Unchecked - New Records WILL NOT be created

   Update Existing
          Checked - Existing records will be updated
      Unchecked - Existing Records WILL NOT be updated

Import Field Definitions

FieldValueType/Size
Vehicle ClassRequiredchar(15)
Class Description
char(40)
Max Units
int(05)

Column 1 Line 1


char(15)
Column 1 Line 2
char(15)
Column 1 Line 3
char(15)
Column 1 Line 4
char(15)
Column 1 Line 5
char(15)
Column 1 Line 6
char(15)
Column 1 Line 7
char(15)
Column 1 Line 8
char(15)
Column 1 Line 9
char(15)
Column 1 Line 10
char(15)
Column 1 Line 11
char(15)
Column 2 Line 1
char(15)
Column 2 Line 2
char(15)
Column 2 Line 3
char(15)
Column 2 Line 4
char(15)
Column 2 Line 5
char(15)
Column 2 Line 6
char(15)
Column 2 Line 7
char(15)
Column 2 Line 8
char(15)
Column 2 Line 9
char(15)
Column 2 Line 10
char(15)
Column 2 Line 11
char(15)
Wash Rate 1
Decimal(5,2)+/-
Wash Rate 1
Decimal(5,2)+/-
Minimum MPG Level
int(4)
Max Repair Cost Level
decimal (8,.2)
Vehicle Counter
int(10)
Estimated Years
int(4)
Estimated Primary Meter
decimal (8,1)
Estimated Resale Value
decimal (8,2)+/-
Low Service Request  Per Year
int(4)
High Service Requests Per Year
int(4)
Service Request Count

1 = By WO

2 = By WO Line

int(1)