OPSTrips
Name: OPS Trips
Type: Application
Modules: OPS-Dispatch
Description: Contains information about OPS Trips. For example, sign-up period, trip type, and distance.
| Field | Documentation |
|---|---|
| OPSTripId | OPS trip ID. |
| SignId | Sign-up period identifier (from SignUpPeriods.SignId). |
| TripType | Type of trip (RG = Regular, PO = Pull Out, PI = Pull In, DH = Dead Head). |
| LineDirId | Numeric identifier of the line direction that the trip is on (from Line.LineDirId). |
| LineAbbr | Abbreviated name of the line. |
| DirectionName | Name of the line direction. |
| Distance | Distance in meters traveled in this trip. |
| FromTime | Start time for consists. (Value is in seconds from midnight.) |
| ToTime | End time for consists. (Value is in seconds from midnight.) |
| DeadheadTime | Length of trip's deadhead in seconds. |
| FromNodeId | First node in the block. |
| ToNodeId | Last node in the block. |
| SourceTripId | Tripid from source data. |
| NumCars | Default number of cars for consists. |
| Revenue | Whether the trip is a revenue trip. |
| OpsVersionId | Import version ID from third-party external source. |
| CommentId | Used to retrieve comments from Fixed Route runs. |
| PatternId | Pattern identifier (from MasterPattern.PatternId). |
| TimeIsPrevDay | Whether the block's pull out time is from yesterday. |
| TripSort | Time to use for sorting. Value may be negative to support the time from the previous day. |
| ServiceId | Unique identifier for the service associated with trip. |
| ModBy | User who last modified the record. |
| ModDate | Date the record was last modified. |
| ModTime | Time the record was last modified. |
| ModAction | Last action performed on the record. |
| TMTripId | TransitMaster Trip Id. |
| TMOverloadIndex | TransitMaster overload index. |
| TripNum | Deprecated. (TripNum can come from the Hastus field or from the Trips Field during the import.) |
| UserLong1 | Client supplementary data. |
| UserLong2 | Client supplementary data. |
| UserLong3 | Client supplementary data. |
| UserString1 | Client supplementary data. |