Data field name | Terminology description |
---|---|
allowance |
Used in the expense related allowance record, contains calculated allowance value for the current year. |
description |
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 |
Wage-related 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 e.g 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. |
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. |
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 (i.e. 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, 2 = 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. |
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 e.g - per week, per hour, per meal etc. |
penaltyCalculatedValue |
Calculated value of penalty. |
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. |