| Field Name | Data type | Description |
|---|---|---|
| award_fixed_id | Integer | A unique code for this instance of the modern award resource that remains identical year on year. |
| award_id | Integer | Unique identification number of award |
| award_operative_from | Date | The date when the award came into operation |
award_operative_to NULLABLE |
Date | The date when the award ceased to be in effect (was revoked). |
| code | String | The code assigned to the modern award. Also known as the award number. |
| name | String | The human readable title of the award |
| last_modified_datetime | DateTime | This is the date and time that the resource was last modified. |
| published_year | String | Year in which the minimum rates of pay were determined in the annual wage review. |
| version_number | Integer | This number indicates the version of the award resource. It is incremented by one each time the resource is updated. |
| Field name | Data type | Description |
|---|---|---|
| award_fixed_id | Integer | A unique code for this instance of the modern award resource that remains identical year on year. |
base_pay_rate_id NULLABLE |
String | A unique identification number of the base pay rate resource. Values have the prefix (BR). |
base_rate NULLABLE |
Decimal | The rate that the annual wage review increase is directly applied to. |
base_rate_type NULLABLE |
String | The rate frequency such as: weekly, hourly, annual, daily, piece rate, cents per km, engagement rate. |
calculate_pay_rate_id* NULLABLE |
String | A unique identification number of the calculated pay rate resource. Values have the prefix (CR). |
calculated_rate_type NULLABLE |
String | Calculated rate type (hourly, weekly, annual, daily, fortnightly, casual hourly, cents per km, piece rate, engagement rate). |
calculated_rate NULLABLE |
Decimal | Calculate rate of classification within clause - derived value from base rate. |
| classification | String | Used to describe a job title that is associated with a rate of pay in a modern award. Sub level classification of clause |
| classification_fixed_id | integer | Unique identification number of classification that remains identical year on year. |
classification_level* NULLABLE |
integer | A numerical representation of the classification within the hierarchical structure of classifications in a clause. Starts at 1 for the lowest level classification. |
clause_description NULLABLE |
String | Used to describe the content of the clause. |
| clause_fixed_id | Integer | Unique identification number of clauses that remains identical year on year. |
| clauses | String | Clause number as it appears in the award. |
| code | String | The code assigned to the modern award. Also known as the award number. |
employee_rate_type_code NULLABLE |
String |
An indicator if the rate is for an adult or otherwise:
|
| last_modified_datetime | DateTime | This is the date and time that the resource was last modified. |
next_down_classification_fixed_id NULLABLE |
integer | Refers to the classification_fixed_id for the next logical classification down the classification hierarchy. |
next_up_classification_fixed_id NULLABLE |
integer | Refers to the classification_fixed_id for the next logical classification up the classification hierarchy. |
| operative_from | Date | 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. |
operative_to NULLABLE |
Date | The date on which the classification ceased to be in effect. |
parent_classification_name NULLABLE |
String | Description of a parent classification. Used when there are classifications that belong to a group of classifications, e.g "Technical stream" may be parent of a group containing Levels 1-6. |
| published_year | Integer | The year in which the minimum rates of pay were determined in the annual wage review. For example, for the published year 2019 the rates in the annual wage review were determined on 30 May 2019. It includes all data that came into operation between 1 July 2019 and 30 June 2020. |
| version_number | Integer | This number indicates the version of the classification resource. It is incremented by one each time the resource is updated. |
| Field name | Data type | Description |
|---|---|---|
| allowance | String | Description of allowance, taken from the summary of monetary allowances table in the award if the award contains one. Otherwise the allowance description is taken from the allowance sheets. |
allowance_amount NULLABLE |
Decimal | Contains calculated allowance value ($) for the current year. |
| award_fixed_id | Integer | A unique code for this instance of the modern award resource that remains identical year on year. |
| base_pay_rate_id | Integer | A unique identification number of the base pay rate resource. Values have the prefix (BR). |
| clause_fixed_id | Integer | Unique identification number of clauses that remains identical year on year. |
| clauses | String | Clause number |
| code | String | The code assigned to the modern award. Also known as the award number. |
| is_all_purpose | TinyInteger |
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 |
| last_modified_date_time | DateTime | This is the date and time that the resource was last modified. |
| operative_from | Date | 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. |
operative_to NULLABLE |
Date | The date on which the allowance ceased to be in effect. |
parent_allowance NULLABLE |
String | Description of parent allowance (often used for a title of a group such as "meal allowances" for a group of breakfast, lunch and dinner allowances). |
payment_frequency NULLABLE |
String | Denotes when the payment of an allowance is made, eg - per week, per hour, per meal etc. |
| published_year | Integer | The year in which the minimum rates of pay were determined in the annual wage review. For example, for the published year 2019 the rates in the annual wage review were determined on 30 May 2019. It includes all data that came into operation between 1 July 2019 and 30 June 2020. |
rate NULLABLE |
Decimal | Percentage of standard rate (base rate) |
rate_unit NULLABLE |
String | Rate unit (Percent) |
| version_number | integer | This number indicates the version of the allowance resource. It is incremented by one each time the resource is updated. |
| wage_allowance_fixed_id | integer | Unique identification number of the wage-related allowance that remains identical year on year. |
| Field name | Data type | Description |
|---|---|---|
| allowance | String | Description of allowance, taken from the summary of monetary allowances table in the award if the award contains one. Otherwise the allowance description is taken from the allowance sheets. |
allowance_amount NULLABLE |
Decimal | Contains calculated allowance value ($) for the current year. |
| award_fixed_id | Integer | A unique code for this instance of the modern award resource that remains identical year on year. |
| clauses | String | Clause number as it appears in the award. |
| clause_fixed_id | Integer | Unique identification number of clauses that remains identical year on year. |
| code | String | The code assigned to the modern award. Also known as the award number. |
cpi_quarter_last_adjusted NULLABLE |
String |
The quarter in which the CPI of last adjusted year relates to. It will be populated in 2021 for those expense allowances that were adjusted in 2020. |
| expense_allowance_fixed_id | Integer | Unique identification number of expense-related allowance remains identical year on year. |
| is_all_purpose | TinyInteger | 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. |
last_adjusted_year NULLABLE |
Integer | The year in which the expense allowance was last adjusted |
| last_modified_date_time | DateTime | This is the date and time that the resource was last modified. |
| operative_from | Date | 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. |
operative_to NULLABLE |
Date | The date on which the allowance ceased to be in effect. |
parent_allowance NULLABLE |
String | Description of parent allowance often used for a title of a group such as "meal allowances" for a group of breakfast, lunch and dinner allowances. |
payment_frequency NULLABLE |
String | Denotes when the payment of an allowance is made, eg - per week, per hour, per meal etc. |
| published_year | Integer | The year in which the minimum rates of pay were determined in the annual wage review. For example, for the published year 2019 the rates in the annual wage review were determined on 30 May 2019. It includes all data that came into operation between 1 July 2019 and 30 June 2020. |
| version_number | integer | This number indicates the version of the allowance resource. It is incremented by one each time the resource is updated. |
| Field name | Data type | Description |
|---|---|---|
| award_fixed_id | Integer | A unique code for this instance of the modern award resource that remains identical year on year. |
base_pay_rate_id NULLABLE |
String | A unique identification number of the base pay rate resource. Values have the prefix (BR). |
classification_level NULLABLE |
Integer | A numerical representation of the classification within the hierarchical structure of classifications in a clause. Starts at 1 for the lowest level classification. |
| clause_description | String |
Adds context to the penalties of a clause. Description is taken from the clause heading from the corresponding Summary table in the Award (ie Full-time and part-time adult employees-ordinary and penalty rates) |
| clause_fixed_id | Integer | Unique identification number of clause that is fixed over each year. |
| code | String | The code assigned to the modern award. Also known as the award number. |
employee_rate_type code NULLABLE |
String |
An indicator if the rate is for an adult or otherwise:
|
| last_modified_date_time | DateTime | This is the date and time that the resource was last modified. |
| operative_from | Date | The date when the record comes into operation. For a particular employee, this will only take effect from the beginning of that employe's first full pay period that starts on or after that date. |
operative_to NULLABLE |
Date | The date on which the penalty rate ceased to be in effect. |
penalty_calculated_value NULLABLE |
Decimal | Calculated value of penalty |
| penalty_description | String | Penalty description from the relevant clause in the award. |
| penalty_fixed_id | Integer | Unique identification number of the penalty that remains identical year on year. |
| published_year | Integer | The year in which the minimum rates of pay were determined in the annual wage review. For example, for the published year 2019 the rates in the annual wage review were determined on 30 May 2019. It includes all data that came into operation between 1 July 2019 and 30 June 2020. |
| rate | Decimal | The value of penalty that is applied as a percentage to the minimum/ordinary hourly rate. |
| version_number | integer | This number indicates the version of the penalty resource. It is incremented by one each time the resource is updated. |