MOHRI (Minimum Obligatory Human Resource Information) sets out the file specification for the collection of workforce data about every Queensland Government employee.
This specification is provided in the following table and a printable version is also available.
| No. | Size | Description | Business Rule/Validation |
|---|---|---|---|
| Data reference & biographical data | |||
| No. | Size | Description | Business Rule/Validation |
| 1 | 5 | Agency Code | Must be a valid code Source: List of Agencies |
| 2 | 4 | Calendar Year | Four character year. |
| 3 | 1 | Quarter of Calendar Year | Must be in the range 1-4. Source: MOHRI Collection Dates |
| 4 | 5 | Unallocated code (future use) | |
| 5 | 10 | Employee Number | Must be unique within each agency. |
| 6 | 8 | Date of Birth | Standard MOHRI date format. Cannot be greater than snapshot date
minus 14 years. Source: Standard MOHRI date format |
| 7 | 1 | Sex | Must be 'M' (male) or 'F' (female) |
| 8 | 1 | ATSI Code | Must be a valid code or blank. Source: List of Aboriginal and Torres Strait Islander Codes |
| 9 | 1 | NESB Code | Must be a valid code or blank. Source: List of Non-English speaking Background Codes |
| 10 | 3 | Disability Code | Must be a valid code or blank. Source: List of people with a disability codes |
| 11 | 5 | Unallocated code (future use) | |
| Human resource issues | |||
| No. | Size | Description | Business Rule/Validation |
| 12 | 8 | Date appointed to Agency | Standard MOHRI date format or blank. Cannot be future date. Source: Standard MOHRI date format |
| 13 | 8 | Date appointed to Queensland Public Sector | Standard MOHRI date format. Cannot be future date. Source: Standard MOHRI date format |
| 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 |
| 15 | 5 | Legislation under which the employee is currently employed | Must be valid code. Source: List of employing legislation |
| 16 | 10 | Award Code - Base Award | Must be valid code. Source: List of Award Codes |
| 17 | 10 | EBA/EDA Agreement Code | Must be valid code. Source: List of EBA/EDA codes |
| 18 | 6 | Unallocated code (future use) | |
| 19 | 4 | Award Standard Full-Time Hours per week x 100 | >= 0 and <= 4500 |
| 20 | 10 | Classification Code within Award | Must be valid code where applicable. Cannot be blank. Source: List of classification codes |
| 21 | 2 | Increment Year within Classification (if applicable) | Valid code for field 20. Cannot be blank. |
| 22 | 1 | Employment Category | Must be a vaild code. Cannot be blank. Source: Employment Category Guideline |
| 23 | 3 | Full Time Equivalent (FTE) ratio x 100 | >= 0 and <=100. FTE's greater than 100 should be reduced to 100. |
| 24 | 1 | Employment Status | Must be valid code. Cannot be blank. Source: Definition of Employment Status |
| 25 | 8 | Separation Date | Standard MOHRI date format of most recent separation in current quarter
or blank. Source: Standard MOHRI date format |
| 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 |
| 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 |
| 28 | 1 | Unallocated code (future use) | |
| Salary and allowance details | |||
| No. | Size | Description | Business Rule/Validation |
| 29 | 5 | Hourly Base Rate of Pay in cents (excluding all allowances) | > = 0 |
| 30 | 5 | Unallocated code (future use) | |
| 31 | 5 | Aggregate Hourly Rate of Regular Allowances in cents | > = 0 |
| 32 | 5 | Hourly rate of total value of all allowance payments at reporting date in cents | > = 0 |
| 33 | 5 | Hourly rate of Higher Duties amount at reporting date in cents | > = 0 |
| 34 | 5 | Hourly rate of Locality Allowance in cents | > = 0 |
| 35 | 5 | Hourly rate of Overtime in cents | > = 0 |
| 36 | 5 | Overtime in hours x 100 | > = 0 |
| 37 | 5 | Hourly Rate of Shift/Penalty Allowances in cents | > = 0 |
| 38 | 5 | Unallocated code (future use) | |
| 39 | 3 | Percentage of Gross Salary being Salary Packaged | >= 0 and <=100 |
| 40 | 1 | Extra Leave for Proportionate Salary | Y or N |
| 41 | 5 | Unallocated code (future use) | |
| Unsheduled absence | |||
| No. | Size | Description | Business Rule/Validation |
| 42 | 5 | Sick leave hours drawn down over the previous quarter x 100 | >= 0 and <= (available working days for the qtr x 8hrs) |
| 43 | 5 | Industrial Disputes hours absent in the previous quarter x 100 | >= 0 and <= (available working days for the qtr x 8hrs) |
| 44 | 5 | Workers' Compensation hours absent in the previous quarter x 100 | >= 0 and <= (available working days for the qtr x 8hrs) |
| 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 |
| 46 | 5 | Carer's leave hours absent in the previous quarter x 100 | >= 0 and <= (available working days for the qtr x 8hrs) |
| Sheduled absence | |||
| No. | Size | Description | Business Rule/Validation |
| 47 | 6 | Recreation Leave hours balance at the end of snapshot fortnight x 100 | >= 0 |
| 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) |
| 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) |
| 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) |
| 51 | 5 | Spousal Leave hours on Full Pay absent in the current quarter x 100 | >= 0 and <= 4000 (5days x 8hrs) |
| 52 | 5 | Spousal Leave hours on Half Pay absent in the current quarter x 100 | >= 0 and <= 8000 (10days x 8hrs) |
| 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) |
| 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) |
| 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) |
| 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) |
| 57 | 5 | Pre-Natal Leave hours absent in the current quarter x 100 | >= 0 and <= 4000 (5days x 8hrs) |
| 58 | 5 | Pre-Adoption Leave hours absent in the current quarter x 100 | >= 0 and <= 4000 (5days x 8hrs) |
| 59 | 5 | Unallocated code (future use) | |
| ELSLER | |||
| No. | Size | Description | Business Rule/Validation |
| 60 | 1 | LSL Entitlement Type | Must be a vaild code Source: List of valid codes |
| 61 | 8 | LSL Vesting Date | Standard MOHRI date format. Source: Standard MOHRI date format |
| 62 | 6 | LSL balance accrued at current quarter start date x 100 | >= 0 |
| 63 | 6 | LSL balance accrued at current quarter end date x 100 | >= 0 |
| 64 | 6 | LSL hours taken during the current quarter x 100 | >= 0 |
| 65 | 6 | LSL hours paid out on separation during the current quarter x 100 | >= 0 |
| Qualification and corporate services | |||
| No. | Size | Description | Business Rule/Validation |
| 66 | 20 | Cost Centre Code | Optional field and not validated |
| 67 | 6 | Past highest level ASCED | Must be valid code and at least 4 characters long Source: ASCED Codes |
| 68 | 2 | AQF level of past highest level ASCED | Must be valid code Source: AQF Codes |
| 69 | 4 | Year of award of past highest level ASCED | Must be valid year. YYYY |
| 70 | 6 | Current highest level ASCED | Must be valid code and at least 4 characters long Source: ASCED Codes |
| 71 | 2 | AQF level of current highest level ASCED | Must be valid code Source: AQF Codes |
| 72 | 5 | Corporate Services - Stream | Must be a valid code. Cannot be blank. Source: Corporate Services Codes |
| 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 |
| Organisational structure and special occupation groups | |||
| No. | Size | Description | Business Rule/Validation |
| 75 | 1 | Flag | Must be a valid code Source: List of valid codes |
| 76 | 1 | Record End Marker | Must be $ |
| 77 | 15 | Org Level 1 | Only validated if lookup table has been supplied to OPSC and imported into WACA |
| 78 | 15 | Org Level 2 | Only validated if lookup table has been supplied to OPSC and imported into WACA |
| 79 | 15 | Org Level 3 | Only validated if lookup table has been supplied to OPSC and imported into WACA |