| Field Name | Data type | Description |
|---|---|---|
| award_fixed_id | Integer | A unique code for this instance of the modern award resource that is fixed over each 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 is fixed over each 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 | Base rate of classification in clause |
base_rate_type NULLABLE |
String | Base rate type (Weekly, Hourly, Annual, Daily, Piecerate) |
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) |
calculated_rate NULLABLE |
Decimal | Calculate rate of classification within clause - derived value from base rate. |
| classification | String | Sub level classification of clause |
| classification_fixed_id | integer | Unique identification number of classification that is fixed over each 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 | Clause description |
| clause_fixed_id | Integer | Unique identification number of clauses that is fixed over each year. |
| clauses | String | Clause number |
| 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 on which the classification came into effect. |
operative_to NULLABLE |
Date | The date on which the classification ceased to be in effect. |
parent_classification_name NULLABLE |
String | Parent level classification of clause |
| published_year | Integer | 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 classification resource. It is incremented by one each time the resource is updated. |
| Field name | Data type | Description |
|---|---|---|
| allowance | String | Description of allowance |
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 is fixed over each year |
| base_pay_rate_id | Integer | A unique identification number of the base pay rate resource used to calculate the allowance amount. Values have the prefix (“BR”). |
| clause_fixed_id | Integer | Unique identification number of clause that is fixed over each 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 on which the allowance came into effect. |
operative_to NULLABLE |
Date | The date on which the allowance ceased to be in effect. |
parent_allowance NULLABLE |
String | Description of parent allowance |
payment_frequency NULLABLE |
String | Denotes when the payment is made (i.e. per week, per hour etc.) |
| published_year | Integer | Year in which the minimum rates of pay were determined in the annual wage review. |
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 is fixed over each year |
| Field name | Data type | Description |
|---|---|---|
| allowance | String | Description of allowance |
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 is fixed over each year |
| clauses | String | Clause number |
| 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. |
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 the expense-related allowance that is fixed over each year |
| 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_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 on which the allowance came into effect. |
operative_to NULLABLE |
Date | The date on which the allowance ceased to be in effect. |
parent_allowance NULLABLE |
String | Description of parent allowance |
payment_frequency NULLABLE |
String | Denotes when the payment is made (ie per meal, per km etc) |
| published_year | Integer | 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 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 is fixed over each year. |
base_pay_rate_id NULLABLE |
String | A unique identification number of the base pay-rate resource used to calculate the penalty value. |
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 on which the penalty rate came into effect. |
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 | A textual description of the penalty rate |
| penalty_fixed_id | Integer | Unique identification number of the penalty that is fixed over time |
| published_year | Integer | Year in which the minimum rates of pay were determined in the annual wage review. |
| 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 |