6333.0.00.001 - Microdata: Characteristics of Employment, Australia, August 2018 Quality Declaration 
Latest ISSUE Released at 11:30 AM (CANBERRA TIME) 29/11/2018   
   Page tools: Print Print Page Print all pages in this productPrint All RSS Feed RSS Bookmark and Share Search this Product

FILE STRUCTURE AND CONTENT


FILE STRUCTURE

The underlying format of the Characteristics of Employment (COE) TableBuilder file is structured at a single person level. This person level contains general demographic information such as age, sex, country of birth and status of employment as well details about weekly earnings, working arrangements and qualifications.

When tabulating data from TableBuilder, person weights are automatically applied to the underlying sample counts to provide the survey's population estimates.

The data items included in the COE TableBuilder are grouped under broad headings and subheadings as shown in the image below. A complete data items list can be accessed from the Downloads tab.

    IMAGE: Headings and subheadings

FILE STRUCTURE

Reference Year

The COE TableBuilder contains a mandatory field called Reference year to allow for historical analysis. By default this field will be present in any new table as per the image below:



Individual years can be removed from the table using the data item panel by selecting the required year and removing it from the table as per the image below:



However, at least one category (reference period) of the mandatory field must be present in a table for TableBuilder to retrieve data.

Biennial Content

The COE TableBuilder contains biennial content, distinguished by odd and even years in the Data items list as per the image below:
    IMAGE: Data items and applicable populations

When a data item is placed in a table and was not applicable for a particular reference year, TableBuilder will return a "Not applicable" reference. Where data is requested for multiple years for a biennial item, TableBuilder will retrieve data at the applicable reference year and return "Not applicable" for the year that the data item was not collected.

Not Applicable Categories

Most data items included in the TableBuilder file include a 'Not applicable' category. The classification values of these 'Not applicable' categories, where relevant, are shown in the data item list in the Downloads tab. The 'Not applicable' category generally represents the number of people who were not asked a particular question or the number of people excluded from the population for a data item when that data were derived (e.g. Status of employment in second job is not applicable for people without a second job).

Table Populations

The population relevant to each data item should be kept in mind when extracting and analysing data. The actual population count for each data item is equal to the total cumulative frequency minus the 'Not applicable' category.

Generally, some populations can be 'filtered' using other relevant data items. For example, if the population of interest is 'Employees', any data item with that population (excluding the 'Not applicable' category) could be used.

Zero Value Cells

Tables generated from sample surveys will sometimes contain cells with zero values because no respondents that satisfied the parameters of a particular cell in a table were in the survey. This is despite there being people in the general population with those characteristics. This is an example of sampling variability which occurs with all sample surveys. Relative Standard Errors cannot be generated for zero cells.


Availability of median earnings data in TableBuilder

For the Characteristics of Employment survey, median weekly earnings are considered to be a more robust measure of centre for earnings data and have been given more prominence since August 2017.

To minimise the risk of identifying individuals in aggregate statistics, a technique is used to randomly adjust cell values. This technique is called perturbation. Perturbation involves small random adjustments of the statistics and is considered the most satisfactory technique for avoiding the release of identifiable statistics while maximising the range of information that can be released.

The ABS has tested and implemented a new perturbation process in respect of median earnings data to ensure that both the confidentiality of individuals are maintained, and the integrity of medians is better preserved.