Trips
Name: Trips
Type: Application
Modules: CTM-complaints, Fx-Backup, Fx-RunCutterInterface, Fx-TpFxC, Fx-Tpu, Fx-BlockBuster, Fx-BusGraph, Fx-RunCutter, Fx-InfoPublisher, Fx-TSEInterface, OPS-YardManagement, Pass-Booking, Pass-TripEdit, School, Shared-TpGnr, Fx-Lib, PassWeb, Common-Gui, Exchange-GoogleExport, Exchange-PrestoInterface, Exchange-Gui, Exchange-Lib, Exchange-DataImportLib, Fx-Ancillary, Fx-TransXChange, Highwire-Reference, Info-Web, Legacy-Fx, Legacy-OPS, Legacy-Shared, MDT2-Pass, Info-UI, ParaCutter, OPS-Lib, OPS-Gui, OPS-Bidding, OPS-CAD, OPS-Dispatch, OPS-WorkForceManagement, OPS-PassBooking, Reports
Description: List of all trips.
| Field | Documentation |
|---|---|
| BestLayover | Ideal layover time in seconds. |
| TripId | Unique identifier for a trip. |
| SignId | Sign-up period identifier from SignUpPeriods.SignId. |
| DivisionId | Division identifier from MasterDivisions.DivisionId. |
| ServiceId | Service identifier from Service.ServiceId. |
| LineDirId | Numeric identifier of the line direction from the Line table that the trip is on. |
| TripSort | Order that the trips should appear on a timetable. (The numbers are not sequential.) |
| PatternId | Pattern identifier from MasterPattern.PatternId. |
| ServiceGroupId | Service group identifier from MasterServiceGroup.ServiceGroupId. |
| LineGroupId | Line group identifier from MasterLineGroup.LinegroupId. |
| FromTime | Start time of a trip. Value is in seconds from midnight. |
| ToTime | End time of a trip. Value is in seconds from midnight. |
| CommentId | Comment identifier from Comments.CommentId. |
| TripType | Trip Type (Sometimes RG for regular and DH for deadhead). |
| Freeze | If true, the trip cannot be modified. |
| Destination | For internal use. |
| Distance | Distance in meters covered in the trip. Only used for trips with no pattern. |
| FromStopNum | Start stop identifier from LineStop.StopNum. |
| ToStopNum | End stop identifier from LineStop.StopNum. |
| BuildStopNum | Identifies the build node, times at other nodes are generated based on the time at the build node, from LineStop.StopNum. |
| BlockName | Name of the block that the trip belongs to. |
| BlockNum | Block number that the trip belongs to. |
| PulloutTime | Deprecated. Use FxBlockEvents table. |
| PullinTime | Deprecated. Use FxBlockEvents table. |
| PulloutGarageId | Deprecated. Use FxBlockEvents table. |
| PullinGarageId | Deprecated. Use FxBlockEvents table. |
| BusTypeId | Bus type identifier from BusTypes.BusTypeId. |
| MinLayover | Minimum layover time in seconds required at the end of a trip. |
| MaxLayover | Maximum layover time in seconds allowed at the end of a trip. |
| ExcComboId | Exception combination identifier from MasterExceptionCombinations.ExcComboId. |
| UserDouble1 | Refer to table SupFieldDescription. |
| UserDouble2 | Refer to table SupFieldDescription. |
| 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. |
| UserShort1 | Refer to table SupFieldDescription. |
| UserShort2 | Refer to table SupFieldDescription. |
| UserShort3 | Refer to table SupFieldDescription. |
| UserShort4 | Refer to table SupFieldDescription. |
| UserShort5 | Refer to table SupFieldDescription. |
| UserShort6 | Refer to table SupFieldDescription. |
| UserString1 | Refer to table SupFieldDescription. |
| UserString2 | Refer to table SupFieldDescription. |
| UserString3 | Refer to table SupFieldDescription. |
| UserString4 | Refer to table SupFieldDescription. |
| UserString5 | Refer to table SupFieldDescription. |
| UserString6 | Refer to table SupFieldDescription. |
| SplitTime | Not generically used. |
| EmptyColumns | Not generically used. |
| Preceeding | Not generically used. |
| Raster | Not generically used. |
| VehicleBlockNum | Vehicle block number that the trip belongs to. |
| VehicleGroupId | Vehicle group identifier from VehicleGroups.VehicleGroupId. |
| BlockId | Block identifier from FxBlocks.BlockId. |
| TripNum | Numeric identifier for a trip, selected by the user. |
| FareHint | Used for custom faring in Info. |
| InfoFromDate | Internal use only. |
| InfoToDate | Internal use only. |
| CreatedFromDeadhead | If true, the trip is generated using the 'Replace garage deadheads with trips' function. |
| NumCars | Default number of cars for consists. |
| Revenue | Whether a trip is generating revenue. |
| TimeIsPrevDay | Whether the pull-out time of a block is from the previous day. |
| OpsVersionId | Import version ID from third-party external source. |