ENR_CNFRMTN_EXTRACT_V

Field Name

Field Description

Data Source

CREATION_DT

extract creation date

system

LOAD_CAL_TYPE

load calendar instance

job run parameter

LOAD_CI_SEQUENCE_NUMBER

ENROLMENT_CAT

enrolment category

job run parameter

STUDENT_TYPE

student commencement type

job run parameter

ORG_UNIT_CD

responsible organisational unit

job run parameter

OU_START_DT

LOCATION_CD

location code (campus)

job run parameter

ATTENDANCE_MODE

attendance mode

job run parameter

ATTENDANCE_TYPE

attendance type

job run parameter

COURSE_TYPE

course type

job run parameter

COURSE_CD

course code

job run parameter

PERSON_ID

person ID number

job run parameter

PERSON_ID_GROUP

ID group code

job run parameter

OVERRIDE_SENT_CHECK

override sent check

job run parameter

REGISTER_CORRESPONDENCE

register correspondence items

job run parameter

CONSIDER_RE_ISSUE

consider reissue of notices

job run parameter

REQUEST_JOB_RUN_ID

system generated ID number of the request job run

passed by job scheduler

REQUEST_NUM

system generated number of the request in which the job was run

derived from request job run ID

UPDATE_WHO

.

system

UPDATE_ON

.

system

ENR_CNFRMTN_RECORD_V

Field Name

Field Description

Source

1. STUDENT-COURSE

CREATION_DT

The Record's Creation Date

system (date(DD/MM/YYYY HH24:MI:SS))

PERSON_ID

The Student Course Attempt to which this Record refers

person.person_id (num(10)) student_course_attempt .course_cd (char(6))

COURSE_CD

The Record Type of the Record (i.e. STUDENT-COURSE)

extract job (ENRJ8500) (char(20))

FIELD1

Surname

person_display_v .surname (char(30))

FIELD2

Title Name

person_display_v .title_name (char(82))

FIELD3

Preferred Name

person_display_v .preferred_name (char(71))

FIELD4

Title

person_display_v.title (char(10))

FIELD5

Course Version Number

course_version .version_number (num(3))

Course Responsible Org Unit Code

course_version .responsible_org_unit_cd (char(10))

FIELD7

Course Responsible OU Start Date

course_version .responsible_ou_start_dt (dd/mm/yyyy)

FIELD8

Course Short Title

course_version .short_title (char(40))

FIELD9

Course Type

course_version .course_type (char(10))

FIELD10

Location Code (campus)

student_course_attempt .location_cd (char(10))

FIELD11

Attendance Mode

student_course_attempt .attendance_mode (char(2))

FIELD12

Attendance Type

student_course_attempt .attendance_type (char(2))

FIELD13

Exam Location Code

student_course_attempt .exam_location_cd (char(10))

FIELD14

Fee Category

student_course_attempt .fee_cat (char(10))

FIELD15

Correspondence Category

student_course_attempt .correspondence_cat (char(10))

FIELD16

Funding Source

student_course_attempt .funding_source (char(10))

FIELD17

Derived Attendance Mode

derived by ENRP_GET_SCA_AM (char(2))

FIELD18

Derived Attendance Type

derived by ENRP_GET_SCA_ATT (char(2))

FIELD19

Enrolment Category

student_crs_atmpt_enr .enrolment_cat (char(10))

FIELD20

Postcode (for sorting purposes)

person_addr.postcode (num(4))

FIELD21

OS Code

person_add.os_code (char(10))

FIELD22

Student Status (HECS Option) (current, if no current option left blank)

student_course_hecs_option .hecs_payment_option (char(10))

FIELD23

Student Status (LIABLE where HECS Payment Type not EXEMPT, and EXEMPT where HECS Payment Type is EXEMPT)

derived from govt_hecs_payment_option .s_hecs_payment_type (char(6))

FIELD24

HECS Differential check box (for current Student Status; if no current option is left blank)

student_course_hecs_option .differential_hecs_ind (char(1))

UPDATE_WHO

system

UPDATE_ON

system

Field Name

Field Description

Source

2. ADDRESS

CREATION_DT

The Record's Creation Date

system (date(DD/MM/YYYY HH24:MI:SS))

PERSON_ID

The Student Course Attempt to which this Record refers

person.person_id (num(10)) student_course_attempt .course_cd (char(6))

COURSE_CD

The Record Type of the Record (i.e. ADDRESS)

extract job (ENRJ8500) (char(20))

Address Type

person_addr.addr_type (char(10))

FIELD2

Start Date

person_addr.start_dt (dd/mm/yyyy)

FIELD3

End Date

person_addr.end_dt (dd/mm/yyyy)

 FIELD4

Address Line 1

person_addr.addr_line1 (char(40))

FIELD5

Address Line 2

person_addr.addr_line2 (char(40))

FIELD6

Address Line 3

person_addr.addr_line3 (char(40))

FIELD7

Address Line 4

person_addr.addr_line4 (char(40))

FIELD8

Address Line 5

person_addr.addr_line5 (char(40))

FIELD9

Postcode

person_addr.postcode (num(4))

FIELD10

OS Code

person_addr.os_code (char(10))

UPDATE_WHO

system

UPDATE_ON

system

Field Name

Field Description

Source

3. UNIT-SET

CREATION_DT

The Record's Creation Date

system (date(DD/MM/YYYY HH24:MI:SS))

PERSON_ID

The Student Course Attempt to which this Record refers

person.person_id (num(10))

student_course_attempt .course_cd (char(6))

COURSE_CD

The Record Type of the Record (i.e. UNIT-SET)

extract job (ENRJ8500) (char(20))

FIELD1

Unit Set Code

student_unit_set_attempt .unit_set_cd (char(10))

FIELD2

Unit Set Version Number

student_unit_set_attempt .version_number (num(3))

FIELD3

Confirmed check box (confirmed and unconfirmed sets are included, ended are not)

student_unit_set_attempt .student_confirmed_ind (char(1))

FIELD4

Primary check box

student_unit_set_attempt .primary_set_ind (char(1))

FIELD5

Selection Date

student_unit_set_attempt .selection_dt (dd/mm/yyyy)

FIELD6

Completion Date

student_unit_set_attempt .rqrmnts_complete_dt (dd/mm/yyyy)

FIELD7

Short Title

unit_set.short_title (char(40))

FIELD8

Administrative check box

unit_set.administrative_ind (char(1))

FIELD9

Category

unit_set.unit_set_cat (char(10))

FIELD10

Category Description

unit_set_cat.description (char(10))

FIELD11

Rank

unit_set_cat.rank (num(3))

FIELD12

Title (derived from the appropriate level. ie. Unit_set, course_offering _unit_set or student_unit_ set_attempt override)

ENRP_GET_US_TITLE (char(90))

UPDATE_WHO

system

UPDATE_ON

system

Field Name

Field Description

Source

4. UNIT

CREATION_DT

The Record's Creation Date

system (date(DD/MM/YYYY HH24:MI:SS))

PERSON_ID

The Student Course Attempt to which this Record refers

person.person_id (num(10)) student_course_attempt .course_cd (char(6))

COURSE_CD

The Record Type of the Record (i.e. UNIT)

extract job (ENRJ8500) (char(20))

FIELD1

Unit Code

student_unit_attempt_v .unit_cd (char(10))

FIELD2

Unit Version Number

student_unit_attempt_v .version_number (num(3))

FIELD3

Teaching Calendar Type

student_unit_attempt_v .cal_type (char(10))

FIELD4

Teaching Calendar Sequence Number

student_unit_attempt_v .ci_sequence_number (num(6))

FIELD5

Teaching Calendar Alternate Code (eg. '1')

student_unit_attempt_v .teach_alternate_cd (char(10))

FIELD6

Unit Attempt Status (indicates the type of unit being displayed; the means of restricting DISCONTIN & INVALID if required)

student_unit_attempt_v .unit_attempt_status (char(10))

FIELD7

Location Code

student_unit_attempt_v .location_cd (char(10))

FIELD8

Unit Class

student_unit_attempt_v .unit_class (char(10))

FIELD9

Unit Mode

unit_class.unit_mode (char(10))

FIELD10

Title (override value if set, otherwise unit version value)

unit_version.title or student_unit_attempt .alternative_title (char(90))

FIELD11

Short Title

unit_version.short_title (char(40))

FIELD12

Enrolled Credit Points (override value if set, otherwise unit version value)

unit_version .enrolled_credit_points or student_unit_attempt .override_enrolled_cp (num(6,3))

FIELD13

Achievable Credit Points (override value if set, otherwise unit version value)

unit_version .achievable_credit_points or student_unit_attempt .override_achievable_cp (num(6,3))

FIELD14

EFTSL (override value if set, otherwise derives the EFTSL total across all contributing load calendars)

derived by ENRS_CLC_SUA_EFTSUT (num(6,3))

FIELD15

Discipline Band (if differential HECS ind = 'N' then value is 'C' otherwise derived from govt_dscpl_hecs_cntrbtn and unit_discipline)

govt_dscpl_hecs_cntrbtn .govt_hecs_cntrbtn_band (char(1))

UPDATE_WHO

system

UPDATE_ON

system

Field Name

Field Description

Source

5. ENCUMBRANCE

CREATION_DT

The Record's Creation Date

system (date(DD/MM/YYYY HH24:MI:SS))

PERSON_ID

The Student Course Attempt to which this Record refers

person.person_id (num(10)) student_course_attempt .course_cd (char(6))

COURSE_CD

The Record Type of the Record (i.e. ENCUMBRANCE)

extract job (ENRJ8500) (char(20))

Encumbrance Type

person_encumbrance_effect_v .encumbrance_type (char(10))

FIELD2

Encumbrance Type Description

encumbrance_type .description (char(10))

FIELD3

Start Date

derived start date from either the person_encumbrance_effect_v or detail record (person_unit_exclusion_v, etc..) (dd/mm/yyyy)

FIELD4

Expiry Date

derived start date from either the person_encumbrance_effect_v or detail record (person_unit_exclusion_v, etc..) (dd/mm/yyyy)

FIELD5

Effect Type

person_encumbrance_effect_v .s_encmb_effect_type (char(10)) (the following effect types are included: EXC_CRS_US, EXC_CRS_U, RQRD_CRS_U, RSTR_AT_TY, RSTR_GE_CP, RSTR_LE_CP)

FIELD6

Effect Description

s_encumb_effect_type .description (char(60))

FIELD7

Unit Code

person_unit_exclusion_v .unit_cd or person_unit_requirement_v .unit_cd (char(10)) (is set for encumbrance types of EXC_CRS_U and RQRD_CRS_U)

FIELD8

Unit Set Code

person_unit_set_exclusion_v .unit_set_cd (char(10)) (is set for encumbrance type of EXC_CRS_US)

FIELD9

Restricted Enrolment Credit Points

person_encumbrance_effect_v .restricted_enrolment_cp (num(6,3)) (is set for encumbrance types of RSTR_GE_CP and RSTR_LE_CP)

FIELD10

Restricted Enrolment Attendance Type

person_encumbrance_effect_v .restricted_attendance_type (char(2)) (is set for encumbrance type of RSTR_AT_TY)

UPDATE_WHO

system

UPDATE_ON

system

Field Name

Field Description

Source

6. RESEARCH

CREATION_DT

The Record's Creation Date

system (date(DD/MM/YYYY HH24:MI:SS))

PERSON_ID

The Student Course Attempt to which this Record refers

person.person_id (num(10)) student_course_attempt .course_cd (char(6))

COURSE_CD

The Record Type of the Record (i.e. RESEARCH)

extract job (ENRJ8500) (char(20))

FIELD1

EFTD Used

Returned from RESP_CLC_USED_EFTD; returns figure in days or fractions of days (num(8,3))

FIELD2

Attendance Percentage

RESP_GET_CA_ATT (num(5,2))

FIELD3

Minimum Submission Date

candidature .min_submission_dt or RESP_CLC_MIN_SBMSN (dd/mm/yyyy)

FIELD4

Maximum Submission Date

candidature .max_submission_dt or RESP_CLC_MAX_SBMSN (dd/mm/yyyy)

FIELD5

Supervisor Person ID

research_supervisor .person_id (where within start_dt,end_dt and parent research_supervisor_type .principal_supervisor_ind = 'Y') (num(10))

FIELD6

Supervisor Type

research_supervisor .supervisor_type (where within start_dt,end_dt and parent research_supervisor_type .principal_supervisor_ind = 'Y') (char(10))

FIELD7

Supervisor Name

person_display_v .title_name (where within start_dt,end_dt and parent research_supervisor_type .principal_supervisor_ind = 'Y') (char(82))

UPDATE_WHO

system

UPDATE_ON

system

Field Name

Field Description

Source

7. THESIS

CREATION_DT

The Record's Creation Date

system (date(DD/MM/YYYY HH24:MI:SS))

PERSON_ID

The Student Course Attempt to which this Record refers

person.person_id (num(10)) student_course_attempt .course_cd (char(6))

COURSE_CD

The Record Type of the Record (i.e. THESIS)

extract job (ENRJ8500) (char(20))

FIELD1

Title

thesis.title (char(200))

FIELD2

Expected Submission Date

thesis .expected_submission_dt (dd/mm/yyyy)

FIELD3

Thesis Status

derived by RESP_GET_THE_STATUS (returns values of PENDING, SUBMITTED, EXAMINED (DELETED are excluded)) (char(10))

UPDATE_WHO

system

UPDATE_ON

system

Field Name

Field Description

Source

8. PROGRESSION

CREATION_DT

The Record's Creation Date

system (date(DD/MM/YYYY HH24:MI:SS))

PERSON_ID

The Student Course Attempt to which this Record refers

person.person_id (num(10)) student_course_attempt .course_cd (char(6))

COURSE_CD

The Record Type of the Record (i.e. PROGRESSION)

extract job (ENRJ8500) (char(20))

FIELD1

Minimum CP Required

course_version .credit_points_required (num(6,3))

FIELD2

Achieved CP

calculated by ENRP_CLC_SCA_PASS_CP (…) subtracting value of Granted Advanced Standing CP below (the enrolment routine derives the credit points passed (including repeated unit logic) including advanced standing. Must subtract AS total to get the unit total) (num(6,3))

FIELD3

Granted Advanced Standing CP

Sum of values of Advanced Standing Unit CP and Advanced Standing Unit Level CP below. (calculates granted advanced standing for a course attempt (both unit and unit level)) (num(6,3))

FIELD4

Advanced Standing Unit CP

Derived from adv_stnd_unit (num(6,3))

FIELD5

Advanced Standing Unit Level CP

Derived from adv_stnd_unit_level (num(6,3))

FIELD6

Course GPA

derived by PRGP_GET_STD_GPA (routine derives the current course GPA; triggers a call to the rules engine) (num(6,3))

FIELD7

Last Progression GPA

From student_crs_prg_measure and PRGP_GET_SCPM_VALUE (selects value from table where matching course attempt and latest value (by calculation date)) (num(6,3))

FIELD8

Last Progression GPA Calendar Type

student_crs_prg_measure .prg_cal_type (char(10))

FIELD9

Last Progression GPA Sequence Number

student_crs_prg_measure .prg_ci_sequence_number (num(3))

FIELD10

Course WAM

derived by PRGP_GET_STD_WAM (routine derives the current course WAM; triggers a call to the rules engine) (num(6,3))

FIELD11

Last Progression WAM

From student_crs_prg_measure and PRGP_GET_SCPM_VALUE (selects value from table where matching course attempt and latest value (by calculation date)) (num(6,3))

FIELD12

Last Progression WAM Calendar Type

student_crs_prg_measure .prg_cal_type (char(10))

FIELD13

Last Progression WAM Sequence Number

student_crs_prg_measure .prg_ci_sequence_number (num(3))

FIELD14

Progression Status

student_course_attempt .progression_status (char(10))

FIELD15

Progression Status Description

s_progression_status .description (char(60))

UPDATE_WHO

system

UPDATE_ON

system