R2 - Risk Reporting

Safety professionals at UQ include HSW Managers and Work Health and Safety Coordinators (WHSCs) and operate at the Organisational Unit level. WHSCs are required to report on risk assessments within their area of responsibility.

All KPI Risk Data can be found with in UQ Safe R2 Analysis module.

1. Log In to UQ Safe R2.
2. Click Analyse Data

   ​ ​  ​ ​
3. Click custom reports on the far right of the display.
4. Click KPI - Risk Assessment (by OrgCode L "corresponding org level")

   ​ ​  ​ ​

   • Note: You must select the correct org level report.
5. Type the desired OrgCode and click enter.
6. Open the CSV File once downloaded.

Prior to reporting data, you must ensure there are no duplicates and the latest data is reported.

1. Open CSV Document in the excel app.
2. Select the DateSubmitted Cell
3. Click the Sort and Filter button on the top of the page, and select filter.
4. Sort the DateSubmitted column, Oldest to Newest using the dropdown arrow.

   ​ ​  ​ ​
5. Click the Data tab.
6. Select the RiskNumber cell.
7. Click the Remove Duplicates on the top of the page.
8. Click unselect All, and select RiskNumber

   ​ ​  ​ ​

If any of these steps are skipped, risk data will not be correct.

To collect the data efficently use of piviot tables is recommended.

1. Select all risk data.
   • Easiest method is to hold ctrl down and press A on your key board.
2. Click the Insert tab.
3. Click the PivotTable Button on the top of the left page.
4. Click okay.

   ​ ​  ​ ​
5. Select the RiskNumber Field on the far right of the page.
6. Click the Field settings button on the top of the page.
7. Select the Count opton and click okay.

   ​ ​  ​ ​

From this set up the number of risk assessments for certain fields can be determined.

Calculation of the KPI data requires the selection of the relevant field in the pivot table and analysing the results.

Target (Key Performance Indicator): 95% of active Risk Assessments in UQSafe are in review date. 

1. Select the Review Status field on the far right of the page.
2. Calculate the percentage of In-Date records, by dividing the number of In-Date records by the total number of records and multiplying by 100%.

   ​ ​  ​ ​

Target (Key Performance Indicator): 10% of active Risk Assessments in UQSafe are reviewed and verified by the local Safety Team. 

1. Select the IsVerified field on the far right of the page.
2. Calculate the percentage of Verified records, by dividing the number of TRUE records in date by the total number of records and multiplying by 100%.

   ​ ​  ​ ​

Note: clear the previous feild (Review Status or IsVerified) prior to running the data to clarify results.

Multiple factors can reduce KPI results the following are some tips to improve the results using the Pivot table.

Risks no longer relevant

1. When collecting In-Date records, double click the number of Not Assessed OR Late records.
2. Contact the Risk Owner and Approvers to determine if the risk is still relevant.
3. Where a risk is no longer relevant archive the risks
4. Enter the Risk Register on UQ Safe R2.
5. Use the filter to select the risks to be archived.
6. Use the archive option in the commands menu (3 dots).

Inactive Risk Owners and Risk Approvers

1. Select the Risk Owner Active, or the Risk Aprover Active field on the far right of the page.
2. Double click on the number of FALSE records. this will show you wich risks have inactive owners/approvers.
   • Use the list of inactive users to reasign risks to active users within UQSafe.
3. Enter the Risk Register on UQ Safe R2.
4. Use the filter to select the inactive users listed in excel.
5. Using the Business Administrator Management option in the commands menu (3 dots), reassign the risks to active owners/approvers.

The Risk Owner/s and Risk Approver/s (both new and old) should be contacted prior to any changes where possible.

Verification of risks

Where the percentage of Risk Assessments in UQSafe are reviewed and verified by the local Safety Team is less than 10%, the local Safety Team should use the R2 - Risk Assessment Verification Guide to verify more risk assessments.