Print-friendly version
MOHRI 6.0 file specifications
Minimum Obligatory Human Resource Information
For a printable version of this table, click here.
| Field | Description | Business Rule/Validation | Comments | |
| No. | Size | |||
| 1 | 5 | Agency Code | Must be a valid code Source: List of Agencies |
Code which uniquely identifies each agency. |
| 2 | 4 | Calendar Year | Four character year. | Calendar year in which dataset is captured. Format is CCYY |
| 3 | 1 | Quarter of Calendar Year | Must be in the range 1-4. Source: MOHRI Collection Dates |
1 = 1 January - 31 March; 2 = 1 April - 30 June; 3 = 1 July - 30 September; 4 = 1 October - 31 December. Refer to cutoff dates for dates by which each quarter's data should be submitted. |
| 4 | 5 | Spare for future use | ||
| 5 | 10 | Employee Number | Must be unique within each agency. | Unique identifier of each employee. |
| 6 | 8 | Date of Birth | Standard MOHRI date format. Cannot be greater than snapshot date minus 14 years. Source: Standard MOHRI date format |
Can only be blank where employers cannot, by law, ask for an employees date of birth - e.g. some overseas countries. DDMMYYYY |
| 7 | 1 | Sex | Must be 'M' (male) or 'F' (female) | Sex which appears on birth documentation. Other documentation may only be used if birth documentation is not available. |
| 8 | 1 | ATSI Code | Must be a valid code or blank. Source: List of Aboriginal and Torres Strait Islander Codes |
Aboriginal or Torres Stait Islander (ATSI) descent. A = not ATSI; B = ATSI; C = Response Declined; Z = No Record |
| 9 | 1 | NESB Code | Must be a valid code or blank. Source: List of Non-English speaking Background Codes |
Non-English Speaking background. NESB1 = people who have migrated to Australia and whose first language is a language other than English. NESB2 = The children of those migrated people as defined by NESB1. See valid codes for allowable entries. |
| 10 | 3 | Disability Code | Must be a valid code or blank. Source: List of people with a disability codes |
999 = Response Declined; Z = No Record. See valid codes for other allowable entries. |
| 11 | 5 | Spare for future use | ||
| 12 | 8 | Date appointed to Agency | Standard MOHRI date format or blank. Cannot be future date. Source: Standard MOHRI date format |
Date of appointment to the current agency. DDMMYYYY |
| 13 | 8 | Date appointed to Queensland Public Sector | Standard MOHRI date format. Cannot be future date. Source: Standard MOHRI date format |
The date that the employee was appointed to the Queensland Public Sector. In instances of broken service or exclusion periods, the same principles for determining long service leave should be applied. DDMMYYYY |
| 14 | 7 | Australian Standard Classification of Occupations (ASCO) | Must be valid code and at least 4 characters long. Source: List of ASCO Codes from ABS |
Four digit, Australian Standard Code for Occupations. The field has been expanded to 7 characters to facilitate agencies wishing to code this field to further levels. |
| 15 | 5 | Legislation under which the employee is currently employed | Must be valid code. Source: List of employing legislation |
A reference to the current employing Act. If a code is not available, please contact OPSC for necesary allocation. |
| 16 | 10 | Award Code - Base Award | Must be valid code. Source: List of Award Codes |
A code which uniquely identifies a registered Industrial Award or Industrial Agreement. A code exists for 'award free'. The first character of the code (S or F) signifies whether the award is State of Federal jurisdiction. |
| 17 | 10 | EBA/EDA Agreement Code | Must be valid code. Source: List of EBA/EDA codes |
A code which uniquely identifies a registered Enterprise Bargaining Agreement or Enterprise Development Agreement. |
| 18 | 6 | Spare for future use | ||
| 19 | 4 | Award Standard Full-Time Hours per week x 100 | >= 0 and <= 4500 | The number of hours a full-time employee (ie FTE 1.0) would work in accordance with the appropriate award or agreement multiplied by 100. Eg if an award prescribes 36 hours 15 minutes for a full-time position, the required entry is 3625 (36.25 x 100) |
| 20 | 10 | Classification Code within Award | Must be valid code where applicable. Cannot be blank. Source: List of classification codes |
If valid codes for common public service award classifications are not utilised, agencies should update the WACA for translation purposes. |
| 21 | 2 | Increment Year within Classification (if applicable) | Valid code for field 20. Cannot be blank. | A code representing the increment year within the classification code for the employee. Must be a 2 character code with leading zeros. ie 01, 02, etc. For qualification increments please use Q. |
| 22 | 1 | Employment Category | Must be a vaild code. Cannot be blank. Source: Employment Category Guideline |
Permanent(P), Casual(C), Temporary(T), Contract(N). (If separated during quarter use immediately prior employment category). Exclude - volunteers, pension from agency, Employment Agency staff, contractors, Consultants, Board members. |
| 23 | 3 | Full Time Equivalent (FTE) ratio x 100. | >= 0 and <=100. FTE's greater than 100 should be reduced to 100. | The ratio of an individual’s working hours to the award full-time standard hours for the work being done x 100. An FTE ratio of 1.00 should be recorded as 100 while an FTE ratio of 0.5 should be recorded as 050. |
| 24 | 1 | Employment Status | Must be valid code. Cannot be blank. Source: Definition of Employment Status |
Active (not on extended leave) (A); absent on extended paid leave (P); absent on extended unpaid leave (U), Separated (S). The status is 'as at' the reporting date and 'extended leave' is greater than eight weeks (56 calendar days), ELSLER only (E). |
| 25 | 8 | Separation Date | Standard MOHRI date format of most recent separation in current quarter or blank. Source: Standard MOHRI date format |
Must not be blank if separation reason is entered or employment status = 'S' (Separated). |
| 26 | 1 | Separation Reason | Must be valid code and be the reason for the most recent separation in the current quarter. (See previous field) Source: List of Separation codes |
A = Appointment to another QLD Public Sector agency, B = Resignation, C = Ill Health retirement, D = Retrenchment, E = End of contract, F = Dismissal, G = Death, H = Voluntary Early Retirement, J = Pension (paid by agency), K = Age retirement, L = Ceased, M = Machinery of Government Change. |
| 27 | 6 | Geographical Feature Code | Can only be blank if Flag is "E". If populated, must be a valid name from list Source: List of valid codes |
Name Code as per list - please contact OPSC for new locations. |
| 28 | 1 | Spare for future use | ||
| 29 | 5 | Hourly Base Rate of Pay in cents (excluding all allowances) | > = 0 | The hourly rate of base pay excluding all allowances in cents at the reporting date. Eg an employee earning $600.00 per week for a 30 hour standard week would have an hourly rate of 2000 cents. |
| 30 | 5 | Spare for future use | ||
| 31 | 5 | Aggregate Hourly Rate of Regular Allowances in cents | > = 0 | Total of 'standing' or 'regular' allowances in cents at the reporting date. Eg an employee earning $150.00 per week in 'standing' or 'regular' allowances for a 30 hour standard week would have an hourly rate of 500 cents. |
| 32 | 5 | Hourly rate of total value of all allowance payments at reporting date in cents. | > = 0 | Total of all allowances at the reporting date in cents. Exclude severance payments, ex gratia payments and leave loading. Eg an employee earning $120.00 per week in total allowances for a 30 hour standard week would have an hourly rate of 400 cents. |
| 33 | 5 | Hourly rate of Higher Duties amount at reporting date in cents. | > = 0 | The hourly rate of approved higher duties allowance paid to the employee at the reporting date in cents. Eg an employee earning $90.00 per week in total higher duties allowance for a 30 hour standard week would have an hourly rate of 300 cents. |
| 34 | 5 | Hourly rate of Locality Allowance in cents. | > = 0 | The hourly rate of Locality Allowance paid to the employee at the reporting date in cents. Eg an employee earning $120.00 per week in Locality Allowances for a 30 hour standard week would have an hourly rate of 400 cents. |
| 35 | 5 | Hourly rate of Overtime in cents. | > = 0 | The amount of approved overtime allowance paid to the employee at the reporting date in cents. Eg an employee earning $120.00 per week in overtime allowance for a 30 hour standard week would have an hourly rate of 400 cents. |
| 36 | 5 | Overtime in hours x 100 | > = 0 | The number of approved overtime hours for which the employee is being paid at the reporting date x 100. Eg an employee being paid 9 hours overtime during at the reporting date will require an entry of 900 (9 x 100). |
| 37 | 5 | Hourly Rate of Shift/Penalty Allowances in cents. | > = 0 | The amount of shift/penalty allowance paid to the employee at the reporting date in cents. Eg an employee earning $120.00 per week in shift/penalty allowance for a 30 hour standard week would have an hourly rate of 400 cents. |
| 38 | 5 | Spare for future use | ||
| 39 | 3 | Percentage of Gross Salary being Salary Packaged | >= 0 and <=100 | The percentage of employee's gross salary (pre tax) which is being packaged (at snapshot date) - NOTE: No multiplying by 100 - normal rounding will apply ie. 5.88% will be 6 |
| 40 | 1 | Extra Leave for Proportionate Salary | Y or N | Yes or No (at snapshot date) |
| 41 | 5 | Spare for future use | ||
| 42 | 5 | Sick leave hours drawn down over the previous quarter x 100 | >= 0 and <= (available working days for the qtr x 8hrs) | Absence in the previous quarter, whether paid or unpaid, resulting from an employee being too ill to work, and where the illness or injury is due to a cause which does not entitle the employee to workers' compensation. The number of hours should be multiplied by 100. |
| 43 | 5 | Industrial Disputes hours absent in the previous quarter x 100 | >= 0 and <= (available working days for the qtr x 8hrs) | The number of hours absent due to industrial disputes during the previous quarter multiplied by 100. |
| 44 | 5 | Workers' Compensation hours absent in the previous quarter x 100. | >= 0 and <= (available working days for the qtr x 8hrs) | The number of hours absent resulting from personal injury or disease sustained out of, or in the course of, employment (ie work related) and which forms part of an approved workers' compensation claim during the previous quarter multiplied by 100. |
| 45 | 5 | Miscellaneous Special Leave such as bereavement or special responsibility hours absent in the previous quater x 100. | >= 0 and <= 8000 (10 days max x 8hrs) Source: Miscellaneous Special leave |
Total number of hours absent due to miscellaneous unscheduled absence (ie unscheduled absence not covered above) during the previous quarter multiplied by 100. See Source: Miscellaneous Special Leave for further explanation. |
| 46 | 5 | Carer's leave hours absent in the previous quarter x 100 | >= 0 and <= (available working days for the qtr x 8hrs) | The number of hours absent on account of carer's leave (paid or unpaid) during the previous quarter multiplied by 100 - See Part 3 Family Leave Award - Qld Public Sector |
| 47 | 6 | Recreation Leave hours balance at the end of snapshot fortnight x 100 | >= 0 | Employees Recreation Leave hours balance (in working hours) accrued at the end of the snapshot fortnight (even if future leave has already been deducted) multiplied by 100 |
| 48 | 5 | Maternity Leave hours on Full Pay absent in the current quarter x 100 | >= 0 and <= (available working days for the qtr x 8hrs) | Number of hours absent on account of full pay maternity leave during the currrent quarter multiplied by 100 |
| 49 | 5 | Maternity Leave hours on Half Pay absent in the current quarter x 100 | >= 0 and <= (available working days for the qtr x 8hrs) | Number of hours absent on account of half pay maternity leave during the currrent quarter multiplied by 100 |
| 50 | 5 | Maternity Leave hours on No Pay absent in the current quarter x 100 | >= 0 and <= (available working days for the qtr x 8hrs) | Number of hours absent on account of no pay maternity leave during the currrent quarter multiplied by 100 |
| 51 | 5 | Spousal Leave hours on Full Pay absent in the current quarter x 100 | >= 0 and <= 4000 (5days x 8hrs) | Number of hours absent on account of full pay spousal leave during the currrent quarter multiplied by 100 |
| 52 | 5 | Spousal Leave hours on Half Pay absent in the current quarter x 100 | >= 0 and <= 8000 (10days x 8hrs) | Number of hours absent on account of half pay spousal leave during the currrent quarter multiplied by 100 |
| 53 | 5 | Spousal Leave hours on No Pay absent in the current quarter x 100 | >= 0 and <= (available working days for the qtr x 8hrs) | Number of hours absent on account of no pay spousal leave during the currrent quarter multiplied by 100 |
| 54 | 5 | Adoption Leave hours on Full Pay absent in the current quarter x 100 | >= 0 and <= (available working days for the qtr x 8hrs) | Number of hours absent on account of full pay adoption leave during the currrent quarter multiplied by 100 |
| 55 | 5 | Adoption Leave hours on Half Pay absent in the current quarter x 100 | >= 0 and <= (available working days for the qtr x 8hrs) | Number of hours absent on account of half pay adoption leave during the currrent quarter multiplied by 100 |
| 56 | 5 | Adoption Leave hours on No Pay absent in the current quarter x 100 | >= 0 and <= (available working days for the qtr x 8hrs) | Number of hours absent on account of no pay adoption leave during the currrent quarter multiplied by 100 |
| 57 | 5 | Pre-Natal Leave hours absent in the current quarter x 100 | >= 0 and <= 4000 (5days x 8hrs) | Number of hours absent on account of pre-natal (paid) leave during the currrent quarter multiplied by 100 |
| 58 | 5 | Pre-Adoption Leave hours absent in the current quarter x 100 | >= 0 and <= 4000 (5days x 8hrs) | Number of hours absent on account of pre-adoption (paid) leave during the currrent quarter multiplied by 100 |
| 59 | 5 | Spare for future use | ||
| 60 | 1 | LSL Entitlement Type | Must be a vaild code Source: List of valid codes |
Must be a vaild type (A or B or C or D or N) The rate at which the employee becomes entitles to long service leave. This depends on the employee's industrial award or employment agreement. |
| 61 | 8 | LSL Vesting Date | Standard MOHRI date format. Source: Standard MOHRI date format |
The date upon which the employee becomes entitled to long service leave |
| 62 | 6 | LSL balance accrued at current quarter start date x 100 | >= 0 | Employee's long service leave balance (in working hours) accrued at the current quarter start date x 100 |
| 63 | 6 | LSL balance accrued at current quarter end date x 100 | >= 0 | Employee's long service leave balance (in working hours) accrued at the current quarter end date x 100 |
| 64 | 6 | LSL hours taken during the current quarter x 100 | >= 0 | Long service leave working hours taken by the employee during the current quarter x 100 |
| 65 | 6 | LSL hours paid out on separation during the current quarter x 100 | >= 0 | Long service leave in working hours paid out to employee on separation during the current quarter x 100 |
| 66 | 20 | Cost Centre Code | Optional field and not validated | Cost Centre Code for the employee. |
| 67 | 6 | Past highest level ASCED | Must be valid code and at least 4 characters long Source: ASCED Codes |
The four digit ASCED code of the highest AQF level course of study which has been awarded to the employee. The field has been expanded to 6 characters to facilitate agencies wishing to code this field to further levels. |
| 68 | 2 | AQF level of past highest level ASCED | Must be valid code Source: AQF Codes |
The AQF level of the course of study refered to in field 67 (Codes range from 00 to 12) |
| 69 | 4 | Year of award of past highest level ASCED | Must be valid year. YYYY | The year that the employee was awarded the qualification detailed in field 67 |
| 70 | 6 | Current highest level ASCED | Must be valid code and at least 4 characters long Source: ASCED Codes |
The four digit ASCED code of the highest AQF level course of study currently being undertaken by the employee. The field has been expanded to 6 characters to facilitate agencies wishing to code this field to further levels. |
| 71 | 2 | AQF level of current highest level ASCED | Must be valid code Source: AQF Codes |
The AQF level of the course of study referred to in field 70 (Codes range from 00 to 12) |
| 72 | 5 | Corporate Services - Stream | Must be a valid code. Cannot be blank. Source: Corporate Services Codes |
Corporate Services Stream code for the employee. Must be valid code: A, B, C, D,E, F, H, K, or Z |
| 73 | 5 | Corporate Services - Process | Must be a valid code. Can only be blank when CS Stream = H Source: Corporate Services Codes |
|
| 74 | 5 | Corporate Services - Item | Not required at this stage | |
| 75 | 1 | Flag | Must be a valid code Source: List of valid codes |
Must be a vaild code. M = MOHRI employee only; E = ELSLER employee only; B = Both (MOHRI & ELSLER employee); X = EEO & ELSLER employee; Z = EEO employee only |
| 76 | 1 | Record End Marker | Must be $ | A dollar symbol ($) must always be used in this field |
| 77 | 15 | Org Level 1 | Only validated if lookup table has been supplied to OPSC and imported into WACA | Optional field |
| 78 | 15 | Org Level 2 | Only validated if lookup table has been supplied to OPSC and imported into WACA | Optional field |
| 79 | 15 | Org Level 3 | Only validated if lookup table has been supplied to OPSC and imported into WACA | Optional field |
This data is always about the substantive position for employee
The MOHRI file must contain all employees who accrue LSL, even if FTE = 0. (then Emp Status = E & Flag = E)
Last reviewed 2 April, 2008