Data dictionary for the modern awards pay database

Data field name	Terminology description
allowance	Description of allowance, taken from the summary of monetary allowances table in the award in 2020. In previous awards the allowance description was taken from the allowance sheets.
allowanceAmount	Allowance amount is the ($) value of allowance.
allowanceLastAdjusted	Contains the last adjusted value of an expense allowance.
allowanceLookupCode	Allowance lookup code.
awardCode	An 8 digit alphanumeric award publication identification number, eg MA000001.
awardID	A 3 digit unique identification number for the award. The number changes each year. This field is common across all files and can be used as the primary key across the data, adding name & awardCode for context.
baseRate	The rate on which the annual wage review increase is applied is known as the base rate. In the case of the wage allowance records, the base rate is also known as the standard rate, used to calculate the allowances.
baseRateType	The rate frequency, such as weekly, hourly or annual is the base rate type.
calculatedRate	A calculated rate of clause – derived value from base rate.
calculatedRateType	Calculated rate type is the rate frequency, such as weekly, hourly or annually.
classification	Used to describe a job title that is associated with a rate of pay in a modern award.
classificationDisplayOrder	Order in which a classification that is linked to the penalty record appears in the clause. It is equal to displayOrder in the Classification record.
classificationID	A unique identification number of the classification for each year.
clauseDescription	Used to describe the content of the clause.
clauseDisplayOrder	Order in which a clause appears in the modern award.
clauseID	Unique identification number of clauses. The clause ID changes every year.
clauseLink	The clause number that the penalty is linked to for the purposes of calculating penalty rates.
clauseLinkDisplayOrder	Order in which classification clause that is linked to the penalty record appears in the Award
clauseLookupID	Look up ID for clause.
clauses	The clause number that appears in the published modern award.
cpiGroupDescription	CPI index name.
cpiQuarterCurrentYear	The quarter in which the cpiValueCurrentYear is based on (March, June, September or December quarter). It is populated in a year in which different quarters were used to update expense allowances across awards (ie 2020).
cpiQuarterLastAdjusted	2021 for those expense allowances that were adjusted in 2020.
cpiSeriesID	CPI series ID as supplied by the ABS.
cpiValueCurrentYear	CPI value for the published year.
cpiValueLastAdjusted	Value when the CPI was last adjusted (in the last adjusted year).
description	Expense-related allowance description.
displayOrder	Order in which the record appears in the clause.
expenseAllowanceID	Unique identification number of expense-related allowance which changes every year.
isAllPurpose	Used to flag whether an allowance applies for all purposes (1 = True, 0 = false). An all-purpose allowance applies to all employees or a specific group of employees and forms part of their ordinary hourly rate.
isHeading	Denotes a field that is presented as a heading in the modern award. If heading field = 0 , there is no heading, if = 1 the field is a heading. The heading fields are used to populate tables in the modern award.
isNonAdult	State if the rate is a non-adult rate ($). If 0 = No, if 1 = Yes. Used to flag juniors, apprentices and trainees.
lastAdjustedYear	Used for the expense-related allowances. The last year in which the allowance value was adjusted upwards.
name	Title of the award, provided in clause 1 of each award.
operativeDate	The date when the record comes into operation. For a particular employee, this will only take effect from the beginning of that employee’s first full pay period that starts on or after that date.
parentAllowance	Description of parent allowance.
parentClassificationName	Parent level classification of clause. Used when there are classifications that belong to a group of classifications.
paymentFrequency	Denotes when the payment of an allowance is made, eg – per week, per hour, per meal etc.
penaltyCalculatedValue	Calculated value of penalty.
penaltyColumnDisplayOrder	Order in which penalty rate column appears in the table in the award
penaltyDescription	Penalty description from the relevant clause in the award.
penaltyID	Unique identification number of a penalty rate.
penaltyRateUnit	Penalty rate unit is the either a ($) amount or percentage.
penaltyText	In cases where a ($) figure does not apply, the numeric field is replaced with text.
publishedYear	the year in which the minimum rates of pay were determined in the annual wage review. For example, for the published year 2020 the rates in the annual wage review were determined on 19 June 2020. It includes all data that came into operation between 1 July 2020 and 30 June 2021.
rate	The percentage that is applied to a base rate (or standard rate) in the wage allowance file or the percentage of the penalty in the penalty file.
rateUnit	The rate unit (percent).
roundValue	number of decimal points that the value is rounded to (rounded up or down). Usually 0, 1 or 2 decimal places.
sourceExpenseAllowanceID	Expense related allowance identification from previous year.
sourceClassificationID	Classification ID from the previous year. This allows you to link the classification in the current year to the previous year.
sourcePenaltyID	Penalty identification number from the previous year.
sourceWageAllowanceID	Wage-related allowance identification code from previous year.
type	The type of record, either Detail or Group. Group is used to assign a classification or allowance description as the parent.
wageAllowanceID	Unique identification number of wage-related allowance that changes with every year.

Data dictionary for the modern awards pay database

How useful was this page?*