OR8 Report
OR8 Report is related to TfNSW ODIN Reporting requirements. The report summarizes the total tickets sold in different time of the day grouped by ticket types and route types. Note : This report is available if your company has paid for the OR8 Report module. |
- Login to Transportme™ Operator Portal.
- Select Reports tab on the main menu.
- Select OR8 Report tab on the side menu
- Filter data before generating the report:
- Include Historical Data: select this option to be able to search the deleted data.
- All Route:
- Select this checkbox to run the report for eligible routes in the system.
- Deselect this checkbox to be able to filter data by Route Categories and Routes.
- Route Category (mandatory): one or more route categories can be picked.
- Routes can be picked from selected route categories dropdown list added.
- Date Range-From and Date Range-To (mandatory): select the duration you wanted to generate the data.
- Select Export ODIN Report button to save the report as a CSV on your local storage.
Example of OR8 Report result:
Data description:
- CONTRACT_CODE
- This column is empty, if the contract is not selected from the filters.
- REPORTING_PERIOD
- It is the MONTH(s) of reporting data range.
- Eg: Date Range is from 01/11/2022 to 07/11/2022 then the REPORTING_PERIOD is 2022-11; Date Range is from 12/10/2022 to 07/11/2022 then the REPORTING_PERIOD is 2022-10 and 2022-11.
- TIME_OF_DAY: time of day is calculated based on the end time of reporting routes.
- WEEKDAY_AM: routes that ended from 6am to 10am weekday.
- WEEKDAY_PM: routes that ended from 3pm to 7pm weekday.
- WEEKDAY_OTHER: routes that ended different weekday time of WEEKDAY_AM or WEEKDAY_PM.
- WEEKEND_PUBLIC_HOLIDAYS: routes that ended on Saturday, Sunday or defined public holidays.
- ADULT_CONCESSION_TICKET: the ticket sold is counted to this column if its TfNSW ticket type is Adult Pax or Concession Pax.
- SSTS_ON_ROUTE_SERVICES: the number of passengers on board of Planned Timetabled Routes without tickets - the drivers count the passengers by tapping Pax Count + on the trip screen of Driver app.
- SSTS_ON_SCHOOL_SERVICES: the number of passengers on board of Dedicated School Routes without tickets - the drivers count the passengers by tapping Pax Count + on the trip screen of Driver app.
- RED: the ticket sold is counted to this column if its TfNSW ticket type is PET/RED or Red reboard.
- NON_FARE: the ticket sold is counted to this column if its TfNSW ticket type is Non Fare Paying Pax.
- Note:
- TfNSW ticket type is defined when a new ticket type is created or you can also edit it later.
- Route type is defined when creating a new route or editing an existing route.