Overview

This tool combines seat availability information from the backend booking system, staff scheduling information from the backend shift scheduling system and fleet information from the Fleet Manager. This module is only available when a shift scheduling system is connected to PaxFlow (not PaxFlow Users).


Features

  • Preset options for different reports
  • Modifiable look and feel of the data
  • Allows addition or modification of shifts

The table in general

The tool provides various options to see different resource related information. You can use any of the preset options or the positioners to customize the data to be displayed.

Results this table can provide:

  • Departure Availabilities are managed in your backend booking system on a departure base. PaxFlow is able to visualize the seat numbers and gives convenient access to the availability management for each departure. It's also possible to apply color codes.
  • Departure Shifts are managed in your backend shift scheduling system on a position and location base. PaxFlow is able to display shift schedules and make amendments. For departure shifts is a combined view with availabilities and fleet assignment on hand.
  • Non-departure shifts are shifts for the office, pickup and drop-off assistance or field shifts. These can only be displayed in the table.

Setting positioners:

Date Range: This field is used to set the date range corresponding to which the data is to be seen. This widget provides multiple options like Shift default (9 days including the current day), This week, Next 7 days, Year to date etc to set the dates automatically. Additionally, a custom date range can be set here. Set the date range as required and click Apply.

Roles dropdown: When using the table to display human resources, different types of staff can be filtered corresponding to whom the data is to be displayed. For example, if Driver and Guide are selected, then only data corresponding to them will be shown in the grid. The positions in the dropdown are as configured in the General Settings under the Shifts section.

  • Guide: Shift data is displayed when scheduled on a field shift location or a departure shift location
  • Driver: Shift data is displayed when scheduled on a pickup or drop-off assistance shift location or a departure shift location
  • Driverguide: Shift data is displayed when scheduled on a pickup or drop-off assistance shift location or a departure shift location
  • Other: Shift data is displayed when scheduled on an office location

Table style variables: The result is always a combination of two multipliers. For logical reasons are some combinations not possible to display. Other combinations might need positions or result settings to be activated otherwise won't display results.


Multipliers:

  • Departures: Displays the tour-codes of the departures in the selected departure group or the default departure group. Can't be used together with Locations.
  • Days: Displays the dates for the selected date range. In case this is not selected as multiplier or result then the amount of days with data per People (= only available combination in this case as Departures and Locations can't be used together as multipliers) is displayed in the results.
  • People: Displays the staff names for the selected positions with shifts scheduled in the selected date range.
  • Locations: Displays location names for pickup, drop-off, field and office shifts depending on which positions are selected. Can't be used together with Departures.

Result variables:

  • Departures: Does not work in results. Use Times to see departure shifts per Days or People.
  • Days: Works only with People as one multiplier. Lists the dates within the selected Date range on which a shift exists for the staff on selected positions either for Departures or Locations.
  • People: Works only with Days as one multiplier. Lists the staff names with a shift on the selected Days for the positions selected by either Departures or Locations. Shift modifying enables when used with Departures.
  • Locations: Does not work in results. Use Times to see pickup, drop-off, field and office shifts per Days or People.
  • Times: Lists the amount of scheduled shifts by their timing per People, Departures, Locations or Days. Locations and Departures canĀ“t be used together as multipliers.
  • Availabilities: Only works with multipliers Departures and Days. This is the so called "Availabilities table". The bolt number displays the occupied number of seats, the number in the middle is the number of seats currently available to book (total availability reduced by the number of occupied seats) and the last number displays the total availability set in the backend booking system.

Result Settings: The options in this drop-down are applied to the results. Some of the options only work for certain variables and need at least one position to be selected.

  • Show shift timing: Shows the timing of a shift for the displayed locations or departures. Does not work with result variables Times and Availabilities
  • Show availabilities: Shows the availabilities for each departure. Does only work when Departures is a multiplier and does not work with the result variable Availabilities
  • Show assigned tour buses: Shows the assigned tour vehicles from the Fleet Manager. Does only work when Departures is a multiplier and does not work with the result variable Availabilities
  • Show all departures & days: Displays empty columns and rows. Does only work when Departures is a multiplier.
  • Show machine-readable dates: Displays any displayed dates in the format YYYY-MM-DD.
  • Don't repeat headers: Headers are normally repeated after 10 rows. The behavior can be disabled with this option.
  • Departure group selector: Display other departures than the default group set up in the General settings by filtering for certain departures by selecting a departure group.

Refresh: This is used to refresh the caches from the third party shift scheduling system and the backend booking system for the current selection of locations and date range.

Go: This button is used to apply the above discussed fields in the tool and generate a data grid corresponding to the specified inputs.


Preset Shifts and Availabilities Options

Some of the common and use cases of this tool are saved as preset options for the ease of use. The users can click on any of the options, modify the date range, if required and click Go.

All these preset options can be further modified using tool to produce specific data grid results. For example, the view of each of these grids can be modified using the positioners in the tool. To save a certain table setting simply save the URL in your favorites.


Office Overview

  • Position: Other
  • Table style: Locations x Days = People
  • Result settings: Show shift timing

This grid shows the shifts of the office people of the organization across different locations. The locations are as specified in the General Settings, under the Shifts tab. A sample grid with office shifts is as shown below. Use the date range widget to select the dates for viewing the data.

By default, all the locations are listed on the column and the dates on the rows. Use the swap button to change the view. Click on any date to see the details of the departures and the passengers on the date.


Departure Shifts

  • Position: Guide, Driver, Driverguide
  • Table style: Departures x Days = People
  • Result settings: - / -

This grid shows the shifts of guides, drivers and driverguides on different departures for the selected date range. When there are multiple people assigned to a departure, the list of all the people is shown along with their shifts for the departure.

Click on any date to view the list of departures and the list of passengers for the selected date. Click on a departure code to view the details of the associated departure.


Availabilities

  • Position: - / -
  • Table style: Departures x Days = Availabilities
  • Result settings: - / -

This grid is used to display the available seats on different departures during the selected date range. It shows the available number of seats / the total number of seats on the departure.

Color codes can be set up in the general settings to highlight different load factors.


Field Shifts

  • Position: Guide
  • Table style: Locations x Days = People
  • Result settings: Show shift timing

This grid shows the shifts of the field employees. It shows information about the field locations only (set in the Shift settings).


Pickup and Drop-off Shifts

  • Position: Driver, Driverguide
  • Table style: Locations x Days = People
  • Result settings: Show shift timing

This is used to display different pickup and drop-off shifts for employees for the selected days. It shows the drivers and driver guides assigned for pickup along with the shift timings. If a person has multiple pickups assigned for a given day, his name will appear multiple times in the list, one for each of the pickup assignment.

Click a date to view the list of departures and the list of passengers on each departure for the day.


Staff, Vehicles and Availabilities

  • Position: Guide, Driver, Driverguide
  • Table style: Departures x Days = People
  • Result settings: Show availabilities, Show assigned tour buses

This is used to view the vehicles and the staff assigned to different departures during a given time period. It also shows the availability of seats on the departures along with the vehicle and staff information.


Office Timing

  • Position: Other
  • Table style: People x Days = Times
  • Result settings: - / -

This is used to view the shift of only the office employees of the organization across different locations. If an employee is not available on a certain day, the entry would be blank.

Click any day to view the list of departures and the list of passengers on different departures for the day.


Accounting Overview

  • Position: Guide, Driver, Driverguide, Other
  • Table style: People x Days = Times
  • Result settings: Show machine readable dates, Don't repeat headers

This preset option can be used to view all shifts of all the employees of the organization. For a given employee on a selected date, it shows the assigned shift's timing for the employee.


Availability (TV Dashboard orientation)

  • Position: - / -
  • Table style: Days x Departures = Availabilities
  • Result settings: - / -

This is the same data as on the Availability tablet but with the same orientation of columns and rows as you would find on the TV Dashboards.


Did this answer your question?