BookingLegs
Name: Booking Legs
Type: Application
Modules: Booking, Scheduling, Reporting
Description: Contains the information for Pickups, Drops, and Transfers of passengers.
| Field | Documentation |
|---|---|
| LegId | Numeric identifier for the booking leg. |
| BookingId | Numeric identifier of the booking related to the booking leg. |
| LegNum | Numeric identifier of the activity for the booking leg (0 = pick-up, 1 = drop-off). |
| ReqTime | Actual time to begin the booking leg (pick-up or drop-off) (requested by the client). Value is in seconds from midnight. |
| ReqEarly | Earliest time the client can begin the booking leg (requested by the client). Value is in seconds from midnight. |
| ReqLate | Latest time the client can begin the booking leg (requested by the client). Value is in seconds from midnight. |
| NegEarly | Earliest time the client can begin the booking leg (negotiated with the client). Value is in seconds from midnight. |
| NegTime | Actual time to begin the booking leg (negotiated with the client). Value is in seconds from midnight. |
| NegLate | Latest time the client can begin the booking leg (negotiated with the client). Value is in seconds from midnight. |
| LoadTime | Amount of time required to load the client on to or off of the vehicle. Value is in seconds. |
| ClosestStopId | Numeric identifier of the pick-up or drop-off stop from the Stops that is closest to the booking leg. |
| AddrName | Name of the building that the booking leg is at (e.g., Trapeze Towers). |
| SiteName | Another name for the building or location that the booking leg is at (e.g., back parking lot). |
| AddrType | Abbreviation of the address type for the booking leg (from the AddressTypes table). |
| StreetNum | Deprecated. (Street number of the address of the location for the booking leg.) |
| StreetNo | Alphanumeric value of the address street number for the booking leg (e.g., 123A First Ave.). |
| OnStreet | Name of the street that the booking leg is on. |
| AtStreet | Cross-street or intersection closest to the booking leg. |
| Unit | Unit number of the booking leg address. |
| City | City of the booking leg address. |
| State | State of the booking leg address. |
| ZipCode | Zip code or postal code of the booking leg address. |
| AddressSummary | UK use only. |
| ZoneCode | UK use only. |
| Phone | Phone number of the booking leg address or location. |
| Lon | Longitude coordinate of the booking leg address or location. |
| Lat | Latitude coordinate of the booking leg address or location. |
| GeoStatus | Numeric value of the status of the geocoding for the longitude and latitude of the booking leg. |
| CellArea | Deprecated. |
| Comments | Comments about the record. |
| PolyId | Numeric identifier of the polygon that the booking leg is in. |
| JurisPolyId | Numeric identifier of the polygon that takes precedence when the address of the booking leg lies within more than one polygon. |
| MapPage | Page number of the location for the booking leg in a mapping book (e.g., page 4, E-4). |
| AddrId | Numeric identifier of the address of the booking leg (from the Address table). |
| MobAids | List of Mobility Aids required for the booking leg. |
| ADACheck | Flag that indicates the pick-up or drop-off is in an ADA polygon. |
| AccessibilityInfo | Internal use only. |
| SmartCardIDUsed | Numeric identifier of the client smart card used to pay for the trip. |
| SmartCardType | Numeric identifier of the smart card type used by the client to pay for the trip (from the SmartCardTypes table). |
| SmartCardExp | Expiration date of the smart card used for the booking by the client. |
| Suppressed | If true, additional bookings cannot be created from this booking. |
| SmartCardComment | Result of the SmartCard attempt (e.g., card mismatch, card not used). |