Trip Details and Custom Report Fields

The All Trips Details report contains all of the data fields that Bambi stores for each trip. Custom Reports allow you to access the same information, but you can choose which fields to include in your download and leave off the ones you don't want.

When building a Custom Report, you can see a brief description of what each field is used for; you'll find a similar description for each trip data field below.

The list is broken down into sections to make it easier to navigate; we recommend using CTRL+F or CMD+F to search if you are looking for a specific field.

Basic Trip Data

trip_date: the date the trip is scheduled for

payer_name: the name of the Payer for the trip

estimated_distance_miles: the estimated distance in miles of the trip

status: the status of the trip

space_type: the space type required for the trip

price: the price of the trip

trip_id: the internal ID of the trip in Bambi

confirmation_code: the confirmation code of the trip

scheduled_pickup_at: The scheduled pickup time for the trip

estimated_dropoff_at: The estimated dropoff time for the trip

appointment_at: the passengers appointment time if they are heading to an appointment

is_will_call: Whether it is a will call trip or not

tags: any tags on the trip

trip_created_at: the time the trip was created

Passenger Data

passenger_full_name: the full name of the passenger

passenger_dob: the date of birth of the passenger

member_id: the passenger's member ID number

passenger_first_name: first name of the passenger

passenger_last_name: last name of the passenger

passenger_preferred_name: preferred name of the passenger

passenger_pronoun: pronoun for the passenger

passenger_gender: passenger's gender

passenger_weight: passengers weight in pounds

passenger_needs_bariatric_transport: whether the passenger needs bariatric transport

passenger_phone_number: passenger's phone number

passenger_email: passenger's email address

passenger_notes: any notes on the passenger

authorization_id: passenger's authorization ID for the trip, normally from an insurance provider

insurance_policy_id: passenger's insurance policy ID used on a trip

Pickup Location Data

pickup_location_label: the full address of the pickup location

pickup_location_detail: apartment room, or suite number at the pickup location

pickup_location_latitude: latitude at the pickup location

pickup_location_longitude: longitude at the pickup location

pickup_contact_name: the name of the contact at the trip pickup

pickup_contact_phone_number: the phone number of the contact at the trip pickup

pickup_number_of_stairs: the number of stairs at the pickup

pickup_stair_equipment: any stair equipment required at the pickup

pickup_driver_notes: any notes for the driver pertaining to the pickup

Dropoff Location Data

dropoff_location_label: the full address of the dropoff location

dropoff_location_detail: apartment room, or suite number at the dropoff location

dropoff_location_latitude: latitude at the dropoff location

dropoff_location_longitude: longitude at the dropoff location

dropoff_contact_name: the name of the contact at the trip dropoff

dropoff_contact_phone_number: the phone number of the contact at the trip dropoff

dropoff_number_of_stairs: the number of stairs at the dropoff

dropoff_stair_equipment: any stair equipment required at the dropoff

dropoff_driver_notes: any notes for the driver pertaining to the dropoff

Additional Trip Data

is_locked: whether the trip was locked to a certain driver

external_trip_id: the ID of the trip in some external system such as a broker

must_provide_wheelchair: whether the passenger needs a wheelchair provided for them

has_infectious_disease: whether the passenger has an infectious disease

service_type: the service type required for the trip

booked_by_name: who outside the transportation provider booked the trip, eg, passenger's daughter

booked_by_phone_number: the phone number of the person who booked the trip

booked_by_phone_extension: the phone number extension of the person who booked the trip

dispatcher_notes: any dispatcher notes for the trip

billing_notes: any billing notes for the trip

driver_entered_notes: any notes entered by the driver for a trip

signature_url_expiration: when the following urls will expire

pickup_driver_signature_url: the url to access the pickup driver signature

pickup_passenger_signature_url: the url to access the pickup passenger signature

dropoff_driver_signature_url: the url to access the dropoff driver signature

dropoff_passenger_signature_url: the url to access the dropoff passenger signature

is_oxygen_required: whether the passenger requires oxygen for the trip

oxygen_liters_per_min: the amount of oxygen required by the passenger

num_attendants_needed: the number of attendants needed for a trip

num_accompanying_passengers: number of accompanying passengers on the trip

correlation_id: a Bambi internal ID for linking multiple leg trips together

Trip Status Updates

actual_en_route_at: the time the driver pressed en route

actual_at_pickup_at: the time the driver pressed at pickup

actual_transporting_at: the time the driver pressed transporting

actual_at_dropoff_at: the time the driver pressed at dropoff

actual_completed_at: the time the driver pressed completed

canceled_at: the time the trip was canceled

canceled_reason: the reason the trip was canceled

canceled_by: the person who canceled the trip

is_canceled_by_driver: whether the assigned driver canceled the trip

minutes_canceled_before_pickup_time: the minutes before the scheduled pickup time that the trip was canceled

Driver and Vehicle Assignment

driver_name: the name of the driver

driver_license_state: the driver's license state

driver_license_number: the driver's license number

attendant_names: the names of any attendants

vehicle_name: the name of the vehicle

vin: the VIN of the vehicle

vehicle_plate: the vehicles license plate number

assigned_by_run_bambi_run: whether the trip was was assigned via RBR

Time and Distance Data and Calculations

odometer_en_route_meters: the value of the odometer on the driver's phone when they pressed en route in meters

odometer_at_pickup_meters: the value of the odometer on the driver's phone when they pressed at pickup in meters

odometer_transporting_meters: the value of the odometer on the driver's phone when they pressed transporting in meters

odometer_at_dropoff_meters: the value of the odometer on the driver's phone when they pressed at dropoff in meters

odometer_completed_meters: the value of the odometer on the driver's phone when they pressed completed in meters

en_route_distance_miles: difference between at pickup odometer and en route odometer: miles

en_route_duration_sec: the number of seconds the trip was in en route status

at_pickup_distance_miles: difference between transporting odometer and at pickup odometer: miles

at_pickup_duration_sec: the number of seconds the trip was in at pickup status

transporting_distance_miles: difference between at dropoff odometer and transporting odometer:vmiles

transporting_duration_sec: the number of seconds the trip was in transporting status

estimated_transport_duration_sec: the estimated number of seconds for transport time for the trip

at_dropoff_distance_miles: difference between complete odometer and at dropoff odometer: miles

at_dropoff_duration_sec: the number of seconds the trip was in at dropoff status

transporting_to_complete_distance_miles: difference between complete odometer and transporting odometer: miles

transporting_to_complete_duration_sec: the total number of seconds between the driver pressing transporting and complete

at_pickup_to_complete_distance_miles: difference between complete odometer and at pickup odometer: miles

at_pickup_to_complete_duration_sec: the total number of seconds between the driver pressing at pickup and complete

total_distance_miles: difference between complete odometer and en route odometer: miles

total_duration_sec: the total number of seconds between the driver pressing en route and complete

pickup_wait_time_minutes: any wait time at the pickup that was added to the trip

is_late_pickup: whether the pickup was late

minutes_arrived_before_scheduled_pickup_time: how many minutes before the scheduled pickup time the driver arrived

entered_pickup_geofence_at: the time the driver entered the geofence at the pickup

exited_pickup_geofence_at: the time the driver exited the geofence at the pickup

entered_dropoff_geofence_at: the time the driver entered the geofence at the dropoff

exited_dropoff_geofence_at: the time the driver exited the geofence at the dropoff