Delegated local government employees can view claims using Qlikview. There are separate Qlikview applications for workers’ compensation, property and liability, and general claims.
This guide will focus on the workers’ compensation platform (therefore claims under the LGIS WorkCare Scheme portfolio).
To access Qlikview, please visit our website www.lgiswa.com.au, You need a member login to access this area of the website (if you do not have a login please select the ‘create account’ button and fill in the necessary requirements and submit). To view your claims profile, select claims and then “View your claim profile”. The dashboard shows a brief overview of total claims over a period of time while detailing their current status.
This tab provides a full breakdown of all claims. You can only access claims history from the date your local government joined the WorkCare Scheme – anytime from 1996 onwards. Please note that data will be reflective of any filters you have applied.
This tab shows you the different types of claimant injuries within your local government. Within this section, you have several subtabs:
Within these subtabs, you can also filter to look at data broken down into the following categories:
This tab looks at your Lost Time Injury (LTI) data, such as how much time claimants spend away from work due to their injury.
Within this section, you have several subtabs:
It is important to note that LTI data will only be accurate if the wages have been claimed.
This tab can be used to benchmark your local government against similar FTE (full time employee) groups/members.
Within this section, you have several subtabs:
Within these subtabs, you can also filter to look at data broken down into the following categories:
At its core, LGIS is all about local governments working together to achieve best outcomes for their organisations, people
and community. LGSAG is one such initiative where we have collaborated with member representatives to ensure they can create a safe and healthy work environment for their workforce when it comes into effect sometime next year.
The Workers’ Compensation & Injury Management Bill 2023, currently before Parliament in Western Australia, will enact major changes to WA’s workers’ compensation scheme
when it comes into effect sometime next year.
The importance of employers following internal policies and procedures and keeping accurate records can’t be emphasised enough when effectively managing a worker’s compensation claim. Our first case explores the need to follow one’s own internal polices in the context of a worker’s compensation work related stress claim.
The body map tab shows the key areas of claimant injuries. Total claim numbers are broken down by bodily location, occupation, gender, and age.
Users can find more detail by selecting one of the areas on the body (note to designer – include image alongside this text). This will filter all the claims with that specific bodily injury.
For example, if you selected the lower back then you can view the number of lower back claims by gender, occupation and age band. You can further analyse lower back claims by clicking on the “LTI Analysis” tab.
To remove a filter, you need to select the eraser.
You have the ability to filter claim information using either of the filter options on both the left and right side of the screen or by using the ‘group filters’. Group filters allow the breakdown of claim information by applying relevant filters specific to the information required. For example, if you would like to see the claims history of ‘body stressing’ related injuries, you can turn on the group filters, select “mechanism group,” then select “body stressing”.
Exporting Information
All raw data of each tab (with the exception of the dashboard) has the ability to be exported to excel, to assist with reporting. For more information, or a more detailed run through of Qlikview and its capabilities, please contact Carrisa Chung, LGIS WorkCare Portfolio Manager, on 9483 8861.
Risk Matters – Autumn 2020 Almost overnight, thousands of Australian office workers went remote. However, LGIS members are in a position where a high number
Risk Matters – Autumn 2020 Why early intervention? Responding early can reduce the likelihood of a worker becoming ill or injured or taking long-term sick
Risk Matters – Autumn 2020 The City of Subiaco has recently had great results in transforming their safety culture through the PErforM program. The purpose
LGIS is the unifying name for the dedicated suite of risk financing and management services for WA local governments, established by the WA Local Government Association in conjunction with JLT Public Sector (part of the Marsh group of companies). LGIS is managed by JLT Public Sector (ABN 69 009 098 864 AFS Licence 226827).
Risk Matters, via this website, is designed to keep members, their staff and elected members informed on topical risk management and insurance issues and LGIS programs and services.
