| Column Name | Description | Source/Location |
|---|---|---|
| AccountBaseRate | Base rate associated with the account, considering mobility factors | Master Pages - Account Master |
| AccountCode | Usually this is an abreviation of the Account Name (I.E. Account Name is Council on Aging, the Code would be COA) | Master Pages - Account Master |
| AccountHourlyRate | Hourly rate associated with the account | Master Pages - Account Master |
| AccountMileageRate | Mileage rate associated with the account | Master Pages - Account Master |
| AccountName | This is the proper name of the Account, Not the Account Code, which is the abreviation. | Master Pages - Account Master |
| AccountStretcherRate | Stretcher rate associated with the account | Master Pages - Account Master |
| AccountWheelchairRate | Wheelchair rate associated with the account | Master Pages - Account Master |
| ActualDropoffTime | The Time when the Client was Actually Dropped off. Not the Arrival Time. | Trip Validation - Rider Data |
| ActualPickupTime | The Time when the Client was Actually Picked up. Not the Arrival Time. | Trip Validation - Rider Data |
| AgencyName | Agencies allow you to nest Accounts under one common Agency. You can assign Agencies to Accounts in Account Master | Master Pages - Agency Master |
| AgeOnRideDate | No matter when you create a Custom Report, you can use this to ensure the Age is Correct for the time period you are creating the report for. | Calculated in the Backend of the System |
| Attendants | Attendants are just units that are added to Reservations. We default to 0 unless a specific number of Attendants is entered. | Reservation (Screen) |
| AuthNum | For those working with Logisticare, this is also referred to as a Trip Number. Example: 1-1234-A. Many of our broker imports, include AuthNum. | Reservation (Screen) |
| BaseRatePlusMobility | Base rate plus additional charges for mobility accommodations | Master Pages - Account Master |
| BrokerComments | Comments provided by the broker | Reservation (Screen) |
| BZone | Billing Zones (Bzone) can be used to define areas of service, mileages of service and can be used in conjunction with Account (Master) Billing Definitions. | Master Pages - Billing Zone Master |
| BZoneRate | The Rate that is assigned to an individual Bzone | Master Pages - Billing Zone Master |
| ChargeOverride | Charge Overide, when entered, will overlook any Account Master settings and use what is manually entered. | Reservation (Screen) |
| ChargeOverrideComments | Anything you want to manually enter to describe the nature of the ChargeOveride. | Reservation (Screen) |
| Children | Children are able to be added to any Reservation. This number is completely up to the user scheduling the Reservation. While there is no name for the child, they are tied to the Client that has the Reservation. | Reservation (Screen) |
| ConfirmationNumber | Each Reservation has a unique Id in your database. This ID is displayed at the top of your Reservation screen. | Reservation (Screen) |
| DateRecorded | The Date the Reservation was actually entered into the database. | Reservation (Screen) |
| DayOfWeek | Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday. You can use Filters if needed, from the Filter View. | Reservation (Screen) |
| DeboardingDuration | Duration in minutes between vehicle arrival at dropoff and actual dropoff | ParaScope or Daily Schedule Screen Validation |
| Demand | 1 is Y, 0 is N. Deman Trips are not Recurring Trips, however, are entered on an individual basis. | Reservation (Screen) |
| DenialReason | Denial Reasons are user definable. A user can Deny a Client from the Holding Pen, only, in Daily Schedule. | Master Pages - Deny Service Master |
| DeniedDateTime | When a Client is Denied for any reason, your database captures the time and date stamp. | System |
| DirectDriveDuration | The time our maps calculate it will be to get from point A to point B based on the Geocoded locations. | Reservation (Screen) |
| DirectDriveDurationMinutes | Estimated direct driving duration between pickup and dropoff locations in minutes based on Geocoded locations | Reservation (Screen) |
| DirectDriveDurationOverride | Very Customer Specific. Must be utilizing Hubs or this does not apply. | Master Pages - Site Master |
| DirectMileage | The distance from point A to point B as calculated by our maps. | Reservation (Screen) |
| DirectMileageOverride | In the Reservation Screen, we call this Billing Mileage. This Overrides what was actually calculated by our maps for a Reservation, point A to B. Billing Mileage is imported from several of the brokers we work with. | Reservation (Screen) |
| Disabled | Y or N. This comes from the Special Assistance Master setting for a particular Special Assistance. | Master Pages - Special Assistance Master |
| DropoffAddress1 | The Address a Client is dropped off at. | Reservation (Screen) |
| DropoffAddress2 | Appartment Number, Room Number, Suite, etc. | Reservation (Screen) |
| DropoffArrivalTime | From ParaScope, the Time that the Driver Arrives at the Dropoff. You can also right Click on a Reservation, select Validate - Dropoff to see these times. | ParaScope |
| DropoffArrivalTimeDeviation | Difference in minutes between the scheduled and actual dropoff arrival time | ParaScope or Daily Schedule Screen Validation |
| DropoffCity | Drop Off City | Reservation (Screen) |
| DropoffCode | This is the Procedure Code, sometimes called Site Code or is used for Medicaid Billing. R is for Residence, H is for Hospital, C is for Clinic, etc. | Reservation (Screen) |
| DropoffCounty | Drop off County | Reservation (Screen) |
| DropoffDateTime | Combined date and time of the dropoff event | ParaScope or Daily Schedule Screen Validation |
| DropoffLatitude | Latitude of the dropoff location | Master Pages - Site Master |
| DropOffLatLong | Based on the Geocoded Lat/Long | System |
| DropoffLocationId | Unique Dropoff Location ID | System |
| DropoffLongitude | Longitude of the dropoff location | Master Pages - Site Master |
| DropoffName | What the Unique Site is called | Master Pages - Site Master |
| DropoffPhone | Phone attached to the Site. | Master Pages - Site Master |
| DropoffState | Drop Off State | Master Pages - Site Master |
| DropoffTimeDeviation | The difference between the Schedule Time and Actual Time. Provides a Custom On Time Performance option. | Validation |
| DropoffZip | Drop off Zip | Master Pages - Site Master |
| Duration | How Long the Client Was physically on the Vehicle, based on Validation manually or from ParaScope | Validation - Rider Data |
| EarliestRideDate | The first day a Unique Client Rode for the first time in your database. | System |
| EndOdometer | The Odometer when the Client physically steps off the Vehicle. | Validation - Rider Data |
| FareCollected | The Fare that is either manually entered in Validation - Rider Data or by a Driver using ParaScope | Validation - Rider Data |
| FareExpected | The Fare that shows on the Reservation Screen and is defaulted as the FareCollected in Validation - Rider Data | Reservation (Screen) |
| Fixed | 1 is Y, 0 is N. | Reservation (Screen) |
| HomeLocationId | Unique Site ID for a Home | Master Pages - Site Master |
| InCounty | 1 is Y, 0 is N. | Reservation (Screen) |
| InServiceArea | 1 is Y, 0 is N. | Reservation (Screen) |
| LatestRideDate | The most recent date for a ride, typically reflecting the latest event or ride date available in the data | System |
| LevelOfService | Level of service provided for the ride | Broker API |
| LoadingTime | Difference between the Arrival Time and Actual Time the Ride is Performed from ParaScope. | ParaScope |
| Mobility | Ambulatory, Wheelchair, Stretcher or Lift Required. | Reservation (Screen) |
| NoShowDateTime | Time and Date Stamp for when a No Show Occurred. | ParaScope or Daily Schedule Screen Validation |
| NoShowType | No Client/Not Present, Not Ready, Client Cancel at door Status' | ParaScope or Daily Schedule Screen Validation |
| OnboardingDuration | Duration in minutes between vehicle arrival at pickup and actual pickup | ParaScope or Daily Schedule Screen Validation |
| OnTheWayETA | Time the vehicle was marked as "on the way" to the pickup location | ParaScope |
| OnTheWayTime | For those using the On the Way Feature, as required by MTM (broker), this is the On the Way Time as entered by a Driver using ParaScope. | ParaScope |
| OutOfCounty | In County/Out of County is set at the Reservation level. In is 1, Out is 0. | Reservation (Screen) |
| OutOfServiceArea | In Service Area/Out of Service Area is set at the Reservation level. In is 1, Out is 0. | Reservation (Screen) |
| PickupAddress1 | The Address a Client is Picked Up from. | Reservation (Screen) |
| PickupAddress2 | Apartment Number, Room Number, Suite, etc. | Reservation (Screen) |
| PickupArrivalOdometer | Odometer reading at the time of arrival at the pickup location | ParaScope or Daily Schedule Screen Validation |
| PickupArrivalTime | From ParaScope, the Time that the Driver Arrives at the Pick Up. You can also right Click on a Reservation, select Validate - Pick Up to see and adjust these times. | Reservation (Screen) |
| PickupArrivalTimeDeviation | Time between pickup arrival and job perform | Calculated |
| PickupCity | Pick Up City | Reservation (Screen) |
| PickupCode | This is the Procedure Code, sometimes called Site Code or is used for Medicaid Billing. R is for Residence, H is for Hospital, C is for Clinic, etc. | Reservation (Screen) |
| PickupCounty | Pick Up County | Reservation (Screen) |
| PickupDateTime | Combined date and time of the pickup event | ParaScope or Daily Schedule Screen Validation |
| PickupLatitude | Latitude of the pickup location | Master Pages - Site Master |
| PickupLatLong | Based on the Geocoded Lat/Long | System |
| PickupLocationId | Unique Site ID | System |
| PickupLongitude | Longitude of the pickup location | Master Pages - Site Master |
| PickupName | What the Unique Site is called | Reservation (Screen) |
| PickupPhone | Phone attached to the Site. | Reservation (Screen) |
| PickupState | Pick Up State | Reservation (Screen) |
| PickupTimeDeviation | The difference between the Schedule Time and Actual Time. Provides a Custom On Time Performance option. | Validation |
| PickupZip | Pick Up Zip | Reservation (Screen) |
| PriorityTime | Appointment Time or Priority. | Reservation (Screen) |
| PriorityTimeArrivalDeviation | Difference in minutes between the priority time and the actual arrival time | ParaScope or Daily Schedule Screen Validation |
| PriorityTimeDeviation | Difference in minutes between the priority time and the actual event time, depending on the ride type | ParaScope or Daily Schedule Screen Validation |
| PriorityType | Pickup, Drop Off or Will Call | Reservation (Screen) |
| ProcedureCode | Assigned Automatically depending on Mobility. A0130 for Wheelchair A0120 for Ambulatory, etc. These are Medicaid Codes. | System |
| RequestedDropoffTime | The time requested by the rider for dropoff | Reservation (Screen) |
| RequestedPickupTime | The time requested by the rider for pickup | Reservation (Screen) |
| RideAccountScheduleProfile | Represents the schedule profile associated with the ride account | Reservation (Screen) |
| RideChargeAdjustment | The Account Master has to allow for Ride Charge Adjustment. Ride Charge Adjustment allows for negative and positive values that will influence the billing. | Reservation (Screen) |
| RideComments | Comments about a Ride as entered by an end user. | Reservation (Screen) |
| RideDate | The Date of the Ride/Reservation. | Reservation (Screen) |
| RideID | The Unique Id for a particular Reservation | Reservation (Screen) |
| RideIVRNightBeforeEnabled | Indicates if a reminder call or text the night before was enabled for the ride | Reservation (Screen) |
| RideIVROnTheWayEnabled | Indicates if a reminder call or text when the vehicle was on the way was enabled for the ride | Reservation (Screen) |
| RideMiles | The Actual amount of Miles a Client is on the Vehicle before bieng marked as Rode. | Validation |
| RideProvider | Defaults from a Clients Rider Master, but can be changed on the Reservation Screen. | Reservation (Screen) |
| RidePurpose | Ride Purpose as selected in the Reservation. Purposes can be added in Master Pages - Purpose Master. | Reservation (Screen) |
| RiderAccountExpiration | In Rider Master there is an Account Expiration. When you assign an Account to a Rider, we automatically default the Expiration 10 years into the future, but this can be changed. | Master Pages - Rider Master |
| RiderAccountNumber | In Rider Master you can assign an Account Number to an Account. | Master Pages - Rider Master |
| RiderComments | Rider Comments are entered in Rider Master. These default to always appear on future Rides that are Scheduled for the Rider/Client. | Master Pages - Rider Master |
| RideReminderProfileName | System | |
| RiderID | This is the Unique Rider ID assigned to a Rider anytime you enter a new Client. You can not change this, as it is automatically assigned. | System |
| RideScheduleProfile | Name of the default schedule profile used for the ride | Reservation (Screen) |
| RideStatus | This will show you the Ride Status, Not Validated, Rode, Admin Cancel, No Show, etc. This is a really good Filter to use from the Filter View. | Validation |
| RunDayString | The days of the week that a Fixed, or Subscription, Reservation is set up to Recur. | Subscription Reservations |
| Rural | In the Reservation Screen, there are options for Rural or Urban. If the Reservation is Rural it will show up as a 1 in Custom Reporting. It will show up as a 0 if it is Urban. | Reservation (Screen) |
| ScheduledDropoffHour | The Hour that the Reservation's Drop Off is Scheduled during. This Makes a Really great Filter. | Reservation (Screen) |
| ScheduledDropoffTime | The Scheduled Drop Off Time | Reservation (Screen) |
| ScheduledPickupHour | The Hour that the Reservation's Pick Up is Scheduled during. This Makes a Really great Filter. | Reservation (Screen) |
| ScheduledPickupTime | The Scheduled Pick Up Time | Reservation (Screen) |
| SignatureImage | Image of Client Signatures | ParaScope - Perform Job |
| SignatureImageRaw | The binary format of the image of the signature | ParaScope - Perform Job |
| SpecialAssistancesNeededByRide | Special Assistance Needs as applied to Reservations | Reservation (Screen) |
| SpecialAssistancesNeededByRider | Special Assistance Needs as they exist in Rider Master | Master Pages - Rider Master |
| StartOdometer | The Actual Odometer when the Client gets on board/is performed from ParaScope or can be adjusted in Validation | ParaScope |
| SubscriptionEndDate | Subscription end date, as entered in Subscription Routes | Subscription Routes |
| SubscriptionStartDate | Subscription start date, as entered in Subscription Routes | Subscription Routes |
| SuspendDateBegin | Suspend Date Begin, as entered in Subscription Trips | Subscription Routes |
| SuspendDateEnd | Suspend Date End, as entered in Subscription Trips | Subscription Routes |
| TodaysDate | The current date you are running the report, regardless of the Date Range of the Data you are running the report for | System |
| TotalCharge | The Total charge No matter Overrides, Adjustments, Mileage, Flat Charge, Custom Charges etc. It is the Total charge based on many factors that can weigh in. | Billing |
| TotalCustomCharges | Gives you the Custom Charges vs. the Total Charges | Billing |
| TrackingCode | Each Reservation has a unique Id in your database. This ID is displayed at the top of your Reservation screen. | Reservation (Screen) |
| TripID | Unique TripID that is automatically assigned when you create a Trip. This is not the same as Trip Number. | Trips |
| Units | Units as entered by an end user in Validation - Rider Data, or by a Driver using ParaScope. This does not include Escorts and Children, like several of our canned reports do. Those are separate options. | Validation |
| Urban | In the Reservation Screen, there are options for Rural or Urban. If the Reservation is Urban it will show up as a 1 in Custom Reporting. It will show up as a 0 if it is Rural. | Reservation (Screen) |
| WaitEndTime | Wait End Time as manually entered in Validation - Rider Data | Validation |
| WaitHours | Wait End Time minus Wait Start time as manually entered in Validation - Rider Data | Validation |
| WaitOverrideHours | Wait Override Hours as manually entered in Validation - Rider Data | Validation |
| WaitStartTime | Wait Start Time as manually entered in Validation - Rider Data | Validation |
| WillCall | Inside the Reservation Screen there are 3 options for Priority. These are Pickup, Dropoff and Will Call. Y and N are what will be displayed in Custom Reporting. | Reservation (Screen) |
| WillCallReadyDateTime | From the Holding Pen in Daily Schedule, you can right click and Mark Ready a Client. We capture the Date and Time Stamp for when that occurred. | Daily Schedule |
Join With: Ride Audit - to access ride audit details
Join With: Rider - to access rider details
Join With: Trip - to access trip details
Join With: Individual Charges - to access individual charge details
Join With: Pass Transactions - to access pass transaction details