Work Order VMRS Import and Export
This program exports your Work Order VMRS 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 |
|---|---|---|
| Major VMRS | Required | int(3) |
| Intermediate VMRS | Required | int(3) |
| Minor VMRS | Required | int(3) |
| Description | char(40) | |
| Miscellaneous | char(25) | |
| Job Hours 1 | decimal(3,2) | |
| Job Hours 2 | decimal(3,2) | |
| Job Hours 3 | decimal(3,2) | |
| Job Hours 4 | decimal(3,2) | |
| Job Hours 5 | decimal(3,2) | |
| Job Hours 6 | decimal(3,2) | |
| Job Hours 7 | decimal(3,2) | |
| Warranty Flag | Y = Is Warranty (Checked) N = Not Warranty (Not Checked) | char(1) |
| Scheduled Flag | Y = Allowed on Job Schedule (Checked) N = Not Allowed on Job Schedule(Not Checked) | char(1) |
| Condition Prompt | Y = Prompt for vehicle condition (Checked) N = Don't Prompt for vehicle condition (Not Checked) | char(1) |
| Delete VMRS | Y = Delete this VMRS Code | char(1) |