Fair Work Commission

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

Year to which award currently maps to.

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.