FxRunPieces

Name: Fx Run Pieces

Type: Application

Modules: Exchange, Fx-BlockBuster, Fx-BlockBusterSupport, Fx-BusGraph, Fx-TpFxC, Highwire-Reference, Legacy-Fx, OPS-Lib, OPS-Tps

Description: Details of the pieces of regular work assigned to a run.

Field Documentation
ScenarioId Scenario identifier from FxRunScenarios.ScenarioId.
RunId Run identifier from FxRuns.RunId.
PieceNum Sequential number of the piece on this run.
StartTripId Trip identifier from Trips.TripId for the start of the piece.
StartStopNum Stop identifier from LineStop.StopNum for the start of the piece.
StartEventType Event type at the start of the piece: Pullout = 1, Pullin = 2, Breakstart = 5, Breakend = 6, Reliefstart = 7, Reliefend = 8, Createdpullin = 9, Createdpullout = 10, Breakreliefstart = 11, Breakreliefend = 12.
StartOffset Duration in seconds that the relieved operator remains with the vehicle after the start of the layover.
EndTripId ID of the last trip in the block.
EndStopNum Stop identifier from LineStop.StopNum for the end of the piece.
EndEventType Event type at the end of the piece: Pullout = 1, Pullin = 2, Breakstart = 5, Breakend = 6, Reliefstart = 7, Reliefend = 8, Createdpullin = 9, Createdpullout = 10, Breakreliefstart = 11, Breakreliefend = 12.
EndOffset Duration in seconds that the relieved operator remains with the vehicle after the end of the layover.
IsStartTravelForced Indicates whether or not the start travel has been overridden
IsEndTravelForced Indicates whether or not 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 driver checks in to complete the piece. Value is in seconds from midnight.
SignOffTime Time at which the driver signs off after completing the piece. Value is in seconds from midnight.
BreakTravelTime Time in seconds spent traveling between a piece and the prior piece.
BreakTime Break time in seconds prior to a piece.
ShiftTime Duration in secnods of the shift that a piece belongs to.
BreakType Break type prior to a piece: 1 = piece break, 2 = shift break
BreakTravelPayTime Time in seconds spent traveling between a piece and the prior piece.
BreakPayTime Time in seconds paid for the operator?s break between a piece and the prior piece
ExtraTime Extra time in seconds.
StartTravelTime Time in seconds that an operator spent traveling at the start of the piece.
StartTravelPayTime Time in seconds for which an operator is paid for traveling at the start of the piece.
EndTravelTime Time in seconds that an operator spent traveling at the end of the piece.
EndTravelPayTime Time in seconds for which an operator is paid for traveling at the end of the piece.
StartTravelNodeId Identifier of the From point of the travel at the start of the piece from Nodes.NodeId
EndTravelNodeId Identifier of the To point of the travel at the end of the piece from Nodes.NodeId
StartTime Start time of the run piece. Value is in seconds from midnight.
EndTime End time of the run 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
CommentId Comment identifier from Comments.CommentId
PrepTime Time in seconds for which a driver is paid after traveling to the start point of the run before taking over the vehicle from the previous operator.
FinishTime Time in seconds for which an operator is paid after handing a vehicle over to the next operator prior to travelling back to the garage.
StartTravelWaitPayTime Waiting time in seconds after traveling at the start of the piece for which an operator is paid.
EndTravelWaitPayTime Waiting time in seconds before traveling at the end of the piece for which an operator is paid.
BreakTravelWaitPayTime Waiting time in seconds during the break prior to a piece for which an operator is paid.
PiecePay Amount of time in seconds paid for the piece.
StartStandBy Time in seconds for which an operator is paid at the beginning of a piece that he or she spent waiting for a possible assignment to other work.
EndStandBy Time in seconds for which an operator is paid at the end of a piece that he or she spent waiting for a possible assignment to other work.
IsStartStandByAtGarage Indicates if the start standby work is performed at a garage.
IsEndStandByAtGarage Indicates if the end standby work is performed at a garage.
PieceName Name of the piece.
ShiftLayover Sum of all layover time in seconds during the shift.
IsStartWaitForced Indicates whether or not the Start wait has been overridden.
IsEndWaitForced Indicates whether or not the End wait has been overridden.
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 Travel identifier from Travels.TravelId for start travel.
EndTravelId Travel identifier from Travels.TravelId for end travel.
LineGroupId Line group identifier from MasterLineGroup.LineGroupId
BlockNum Identifier for a block that is unique within a line group.
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.
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.
StartReliefType Type of driver relief at the start of the run.
EndReliefType Type of driver relief at the end of the run.