OR3 Report

• Login to Transportme™ Operator Portal.
• Select Reports tab on the main menu. 
• Select OR3 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 CSV button to save the report as a CSV on your local storage. 

Example of OR3 Report result: 

Data description: 

• CONTRACT_CODE: 
  • This column is empty, it is not extracted from the system. Operator may need to enter the contract code manually.
  • For Rural and Regional NSW operators, where the contract code is available (has been populated by the bus operator in route information) this information can be shown in the report. 
• 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. 
• ROUTE_ID: It is extracted from Route Name/Number of reporting routes - Note: Routes will be combined by this value, example, if you have two routes with a Route Name/Number of XX all of their data will be combined for all OR reports.
• ROUTE_DESCRIPTION: It is extracted from Route Description for Reporting of reporting routes. 
• PLAN_TIMETABLE_TRIPS: the total number of planned trips of reporting routes in reporting month(s) based on their Trips Per Day M-F Term, Trips Per Day M-F Hols, Trips Per Day Sat, Trips Per Day Sun and Trips Per Day Public Hol. 
• INCOMPLETE_TRIPS: 
  • Number of trips were incomplete ended on the Driver app of reporting routes in reporting months. 
  • Note: the driver can only end a route as an incomplete route if your company paid for Cancelled/Incomplete Trip module. 
• CANCELLED_TRIPS: 
  • Number of trips were cancelled on the Driver app of reporting routes in reporting months. 
  • Note: the driver can only end a route as a cancelled. route if your company paid for Cancelled/Incomplete Trip module. 
• TRIPS_EARLY_START: the value is always 0. 
• TRIPS_LATE_START: the value is always 0. 
• TRIPS_EARLY_MID_POINT: 
  • Number of mid point stops that the bus arrived earlier than their configured departure times. 
  • Conditions to be counted in this column: 
    • The routes need to select On Time Running feature. 
    • The mid point stops need to have Departing time to be checked for this point. 
• TRIPS_LATE_MID_POINT: 
  • Number of mid point stops that the bus arrived late compared to their configured departure times. 
  • Conditions to be counted in this column: 
    • The routes need to select On Time Running feature. 
    • The mid point stops need to have Departing time to be checked for this point. 
• TRIPS_LATE_END_POINT: the value is always 0. 
• TRIPS_LATE_TRAIN: the value is always 0. 
• FULL_SERVICES: the value is always 0. 
• SCHOOL_ARRIVE_EARLY_BELLTIME: 
  • Number of school stops that the bus arrived earlier than their configure bell times. 
  • Conditions to be counted in this column: 
    • The routes need to be Dedicated School Route (Route Type) 
    • The stop is set as a school stop - Is School is selected.  

    

• SCHOOL_ARRIVE_LATE_BELLTIME:
  • Number of school stops that the bus arrived late compared to their configure bell times. 
  • Conditions to be counted in this column: 
    • The routes need to be Dedicated School Route (Route Type) 
    • The stop is set as a school stop - Is School is selected.  
• SCHOOL_DEPART_LATE_BELLTIME:
  • Number of school stops that the bus departed late compared to their configure bell times. 
  • Conditions to be counted in this column: 
    • The routes need to be Dedicated School Route (Route Type) 
    • The stop is set as a school stop - Is School is selected. 
• TIMETABLED_ACCESSIBLE: 
  • Number of timetable accessible routes that were started on a bus provide wheelchair accessibility. 
  • Conditions to be counted in this column: 
    • Timetabled Accessible Service option is selected on the routes. 
    • Routes were started on the bus has wheelchair. 

    

• INCOMPLETE_CANCELLED_ACCESS: the value is always 0. 
• Note: 
  • Above route information can be assigned to a route when a new route is created or edit an existing route. Eg: Editing Jetty to CHC route as following screenshot.
  • Departing time can be found here.