Table: ENR_STATISTICS_SNAPSHOT

 ATTENDANCE_TYPE

A code which identifies whether a student is classified as being a full-time or part-time student, based on their Student Load in the half year

330

Attendance Type in the govt_student_enrolment table is currently calculated for all students. The value is calculated by:

• Attendance Type is only derived for higher degree research students (ie. where the student’s Course Type corresponds to a Government Course Type of 2 or 3). For other Government Course Types, a value of 0 is inserted into attendance_type and govt_attendance_type
• The actual value simplifies the student’s course attempt. (ie. student_course_attempt.attendance_type). EFTSL will not be taken into account.

 COMMENCING_STUDENT_IND

Indicates whether or not the student is considered a commencing student

-

Refer to Derivation of Commencing Student and Commencement Date

Refer to Derivation of Commencing Student and Commencement Date

 SCHOOL_LEAVER

Indicates whether or not the student is considered a school leaver

-

Checks the Commencing Student check box in Enrolmet Statistics Snapshot. If the student is not a commencing student, then the student is not a school leaver and 1 is inserted

For commencing students, checks the student's current statistics record (ENRF3000 or ADMF3000 > ENRF3060) and if:

• No record is found, the student is classed as an other commencing student and 8 is inserted
• If highest attainment value indicates that the student has completed all requirements of a qualification higher than secondary education, 2 is inserted
• If highest attainment education value indicates that the student completed their final year of secondary education in the current collection year or the previous year, 3 is inserted
• If highest attainment education value indicates that the student completed their final year of secondary education earlier than the year prior to the current collection year, 4 is inserted
• If highest attainment education value indicates that the student has completed their final year of secondary education but no information on the year of completion is provided, 9 is inserted

 NEW_TO_HIGHER_EDUCATION

Indicates whether or not the student is attempting higher education for the first time

-

Checks the Commencing Student check box in this file. If the student is not a commencing student, then the student is not new to higher education and 1 is inserted

For commencing students, checks the student's current statistics record (ENRF3000 or ADMF3000 > ENRF3060) and if:

• No record is found, the student is classed as a commencing student but no information on prior higher education course, and 9 is inserted
• If highest attainment indicates the student has never commenced a higher education course prior to this one, and 2 is inserted
• If highest attainment indicates the student has completed all of the requirements of a higher education course prior to starting this one, and 3 is inserted
• If highest attainment indicates the student has commenced but not completed all of the requirements of a higher education course prior to starting this one, and 4 is inserted

 UNIT_LEVEL

The year level in which the unit is normally attempted for the Course Type of the Course Attempt

-

For the Unit Attempt within a Course Attempt, either:

• Retrieves the Unit Level from Course Unit Level (CRSF2210 > CRSF2240) or
• Retrieves the Unit Level from the Unit Version of the Unit Attempt (CRSF2210) or
• Returns NULL where no values exist in either location

 EFTSU

Equivalent full-time Student Unit Load (EFTSL) for this record (Field remains old EFTSU)

339

Refer to Calculation of EFTSL

0000000001 to 1000000000 EFTSU value (For example, 0.125 is coded 0125000000)

 WEFTSU

Weighted EFTSL (Field remains old WEFTSU)

-

Calculated for each record in the enrolments statistics file using the formula:

WEFSTL = EFTSL * discipline.funding_index * unit_internal_ course_level. WEFTSU_factor

where:

• EFTSL is the value calculated for this record (see above)
• Funding index refers to funding index 1 as recorded for the discipline group of this record in CRSF2110
• WEFTSU factor refers to the WEFTSL factor recorded against the unit internal course level (CRSF2180) which is an attribute of the Unit Version of this record (CRSF2210)

 GOVT_REPORTABLE_IND

Indicates whether or not this record should be considered for inclusion in the Government submission snapshot

-

Refer to Government Reportable check box

Table: GOVT_STUDENT_ENROLMENT

Derived from Citizenship, Student Status and Commencement Date:

When the Derive Permanent Resident Eligibility checkbox is selected in STAF1000, a value is derived. If it isn't selected, and a value exists in the Permanent Resident Status field of ENRF3060, then this value is used. If it isn't selected, and there is no value in the Permanent Resident Status field of ENRF3060, the value is set to '9' and added to the error log as a warning.

Value = 0 if the person is:

• Australian citizen or holder of a permanent humanitarian visa (Citizenship code of 1 or 8)
• Permanent visa holder (other than permanent humanitarian visa holder) or New Zealand citizen (Citizenship 2 or 3) who is Commonwealth supported and who began the course on or after 1 January 2005 (Student Status 203)
• Overseas student (Citizenship = 4 or 5)
• Permanent visa holder (Citizenship of 3) who is non-Commonwealth supported and who has requested FEE-HELP for a bridging for overseas trained professionals course (Student Status 233)
• Permanent visa holder or New Zealand citizen (Citizenship of 2 or 3) who is exempt from payment of student contribution or tuition fee (Student Status of 250, 260, 261, 262, 270, 271)
• Permanent visa holder or New Zealand citizen (Citizenship of 2 or 3) who is non-Commonwealth supported and who has not requested FEE-HELP (Student Status of 301, 302, 303 or 305)

Value = 1 if the person is:

• Commonwealth supported pre-2005 HECS student (Student Status of 110, 111) with a permanent visa (other than a permanent humanitarian visa) (Citizenship of 3) who is eligible for HECS-HELP
• Commonwealth supported pre-2005 HECS student (Student Status of 110, 111) who is a New Zealand citizen (Citizenship of 2) who commenced the course before 1 January 1996, and who is eligible for HECS-HELP
• Non-Commonwealth supported pre-2005 PELS student (Student Status of 220) with a permanent visa (other than a permanent humanitarian visa) (Citizenship of 3) who has requested and is eligible for FEE-HELP

Value = 2 if the person is:

• Commonwealth supported pre-2005 HECS student (Student Status of 112) with a permanent visa (other than a permanent humanitarian visa) (Citizenship of 3) who is not eligible for HECS-HELP because they are residing overseas (Term location begins with an X)
• Commonwealth supported pre-2005 HECS student (Student Status of 112) who is a New Zealand citizen who (Citizenship of 2) is not eligible for HECS-HELP because they are residing overseas (Term location begins with an X)
• Non-Commonwealth supported pre-2005 PELS student (Student Status of 302) with a permanent visa who (Citizenship of 3) has requested but is not eligible for FEE-HELP because the student is residing overseas (Term location begins with an X)

Value = 3 if the person is:

• Commonwealth supported pre-2005 HECS student (Student Status of 112) with a permanent visa (other than a permanent humanitarian visa) (Citizenship of 3) who is not eligible for HECS-HELP because the student meets the prescribed residency requirements and first met them more than 12 months ago (Assumed if the person has a Student Status of 112) and Term Location begins with ‘A’
• Commonwealth supported pre-2005 HECS student (Student Status of 112) who is a New Zealand citizen (Citizenship of 2) who is not eligible for HECS-HELP because the student commenced the course on or after 1 January 1996 (Based on the Course of Study commencement) and Term Location begins with ‘A’
• Non-Commonwealth supported pre-2005 PELS student (Student Status of 302) with a permanent visa (Citizenship of 3) who is not eligible for FEE-HELP because the student satisfies the residency test and first satisfied it more than 12 months ago (Assumed) and Term Location begins with ‘A’ and previous PELS debt reported (in an earlier pre-2005 submission) and course commencement < 1/1/2005.

Value = 9 then error. See beginning paragraph.

If Permanent Resident Eligibility is coded 2 or 3 THEN Student Status Code must be 112, 302, 303, 304, 305.

If Student Status is 250, 260, 261, 262, 270, 271 THEN Permanent Resident Eligibility must be coded 0.

If Citizen/Resident Indicator is one of 1, 4, 5 or 8 THEN Permanent Resident Eligibility must be coded 0.

If Student status code is 110, 111, 201, 202, 220, 230, 231, 232, 233 THEN Permanent Resident Eligibility must be 0 or 1.

ATTENDANCE_TYPE

A code which identifies whether a student is classified as being a full-time or part-time student, based on their Student Load in the half year

330

Same as above.

 GOVT_DISABILITY

An eight-character code indicating responses to three questions about disabilities

386

An eight character code is derived for each student based on any disabilities recorded against the student (ENRF3000 or ADMF3000 > ENRF3040). Each character of the code has specific meaning:

1st character - 0 - Student did not indicate the existence of a disability, impairment or long term medical condition
1st character - 1 - Student indicated that she/he has a disability, impairment or long term medical condition
1st character - 2 - Student indicated that she/he does not have a disability, impairment or long term medical condition

2nd character - 0 - Student did not indicate she/he has a hearing disability
2nd character - 1 - Student indicated that she/he has a disability, impairment or long term medical condition and that she/he has a hearing disability

3rd character - 0 - Student did not indicate she/he has a learning disability
3rd character - 1 - Student indicated that she/he has a disability, impairment or long term medical condition and that she/he has a learning disability

4th character - 0 - Student did not indicate she/he has a mobility disability
4th character - 1 - Student indicated that she/he has a disability, impairment or long term medical condition and that she/he has a mobility disability

5th character - 0 - Student did not indicate she/he has a visual disability
5th character - 1 - Student indicated that she/he has a disability, impairment or long term medical condition and that she/he has a visual disability

6th character - 0 - Student did not indicate she/he has a medical disability
6th character - 1 - Student indicated that she/he has a disability, impairment or long term medical condition and that she/he has a medical disability

7th character - 0 - Student did not indicate she/he has an other disability
7th character - 1 - Student indicated that she/he has a disability, impairment or long term medical condition and that she/he has an other disability

8th character - 0 - Student did not indicate that she/he has a disability
8th character - 1 - Student indicated that she/he has a disability, impairment or long term medical condition and that she/he would like to receive advice on support services, equipment and facilities
8th character - 2 - Student indicated that she/he has a disability, impairment or long term medical condition and that she/he does not wish to receive advice on support services, equipment and facilities.

This one digit code is determined using Student Course Attempt records.

Code 1 Student is commencing a Higher Degree Research course and is transferring from one Higher Degree Research course to another Higher Degree Research course at the same level at the same Higher Education Provider

Code 2 Student is commencing a Higher Degree Research course and is upgrading from a Masters by Research course to a Doctorate by Research course at the same Higher Education Provider, without having successfully completed the initial degree.

Code 3 Student is commencing a Higher Degree Research course and is downgrading from a Doctorate by Research course to a Masters by Research course at the same Higher Education Provider, without having successfully completed the initial degree.

Otherwise a 9 is inserted.

Students who transfer from a Higher Degree Research course in one Higher Education Provider to a Higher Degree Research course at another Higher Education Provider, regardless if there has been a change of level are to be recorded as '9'.

COMMENCEMENT_DT

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

534

If Student Status Code is 201, 202, 203, 230, 231, 233, 260, 270 THEN Course of Study Commencement Date should be equal to or greater than the Calendar Value of 200501. Warning if it is not.

Code 00001 - Not a Domestic school leaver commencing an undergraduate course.
The following two codes are for a domestic school leaver commencing an undergraduate course:
A0001 to A9998 - Australian postcode
99999 - No information on location of residence

Only for Domestic school leaver students commencing an undergraduate course.
A school leaver is one who has completed Year 12 in the year of the collection or the year prior to the year of the collection.

This code must reflect the permanent home residence of the student in the last year of their secondary study and is to be provided by the student when the course is first commenced.

Table: GOVT_STUDENT_LOAD_LIABILITY

 TOTAL_EFTSL

Total EFTSL for a Student Course Attempt within a Government Semester.

-

Total EFTSL for the Unit of Study split by Teaching Organisation Unit. Replaces Total EFTSU.

Pre-2005 HECS-liable students
110 Deferred all or part of student contribution through HECS-HELP
111 Paid full student contribution up-front with HECS-HELP discount
112 Paid full student contribution up-front without HECS-HELP discount

Contribution-liable students from 2005
201 Deferred all or part of the student contribution through HECS-HELP
202 Paid the full student contribution up-front with the HECS-HELP discount
203 Paid the full student contribution up-front without the HECS-HELP discount

Pre-2005 PELS students
220 Deferred all or part of the tuition fee through FEE-HELP

FEE-HELP eligible students from 2005
230 Deferred all or part of Award or Enabling course tuition fee through FEE-HELP
231 Deferred all or part of Employer reserved place tuition fee through FEE-HELP
232 Deferred all or part of OLA tuition fee through FEE-HELP
233 Deferred all or part of BOTP tuition fee through FEE-HELP
OS-HELP recipient students from 2005
240 Received loan through OS-HELP

Pre-2005 HECS-exempt students
250 A domestic student holding a Commonwealth-funded, merit-based, undergraduate HECS-exemption scholarship for disadvantaged students

Contribution-exempt students from 2005
260 Student in a Commonwealth supported place with an Exemption scholarship (no student contribution to be charged)
261 A domestic student enrolled in an enabling course (i.e. bridging or supplementary programme)
262 Student undertaking Work Experience in Industry (WEI) where learning and performance is not directed by, and support is not received from, the provider and for which a student contribution cannot be charged

Non-overseas tuition fee-exempt students from 2005
270 Student in a non-Commonwealth supported place with an Exemption scholarship (no tuition fee to be charged)
271 Student undertaking Work Experience in Industry (WEI) where learning and performance is not directed by, and support is not received from, the provider and for which a tuition fee cannot be charged

Fee-paying non-overseas students
301 A domestic student enrolled in a non-award course (other than an Enabling course)
302 Paid full Award or Enabling course tuition fee
303 Paid full Employer reserved place tuition fee
304 Paid full OLA tuition fee
305 Paid full BOTP tuition fee

Fee-paying overseas students
310 A fee-paying overseas student who is not sponsored under a foreign aid program, and including students with these awards: IPRS (International Postgraduate Research Scheme); SOPF (Special Overseas Postgraduate Fund); Australian-European Awards Program; and the Commonwealth Scholarship and Fellowship Plan
311 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 Higher Education Providers by the Australian Agency for International Development (AusAID)

Pre-2001 RTS students
320 A domestic student who received a research HECS exemption prior to 1 September 2000 and continues studying on a student contribution exempt basis under the Research Training Scheme (RTS) as a pre-2001 student. Include internal transfers/upgrades/downgrades (as defined under Element 465) (see coding notes)

RTS students from 2001
330 A domestic student enrolled under the Research Training Scheme (RTS) from 1 September 2000 (see coding notes)

Australian Maritime College (AMC)
340 A Commonwealth funded VET student enrolled in an Australian Maritime College Special Course
341 A non-Commonwealth funded VET student in an Australian Maritime College Special Course.

Code 240 “Received loans through OS-HELP” is not to be used on the Load/Liability File. This code is only to be used in the HELP-DUE File in respect of students who are reported on the OS-HELP File.

A domestic postgraduate research student who is not RTS supported may be charged tuition fees or awarded an Exemption scholarship under code 270. If regional adjustment package has been used to support such students, these students should be included under code 270.

A domestic postgraduate research student charged tuition fees may receive FEE-HELP assistance.

FOR ATO purposes only, Element 380 (Liability status codes) will be concorded to Element 490 (Student status):

• Element 380 = 80 (E490 = 110, 201)
• Element 380 = 81 (E490 = 220, 230, 231, 232, 233)
• Element 380 = 82 (E490 = 240)

 INDUSTRIAL_INDICATOR

An indicator of whether a unit of study consists wholly of work experience in industry

337

Code 0 - Student is not undertaking work experience in industry or student is undertaking work experience in industry where learning and performance is directed by the provider
Code 1 - Student is undertaking work experience in industry where learning and performance is not directed by the provider, but support is received from the provider
Code 2 - Student is undertaking work experience in industry where learning and performance is not directed by, and support is not received from, the provider.

Students coded as '0' are not considered to be undertaking a unit of study consisting wholly of work experience in industry.

Students coded as '1' are considered to be undertaking a unit of study consisting wholly of work experience in industry and the provider may charge a student contribution amount or tuition fee.

Students coded as '2' are considered to be undertaking a unit of study consisting wholly of work experience in industry and the unit of study is student contribution and tuition fee exempt.

A Work Experience in Industry unit of study for which no credit is given (and therefore has no EFTSL value), is not to be reported to DEST

The Maximum Student Contribution Indicator is:

• 0 If the Student Status is not 110, 111, 112, 201, 202, 203 (or if the Student Status is 110, 111 or 112 and the differential HECS Indicator is N)
• 1 If the Student Status is 110, 111 or 112 and the differential HECS Indicator is Y
• 2 If the Student Status is 201, 202 or 203 commencing before 2008
• 3 If the Student Status is 201, 202 or 203 commencing 2008 or after

HECS-HELP

IF Student Status (E490) = 110, 111, 201, or 202 THEN

FOR each Student ID (E313) / Course code (E307) / Unit of study code (E354) record where Student Status (E490) = 110, 111, 201, or 202

SUM all values for Amount paid up front (E381) and Total Amount charged (E384)

END FOR

IF SUM of Amount paid up front (E381) >= $500 or is <$500 but >= 80% of the SUM of Total Amount charged (E384) THEN

The “realvalue” of Amount paid up front (E381) = 1.25 x Amount paid up front (E381)

END IF

IF SUM of Amount paid up front (E381) < $500 and < 80% of the SUM of Total Amount charged (E384) THEN

The “realvalue” of Amount paid up front (E381) = Amount paid up front (E381)

END IF

Unit of study HELP debt (E558) = Total Amount charged (E384) - “real value” of Amount paid upfront (E381)

END IF

FEE-HELP

FOR each Student ID (E313) / Course code (E307) / Unit of study code (E354) record where Student Status (E490) = 220, 230, 231, 232, or 233

IF Amount paid up front (E381) < Total Amount charged (E384) THEN

Unit of study HELP debt (E558) = Total Amount charged (E384) - Amount paid up front (E381) + Loan Fee (E529)

END IF

END FOR