585

Student Fee Type Indicator

Program Enrolment

dest_student_status

HEIMS Student Status

Student/Course Enrolment/Course/HEIMS Information

INPUT

2

2

Yes

When the HEIMS student status (E490) is set to 310 or 311 then return 02.

When the HEIMS student status (E490) is set to 301, 302, 303, 304 or 305 then return 01

*Note E490 field is at both student course enrolment and unit enrolment screen.

SELECT CASE WHEN pe.dest_student_status IN ('310','311') THEN '02'
WHEN pe.dest_student_status IN ('301','302','303','304','305') THEN '01'
ELSE ''
END AS dest_e585

586

Broad Course Type

Base Program

dest_course_type

HEIMS Course Type

Courses/Edit Details/HEIMS Fields

INPUT

4

2

Yes

When the HEIMS course type is set to Doctorate by research (02) or Master's by research (03) then return 01

When the HEIMS course type is set to Doctorate by coursework (12) or Masters (Coursework) (04) then return 02

When the HEIMS course type is set to Higher Doctorate (01) or Masters (Extended) (14) or Open Universities Australia postgraduate studies (61) or Postgraduate Qualifying or Preliminary (for Master's, Doctorate or Higher Doctorate)(05) or Cross Institutional program for postgraduate courses at home Higher Education Provider (42) then return 03

When the HEIMS course type is set to '06','07','08','09','10','11','13','20','21','41','60','82' then return 04

When the HEIMS course type is set to Enabling course (30) or Non-award course (including Bridging for overseas trained professionals) (50) then return 05

CASE WHEN q.dest_course_type IN ('02','03') THEN '01'
WHEN q.dest_course_type IN ('12','04') THEN '02'
WHEN q.dest_course_type IN ('01','14','61','05','42') THEN '03'
WHEN q.dest_course_type IN ('06','07','08','09','10','11','13','20','21','41','60','82') THEN '04'
WHEN q.dest_course_type IN ('30','50') THEN '05'
ELSE ''
END AS dest_e586

589

Commencing Student Indicator

Program Enrolment

start_date

Start Date

Student/Course Enrolment/Course

INPUT

1

1

Yes

When the start date of the course enrolment is on or after the 1st January of the submission year then return 1 else return 0

CASE WHEN pe.start_date>='".$submissionYear."-01-01' THEN '1'
ELSE '0'
END AS dest_e589

590

Estimated Full-Time Student Load

Base Program

Base Unit

Base Unit

program_level

ugrad_eftsu_load

pgrad_eftsu_load

Course Level

EFTSL Load (UGrad)

EFTSL Load (PGrad)

Courses/Edit Details

Units/Unit Details/Edit Details

INPUT

1

5

Yes

Sum the EFTSL value studied by each student per unique course enrolment for the listed census dates and multiply this value by 2 to derive an Estimated full‑time equivalence (FTE) for a full year. Round this figure to the nearest whole number.

The field program level on the base course is used to determine the appropriate EFTSL value. Undergraduate students use the value in the field ugrad_eftsu_load. Postgraduate students use the value in the field pgrad_eftsu_load.

ROUND (

SUM ( CASE WHEN q.program_level='POSTGRAD' THEN u.pgrad_eftsu_load ELSE u.ugrad_eftsu_load END ::decimal)

*2)

415

Reporting Year/Period

-

-

-

-

INPUT

0

5

No

-

Entered by the user on the Paradigm report form