OPSRun
Name: OPSRun
Type: Application
Modules: OPS ONLY
Description: Based on the Run table. Populated via bulk data importation from either Run or from a third party database.
| Field | Documentation |
|---|---|
| RunId | Run identifier (from MasterRun.RunId). |
| RunVersionId | Run versioning identifier that is employed along with RunId to uniquely identify a run in OPSMasterRun and OPSRun; generally sourced from the FX ExcComboId. |
| PieceNum | Sequential number of the piece on this run. |
| PlatformTime | Time during which an operator operates the revenue vehicle. |
| ReportTime | Time for which an operator is paid to report to work before pulling the vehicle out of the garage. |
| ClearTime | Time for which an operator is paid to clear a vehicle after returning it to the garage. |
| WorkTime | Time the operator is performing work. |
| MakeupTime | Payment to an operator for time not actually worked on a run to meet a guaranteed time. |
| SignOnTime | Time the operator checks in to complete a piece. |
| SignOffTime | Time the operator signs off after completing a run. |
| TravelTime | Time for which an operator is paid when traveling to and from relief points. |
| SwingTime | Time between pieces. |
| SwingTravelTime | Time for travel between pieces. |
| InterveningTime | Incidental time between pieces. |
| StartEventType | Event type at the start of the piece (1 = Pullout, 2 = Pullin, 5 = Breakstart, 6 = Breakend, 7 = Reliefstart, 8 = Reliefend, 9 = Createdpullin, 10 = Createdpullout, 11 = Breakreliefstart, 12 = Breakreliefend). |
| EndEventType | Event type at the end of the piece (1 = Pullout, 2 = Pullin, 5 = Breakstart, 6 = Breakend, 7 = Reliefstart, 8 = Reliefend, 9 = Createdpullin, 10 = Createdpullout, 11 = Breakreliefstart, 12 = Breakreliefend). |
| StartTravel | Time that an operator spent traveling at the start of the piece. |
| EndTravel | Time that an operator spent traveling at the end of the piece. |
| PaidSwing | Paid time between pieces. |
| UserLong1 | Client supplementary data. |
| UserLong2 | Client supplementary data. |
| UserLong3 | Client supplementary data. |
| UserLong4 | Client supplementary data. |
| UserLong5 | Client supplementary data. |
| StartWait | For wait and travels, the wait time at the start of the run. |
| EndWait | For wait and travels, the wait time at the end of the run. |
| ShiftTime | Duration of the shift that a piece belongs to. |
| UserLong10 | Client supplementary data. |
| UserLong6 | Client supplementary data. |
| UserLong7 | Client supplementary data. |
| UserLong8 | Client supplementary data. |
| UserLong9 | Client supplementary data. |
| PieceName | Name of the piece. |
| ShiftLayover | Sum of all layover time during the shift. |
| UserString1 | Client supplementary data. |
| UserDouble1 | Client supplementary data. |
| CommentId | TBD |
| FromNodeId | First node in the block. |
| ToNodeId | Last node in the block. |
| FromTime | From time for consists. |
| ToTime | To time for Consists. |
| SignOnNodeId | Signon node for the run. |
| SignOffNodeId | Signoff node for the run |
| BlockId | TBD |
| BlockVersionId | Same block run in a different scenario. |
| BlockFlag | Indicates the pullout type ( 0 = Normal, scheduled and pullout happens on current day; 1 = Block is scheduled for next day but pull-out is on current day; 2 = Block is scheduled for next day and the pull-out time is for next day). |
| LineList | Line list for operator. |
| BlockName | Block name that the OPS run operates on. |
| LineGroupId | Line group identifier from MasterLineGroup.LineGroupId. |
| BlockNum | Block number that the OPS run operates on |
| BusTypeId | Bus type suggested for the OPS run. |
| UseDriverBlocks | If true, use driver blocks. |
| PrepTime | Total prep time (in seconds) for the run. |
| FinishTime | Total finish time (in seconds) for the run. |
| StartStandBy | Time at which standby is started. |
| EndStandBy | Time at which standby is ended. |