OR3 Report

OR3 Report is related to TfNSW ODIN Reporting requirements. The report summarizes the operational performance data by counting number of late or early trips monthly.

Note
This report is available if your company has paid for the OR3 Report module.
  • 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: 

    OR3 report filter screenshot

    • 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. 
  • 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.  

      edit stop screenshot

  • 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 stopIs 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. 

      edit bus screenshot

  • 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 routeEg: Editing Jetty to CHC route as following screenshot.
    • Departing time can be found here

edit route screenshot

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.