FxRuns
Name: Fx Runs
Type: Application
Modules: Exchange-Srv, Highwire-Reference, Legacy-Fx, Legacy-OPS, Legacy-Shared, OPS-Bidding, OPS-Costing, OPS-Employees, OPS-Tpx, OPS-Dispatch, OPS-Vehicle, Reports
Description: List of all runs (also known as duties). This table is used by Blockbuster.
| Field | Documentation |
|---|---|
| ScenarioId | Scenario identifier from FxRunScenarios.ScenarioId |
| RunId | Run identifier |
| RunNum | Identifier of a run that is unique within a sign-up period, service group, and division. |
| RunName | Name of the run. |
| NumPieces | Total number of regular and extra pieces in the run. A piece is a portion of work for a driver from a single block. An extra piece is a portion of work for a driver unrelated to a block. |
| Freeze | If true, the run cannot be modified. |
| ForcedRunType | If true, the run type has been overridden by the user. |
| RunTypeNum | Identifier for a run type that is unique for each collection of sign-up period, service group, and division. |
| LineGroupId | Line group identifier from MasterLineGroup.LineGroupId. |
| PlatformTime | Time in seconds during which an operator operates the revenue vehicle. |
| SpreadTime | Time in seconds measured from the beginning of the first piece to the end of the last piece. |
| WorkTime | Time in seconds when the operator is performing work. |
| TravelTime | Time in seconds for which an operator is paid when traveling to and from relief points. |
| PayTime | Time in seconds for which workers are compensated. |
| 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 run to meet a guaranteed time. |
| OverTime | Amount of work time in seconds worked beyond a normal working day. |
| SpreadOverTime | Spread time in seconds in excess of a normal working day. |
| SignOnTime | Time at which the driver checks in to complete a piece. Value is in seconds from midnight. |
| SignOffTime | Time at which an operator officially ends work. Value is in seconds from midnight. |
| TravelPayTime | Total travel pay time in seconds for the run. |
| BreakPayTime | Total break pay time in seconds for the run. |
| IsCostingOverridden | If true, run costing has been manually updated. |
| BreakTime | Total break time in seconds for the run. |
| PrepTime | Total prep time in seconds for the run. |
| FinishTime | Total finish time in seconds for the run. |
| MealBreakStartTime | Start time of a meal break, if applicable. Value is in seconds from midnight. |
| MealBreakEndTime | End time of a meal break, if applicable. Value is in seconds from midnight. |
| TravelWaitPayTime | Total travel wait pay time in seconds for a run (wait time only). |
| PayAmount | Amount of compensation provided to the employee for the completion of the run. |
| Cost | Cost of run including pay and overtime. |
| Penalty | Penalty value assigned to the run by BlockBuster costing routine. This does not affect run pay. |
| VehicleTypeBonusPayTime | Bonus pay (time in seconds) for based on vehicle type. |
| MealBreakBonusPayTime | Bonus pay (time in seconds) for meal break. |
| NightDifferentialPay | Amount of extra compensation for working at night. |
| SpreadOverTime1 | Duration in seconds by which the run exceeds the first spread overtime threshold. |
| SpreadOverTime2 | Duration in seconds by which the run exceeds the second spread overtime threshold. |
| SpreadOverTime3 | Duration in seconds by which the run exceeds the third spread overtime threshold. |
| MealBreakPayTime | Total pay time in seconds for meal breaks. |
| StandBy | Total standby time in seconds for the run. |
| PieceBreakPayTime | Total pay time in seconds for all piece breaks. |
| ShiftBreakPayTime | Total pay time in seconds for all shift breaks. |
| BidDivisionId | If true, this is the alternate division that the run is assigned to for bidding. |
| NightDifferentialPayTime | Time in seconds spent working at night. |
| UserLong1 | Refer to table SupFieldDescription. |
| UserLong2 | Refer to table SupFieldDescription. |
| UserLong3 | Refer to table SupFieldDescription. |
| UserLong4 | Refer to table SupFieldDescription. |
| UserLong5 | Refer to table SupFieldDescription. |
| UserLong6 | Refer to table SupFieldDescription. |
| OvertimeNightDifferentialPay | Amount of extra compensation for working overtime at night. |
| OTNightDifferentialPayTime | Time spent in seconds working overtime at night. |
| DayPremiumPay | Day premium in seconds. |
| SpreadExcess1 | Duration in seconds by which the run exceeds the spread overtime after parameter. |
| WorkExcess1 | Duration in seconds by which the run exceeds the overtime after parameter. |
| PayTimeBeforeRounding | Unrounded pay time in seconds. |
| NightDifferentialTimeEquiv | Straight time in seconds, equivalent of extra pay for working overtime at night. |
| NumMealBreaks | Number of meal breaks taken throughout the run. |
| MealBreakStartTime2 | Start time of the second meal break, if applicable. Value is in seconds from midnight. |
| MealBreakEndTime2 | End time of the second meal break, if applicable. Value is in seconds from midnight. |
| OverTime1 | Duration in seconds by which the run exceeds the first overtime threshold. |
| OverTime2 | Duration in seconds by which the run exceeds the second overtime threshold. |
| OverTime3 | Duration in seconds by which the run exceeds the third overtime threshold. |
| PaidOvertime | Time in seconds in excess of overtime threshold which is paid. |
| PaidSpreadOT | Time in seconds in excess of spread overtime threshold which is paid. |
| SrcRunNum | Run number (from FxRuns.RunNum) of the run from which this run was copied. |
| WheelTurningTime | Total time in seconds for the run during which the operator is driving a vehicle. |
| UserLong7 | Refer to table SupFieldDescription. |
| UserLong8 | Refer to table SupFieldDescription. |
| UserLong9 | Refer to table SupFieldDescription. |
| UserLong10 | Refer to table SupFieldDescription. |
| TravelWaitTime | Total travel wait time in seconds for a run. |
| WheelTurningPercentage | Percentage of work time during which an operator is driving a vehicle (Wheel Turning Time). |