OPSTrips
Name: OPS Trips
| 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. References Line.LineDirId. |
| LineAbbr | Abbreviated name of the line. |
| DirectionName | Name of the line direction. |
| Distance | Distance in meters travelled 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 comment sfrom 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. |
| ModBy | Time when the record was last modified. |
| ModDate | Date when the record was last modified. |
| ModTime | Time when the record was last modified. Value is in seconds from midnight. |
| ModAction | Last action that was performed on the record. |
| TMTripId | The TransitMaster Trip-ID |
| TMOverloadIndex | The TransitMaster overload index |
| TripNum | TripNum can come from Hastus Filed or come from Trips Field during the import., OPS do not use this filed now. |
| UserLong1 | TBD |
| UserLong2 | TBD |
| UserLong3 | TBD |
| UserString1 | TBD |