Pivot Table Field List

This page describes the fields in the various pivot tables and Power cubes prepared by Planning and Assurances Services. Click HERE to return to the Statistics Page.

Division Code
Division Name
School Code
School Name
Program Code
Program Name
Program Level - All
Program Level - Medium
Program Level - Broad
Program Major
Field of Study
Campus
Australian/International
Onshore/Offshore
Citizenship Status
Internal/External
Attendance Mode
Full Time/Part Time
Commence Date
Commencing/Continuing
HECS Exemption Status
Total Units
Credit Granted %
Stage of Program
Basis of Admission
Gender
Years of Age
Age by Groups
Country of Birth Code
Country of Birth Name
Language Code
language
Funding Source
ATSI Status
ATSI Origin
Home Residence Group
Home Residence Code
Home Residence
Semester Residence Group
Semester Residence Code
Semester Residence
Disability Status
Years Since Commenced
Total Exemption %
Commence Year
Specialty Area

Pivot Table Definitions

Division Code & Name

in Planning > Management Reporting refer to Organisational Codes Org1 codes.

School Code & Name

in Planning > Management Reporting refer to Organisational Codes Org2 codes.

Program Code

Generally:

First letter represents the campus (see Campus above)
Second letter represents the program level
Last two letters are an abbreviation of the program name

Program Name

Abbreviated program name

Program Level - All

A code which indicates the type of higher education program.

01	Higher Doctorate
02	Doctorate by research
12	Doctorate by coursework
03	Master's by research
04	Master's by coursework
05	Postgraduate Qualifying or Preliminary (for Master's, Doctorate or Higher Doctorate)
06	Graduate Diploma/ Postgraduate Diploma (pass or honours) involving new academic, professional or vocational area
07	Graduate Diploma/ Postgraduate Diploma (pass or honours) extending skills and knowledge in a professional area previously studied · Graduate Certificate
11	Graduate Certificate
08	Bachelor's Graduate Entry
09	Bachelor's Honours
10	Bachelor's Pass
13	Associate degree
20	Advanced Diploma (AQF terminology)/Diploma (pre-AQF terminology)
21	Diploma (AQF terminology)/ Associate Diploma (pre-AQF terminology)
22	Other award program
30	Enabling program
41	Cross-institution program for undergraduates at home institution
42	Cross-institution program for postgraduates at home institution
50	Non-award program
60	Open learning studies

Program Level - Medium

A breakdown of program levels into 5 main groups

Higher Degree - research	Doctorate by research
	Master's by research
Higher Degree - coursework	Master's by coursework
	Doctorate by coursework
Other Postgraduate	Grad/Postgrad Diploma (new)
	Grad/Postgrad Diploma (previous)
	Graduate Certificate
Undergraduate	Bachelor 's Graduate Entry
	Bachelor's Honours
	Bachelor's Pass
	Advanced Diploma
	Diploma
Other	Enabling program
	Cross-institution (undergraduate)
	Cross-institution (postgraduate)
	Non-award program

Program Level - Broad

A breakdown of program level into Postgraduate/Undergraduate

Postgraduate	Doctorate by research
	Master's by research
	Master's by coursework
	Grad/Postgrad Diploma (new)
	Grad/Postgrad Diploma (previous)
	Cross-institution (postgraduate)
	Graduate Certificate
	Doctorate by coursework
Undergraduate	Bachelor 's Graduate Entry
	Bachelor's Honours
	Bachelor's Pass
	Advanced Diploma
	Diploma
	Enabling program
	Cross-institution (undergraduate)
	Non-award program

Program Major

A single alphbaetic character indicating the program option or stream the student has chosen to major in

Speciality Area Code

Six digit 'Speciality Area' code including broad, major and minor fields of study

Field of Study or Speciality Area

A classification of programs based on similarity in terms of the vocational field of specialisation or the principal subject matter of the program. The 2 digit Broad Field of Study groups or Speciality Area are:

01	Agriculture, Animal Husbandry
02	Architecture, Building
03	Arts, Humanities and Social Science
04	Business, Administration, Economics
05	Education
06	Engineering, Surveying
07	Health
08	Law, Legal Studies
09	Science
10	Veterinary Science

Campus Code & Name

D	City West
I	City East
L	Mawson Lakes
M	Magill
O	Offshore
S	Salisbury
U	Underdale
W	Whyalla

Australian/International

Broad reference to citizenship status:

Australian - student whose citizenship status is Australian, New Zealand or permanent resident
International - student on a temporary residency permit or has status other than the above

Onshore/Offshore

Indicates whether a student is studying at an onshore or offshore campus

Citizenship Status

Indicates a student's citizenship and residence status

Internal/External

Identifies the mode of attendance by which the student undertakes a program:

Internal - Internal Mode or Multi-modal of Attendance at an onshore or offshore campus
External - External Mode of Attendance at an onshore or offshore campus

Attendance Mode

Identifies the mode of attendance by which the student undertakes a program:

Internal - Internal mode of attendance at an onshore or offshore campus
External - External mode of attendance at an onshore or offshore campus
Mixed - Multi-modal attendance at an onshore or offshore campus

Full Time/Part Time

Identifies whether a student is classified as being a full-time or part-time student

Full-time - Full-time attendance (Load for all the programs being undertaken is 0.75 or more)
Part-time - Part-time attendance (Load for all the programs being undertaken is less than 0.75)

Commence Date

A code which indicates the year and month in which the student commenced the current program for the first time

Commence Year

In completions tables only. A code which indicates the year in which the student commenced the current program for the first time

Years Since Commenced

In completions tables only. The total number of years that a student took to complete their award. Periods of leave taken from the program are included in the time taken

Commencing/Continuing

Indicates whether the student is commencing or continuing their studies

Total Exemption %

Percentage of a student's program for which they have been granted exemption. An exemption is granted by an institution when a student is not required to undertake a part of a course, a course or courses because of prior studies or work experience.

HECS Exemption Status

Deferred	HECS liable student who deferred all or part of liability
Paid up-front, discount	HECS liable student who paid full liability up-front with discount
Paid up-front, no discount	HECS liable student who paid full liability up-front with no discount
FPUG	A non-overseas student who is paying tuition fees for an undergraduate award program. Excludes student enrolled in remedial or fast tracking courses
FPPS	A non-overseas student who is paying tuition fees for a postgraduate program. Excludes students enrolled in remedial of fast tracking courses.
FPOS	A fee-paying overseas student who is not sponsored under a foreign aid program, and including students with these awards: OPRS (Overseas Postgraduate Research Scheme); SOPF (Special Overseas Postgraduate Fund); Australian-European Awards Program; and the Commonwealth Scholarship and Fellowship Plan. Excludes OPRS and SOPF students who have category 818 visas.
Overseas - non-fee	An overseas student who is not a fee-paying overseas student but is subject to the Overseas Student Charge arrangements
FPOS Sponsored	A fee-paying overseas student who is sponsored under a foreign aid program. Includes those with Australian Development Cooperation Scholarships (ADCOS) and any other Australian foreign aid program for which students are enrolled in institutions by the Australian Agency for International Development (AusAID).
Bridging	A non-overseas disadvantaged student enrolled in an enabling program (i.e. bridging or supplementary program).
Non award	A student enrolled in a non-award program.
Employer Sponsored	A student enrolled in a program fully funded by an employer.
Research over limit	A non-overseas student enrolled in a Higher Doctorate. Ph.D by research or thesis, or Masters degree by research or thesis program who has exceeded the maximum time limit for completion of such a program.
29	A non-overseas student who is paying tuition fees for a remedial or fast tracking course, or courses in a non-standard semester.
30	Overseas student in Australia as an exchange student and who is paying tuition fees or has their fees paid for them.
UG Scholarship	A non-overseas student holding a Commonwealth-funded, merit-based, undergraduate HECS-exemption scholarship for disadvantaged students
CIPS	A student in a Commonwealth-industry place and is deemed by the institution to be exempt from HECS.
WEI	A non-overseas student whose FULL load is work experience in industry.
Aust PG Scholarship	A student with an Australian Postgraduate Award awarded by the institution, or a student with an Overseas Postgraduate Research Scholarship (OPRS) who has a category 818 visa, or a Special Overseas Postgraduate Fund (SOPF) student who has a category 818 visa.
71	A non-overseas student enrolled in an Australian Maritime College Special Program
72	A fee-paying overseas student enrolled in an Australian Maritime College Special Program
99	A student enrolled in an Avondale Special Program
TAFE	A student enrolled in a TAFE program
Missing	Missing Data

Total Units

Points awarded for completed courses and any exemption granted for the current program

Credit Granted %

Percentage of the current program’s requirements over all its stages, for which exception was granted by the reference date in the first year of enrolment

Stage of Program

Indicates the 'year' of the program the student is studying. E.g. Stage 1 = '1st year'. From 2000, the stage has been calculated by the total number of units for the student.(Every 36 units are considered as 1 year completed).

Basis of Admission

Not a commencing student

A completed higher education program (Australian or overseas equivalent)

An incomplete higher education program (Australian or overseas equivalent)

A complete or incomplete TAFE award program other than a secondary education program (Aust or OS equiv)

Satisfactory completion of final year of secondary education undertaken at school (Aust or OS equiv)

Satisfactory completion of final year of secondary education undertaken at a TAFE institution or other institution (Aust or OS equiv)

Mature age special entry provisions

Special entry provisions other than mature age

An examination or assessment by or on behalf of the institution (includes assessment of performances or products)

Employment experience

A professional qualification

Completion of open learning studies conducted by the OLAA

A complete TAFE award program other than a secondary education program

An incomplete TAFE award course other than a secondary education program

Other basis

Gender

Indicates whether the student is Male or Female

Years of Age

Indicates the age of the student

Age by Groups

Indicates the age of the students in broad age ranges

Older than 21

Indicates whether the students are aged over 21 years

Older than 24

Indicates whether the students are aged over 24 years

Country of Birth Code or Name

Indicates the code or name of the student's country of birth

Language Code or Language

Language code or language spoken at permanent home residence

LOTE Status

Indicates whether there is a main language other than English spoken at the permanent home residence

Non-English Speaking Background

Includes students whose:

Citizenship status is Australian, New Zealand or permanent resident
Language spoken at permanent home residence is not English
Arrival in Australia is within the last 10 years

Equity Scope Indicator

Indicates the scope within which students are considered for equity status:

Yes - includes those students whose citizenship status is Australian, New Zealand or permanent resident, and are not enrolled in an open learning or cross institutional program
No - includes all other students not included in the above criteria

In an Equity Group

Students who are included in any of the following groups:

WINS, ATSI, Disability, low SES, Rural, Isolated and NESB

In an Equity Group - Incl Bus

Students who are included in any of the following groups:

WINSB, ATSI, Disability, low SES, Rural, Isolated and NESB

WINS or WINSB

WINS - Female students enrolled in non-traditional study areas (excluding business studies)
WINSB - Female students enrolled in non-traditional study areas (including business studies)

Funding Source

Indicates where the funds for the student's program are derived

01	Comm. Op. Grant Non Fee	Commonwealth Operating Grants - ie HECS Liable or
02	FPOS Offshore	Fee Paying Overseas Student - Studying outside Australia
03	FPOS Onshore	Fee Paying Overseas Student - Studying in Australia
04	FPPS Offshore	Fee Paying Postgraduate Student - Studying outside Australia
05	FPPS Onshore	Fee Paying Postgraduate Student - Studying in Australia
06	FPUG Offshore	Fee Paying Undergraduate Student - Studying in Australia
07	FPUG Onshore	Fee Paying Undergraduate Student - Studying in Australia
08	Non Award	A program of study which does not lead to an award
09	Employer Sponsored	A student enrolled in a program fully funded by an employer
10	Tafe	A TAFE program
11	ISAS	Study Abroad Australia
12	IESP	International Exchange Student Program
13	Research over time limit	A non-overseas student enrolled in a Higher Doctorate. Ph.D by research or thesis, or Masters degree by research or thesis program who has exceeded the maximum time limit for completion of such a program.

ATSI Status

Identifies whether or not the student identifies themselves as being of either Australian Aboriginal or Torres Strait Islander descent

ATSI Origin

Identifies whether or not the student identifies themselves as being of either Australian Aboriginal and Torres Strait Islander descent

Neither Aboriginal nor Torres Strait Islander origin

Of Aboriginal origin

Of Torres Strait Islander origin

Of both Aboriginal and Torres Strait Islander origin

No information

Low Socio Economic Status

Equity indicator for low socio economic group, derived from post-codes of students whose home residence status is Australian

Socio Economic Status

Equity indicator for socio economic groups (low, medium and high) derived from post-codes of students whose home residence status is Australian

Rural or Isolated

Equity indicator derived from post-codes of students whose home residence status is Australian

Home Residence Group

Indicates a student's permanent home residence:

Australian state or territory (South Australia is divided into metro and other)
Overseas

Home Residence Code

The Australian postcode or overseas country code of a student's permanent home residence

Home Residence

Indicates the country name of a student's permanent home residence

Semester Residence Group

Indicates a student's place of residence during a semester or term

Australian state or territory (South Australia is divided into metro and other)
Overseas