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