Go to top of page

MOHRI file specifications

MOHRI v6.01 sets out the file specification for collecting workforce data about Queensland Government employees.

Download a copy of the MOHRI file specifications (PDF, 74 KB) – this provides more detail.

On this page:

Data reference and biographical data

NumberSizeDescriptionBusiness rule or validation
15Agency CodeMust be a valid code. List of Agencies  
24Calendar YearFour character year.
31Quarter of Calendar YearMust be in the range 1-4. MOHRI Collection Dates
45Unallocated code (future use) 
510Employee NumberMust be unique within each agency.
68Date of BirthStandard MOHRI date format. Cannot be greater than snapshot date minus 14 years.
71SexMust be 'M' (male) or 'F' (female)
81ATSI CodeMust be a valid code or blank. List of Aboriginal and Torres Strait Islander Codes
91NESB CodeMust be a valid code or blank. List of Non-English speaking Background Codes
103Disability CodeMust be a valid code or blank. List of people with a disability codes
115Unallocated code (future use) 

Human resource issues

NumberSizeDescriptionBusiness rule or validation
128Date appointed to AgencyStandard MOHRI date format or blank. Cannot be future date.
138Date appointed to Queensland Public SectorStandard MOHRI date format. Cannot be future date.
147Australian & New Zealand Standard Classification of Occupations (ANZSCO)Must be valid code and 6 characters long. List of ANZSCO Codes from ABS
155Legislation under which the employee is currently employedMust be valid code. List of employing legislation  
1610Award Code - Base AwardMust be valid code. List of Award Codes  
1710EBA/EDA Agreement CodeMust be valid code. List of EBA/EDA codes  
186Unallocated code (future use) 
194Award Standard Full-Time Hours per week x 100>= 0 and <= 4500
2010Classification Code within AwardMust be valid code where applicable. Cannot be blank. 
List of classification codes (DOC, 203 KB)
212Increment Year within Classification (if applicable)Valid code for field 20. Cannot be blank.
221Employment CategoryMust be a valid code. Cannot be blank. Employment Category Guideline
233Full Time Equivalent (FTE) ratio x 100>= 0 and <=100. FTE's greater than 100 should be reduced to 100.
241Employment StatusMust be valid code. Cannot be blank. Definition of Employment Status
258Separation DateStandard MOHRI date format of most recent separation in current quarter or blank.
261Separation ReasonMust be valid code and be the reason for the most recent separation in the current quarter. (See previous field). List of Separation codes
276Geographical Feature CodeCan only be blank if Flag is "E". If populated, must be a valid name from list. List of valid codes  
281Unallocated code (future use) 

Allowance details

No.SizeDescriptionBusiness Rule/Validation
295Hourly Base Rate of Pay in cents (excluding all allowances)> = 0
305Unallocated code (future use) 
315Aggregate Hourly Rate of Regular Allowances in cents> = 0
325Hourly rate of total value of all allowance payments at reporting date in cents> = 0
335Hourly rate of Higher Duties amount at reporting date in cents> = 0
345Hourly rate of Locality Allowance in cents> = 0
355Hourly rate of Overtime in cents> = 0
365Overtime in hours x 100> = 0
375Hourly Rate of Shift/Penalty Allowances in cents> = 0
385Unallocated code (future use) 
393Percentage of Gross Salary being Salary Packaged>= 0 and <=100
401Extra Leave for Proportionate SalaryY or N
415Unallocated code (future use) 

Unscheduled absence

No.SizeDescriptionBusiness Rule/Validation
425Sick leave hours drawn down over the previous quarter x 100>= 0 and <= (available working days for the qtr x 8hrs)
435Industrial Disputes hours absent in the previous quarter x 100>= 0 and <= (available working days for the qtr x 8hrs)
445Workers' Compensation hours absent in the previous quarter x 100>= 0 and <= (available working days for the qtr x 8hrs)
455Miscellaneous Special Leave such as bereavement or special responsibility hours absent in the previous quater x 100>= 0 and <= 8000 (10 days max x 8hrs)

Miscellaneous Special leave
465Carer's leave hours absent in the previous quarter x 100>= 0 and <= (available working days for the qtr x 8hrs)

Scheduled absence

No.SizeDescriptionBusiness Rule/Validation
476Recreation Leave hours balance at the end of snapshot fortnight x 100>= 0
485Maternity Leave hours on Full Pay absent in the current quarter x 100>= 0 and <= (available working days for the qtr x 8hrs)
495Maternity Leave hours on Half Pay absent in the current quarter x 100>= 0 and <= (available working days for the qtr x 8hrs)
505Maternity Leave hours on No Pay absent in the current quarter x 100>= 0 and <= (available working days for the qtr x 8hrs)
515Spousal Leave hours on Full Pay absent in the current quarter x 100>= 0 and <= 4000 (5days x 8hrs)
525Spousal Leave hours on Half Pay absent in the current quarter x 100>= 0 and <= 8000 (10days x 8hrs)
535Spousal Leave hours on No Pay absent in the current quarter x 100>= 0 and <= (available working days for the qtr x 8hrs)
545Adoption / Surrogacy Leave hours on Full Pay absent in the current quarter x 100>= 0 and <= (available working days for the qtr x 8hrs)
555Adoption / Surrogacy Leave hours on Half Pay absent in the current quarter x 100>= 0 and <= (available working days for the qtr x 8hrs)
565Adoption / Surrogacy Leave hours on No Pay absent in the current quarter x 100>= 0 and <= (available working days for the qtr x 8hrs)
575Pre-Natal Leave hours absent in the current quarter x 100>= 0 and <= 4000 (5days x 8hrs)
585Pre-Adoption / Pre-Surrogacy Leave hours absent in the current quarter x 100>= 0 and <= 4000 (5days x 8hrs)
595Unallocated code (future use) 

ELSLER

No.SizeDescriptionBusiness Rule/Validation
601LSL Entitlement TypeMust be a valid code. List of valid codes  
618LSL Vesting DateStandard MOHRI date format
626LSL balance accrued at current quarter start date x 100>= 0
636LSL balance accrued at current quarter end date x 100>= 0
646LSL hours taken during the current quarter x 100>= 0
656LSL hours paid out on separation during the current quarter x 100>= 0

Qualification and corporate services

No.SizeDescriptionBusiness Rule/Validation
6620Cost Centre CodeOptional field and not validated
676Past highest level ASCEDMust be valid code and at least 4 characters long.
ASCED Codes
682AQF level of past highest level ASCEDMust be valid code. AQF Codes  
694Year of award of past highest level ASCEDMust be valid year. YYYY
706Current highest level ASCEDMust be valid code and at least 4 characters long. ASCED Codes
712AQF level of current highest level ASCEDMust be valid code. AQF Codes
725Corporate Services - StreamMust be a valid code. Cannot be blank.

MOHRI Corporate Services Codes (PDF, 282 KB)
MOHRI Workforce Definitions (PDF, 222 KB)
735Corporate Services - ProcessNot required at this stage
745Corporate Services - ItemNot required at this stage

Organisational structure and special occupation groups

No.SizeDescriptionBusiness Rule/Validation
751FlagMust be a valid code. List of valid codes  
761Record End MarkerMust be $
7715Org Level 1Only validated if lookup table has been supplied to PSC and imported into WACA
7815Org Level 2Only validated if lookup table has been supplied to PSC and imported into WACA
7915Org Level 3Only validated if lookup table has been supplied to PSC and imported into WACA
8015SOG1Only validated if lookup table has been supplied to PSC and imported into WACA
8115SOG2Only validated if lookup table has been supplied to PSC and imported into WACA