PassCmnTNCTripInfo
Name: PASS Common TNC Trip Info
Type: Application
Modules: PASS, PASSCommon
Description: Stores constantly updated Transportation Network Company (TNC)
trip.
| Field | Documentation |
|---|---|
| BookingId | Numeric identifier of the booking (from the Bookings table). |
| InterfaceType | Numeric identifier of the interface type (e.g., -1 = Uber, -2 = Lyft). |
| DateTimeStamp | Date and time the record was added. |
| RTPRideId | Transportation network company ride ID. |
| RTPRideStatus | Transportation network company trip status (e.g., processing, accepted, arriving, in_progress, completed, driver_canceled, rider_canceled, dispatcher_canceled, no_drivers_available). |
| TNCEventType | Transportation network company event type (e.g., ride.status.requested, ride.receipt.requested). |
| ETA | Estimated time of arrival of the trip event (e.g., if the trip is accepted the estimated arrival time is shown, if the trip is in progress the estimated drop-off time is shown). |
| Lat | Latitude coordinate of the vehicle. |
| Lon | Longitude coordinate of the vehicle. |
| DriverName | Name of the vehicle's driver. |
| DriverPhone | Phone number of the vehicle's driver. |
| VehDescription | Description of the vehicle (e.g., make, model, license plate). |
| VehicleNumber | Unique vehicle number assigned to a taxi. (Not used for TNC vehicles.) |