Introduction
Data dictionary for the terminology in the Modern awards pay database. The database shows current and historical minimum rates of pay, allowances and penalty rates in modern awards.
Data dictionary for the terminology in the Modern awards pay database. The database shows current and historical minimum rates of pay, allowances and penalty rates in modern awards.
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. |