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
| Field | Value | Type/Size |
|---|---|---|
| Vehicle Class | Required | char(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) |