Video - How to run a report




RIW Knowledge Centre Article Link:

https://support.riw.net.au/support/solutions/articles/51000077426

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

How does a company run an existing report?


This article details the existing reports function available in the RIW System.


Existing reports include: 

  • Standard reports available in the RIW System based on the logged in user permission.
  • Any saved/scheduled reports that have been created by the user.


Note: To find out what an existing report delivers, please type the existing report name in the RIW Knowledge Centre search.


This instruction applies to the following user roles:

  • Advanced Project Admin
  • Assessor
  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only
  • Helpdesk
  • Network Manager
  • Network Manager - Read Only
  • Project Admin
  • Site Admin
  • Training Provider User


1


Go to https://app.riw.net.au and log in using your credentials. 

2


Click on Reports > Existing Reports.

3


A list of default existing reports will display, as well as any previously created and saved/scheduled reports.  The list may look different to the image below, based on your user permission. 


You can also Edit or Delete any existing reports you have previously saved and scheduled.  Refer to How does a company save and schedule a report? for further information.




4


To run an existing report, click on the Report name from the list.

Follow the onscreen guidance should any further report criteria need to be defined, such as run dates or job role names.

5


Some reports will be displayed immediately on-screen, where you can Export the report to a CSV file. You can also save and schedule the report to run periodically.


Some reports are quite large and do no support an on-screen preview. You can click the Export button immediately to receive the results on email, or save and schedule the report.




Article link:

https://support.riw.net.au/en/support/solutions/articles/51000152821


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

How does a company create a custom report?


This article details how to create a custom report in the RIW System.


This instruction applies to the following user roles:

  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only
  • Helpdesk
  • Network Manager
  • Network Manager - Read Only


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on the Reports tab.


Depending on the permission of the logged in RIW System User, users can either Create Reports or run, schedule or delete an Existing Report. This guide details the process to create a custom report. 


Click on Create Report.


3


On the Report Tables page, click on the + symbol to expand the table selection. Place a check in the required fields you wish to report, noting a maximum of 3 tables can be selected.  


Click Continue.



4


On the Report Columns page, select the columns required for the report, up to a maximum of 20 columns. To access more columns, click on the Show All Columns hyperlink. Click Continue when all columns have been selected.



5


The Report Filters page also allows the results to be filtered, or to apply logic and run time filters, such as equal to, not equal to, contains, does not contain and has value.


You can also filter the report by Employment Relationship:

 

The ellipsis button (three dots in the square as pictured below) can be selected to further refine reports with a True or False value, or the name of the value you wish to report on. 



Note: A maximum number of 5 filters in each table row in a custom report can be used when using the ellipsis, or through adding additional filters using the green cross, which represents additional parameters.


To alter the report’s final structure, drag the arrows in the left column up or down to change the order in which the results will be displayed. 




If the report is intended to be a saved report (completed in the next step), the Set Value at Runtime can be entered before continuing, which will allow certain data filters to be set only at the point of running the report.


Click Continue when complete.


6


Once the report has been generated, it can be viewed on screen or exported as a comma separated value (CSV) file by clicking on Export. 

To ensure the integrity of the RIW System when generating larger reports, the export function may result in the report being processed offline and a link being emailed to you.




You can also choose to Save the report.


7


On the Save Report screen, enter the Name of the report and click Save.



8


You can also choose the Enable Scheduling, which will allow the saved report to run at set times. The report can be emailed to any user (not just those with RIW System access).

Enter the Start Date and End Date, the Repeat Task Every x Days/Months/Weeks and the email list.


If emailing a report to more than one recipient, please seperate the email address with a comma.



When the report is generated, a link to download the report will be sent to recipients.



Article link:

https://support.riw.net.au/support/solutions/articles/51000031691


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

How does a company save and schedule a report?


This article details how you can schedule an existing or custom report to be run and sent to defined contacts.


For more information about how to run a report, refer to:


This instruction applies to the following user roles:

  • Advanced Project Admin
  • Assessor
  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only
  • Helpdesk
  • Network Manager
  • Network Manager - Read Only
  • Project Admin
  • Site Admin
  • Training Provider User



1


Go to https://app.riw.net.au and log in using your credentials. 

2


Go to Reports.


Depending on your user permission, you may be able to create a new report or only run existing reports. The save and schedule function works for both creating reports and existing reports.

3


Go to Existing Reports.


A list of default existing reports will display, as well as any previously created and saved/scheduled reports.  The list may look different to the image below, based on your user permission. 


You can also Edit or Delete any existing reports you have previously saved and scheduled. 


4


When you run any report, once displayed you will be able to save and schedule the report. In the below example, we are running the Expiring Competencies Report with a run date filter of 30 days plus and minus.

After you Run Report and the details are displayed, click Save.


On the Save Report screen, you must give the report a new name. If you do not want to schedule the report, you can just click Save now.


To schedule the report, tick the Enable Scheduling box, and further fields will appear.


You can set the Start Date and End Date (when you want the report to start and end running), Repeat Task Everyx Days/Weeks/Months, Format(CSV only), and whether it needs to be emailed to others.


Email recipients do not need to be RIW System users.

Click on Save when complete.

5


The report will now run as per the schedule. At any time you can click on Edit or Delete to adjust the saved report.


Article link:

https://support.riw.net.au/support/solutions/articles/51000152653




Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

How can a company report on Breathalyser test records?


This article details how a company can report on Breathalyser test records in the RIW System.


Note: The result of breathalyser tests are not recorded in the RIW System. A non-negative breathalyser test will result in the placement of an immediate site block, however, this result must be confirmed with a secondary alcohol test.


This instruction applies to the following user roles:

  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only
  • Helpdesk


1


Go to https://app.riw.net.au and log in using your credentials.


2


Go to Reports > Custom Report.

3


On the Report Tables screen, click the + symbol next to People to expand the list, and then place a tick in People and Breathalyser. Click Continue.



4


On the Report Column screen, choose the Rail Industry Worker columns you wish to display in the People section by placing a tick in each column.  Click Show All Columns to reveal more reporting columns in this area.

In the Breathalyser section, click on the required columns to display.

Click Continue.



5


On the Report Filters screen, click the ellipsis (three dots) on Breathalyser Test Status, and choose Breath alcohol test completed. You can also add additional filters required, or Set Value at Runtime? if you wish to schedule the report to run periodically. Refer to How does a company save and schedule a report? for more information on this feature.

Click Continue.

6


The report will now display on screen and show all breathalyser tests conducted. You can Export the file immediately to a CSV file, or Save the file for later reference.




Article link:

https://support.riw.net.au/support/solutions/articles/51000029656

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

How does a company monitor expiries?


The RIW System monitors the expiry dates of competencies, RIW cards, medicals, additional medical information, allocated items, worker (cardholder) subscriptions and ID checks.


This instruction applies to the following user roles: 

  • Advanced Project Admin
  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only
  • Helpdesk



1


Go to https://app.riw.net.au and log in using your credentials.


2


Click on the Expiries menu.


3


On the left-hand menu, click on the item you wish to view: competencies, cards, medicals, additional medical information, allocated items, worker subscriptions or ID checks.


Choose to Show All, Show Forthcoming, or Show Expired by clicking on the appropriate radio button and clicking Search.


If clicking Show All, the following colour legend will display the status of expiries:

  • Items expiring soon are identified in AMBER. 
  • Items already expired are identified in RED.
  • Show all - for worker subscriptions menu only, all subscriptions are displayed even when not expired to help manage / schedule subscription renewals.  These are identified in BLACK.



On most screens you can click on a line item and Edit, which will take you to the relevant item on the Rail Industry Worker profile for update.

You can also Export the data to a *.CSV file for further interrogation.


For more information on how each of these expiry menus work, you can view the following articles:


To further monitor or report on expiring items, consider running a custom report.


Article Link:

https://support.riw.net.au/support/solutions/articles/51000030483


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Virtual Card Uptake Report?


This article provides an overview of Virtual Card Uptake Report, which is available as an RIW System existing report.


The report lists all cardholders who have a relationship with company, including primary, secondary and associated cardholders, and whether they have a virtual RIW card loaded to their Vircarda wallet.


For more information about how to issue a virtual RIW card, please refer to How does a company order or reorder a physical or virtual RIW card?



This instruction applies to the following user roles:

  • Advanced Project Admin
  • Employer Admin
  • Helpdesk



1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > Virtual Card Uptake Report.

3


The report will immediately display on screen. 


The report details all cardholders that have a relationship with the user, including the cardholders name, RIW number, employment relationship, whether a virtual RIW card is loaded to the Vircarda wallet, date loaded to the wallet, and the cardholders primary employer.




4


If required, the report can be exported to a CSV file by clicking on the Export button.  The following Export Report pop-up will appear, advising the report has been queued.  The report will be emailed to you.  


Click OK to proceed.


5


You can also save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.




Article link:

https://support.riw.net.au/support/solutions/articles/51000170875



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Card Application Progress Report?


This article provides an overview of the Card Application Progress Report, which is available as an RIW System Existing Report.


The report displays all cards applied for in a defined period, their production status and delivery details.


This instruction applies to the following user roles:

  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > Card Application Progress Report.

3


On the Card Application Progress Report screen, enter in the Issue Date From and Issue Date To to return results for cards applied between two dates (mandatory). You can also choose a Fixed Date for both fields, or if you want to save and schedule the report, a Run Date Plus or Run Date Minus filter can be applied.  


Click on Run Report.



4


On the Card Application Progress Report screen, enter in the Issue Date From and Issue Date To to return results for cards applied between two dates (mandatory). You can also choose either a Fixed Date for both fields, or if you want to save and schedule this report, then a Run Date Plus or Run Date Minus filter can be applied.  Click on Run Report button when complete.



5


The report will immediately display on screen. 

The report will display:
  • First Name
  • Surname
  • RIW Number
  • Production Status
  • Issue Date (UTC time)
  • Issue No
  • Print Date
  • Created By
  • Requested by Employer
  • Delivery Address Name
  • Delivery Address Line 1
  • Delivery Address Line 2
  • Suburb
  • State
  • Postcode


6


If required, the report can be exported to a *.CSV file by clicking on the Export button.  The following Export Report pop-up will appear advising the report has been queued.  The report will be emailed to you.  


Click OK to proceed.




7


You can also save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.


Article link:

https://support.riw.net.au/support/solutions/articles/51000176533

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Next Key Expiry Report for Valid Job Roles report?


This article provides an overview of the Next Key Expiry Report for Valid Job Roles report, which is available as an RIW System existing report. This report can be used to view when a job role is coming up for expiry and what is expiring.


The report allows employers to monitor the upcoming expiry of a job role based on when the next competency, rail health (medical) assessment, drug and/or alcohol assessment, or other medical information is due to expire within that valid job role for their employed and associated Rail Industry Workers. The results can be filtered by job role name or left blank for an entire workforce view.


This instruction applies to the following user roles:

  • Advanced Project Admin
  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only
  • Helpdesk


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports.

3


A list of default reports will appear.  Click on Next Key Expiry Report for Valid Job Roles.


Note: The Reports List displayed below may be different to the Report List surfaced for user depending on their permission.



4


On the Next Key Expiry Report for Valid Job Roles Report screen, enter a specific job role or simply leave the field blank to capture all next key expiry dates for your workforce.  Click Run Report.



The report will not display on screen if there is a high volume of data. If this is the case, the following additional options will display, allowing you to Export the file as a *.CSV or to save the file, which will allow you to schedule the report.



5


The report will display:

  • First Name
  • Surname
  • RIW Number
  • Date of Birth
  • Relationship (Primary Employer, Secondary Employer, Associated, Swipe)
  • Primary Contact First Name
  • Primary Contact Surname
  • Primary Contact Email
  • Cost Centre
  • Job Role Name
  • Job Role Owner
  • Is Job Role Assessable
  • Next Key Expiry Date
  • Next Key Expiry Item (which could be a competency, rail health (medical) assessment, additional medical item, drug test pass, alcohol test pass)

6



You can also save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.



Article link:

https://support.riw.net.au/support/solutions/articles/51000259075

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the ARTC Protection Officer Profile Changes report?


This article provides an overview of the ARTC Protection Officer Profile Report, which is available as an RIW System Existing Report.


The report will display any changes to a Rail Industry Worker who holds the following job role(s):

  • ARTC - Protection Officer Level 1 – NSW
  • ARTC - Protection Officer Level 2 - NSW
  • ARTC - Protection Officer Level 3 – NSW
  • ARTC - Protection Officer Level 4 - NSW


This will allow you to view if an ARTC Protection Officer has been blocked or suspended, or if their competencies, job roles or rail health (medical) assessment has expired within a defined period.


Note: While this report is available to all Network Manager user roles, you will only be able to access data your Network has permission to view.


This instruction applies to the following user roles:

  • Network Manager
  • Network Manager - Read Only


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > ARTC Protection Officer Profile Report.

3


On the ARTC Protection Officer Profile Report screen, enter in the From Date and To Date. You can choose a Fixed Date for both fields, or if you want to save and schedule this report, a Run Date Plus or Run Date Minus filter can be applied.  

Click on Run Report.

4


The report will immediately display on screen. 


The report will display:

  • First name
  • Surname
  • RIW Number
  • Job Role Is Currently Valid
  • Job Role Name
  • Competency Status Change
  • Competency Name
  • Competency Award Date
  • Competency Expiry Date
  • Competency Verification Date
  • Competency Currently Suspended
  • Job Role Currently Suspended
  • Job Role Suspension Reason
  • Block Status Change
  • Block Type
  • Block Reason
  • Date Block Placed
  • Date Block Lifted 
  • Current Medical Level
  • Medical Examination Date
  • Medical Expiry Date
  • Current AHP Work Restriction


5


If required, the report can be exported to a CSV file by clicking on the Export button.  The following Export Report pop-up will appear, advising the report has been queued.  The report will be emailed to you.  


Click OK to proceed.



6


You can also save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.


Article link:

https://support.riw.net.au/support/solutions/articles/51000310155



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Permission Access Agreement Report For Employer Admin Report?


This article provides an overview of the Permission Access Agreement Report for Employer Admin available as an existing report in the RIW System.


The report will display the Permission Access Agreement (PAA) approval status for primarily employed Rail Industry Workers.


This instruction applies to the following user roles:

  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > Permission Access Agreement Report for Employer Admin.

3


The report will automatically display on screen with the following fields:
  • Rail Industry Worker First Name
  • Rail Industry Worker Surname
  • RIW Number
  • Date of Birth
  • Rail Industry Worker Email Address
  • PAA Status



4


If required, you can export the report to a *.CSV file by clicking on the Export button.  The following Export Report pop-up will appear advising the report has been queued, which will be emailed to you. 


Click OK to proceed.



5


You can also Save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.


Article link:

https://support.riw.net.au/support/solutions/articles/51000310180




Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Company Contact Report?


This article details how to run the Company Contact Report in the RIW System.


The report provides the employer name and primary contact for all Rail Industry Workers that have a current relationship with the Network or Project.


This instruction applies to the following user roles:

  • Advanced Project Admin
  • Network Manager
  • Network Manager - Read Only
  • Project Admin


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > Company Contact Report.

3


On the Company Contact Report screen, the report will automatically display.

If the data set returned is large, you may be prompted to Export the report which will be emailed to you.



4


The report will display:
  • Employer Name
  • Contact Name
  • Contact Email
  • Contact Phone Number



5


If required, the report can be exported to a *.CSV file by clicking on the Export button.  The following Export Report pop-up will appear advising the report has been queued.  The report will be emailed to the user.  

Click OK to proceed.




6


You can also save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.


Article link:

https://support.riw.net.au/support/solutions/articles/51000310159



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Expiring Competencies Report?


This article details how to run the Expiring Competencies Report in the RIW System.


The report lists competencies due to expire for a worker who has a current relationship with the company. Filters can be applied to the report to display competencies expiring between a date range or to workers who belong to part of a crew. The results can be filtered once exported by competency name or date range or left blank for an entire workforce view.


This instruction applies to the following user roles:

  • Advanced Project Admin
  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only
  • Project Admin
  • Site Admin


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > Expiring Competencies Report.

3


On the Expiring Competencies Report screen, enter the From Date and To Date to be queried.  You can elect either a Fixed Date for both fields, or if you choose to save and schedule this report, then a Run Date Plus or Run Date Minus filter can be applied.   You can also filter by Crew Name if required.

Click Run Report.


If the data set is small, the report will immediately display on screen.  If the data set is large, you may be prompted to Export the report which will be emailed to you.



4


The report will display:
  • Rail Industry Worker First Name
  • Rail Industry Worker Surname
  • Rail Industry Worker Number
  • Competence Name
  • Competence Category
  • Competence Network Name
  • Competence Employer Name
  • Competence Project Name
  • Competence Site Name
  • Competence Zone Name
  • Individual Award Date
  • Individual Expiry Date
  • Is Suspended
  • Crew Name
  • Employer Name
  • Cost Centre



5


If required, the report can be exported to a *.CSV file by clicking on the Export button.  The following Export Report pop-up will appear advising the report has been queued.  The report will be emailed to the user.  

Click OK to proceed.


6


You can also save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.


Article link:

https://support.riw.net.au/support/solutions/articles/51000310163



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Individual Job Role Report?


This article details how to run the Individual Job Role Report in the RIW System.


The report lists the competency requirements to fulfil a job role in the RIW System.  The results can be filtered by a particular job role name, or left blank for all job roles in the RIW System.


This instruction applies to the following user roles:

  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only
  • Helpdesk
  • Network Manager
  • Network Manager - Read Only


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > Individual Job Role Report.

3


On the Individual Job Role Report  screen, enter the Job Role Name to be queried and click Run Report.


If the data set is small, the report will immediately display on screen.  If the data set is large, you may be prompted to Export the report which will be emailed to you.



4


The report will display:
  • Job Role Name
  • Competency Name
  • Required Group
  • Competency Category
  • Job Role Owner


The Required Group column will show whether:

  • all the competencies in one (or more) groups are required 
  • only one of multiple competencies in one or more groups are required 




5


If required, the report can be exported to a *.CSV file by clicking on the Export button.  The following Export Report pop-up will appear advising the report has been queued.  The report will be emailed to the user.  

Click OK to proceed.




6


You can also save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.


Article link:

https://support.riw.net.au/support/solutions/articles/51000310167



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Job Role Validity Report?


This article details how to run the Job Role Validity Report in the RIW System. This report can be used to view the job role validity of your workforce.


The report lists the validity of job roles for all workers with a relationship with the employer, project or site (depending on the user's permission), and if the role is valid or invalid for the role(s) on their profile. If they are invalid, the report lists the missing or invalid competencies affecting the validity. The results can be filtered once exported by job role name or left blank for an entire workforce view.


This instruction applies to the following user roles:

  • Advanced Project Admin
  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only
  • Project Admin
  • Site Admin


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > Job Role Validity Report.

3


On the Job Role Validity Report screen, click Run Report.

If the data set is small, the report will immediately display on screen.  If the data set is large, you will be prompted to Export the report which will be emailed to you.




4


The report will display:

  • Rail Industry Worker First Name
  • Rail Industry Worker Surname
  • Rail Industry Worker Number
  • Job Role Name
  • Required Medical Level Held
  • Required Alcohol Test Pass Held
  • Required Drug Test Pass Held
  • Required Additional Medical Information Held
  • Job role owner
  • Assessment Status
  • Relationship
  • Pegasus ID
  • Date of Birth
  • Worker Subscription Expiry Date
  • Valid 
  • Missing or Invalid Competencies
  • Cost Centre
  • Current Project
  • Primary Employer
  • Crew Name *
  • Crew Project *


* Only viewable by Advanced Project Admin, Project Admin, Site Admin and Employer Admin (where designated as Contractor in Charge)




5


If required, the report can be exported to a *.CSV file by clicking on the Export button.  The following Export Report pop-up will appear advising the report has been queued.  The report will be emailed to the user.  

Click OK to proceed.




6


You can also save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.



Article link:

https://support.riw.net.au/support/solutions/articles/51000310169



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Job Role Validity Report for Network Operators?


This article provides an overview of Job Role Validity Report for Network Operators, which is available as an RIW System existing report.  This report can be used to view the job role validity of your workforce.


The report lists the validity of job roles for all workers with a relationship with the Network and if the role is valid or invalid for the role(s) on their profile. If they are invalid, the report lists the missing or invalid competencies affecting the validity. The results can be filtered once exported by job role name or left blank for an entire workforce view.


 This instruction applies to the following user roles:

  • Network Manager
  • Network Manager - Read Only



1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > Job Role Validity Report for Network Operators.

3


On the Job Role Validity Report for Network Operator screen, enter the Job Role Name to be queried and click Run Report.


If the data set is small, the report will immediately display on screen.  If the data set is large, you will be prompted to Export the report which will be emailed to you.



4



The report will display:

  • Rail Industry Worker First Name
  • Rail Industry Worker Surname
  • Rail Industry Worker Number
  • Rail Industry Worker's Primary Employer
  • Job Role Name
  • Required Medical Level Held
  • Required Alcohol Test Pass Held
  • Required Drug Test Pass Held
  • Required Additional Medical Information Held
  • Assessment Status
  • Rail Industry Worker Subscription Expiry Date
  • Job Role Is Valid (True / False)
  • Valid Competencies
  • Missing or Invalid Competencies




5


If required, the report can be exported to a *.CSV file by clicking on the Export button.  The following Export Report pop-up will appear advising the report has been queued.  The report will be emailed to the user.  

Click OK to proceed.




6


You can also save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.



Article link:

https://support.riw.net.au/support/solutions/articles/51000310171



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Next Key Expiry Report For Valid Job Roles for Network Operator?


This article details how to run the Next Key Expiry Report for Valid Job Roles for Network Operators in the RIW System. This report can be used to view when a job role is coming up for expiry and what is expiring. 


The report allows a Network to monitor the upcoming expiry of a job role based on when the next competency, rail health (medical) assessment, drug and/or alcohol assessment, or other medical information is due to expire within that valid job role for workers who have a swipe or rail corridor access job role relationship with the Network Operator.  The results can be filtered by job role name or left blank for an entire workforce view.


This instruction applies to the following user roles:

  • Network Manager
  • Network Manager - Read Only


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > Next Key Expiry Report for Valid Job Roles for Network Operator.

3


On the Next Key Expiry Report for Valid Job Roles for Network Operator screen, enter the specific Job Role Name to be queried and click Run Report.

Alternatively, leaving the Job Role Name blank will return the job role validity of all Rail Industry Worker's with a current relationship with the Network Operator.


This report does not support an on-screen preview, so you will be prompted to Export the report which will be emailed to you.



4


The report will return:
  • Rail Industry Worker First Name
  • Rail Industry Worker Surname
  • Rail Industry Worker Number
  • Date of Birth
  • Primary Employer Name
  • Primary Contact First Name
  • Primary Contact Surname
  • Primary Contact Email
  • Cost Centre
  • Job Role Name
  • Job Role Owner
  • Is Job Role Assessable
  • Next Key Expiry Date
  • Next Key Expiry Item

5


You can also save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.


Article link:

https://support.riw.net.au/support/solutions/articles/51000310173



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Outstanding Worker 100pt ID Check Report?


This article details how to run the Outstanding Worker 100pt ID Check Report in the RIW System.


The report lists the ID check status for all primary employees managed by a company.


This instruction applies to the following user roles:

  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only
  • Helpdesk


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > Outstanding Worker100pt ID Check.

3


On the Outstanding Worker100pt ID Check screen, the report will automatically display.

If the data set returned is large, you may be prompted to Export the report which will be emailed to you.



4


The report will display
  • Rail Industry Worker First Name
  • Rail Industry Worker Surname
  • Rail Industry Worker Number
  • Current IDCheck Status
  • IDCheck Submitted Date
  • IDCheck Created By
  • Employer Name


 

5


If required, the report can be exported to a *.CSV file by clicking on the Export button.  The following Export Report pop-up will appear advising the report has been queued.  The report will be emailed to the user.  

Click OK to proceed.




6


You can also save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.


Article link:

https://support.riw.net.au/support/solutions/articles/51000310174




Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Pegasus ID Report?


This article provides an overview of the Pegasus ID Report available as an existing report in the RIW System.


The report will display the Pegasus ID Number (previous RIW System service provider), mapped to the current RIW Number.



This instruction applies to the following user roles:

  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only
  • Helpdesk


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > Pegasus ID Report.

3


The report will automatically display on screen with the following fields:
  • RIW Number
  • Pegasus ID


4


If required, you can export the report to a *.CSV file by clicking on the Export button.  The following Export Report pop-up will appear advising the report has been queued, which will be emailed to you. 


Click OK to proceed.




5


You can also save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.


Article link:

https://support.riw.net.au/support/solutions/articles/51000310176



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the People Who Swiped Into Site Report?


This article provides an overview of the People Who Swiped Into Site Report available as an existing report in the RIW System.


The report will display all Rail Industry Worker's and visitors who swiped into a site between two defined dates.


This instruction applies to the following user roles:

  • Advanced Project Admin
  • Project Admin
  • Site Admin


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > People Who Swiped Into Site Report.

3


On the People Who Swiped Into Site Report screen, enter the From Date and To Date and the Site Name. If you choose to save and schedule this report, you can use a Run Date Plus/Minus filter on the From/To Date.

Click Run Report.



4


The report will display onscreen with the following fields:
  • First Name
  • Surname
  • RIW Number
  • Visitor Pass Number (if applicable)
  • Swipe Date/Time
  • Site Name

5


If required, you can export the report to a *.CSV file by clicking on the Export button.  The following Export Report pop-up will appear advising the report has been queued, which will be emailed to you. 


Click OK to proceed.




6


You can also Save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.


Article link:

https://support.riw.net.au/support/solutions/articles/51000310177



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Person Role Competency Status Matrix Report?


This article provides an overview of the Person Role Competency Status Matrix Report available as an existing report in the RIW System.


The report will surface the competency validity status for a defined Rail Industry Worker.


This instruction applies to the following user roles:

  • Advanced Project Admin
  • Employer Admin
  • Project Admin
  • Site Admin


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > Person Role Competency Status Matrix Report.

3


On the Person Role Competency Status Matrix screen, enter the RIW Number of the worker you wish to display and Run Report.


The report will automatically display on screen with the following fields:
  • Rail Industry Worker First Name
  • Rail Industry Worker Surname
  • RIW Number
  • Job Role Name
  • Competency Name
  • Competency Status 
  • Crew Names
  • Required Medical Level Held
  • Required Alcohol Test Pass Held
  • Required Drug Test Pass Held
  • Required Additional Medical Information Held
  • Valid
  • Cost Centre



4


If required, you can export the report to a *.CSV file by clicking on the Export button.  The following Export Report pop-up will appear advising the report has been queued, which will be emailed to you. 


Click OK to proceed.




5


You can also Save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.


Article link:

https://support.riw.net.au/support/solutions/articles/51000310182



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Primary Employed Workers Report?


This article provides an overview of the Primary Employed Workers Report available as an existing report in the RIW System.


The report will surface all Rail Industry Workers primarily employed by the company, and their contact details.


This instruction applies to the following user roles:

  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > Primary Employed Workers Report.

3


The report will automatically display on screen with the following fields:
  • Rail Industry Worker First Name
  • Rail Industry Worker Middle Name
  • Rail Industry Worker Surname
  • RIW Number
  • Date of Birth
  • Mobile Number
  • Email Address
  • Pegasus ID
  • Cost Centre



4


If required, you can Export the report to a *.CSV file by clicking on the Export button.  The following Export Report pop-up will appear advising the report has been queued.  The report will be emailed to you.  


Click OK to proceed.




5


You can also Save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.


Article link:

https://support.riw.net.au/support/solutions/articles/51000310184



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

What is the Role Library And Corresponding Competency Grouping Report?


This article provides an overview of the Role Library and Corresponding Competency Group Report available as an existing report in the RIW System. This report would be used if you need to view what competency requirements make up a job role.


The role library includes all job roles in the RIW System and their corresponding competency requirements.  A job role can include groups of competencies where all of the competencies are required, or one in a group are required.


This instruction applies to the following user roles:

  • Advanced Project Admin
  • Assessor
  • Employer Admin
  • Employer Admin - No Payment
  • Employer Admin - Read Only
  • Helpdesk
  • Network Manager
  • Network Manager - Read Only
  • Project Admin
  • Site Admin
  • Training Provider User


1


Go to https://app.riw.net.au and log in using your credentials.

2


Click on Reports > Existing Reports > Role Library And Corresponding Competency Grouping Report.

3


On the Role Library And Corresponding Competency Grouping Report screen, you can either:
  • Run Report to receive all job roles and their corresponding competencies.
  • Enter a Job Role Name to receive only the defined job role corresponding competencies. Click Run Report.



4


The report will display:

  • Job Role Name
  • Job Role Is Active
  • Competency Name
  • Competency code
  • Required Group
  • Competency Category
  • Competency is Awardable
  • Job Role Owner



Advice on how to read the Required Group column
  • If the competency has Required noted in this column, the competency is required to fulfil the job role.
  • If the competency has a Group{x} noted in this column, then one competency in the listed Group is required to fulfil the job role.

5


If required, the report can be exported to a *.CSV file by clicking on the Export button.  The following Export Report pop-up will appear advising the report has been queued.  The report will be emailed to the user.  

Click OK to proceed.




6


You can also save and schedule the report to be run periodically.  Refer to How does a company save and schedule a report? for more information.


Article link:

https://support.riw.net.au/support/solutions/articles/51000310186



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.