OR4 Report

OR4 Report is related to TfNSW ODIN Reporting requirements. The report summarizes the total tickets sold by reporting routes grouped by ticket type, passenger type, and the number of sections monthly.

Note
This report is available if your company has paid for the OR4 Report module.
  • Login to Transportme™ Operator Portal.
  • Select Reports tab on the main menu. 
  • Select OR4 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 OR4 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.
  • 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. 
  • PATRONAGE_TYPE. There are 3 patronage types categorised from TfNSW ticket types of ticket sold:
    • ADULT: is linked to Adult Pax ticket type for TfNSW. 
    • CONCESSION: is linked to Concession Pax, PET/RED, School Term Pass, and Red reboard ticket type for TfNSW. 
    • OTHER: is linked to Non Fare Paying Pax ticket type for TfNSW.
  • TICKET_TYPE
    • TfNSW ticket type is defined when a new ticket type is created or you can also edit it later. 
    • This report runs on non daily ticket type. A ticket type can be defined as non daily if Is Daily attribute is not selected when a new ticket type is created or edit

    ticket type screenshot

    • CASH: if the TfNSW ticket type of ticket sold is Adult Pax or Concession Pax and using price per section.
    • RED - Regional Excursion Daily tickets: if the TfNSW ticket type of ticket sold is PET/RED.
    • RED_REBOARD: if the TfNSW ticket type of ticket sold is Red reboard.
    • SSTS: The School Student Transport Scheme - NSW Government. When the driver select the button + Pax Count on the driver app, it will be counted to this type. 
    • SCHOOL_TERM_PASS: if the TfNSW ticket type of ticket sold is School Term Pass.
    • NON_FARE: if the TfNSW ticket type of ticket sold is Non Fare Paying Pax.
  • SECTION
    • It is the number of sections of ticket sold. 
    • NOT_APPLICABLE: when the ticket sold but not using sections. 
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.