Student identification code

Student

Student No.

studentNumber

Student > Student Details > Edit details

TEXT

N/A

10

N/A

Course code

Base Course

Id

eduProgramId

Courses > Edit Details

TEXT

N/A

10

N/A

Date of birth

Student

DOB

birthDate

Student > Student Details > Edit details

DATE

N/A

8

N/A

Gender code

Student

Gender

gender

Student > Student Details > Edit details

SELECT

N/A

1

N/A

Aboriginal and Torres Strait Islander code

Student

DEST_316

destE316

Student > Student Details > Edit details

SELECT

9 - No information

1

N/A

Location code of semester/term residence

Student

DEST_319

destE319

Student > Student Details > Edit details

POSTCODE

99999 - No information on location of residence​

5

N/A

Location code of permanent home residence

Student

DEST_320

destE320

Student > Student Details > Edit details

POSTCODE

99999 - No information on location of residence​

5

N/A

Basis for admission to current course

Course Enrolment

Student Admission

destE327

Student > Course Enrolment > Course

SELECT_LONG

01 - Not a commencing student

2

YES

If commencement year < submission year, then return 01 - Not a commencing student;

Otherwise, return the code that reflects the selection you chose.

if($commencement_year < $submission_year){
return '01';
else return $survey_program_enrolment_dtls->data_fields

Type of attendance code

Course Enrolment

HEIMS Type of Attendance

destTypeOfAttendance

Student > Course Enrolment > Course

SELECT

1

1

N/A

Country of birth code

Student

DEST_346

destE346

Student > Student Details > Edit details

SELECT

0000

4

N/A

Year of arrival in Australia

Student

DEST_347

destE347

Student > Student Details > Edit details

YEAR

A999

4

N/A

Language spoken at home code

Student

DEST_348

destE348

Student > Student Details > Edit details

SELECT

9999

4

N/A

Credit offered value

Course Enrolment

HEIMS Credit Offered

destE565

Student > Course Enrolment > Course

TEXT

0000

4

N/A

Credit/status Higher Education Provider code

Course Enrolment

HEIMS Credit Intitution

destE566

Student > Course Enrolment > Course

SELECT

0000

4

N/A

Tertiary entrance score

Course Enrolment

Tertiary Entrance Score

destE369

Student > Course Enrolment > Course

SELECT_TERT

001

3

N/A

Disability

Student

DEST_386

destE386

Student > Student Details > Edit details

MULTI_SELECT

00000000

8

N/A

Total Previous RTS EFTSU

Student

DEST_460

destE460

Student > Student Details > Edit details

TEXT

0000

4

N/A

Separation Status code

Student

DEST_465

destE465

Student > Student Details > Edit details

SELECT

9

1

N/A

Commencing Location

Student

DEST_476

destE476

Student > Student Details > Edit details

LOCATION

00001

5

N/A

Name of Town/Locality for the student

Student

DEST_486

destE486

Student > Student Details > Edit details

TEXT

null

27

N/A

Overseas student tuition fee

-

-

-

-

TEXT

00000

5

YES

This is a complicated derived field.

You will need to check the following fields are filled out correctly:

• HEIMS census date(e489) filled out at the scheduled unit level

• The unit enrolment withdraw date is greater than the census date or withdraw date is null

• Select the unit enrolment status from the drop down

• HEIMS Variation reason is null or the code is not equal to 4

• Unit_enrolment_HEIMS E490 field has selected either ‘310’ or ‘311’.

sum (unit_fee) as fees
FROM edu_unit_enrolment e, edu_scheduled_unit u
WHERE
AND u.dest_census_date in (".create_csv_list_from_array($census_date).")
AND (e.withdrawal_date > u.dest_census_date OR e.withdrawal_date is null)
AND (e.enrolment_status_id in (".create_csv_list_from_array($unit_enrolment_status)."))
AND e.edu_scheduled_unit_id = u.edu_scheduled_unit_id
AND (e.dest_variation_reason::Integer <> 4 OR e.dest_variation_reason is null)
AND e.dest_e490 in ('310', '311')";

Highest educational attainment prior to commencement

Student

DEST_493

destE493

Student > Student Details > Edit details

SELECT_YEAR

090000

6

N/A

Scholarship-Type

Course Enrolment

HEIMS Scholarship Type

scholarshipType

Student > Course Enrolment > Course

SELECT

00

2

N/A

Commonwealth Higher Education Student Support Number (CHESSN)

Student

CHESSN No

chessenNo

Student > Student Details > Edit details

TEXT

ZZZZZZZZZZ

10

N/A

Reporting year and period code

Reports

Submission Year

Period Number

submission_year

period_no

Reports/HEIMS

INPUT

00000

5

N/A

Credit used value

Course Enrolment

HEIMS Credit Used

destE560

Student > Course Enrolment > Course

TEXT

0000

4

N/A

Details of prior study for which credit was offered

Course Enrolment

HEIMS Credit Basis

destE561

Student > Course Enrolment > Course

SELECT

0000

4

N/A

Field of education of prior VET study for which credit was offered

Course Enrolment

HEIMS Field Details

destE562

Student > Course Enrolment > Course

SELECT

0000

4

N/A

Level of education of prior VET study for which credit was offered

Course Enrolment

HEIMS Level Details

destE563

Student > Course Enrolment > Course

SELECT

000

3

N/A

Type of provider where VET study was undertaken

Course Enrolment

HEIMS Provider Type Details

destE564

Student > Course Enrolment > Course

SELECT

00

2

N/A

Year left school

Course Enrolment

Year Left School

destE572

Student > Course Enrolment > Course

SELECT

0001

4

YES

If course enrolment start date smaller than the reporting year, return ‘0001’,

Otherwise, return the code that reflects the selection you chose.

if($commencement_year < $submission_year){
return '0001';
}else{
return $survey_program_enrolment_dtls->data_fields[

Filler

-

-

destFA50

-

ASCII_FILLER

-

50

-

Highest educational attainment of parent/guardian 1

Course Enrolment

Highest Educational Attainment 1

destE573

Student > Course Enrolment > Course

SELECT

99

2

YES

If course enrolment start date smaller than the reporting year, return ‘01’,

Otherwise, return the code that reflects the selection you chose.

if($commencement_year < $submission_year){
return '01';
}else{
return $survey_program_enrolment_dtls->data_fields

Highest educational attainment of parent/guardian 2

Course Enrolment

Highest Educational Attainment 2

destE574

Student > Course Enrolment > Course

SELECT

99

2

YES

If course enrolment start date smaller than the reporting year, return ‘01’,

Otherwise, return the code that reflects the selection you chose.

if($commencement_year < $submission_year){
return '01';
}else{
return $survey_program_enrolment_dtls->data_fields

Filler

-

-

destFA4

-

ASCII_FILLER

-

4

-

Higher degree by research end.user engagement code

Course Enrolment

HDR end-user engagement code

hdrEngagementCode

Student > Course Enrolment > Course

MULTI_SELECT

00

10

N/A