ExtraWorkImport
Name: Extra Work Import
Type: Interface
Modules: OPS-Dispatch
Description: Used to import extra work information.
| Field | Documentation |
|---|---|
| TransactionDate | Date the record was changed in the source system. |
| TransactionTime | Time the record was changed in the source system. Value is in seconds from midnight. |
| WorkName | Name of the work. |
| WorkType | Work type identifier from WorkSubtypes.Worktype. References the associated work type. |
| WorkSubtype | Work subtype identifier from WorkSubtypes.WorkSubtype. References the associated work subtype. |
| FromDate | Start date of the validity period. |
| ToDate | End date of the validity period. |
| DivisionAbbr | Abbreviation of the associated division. |
| WeekTemplate | 7-character string indicating what days of the week on which the work is valid (e.g., 0011001 means Monday, Tuesday, and Friday). |
| SignOnTime | Sign-on time. Value is in seconds from midnight. |
| SignOffTime | Sign-off time. Value is in seconds from midnight. |
| FromTime | Start time of the work. Value is in seconds from midnight. |
| ToTime | End-time of the work. Value is in seconds from midnight. |
| NumberNeeded | Number of copies of this work that is required. |
| Comments | Comments about the record. |
| FromLocation | Description of the start location. |
| ToLocation | Description of the end location. |
| DoneFlag | If true, the record has been processed. |
| Violations | Import violations (e.g., 'Invalid Work Type'). |
| StartTravel | Elapsed travel time in seconds associated with the beginning of the piece. |
| StartWait | Elapsed wait time in seconds associated with the beginning of the piece. |
| EndTravel | Elapsed travel time in seconds associated with the end of the piece. |
| EndWait | Elapsed wait time in seconds associated with the end of the piece. |