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

Record Type

Field Name

Field Description

Source

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

student_course_attempt .course_cd (char(6))

 COURSE_CD

RECORD_TYPE

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))

 FIELD6

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

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

student_course_hecs_option .hecs_payment_option (char(10))

 FIELD23

HECS 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 Indicator (for current HECS payment option; if no current option is left blank)

student_course_hecs_option .differential_hecs_ind (char(1))

 UPDATE_WHO

system

UPDATE_ON

system

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

student_course_attempt .course_cd (char(6))

 COURSE_CD

RECORD_TYPE

the record type of the record (i.e. ADDRESS)

extract job (ENRJ8500) (char(20))

 FIELD1

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

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

student_course_attempt .course_cd (char(6))

 COURSE_CD

RECORD_TYPE

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 Indicator (confirmed and unconfirmed sets are included, ended are not)

student_unit_set_attempt .student_confirmed_ind (char(1))

 FIELD4

Primary Indicator

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 Indicator

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

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

student_course_attempt .course_cd (char(6))

 COURSE_CD

RECORD_TYPE

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

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

derived by ENRS_CLC_SUA_EFTSUT (num(6,3))

 FIELD15

HECS 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

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

student_course_attempt .course_cd (char(6))

 COURSE_CD

RECORD_TYPE

the record type of the record (i.e. ENCUMBRANCE)

extract job (ENRJ8500) (char(20))

 FIELD1

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

(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

(is set for encumbrance types of EXC_CRS_U and RQRD_CRS_U)

 FIELD8

Unit Set Code

(is set for encumbrance type of EXC_CRS_US)

 FIELD9

Restricted Enrolment Credit Points

(is set for encumbrance types of RSTR_GE_CP and RSTR_LE_CP)

 FIELD10

Restricted Enrolment Attendance Type

(is set for encumbrance type of RSTR_AT_TY)

 UPDATE_WHO

system

UPDATE_ON

system

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

student_course_attempt .course_cd (char(6))

 COURSE_CD

RECORD_TYPE

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

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

 FIELD6

Supervisor Type

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

 FIELD7

Supervisor Name

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

 UPDATE_WHO

system

UPDATE_ON

system

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

student_course_attempt .course_cd (char(6))

 COURSE_CD

RECORD_TYPE

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

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

 UPDATE_WHO

system

UPDATE_ON

system

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

student_course_attempt .course_cd (char(6))

 COURSE_CD

RECORD_TYPE

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

(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

(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

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

 FIELD7

Last Progression GPA

(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

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

 FIELD11

Last Progression WAM

(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