RidTripsRpt
Name: Ridership Trips
Type: Application
Modules: FX-TSEInterface, Tpwin-ETMImport, Tpwin-TpRid, Tpwin-TpFx, CAD_DailySchedule, CAD-DatabaseInterface
Description:
| Field | Documentation |
|---|---|
| NodeId | Node identifier from Nodes.NodeId. |
| LineDirId | Numeric identifier of the line direction that the trip is on. References Line.LineDirId. |
| LineAbbr | Abbreviated name of the line. |
| Pattern | Abbreviated name of pattern. |
| PatternId | Pattern identifier from MasterPattern.PatternId. |
| ServiceAbbr | Abbreviated name of service. |
| SignId | Sign-up period identifier from SignUpPeriods.SignId. |
| ServiceId | Service identifier from Service.ServiceId. |
| RidCheckDate | Date when the check was performed. |
| RidExtractDate | Date the check was extracted. |
| RidCheckId | Unique identifier of the ridership check. |
| FromTime | Start time of the trip, from Trips.FromTime. Value is in seconds from midnight. |
| DirectionName | Name of the line direction, e.g., NORTHBOUND. |
| RidCheckType | Ridership check type from RidershipTypes.RidershipTypeId. |
| BlockName | Name of the block that the trip belongs to. |
| BlockNum | Number of the block that the trip belongs to. |
| TripId | Trip identifier from Trips.TripId. |
| EmployeeId | Employee Id of the person who performed the check from Employees.EmployeeId. |
| WeatherId | Weather identifier from Weather.WeatherId. |
| PassengerMiles | Measure of passenger traffic calculated by multiplying the number of passengers by the distance traveled (in miles). |
| PassengerMinutes | Deprecated. |
| Section15 | Indicates that this trip was checked for compliance with NTD Section 15 report requirements. |
| InitialLoad | Number of passengers on board before the start of the trip. |
| ScheduleDate | Date the check is scheduled to be done. |
| Comments | Comments about the ridership check. |
| BusNum | Number of the vehicle that performed the trip. |
| RidCheckMode | Ridership check mode: 0 = riding survey sheet, 1 = riding handheld, 2 = automated, 3 = random, 4 = point survey sheet, 5 = point handheld, 6 = undefined, 7 = fare count. |
| ApcCert | Internal use only. |
| NTDPassengerMiles | Internal use only. |
| StopNum | StopNum from LineStop.StopNum for point checks only. |
| instanceId | Device identification string that distinguishes the device from others on the same computer. |