32. Customisable data report (CIS report)
This report is part of our Customer Information System (CIS).
Description: This report is a customisable version of Report 66, allowing you to select the fields that you wish to display for all claims for your agency.
Access Level Required: Case Management Detail level access.
Export options: .csv
Benefits: Report 66 is one of the most used reports within CIS, although its size can be prohibitive for larger agencies.
This customisable version of the report allows you to select the columns that you want to display in the final report, with Employee Number, Given Names, Suffix and Surname being the only mandatory columns.
You can then filter the report further by Claim Status, Date of Injury, Liability Status, Liable Cost Centre, and Payroll Cost Centre. For example, you may want to run a report for a certain number of columns, where the Date of Injury is between 1 June 2010 and 30 September 2011, where the Claim Status is Reopened (R), and the Liability Status is Accepted (A).
Parameters: The report allows to choose which data is pulled from the claim listing of all of the claims the agency is liable for.
|Given Names||Employee's first name/s.|
|Empl No||A unique eight digit claim identification number allocated by Comcare for each claimant.|
|Suffix||A two digit number identifying the claim sequence number, for example, if the claimant has had two previous claims then these last two digits of the claim number for their third claim would be 03.|
|Date Resignation/ Termination||Date of effect if employee is no longer a Commonwealth employee.|
|Date of Birth||Employee's date of birth.|
|Post code||The post code relevant to the claimant's address.|
|Date of Injury||The date of injury, for example, the specific day on which the claimed injury occurred or a disease was first medically diagnosed.|
|Comcare Receipt Date||The date the claim was received by Comcare.|
The current liability status for the injury or disease. This can change throughout the life of the claim—only the current value is listed. |
Note—Premium calculation includes claims with a Liability Status of 'A' at the time of the data extraction for Likely Future Costs. The valid values for this field are:
(A)ccepted—Liability has been accepted for this claim, for example medical claims etc. can be paid.
(D)eleted—Claim has been deleted.
(N)on-Compliance—Does not meet the requirements of the legislation, for example medical certificate missing, inadequate etc. Claims are received by Comcare (Date of Receipt), then when all legislative requirements for the claim are met the Date of Compliance is set. For most claims, Date of Compliance equals Date of Receipt.
(R)ejected—The claim is not accepted as a liability for Comcare, the injury is not covered by the workers compensation Act.
(U)ndetermined—Liability for a claim is yet to be determined by Comcare.
(W)ithdrawn—The claimant has withdrawn the claim.
|Decision Date||Date liability decision made by Comcare.|
|Claim Status||The Open/ Closed/ Reopened status of the claim.|
|Status Date||The date when the Claim Status field was last changed.|
|Liable Cust and Liable Cost Ctr||Customer and cost centre liable for the injury. Usually the current employer as at the 'Date of Injury'.|
|Payroll Cust and Payroll Cost Ctr||This is the Comcare code for the current employer. This may or may not be the same as the code for the liable employer.|
|Case Manager||Agency contact responsible for rehab on claim.|
|Claim Manager||Comcare contact responsible for the management of the claim.|
|First Rehab assessment||Date of first Rehab assessment.|
|Month 5th day incap detd||Month in which the 5th day of incapacity was determined.|
|Claim Lodged with Employer||Date the claim was lodged with the liable employer.|
|Employee sign date||Date the employee signed the claim form.|
|Agree with claim||Does the employer agree with the claim.|
(code and description)
|The Body Location Of Injury/Disease classification is intended to identify the part of the body affected by the most serious injury or disease. These codes are based on the Type of Occurrence Classification System (TOOCS).|
Nature of Injury|
(code and description)
|The Nature of Injury classification is intended to identify the most serious injury or disease sustained or suffered by the worker. These codes are based on the TOOCS.|
(code and description)
|The Occupation classification is intended to identify the occupation of the claimant at the time of the injury. These codes are based on the TOOCS. The codes reported in the CDS are the first two digits of the six digit TOOCS code recorded by Comcare.|
|Agency of Accident (code and description)||The Agency of Accident classification is intended to identify the object, substance, or circumstance that was principally involved in, or most closely associated with, the point at which things started to go wrong and which ultimately led to the most serious injury or disease. These codes are based on the TOOCS.|
Mechanism of Incident |
(code and description)
|The Mechanism of Incident classification is intended to identify the action, exposure, or event, which was the direct cause of the most serious injury or disease. These codes are based on the TOOCS.|
The location of the employee in relation to their employment at the time of injury. Length: 1 character. The valid values for this field are:|
A - working at usual workplace
B - traffic accident whilst working
C - while working elsewhere
D - while having a break
E - while travelling to or from work
F - while attending approved course of study
G - during an authorised sporting activity
H - other
J - home based work
K - engaged in employer approved activity
L - travelling for work purposes
X - all diseases.
|Claim Cust Reference||The employer's reference number for this claim.|
|Payroll code||The employer's internal payroll code for this claim.|
|Total Weeks Incap Paid||This is the total incapacity recorded against the claim. This field is the sum of all periods of incapacity to date. The calculation is based on standard hours worked and is expressed in decimal weeks.|
|NWE||Normal Weekly Earnings of employee.|
|Total Incap||Total Incapacity Cost. This is the total cost of Incapacity payments received from Comcare from 1 December 1988 to date.|
|Total Medical||Total Medical Cost. This is the total cost of Medical payments from 1 December 1988 to date.|
|Total Other||This is the total of all payments not specified elsewhere from 1 December 1988 to date. This amount includes AAT and legal costs.|
|Total Travel||Total Travel Cost. This is the total cost of Travel payments from 1 December 1988 to date.|
|Total Rehab||Total Rehab Cost. This is the total cost of Rehabilitation payments from 1 December 1988 to date excluding any GST amount claimable by Comcare as an Input Tax Credit.|
|Costs to Date||Total Cost of claim to date. This is the sum of Total Incap, Total Medical, Total Subseq, Total Travel and Total Rehab excluding any GST amount claimable by Comcare as an Input Tax Credit.|
|Likely Future Costs||Actuarial assessment of the possible future costs of the claim for the life of that claim. This total uses the most recent case estimates.|
|AGS No||Employee's AGS number.|
|Secondary Condition||Indicates whether a secondary condition has been approved.|
|Third party recoveries||Where an employee is involved in a compensable injury involving a third party, the employee or Comcare may seek damages from the third party on behalf of the employee.|
|Resignation reason||Reason for leaving, for example, invalidity retirement, voluntary redundancy.|
|Exposure Flag||The claim was the result of pre-1 December 1988 exposure.|
|Exposure Date||Pre-1 December 1988 exposure date.|
|Total cost at date of latest case estimate||Total Cost of claim as at the date of the latest case estimate. This is the sum of Total Incap, Total Medical, Total Subseq, Total Travel and Total Rehab excluding any GST amount claimable by Comcare as an Input Tax Credit. Case Estimates are usually available two to three months after the end of each month.|