FxRunExtraPieces
Name: Fx Run Extra Pieces
Type: Application
Modules: Exchange, Fx-RunData, Legacy-Fx, OPS-Lib, OPS-BlockBuster
Description: Details of the extra work pieces belonging to a run. Extra work. Extra work is work, other than operating a bus in scheduled service which is assigned to a run.
| Field | Documentation |
|---|---|
| RunExtraPieceId | Unique identifier of a run extra piece. |
| ScenarioId | Scenario identifier from FxRunScenarios.ScenarioId. |
| RunId | Run identifier from FxRuns.RunId |
| PieceNum | Sequential number of the piece on this run. |
| FromTime | Start time of the run extra piece. Value is in seconds from midnight. |
| ToTime | End time of the run extra piece. Value is in seconds from midnight. |
| FromNodeId | Node identifier from Nodes.NodeId for the starting point of the run. |
| ToNodeId | Node identifier from Nodes.NodeId for the end point of the run. |
| ExtraPieceType | Abbreviation describing the type of extra work. |
| Comments | Comments about the record. |
| IsStartTravelForced | Indicates whether the start travel has been overridden. |
| IsEndTravelForced | Indicates whether the end travel has been overridden. |
| PlatformTime | Time in seconds during which an operator operates the revenue vehicle. |
| ReportTime | Time in seconds for which an operator is paid to report to work before pulling the vehicle out of the garage |
| ClearTime | Time in seconds for which an operator is paid to clear a vehicle after returning it to the garage. |
| MakeupTime | Payment to an operator for time in seconds not actually worked on a piece to meet a guaranteed time. |
| SignOnTime | Time at which the operator checks in to complete a piece. Value is in seconds from midnight. |
| SignOffTime | Time at which the operator signs off after completing a piece. Value is in seconds from midnight. |
| BreakTravelTime | Time in seconds that an operator spends traveling between a piece and the prior piece. |
| BreakTime | Break time in seconds prior to a piece of run. |
| ShiftTime | Duration of the shift in seconds that a piece belongs to. |
| BreakType | Break type prior to a piece: 1 = piece break, 2 = shift break. |
| BreakTravelPayTime | Time in seconds for which an operator is paid for traveling between a piece and the prior piece. |
| BreakPayTime | Time in seconds paid for an operator's break between a piece and the prior piece. |
| ExtraTime | Extra time in seconds. |
| StartTravelTime | Time in seconds that an operator spends traveling at the start of the piece. |
| StartTravelPayTime | Paid time in seconds that an operator spends traveling at the start of the piece. |
| EndTravelTime | Time in seconds that an operator spends traveling at the end of the piece. |
| EndTravelPayTime | Paid time in seconds that an operator spends traveling at the end of the piece that is paid. |
| StartTravelNodeId | Identifier of the From point of the travel at the start of a piece from Nodes.NodeId. |
| EndTravelNodeId | Identifier of the To point of the travel at the end of a piece from Nodes.NodeId. |
| StartTime | Start time of the piece. Value is in seconds from midnight. |
| EndTime | End time of the piece. Value is in seconds from midnight. |
| StartTravelType | Type of the start travel: 1= none, 2 = regular, 3 = wait, 4 = shuttle, 5 = created pull. |
| EndTravelType | Type of the end travel: 1 = none, 2 = regular, 3 = wait, 4 = shuttle, 5 = created pull. |
| PrepTime | Time in seconds for which an operator is paid after traveling to the start point of the run and before taking over a vehicle from the previous operator. |
| FinishTime | Time in seconds for which an operator is paid after handing a vehicle over to the next operator and before traveling back to the garage. |
| StartTravelWaitPayTime | Waiting time in seconds for which an operator is paid after traveling at the start of the piece. |
| EndTravelWaitPayTime | Waiting time in seconds for which an operator is paid before traveling at the end of the piece. |
| BreakTravelWaitPayTime | Waiting time in seconds for which an operator is paid during the break prior to a piece. |
| PiecePay | Amount of time in seconds paid for a piece. |
| StartStandBy | Time in seconds for which an operator is paid at the beginning of a piece when he or she waits for a possible assignment to other work |
| EndStandBy | Time in seconds for which an operator is paid at the end of a piece when an operator waits for a possible assignment to other work. |
| IsStartStandByAtGarage | If true, the start standby work is performed at a garage. |
| IsEndStandByAtGarage | If true, the end standby work is performed at a garage. |
| PieceName | Name of the piece. |
| IncludeIntoPlatform | If true, the time for the extra work is included in the platform time of the run. |
| ShiftLayover | Sum of all layover time in seconds during the shift. |
| StartTravelTravelPayTime | Paid travel time in seconds at the start of the piece, excluding wait time. |
| EndTravelTravelPayTime | Paid travel time in seconds at the end of the piece, excluding wait time. |
| StartTravelId | Identifier for the travel at the start of the piece from Travels.TravelId. |
| EndTravelId | Identifier for the travel at the end of this piece from Travels.TravelId. |
| LineGroupId | Line group identifier from MasterLineGroup.LineGroupId. |
| BlockNum | Identifier for a block that is unique within a line group, service group, sign up period combination. |
| ActualStartTime | Start time of the piece used by the software to match runs after trip data has been modified. |
| ActualEndTime | End time of the piece used by the software to match runs after trip data has been modified. |
| ExtraPieceBlockNum | Artificial block number for the extra piece to mimic regular work. |
| ExtraPieceBlockName | Artificial block name for the extra piece to mimic regular work. |
| UserLongString1 | Refer to table SupFieldDescription. |
| UserLongString2 | Refer to table SupFieldDescription. |
| UserLongString3 | Refer to table SupFieldDescription. |
| UserLongString4 | Refer to table SupFieldDescription. |
| IsEndWaitForced | Indicates whether or not the End wait has been overridden. |
| IsStartWaitForced | Indicates whether or not the Start wait has been overridden. |
| UserLong1 | Refer to table SupFieldDescription. |
| UserString1 | Refer to table SupFieldDescription. |
| UserDouble1 | Refer to table SupFieldDescription. |
| BreakTravelWaitTime | Waiting time in seconds for which an operator is paid during the break prior to a piece. |
| StartTravelWaitTime | Waiting time in seconds after traveling at the start of the piece. |
| EndTravelWaitTime | Waiting time in seconds before traveling at the end of the piece. |