6311.0 - Information Paper: Construction of Experimental Statistics on Employee Earnings and Jobs from Administrative Data, Australia, 2011-12  
Latest ISSUE Released at 11:30 AM (CANBERRA TIME) 11/12/2015  First Issue
   Page tools: Print Print Page Print all pages in this productPrint All RSS Feed RSS Bookmark and Share Search this Product

APPENDIX 1: DISTRIBUTION OF KEY VARIABLES

To assist users in interpreting the aggregate experimental statistics, this appendix presents the distribution of key data items on the Integrated Dataset, including the amount of inadequately defined, not stated or missing information on each of the three files.

EMPLOYEE FILE AND JOB FILE

The following section presents the distribution of data from the Employee File and Job File. Care should be taken in comparing these to other publications, as the population and the distribution of variables will be different (see Explanatory Notes, paragraphs 74-77).

Age

Table 1.1: Distribution of employees by age group
Age group
Employees
(‘000)
%

14 years and under
5.7
0.1
15-17
134.8
1.3
18-20
561.0
5.4
21-24
992.2
9.6
25-29
1 337.5
12.9
30-34
1 192.8
11.5
35-39
1 113.5
10.8
40-44
1 142.2
11.1
45-49
1 071.2
10.4
50-54
1 029.9
10.0
55-59
826.2
8.0
60-64
564.4
5.5
65-69
238.2
2.3
70-74
71.4
0.7
75-79
27.5
0.3
80-84
15.8
0.2
85 & over
10.3
0.1


Sex
Table 1.2: Distribution of employees by sex
Sex
Employees
(‘000)
%

Male
5 359.1
51.9
Female
4 975.6
48.1


Geography
Table 1.3: Distribution of employees by state and territory of home address
State and territory
Employees
(‘000)
%

New South Wales
3 180.7
30.8
Victoria
2 531.1
24.5
Queensland
2 065.7
20.0
South Australia
705.9
6.8
Western Australia
1 151.5
11.1
Tasmania
216.7
2.1
Northern Territory
95.0
0.9
Australian Capital Territory
198.3
1.9
Other territories
0.5
0.0
Inadequately defined/missing
189.3
1.8


Table 1.4: Completeness of address coding at the state and territory and SA4
Geographic level
Employees
(‘000)
%

State and territory present
10 145.4
98.2
State and territory missing
189.3
1.8
SA4 present
10 123.0
98.0
SA4 missing
211.7
2.1


Occupation in Main Job
Table 1.5: Distribution of employees by occupation (a)
Occupation
Employees
(‘000)
%

Managers
1 213.5
11.7
Professionals
2 180.3
21.1
Technicians and trades workers
1 274.0
12.3
Community and personal service workers
1 037.9
10.0
Clerical and administrative workers
1 624.7
15.7
Sales workers
892.3
8.6
Machinery operators and drivers
624.2
6.0
Labourers
1 062.7
10.3
Inadequately defined/not stated
425.2
4.1

(a) Occupation in main job.

Earnings and Gross Payments

The following table shows the total earnings (reported on an ITR) for all employees, and gross payments (reported on the Individual PAYG summaries) for all jobs, along with their respective mean and median.

Table 1.6: Earnings and gross payments in all jobs
Item
Total
Mean
Median
($b)
($)
($)

Earnings
575.4
55 678
45 869
Gross payments
505.5
37 961
26 134


Mean earnings is calculated by summing all employee earnings (Total) and dividing by the number of employees. Mean gross payment is calculated by summing all of the gross payments (Total) and dividing by the number of jobs.

The following graph shows the proportional distribution of the components of earnings.

Graph 1.1: Distribution of earnings components (a)

Graph 1.1 shows the distribution of the earnings components as a percentage of total earnings.
(a) This excludes employees whose earnings data was cleaned (see Integration Methodology).


As shown in Graph 1.1, Wages and Salaries comprise 93.3% of earnings, with the remaining 6.7% distributed mostly among Superannuation Contributions, Fringe Benefits, and Allowances.

The distribution of earnings recorded in the LEED Foundation Projects is comparable at aggregate level to the data presented in the ATO Tax Statistics for the 2011-12 financial year published on the ATO website.

Start and End Dates

The following table shows the quality of the start and end dates for each job. It is categorised by whether one or both dates are present and whether they are within an acceptable range (between 1 July 2011 to 30 June 2012).

Table 1.7: Comparison of dates from Individual PAYG summary data
Quality of date variable
Jobs
(‘000)
%

Both dates acceptable
13 092.0
98.3%
Date missing
One date
10.6
0.1%
Both dates
73.9
0.6%
Error in dates
One date
116.7
0.9%
Both dates (a)
23.7
0.2%

(a) Includes records where the end date is before the start date.

As shown in Table 1.7, the start and end dates for some Individual PAYG summaries contain invalid date information. These resulted in durations of 0 or negative days, or more than 366 days. The number of incorrect and missing dates, however, is relatively low at 1.7%. There may be other incorrect dates which fall within the 2011-12 financial year but these are not able to be identified.

BUSINESS FILE

The following section presents the distribution of data from the Business File. Care should be taken in comparing these to other ABS publications such as Counts of Australian Businesses, Entries and Exits (cat. no. 8165.0), as the population and the distribution of variables will be different as a result of the scope (see Introduction) and the ABN to TAU mapping process (see Integration Methodology) used in the LEED Foundation Projects (see Explanatory Notes, paragraphs 74-77).

Profiled and Non-profiled businesses

Table 1.8: Distribution of businesses by profiled status
Whether profiled
Businesses
Job share (a)
(‘000)
%
%

Profiled (TAU based)
7.8
1.1
49.2
Non-profiled (ABN based)
675.6
98.9
50.7

(a) Percentage of all jobs on the Job File. Totals do not add to 100% due to jobs which are not linked to businesses.

Employment size

Table 1.9: Distribution of businesses by employment size
Employment size
Businesses
Employment share (a)
(‘000)
%
%

1 to 4 employees
419
61.3
9.4
5-19 employees
172
25.2
16.0
20-199 employees
48.8
7.1
23.5
200 employees or more
4.2
0.6
51.1
No employees reported (b)
39.3
5.8
0.0

(a) Percentage of total employment on the Business File.
(b) These businesses have jobs linked to them in the LEED Foundation Projects, but have reported no employees. This may be due to:
    • the time of reporting (i.e. they did not have any employees at the time of reporting but did at another point in the financial year); or
    • incorrect linking of jobs to a TAU; or
    • reporting errors made by the business.

Business Turnover

Table 1.10: Distribution of businesses by business turnover
Business turnover
Businesses
Turnover share (a)
(‘000)
%
%

Less than $50,000
43.5
6.4
0.0
$50,000 to less than $200,000
144.9
21.2
0.6
$200,000 to less than $2 million
376.6
55.1
8.1
$2 million or more
100.5
14.7
91.3
Inadequately defined/not stated
17.7
2.6
0.0

(a) Percentage of turnover on the Business File.

Industry

Table 1.11: Distribution of businesses by industry
Industry
Businesses
(‘000)
%

Agriculture, forestry and fishing
46.0
6.7
Mining
3.1
0.5
Manufacturing
41.1
6.0
Electricity, gas, water and waste services
2.1
0.3
Construction
104.1
15.2
Wholesale trade
33.2
4.9
Retail trade
64.4
9.4
Accommodation and food services
46.3
6.8
Transport, postal and warehousing
32.1
4.7
Information media and telecommunications
5.8
0.8
Financial and insurance services
24.7
3.6
Rental, hiring and real estate services
25.3
3.7
Professional, scientific and technical services
91.4
13.4
Administrative and support services
29.7
4.4
Public administration and safety
3.9
0.6
Education and training
13.3
2.0
Health care and social assistance
47.1
6.9
Arts and recreation services
9.6
1.4
Other services
52.0
7.6
Inadequately defined/not stated
8.0
1.2


Type of Legal Organisation (TOLO)

Table 1.12: Distribution of businesses by TOLO
TOLO
Businesses
(‘000)
%

Incorporated private sector entities
377.1
55.2
Unincorporated private sector entities
294.4
43.1
Public sector entities
11.8
1.7


Institutional Sector (SISCA)

Table 1.13: Distribution of businesses by institutional sector
Institutional sector
Businesses
(‘000)
%

Non-financial corporations
351.0
51.4
Financial corporations
24.5
3.6
General government
3.3
0.5
Households
281.3
41.2
Non-profit institutions serving households
15.1
2.2
Inadequately defined/not stated
8.1
1.2