This program exports your vehicle 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.
...
Update Existing
Checked - Existing records will be updated
Unchecked - Existing Records WILL NOT be updated
Import Field Definitions
Diff Factor 2
Field | Value | Type/Size |
---|---|---|
Facility | Required | int(5) |
Vehicle | Required | char(8) |
Year | int(4) | |
Make | char(15) | |
Model | char(15) | |
Serial Number | char(20) | |
License Plate | char(15) | |
Cross-Reference Number | char(8) | |
Class | char(15) | |
Department | char(10) | |
Customer Facility | int(5) | |
Customer Number | char(10) | |
Registration | char(20) | |
Purchase Date | date | |
Inservice Date | date | |
Vehicle Size | L = Light M = Medium H = Heavy T = Trailer O = Other | char(1) |
Gross Vehicle Weight | Depending on switch SSM Misc 1 tab #29 alpha or numeric | Numeric int(7) Alpha char(10) |
Rear End Capacity | int(7) | |
Mechanic Number | int(10) | |
Meter Units | Add only, update not allowed G = Gallons K = Kilometers U = Units M = Miles H = Hours N = None | char(1) |
Current Odometer | Add only update not allowed | decimal(8,1) |
Post Odometer Life/Period | P = Period L = Life | char(1) |
Base Meter | decimal(8,1)+/- | |
Last Meter Date | date | |
Last Fuel Date | date | |
Begin Odometer Reading | decimal(7,1) | |
Meter Range | int(5) | |
Vehicle Location | char(20) | |
Vehicle Operator | char(20) | |
Inspection Type | char(20) | |
Inspection Period | int(2) | |
Inspection Period Count | int(2) | |
Inspection Position | int(2) | |
Tire Count | Add only Update not allowed | int(2) |
Max Tire Count | int(2) | |
Usage Code | char(5) | |
PM Service Note 1 | char(40) | |
PM Service Note 2 | char(40) | |
PM Service Note 3 | char(40) | |
Purchase Price | decimal(8,3)+/- | |
Insurance Per Year | decimal(8,3)+/- | |
License Per Year | decimal(8,3)+/- | |
License Period | int(2) | |
License Period Count | int(2) | |
License Position | int(2) | |
Leased Vehicle | Y = Is Leased N = Not Leased | char(1) |
Outside Vehicle | Y = Outside N = Inside | char(1) |
Fuel Type | Must match a Fuel type code under fuel types (MUF) | char(1) |
Fuel Capacity | int(6) | |
Average MPG | decimal(3,3) | |
Highway Tax rate | decimal(1,4) | |
Fuel Taxable | Y = Taxable N = Not Taxable | char(1) |
Split Fuel Facility | int(5) | |
Split Fuel Number | char(8) | |
Split Fuel Percentage | Cannot be greater than 1.0000 or less than -1.0000 | decimal(1,4)+/- |
Fuel Cross-Reference | char(8) | |
Oil Type | char(25) | |
Oil Capacity | decimal(4,1) | |
Transmission Fluid | char(25) | |
Transmission Capacity | decimal(4,1) | |
Anti-freeze | char(25) | |
Anti-freeze Capacity | decimal(4,1) | |
Gear Oil | char(25) | |
Gear Oil Capacity | decimal(4,1) | |
Hydraulic Fluid | char(25) | |
Hydraulic Capacity | decimal(4,1) | |
Freon | char(25) | |
Freon Capacity | decimal(4,1) | |
Alternate Meter 1 | Must match Alternate Meter Type ID (MVA) Add only Update not allowed | int(2). |
Alternate Meter 1 Odometer | Add only Update not allowed | decimal(7,2) |
Alternate Meter 2 | Must match Alternate Meter Type ID (MVA) Add only Update not allowed | int(2). |
Alternate Meter 2 Odometer | Add only Update not allowed | decimal(7,2) |
Alternate Meter 3 | Must match Alternate Meter Type ID (MVA) Add only Update not allowed | int(2). |
Alternate Meter 3 Odometer | Add only Update not allowed | decimal(7,2) |
Alternate Meter 4 | Must match Alternate Meter Type ID (MVA) Add only Update not allowed | int(2). |
Alternate Meter 4 Odometer | Add only Update not allowed | decimal(7,2) |
classinfo1 | char(20) | |
classinfo2 | char(20) | |
classinfo3 | char(20) | |
classinfo4 | char(20) | |
classinfo5 | char(20) | |
classinfo6 | char(20) | |
classinfo7 | char(20) | |
classinfo8 | char(20) | |
classinfo9 | char(20) | |
classinfo10 | char(20) | |
classinfo11 | char(20) | |
classinfo12 | char(20) | |
classinfo13 | char(20) | |
classinfo14 | char(20) | |
classinfo15 | char(20) | |
classinfo16 | char(20) | |
classinfo17 | char(20) | |
classinfo18 | char(20) | |
classinfo19 | char(20) | |
classinfo20 | char(20) | |
classinfo201 | char(20) | |
classinfo22 | char(20) | |
Definable Description 1 | char(15) | |
Definable Value 1 | char(20) | |
Definable Description 2 | char(15) | |
Definable Value 2 | char(20) | |
Definable Description 3 | char(15) | |
Definable Value 3 | char(20) | |
Definable Description 4 | char(15) | |
Definable Value 4 | char(20) | |
Definable Description 5 | char(15) | |
Definable Value 5 | char(20) | |
Definable Description 6 | char(15) | |
Definable Value 6 | char(20) | |
Definable Description 7 | char(15) | |
Definable Value 7 | char(20) | |
Definable Description 8 | char(15) | |
Definable Value 8 | char(20) | |
Definable Description 9 | char(15) | |
Definable Value 9 | char(20) | |
Definable Description 10 | char(15) | |
Definable Value 10 | char(20) | |
Definable Description 11 | char(15) | |
Definable Value 11 | char(20) | |
Definable Description 12 | char(15) | |
Definable Value 12 | char(20) | |
Definable Description 13 | char(15) | |
Definable Value 13 | char(20) | |
Definable Description 14 | char(15) | |
Definable Value 14 | char(20) | |
Definable Description 15 | char(15) | |
Definable Value 15 | char(20) | |
Definable Description 16 | char(15) | |
Definable Value 16 | char(20) | |
Definable Description 17 | char(15) | |
Definable Value 17 | char(20) | |
Definable Description 18 | char(15) | |
Definable Value 18 | char(20) | |
Definable Description 19 | char(15) | |
Definable Value 19 | char(20) | |
Definable Description 20 | char(15) | |
Definable Value 20 | char(20) | |
Diff Factor 1 | int(1) | |
Diff Factor 2 | int(1) | |
Diff Factor 3 | int(1) | |
Diff Factor 4 | int(1) | |
Diff Factor 5 | int(1) | |
Diff Factor 6 | int(1) | |
Diff Factor 7 | int(1) | |
Diff Factor 8 | int(1) | |
Diff Factor 9 | int(1) | |
Diff Factor 10 | int(1) |