| Top of ENR | Index | Table of Contents | Feedback | |
Enrolment Form Extract - View Details
Enrolment Form Extract View Details
The table shows the fields presented by this view.
| Field Name |
Field Description |
Data Source |
|
| CREATION_DT |
extract creation date |
system |
|
| EXTRACT_COMMENT |
comments for inclusion on all enrolment forms in the run. |
job run parameter |
|
| ENR_CAL_TYPE |
the enrolment period for which the extract was run. |
|
|
| ENR_CI_SEQUENCE_NUMBER |
|||
| COURSE_TYPE1 |
course type |
job run parameter |
|
| COURSE_TYPE2 |
course type |
job run parameter |
|
| COURSE_CD1 |
course code |
job run parameter |
|
| COURSE_CD2 |
course code |
job run parameter |
|
| LOCATION_CD1 |
course attempt location |
job run parameter |
|
| LOCATION_CD2 |
course attempt location |
job run parameter |
|
| ATTENDANCE_MODE1 |
course attempt attendance mode |
job run parameter |
|
| RESPONSIBLE_ORG_UNIT_CD |
course responsible organisational unit |
job run parameter |
|
| STUDENT_COMM_TYPE |
student commencement type i.e. new or returning. |
job run parameter |
|
| ENROLMENT_CAT1 |
enrolment category |
job run parameter |
|
| ENROLMENT_CAT2 |
enrolment category |
job run parameter |
|
| FEE_CAT1 |
fee category |
job run parameter |
|
| FEE_CAT2 |
fee category |
job run parameter |
|
| CORRESPONDENCE_CAT1 |
correspondence category |
job run parameter |
|
| CORRESPONDENCE_CAT2 |
correspondence category |
job run parameter |
|
| OVERRIDE_SENT_CHECK |
indicates whether or not checks should be performed for existing correspondence items relating to extract records. If a correspondence item exists for a record, the record is not included in the extract table. |
job run parameter |
|
| SPECIFIC_PERSON_ID |
the ID number of a person recorded in Callista. |
job run parameter |
|
| SPECIFIC_COURSE_CD |
in conjunction with SPECIFIC_PERSON_ID, defines a particular student course attempt. |
job run parameter |
|
| TEST_EXTRACTION |
indicates whether or not ENRJ3161 was run as a test extraction only. |
job run parameter |
|
| ADM_CAL_TYPE |
the admission period for which the extract was run. |
|
|
| ADM_CI_SEQUENCE_NUMBER |
|||
| ADMISSION_CAT |
admission category |
job run parameter |
|
| ACCEPT_OFFER_IND |
indicates whether or not ENRJ3161 was run only for students who had accepted an offer of admission. |
job run parameter |
|
| PERSON_GROUP_ID |
person ID group |
job run parameter |
|
| ATTENDANCE_TYPE |
student course attempt attendance type |
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 |
|
The table shows the different record types presented by this view and the fields in each record type. Field names in blue are common to all record types.
1. Header
2. Person
3. Addresses
4. Statistical Details
5. Prior Education
6. Disability Details
7. Course Attempt Details
8. Unit Set Details
9. Research Details
10. Thesis Details
11. Pre-Enrolment
12. Advanced Standing Unit Level
13. Advanced Standing Unit
14. Academic History
15. Footer - Record Count
| Field Name | Field Description | Source |
| 1. Header | ||
| CREATION_DT | The Record's Creation Date. | System (Date as - DD/MM/YYYY HH24:MI:SS) |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run. | Job Run parameter (characters - 10) |
| ENR_CI_SEQUENCE_NUMBER | Job Run parameter (numbers - 6) | |
| PERSON_ID | NULL | |
| COURSE_CD | ||
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 1). | Extract Job (ENRJ3161) (characters -10) |
| FIELD1 | Comment | Job parameter (characters - 30) |
| Field Name | Field Description | Source |
| 2. Person (For each Person selected.) | ||
| CREATION_DT | The Record's Creation Date. | System |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run. | Job Run parameter |
| ENR_CI_SEQUENCE_NUMBER | ||
| PERSON_ID | The Student Course Attempt to which this Record refers. | person.person_id |
| COURSE_CD | student_course_attempt.course_cd | |
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 2). | Extract Job (ENRJ3161) |
| FIELD1 |
Person ID |
person.person_id |
| FIELD2 |
Title |
person_alias.title, or if person_alias.title is null then person.title |
| FIELD3 |
Surname |
person_alias.surname, or if person_alias.surname is null then person.surname |
| FIELD4 |
Given Names |
person_alias.given_names, or if person_alias.given_names is null then person.surname |
| FIELD5 |
Preferred Name |
person.preferred_given_name |
| FIELD6 |
Sex |
person.sex |
| FIELD7 |
Birth Date (DDMMYYYY) |
person.birth_dt |
| FIELD8 |
Email Address |
person.email_addr |
| FIELD9 |
Enrolment/Re-Enrolment check box |
derived (commencing student derivation) |
| FIELD10 |
Form Due Date (DDMMYYYY) |
student_crs_atmpt_enr.enr_form_due_dt or if student_crs_atmpt_enr.enr_form_due_dt is null, then from enrolment period calendar, date alias. |
| Field Name | Field Description | Source |
| 3. Addresses (All of the current Address Records for each person selected.) | ||
| CREATION_DT | The Record's Creation Date. | System |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run. | Job Run parameter |
| ENR_CI_SEQUENCE_NUMBER | ||
| PERSON_ID | The Student Course Attempt to which this Record refers. | person.person_id |
| COURSE_CD | student_course_attempt.course_cd | |
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 3). | Extract Job (ENRJ3161) |
| FIELD1 | Address Type | person_addr.addr_type |
| FIELD2 | Address Line 1 | person_addr.addr_line_1 |
| FIELD3 | Address Line 2 | person_addr.addr_line_2 |
| FIELD4 | Address Line 3 | person_addr.addr_line_3 |
| FIELD5 | Address Line 4 | person_addr.addr_line_4 |
| FIELD6 | Address Line 5 | person_addr.addr_line_5 |
| FIELD7 | Australian Postcode | person_addr.aust_postcode |
| FIELD8 | Overseas Postal Code | person_addr.os_code |
| FIELD9 | Phone 1 | person_addr.phone_1 |
| FIELD10 | Phone 2 | person_addr.phone_2 |
| FIELD11 | Phone 3 | person_addr.phone_3 |
| FIELD12 | Person's other Address details | person_addr.other_details |
| FIELD13 | Correspondence check box | calculated (characters - 1) |
| FIELD14 | Person Address Start Date (DDMMYYYY) | person_addr.start_dt |
| FIELD15 | Person Address End Date (DDMMYYYY) | person_addr.end_dt |
| Field Name | Field Description | Source |
| 4. Statistical Details (The person's current statistical details only.) | ||
| CREATION_DT | The Record's Creation Date. | System |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run. | Job Run parameter |
| ENR_CI_SEQUENCE_NUMBER | ||
| PERSON_ID | The Student Course Attempt to which this Record refers. | person.person_id |
| COURSE_CD | student_course_attempt.course_cd | |
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 4). | Extract Job (ENRJ3161) |
| FIELD1 | Australian Aboriginal or Torres Strait Islander | person_statistics.aborig_torres_cd |
| FIELD2 | Description associated with Extracted Value for Australian Aboriginal or Torres Strait Islander | aborig_torres_cd.description |
| FIELD3 | Citizenship/Residence Status | person_statistics.citizenship_cd |
| FIELD4 | Description associated with Extracted Value for Citizenship/Residence Status. | citizenship_cd.description |
| FIELD5 | Permanent Resident Status | person_statistics.perm_resident_cd |
| FIELD6 | Description associated with Extracted Value for Permanent Resident Status. |
perm_resident_cd.description |
| FIELD7 | Home Residence Postcode |
person_statistics.home_location_postcode |
| FIELD8 | Home Residence Country |
person_statistics.home_location_country |
| FIELD9 | Description associated with Extracted Value for Home Residence Country. |
country_cd.description |
| FIELD10 | Semester Residence Postcode |
person_statistics.term_location_postcode |
| FIELD11 | Semester Residence Country |
person_statistics.term_location_country |
| FIELD12 | Description associated with Extracted Value for Semester Residence Country. |
country_cd.description |
| FIELD13 | Country of Birth |
person_statistics.birth_country_cd |
| FIELD14 | Description associated with Extracted Value for Country of Birth. |
country_cd.description |
| FIELD15 | Year of Arrival |
person_statistics.yr_arrival |
| FIELD16 | Language other than English |
person_statistics.home_language_cd |
| FIELD17 | Description associated with Extracted Value for Language other than English. |
language_cd.description |
| FIELD18 | DIISRTE Disability Code | derived (characters - 8) |
| FIELD 19 | Commencing Location | commencing_location |
| FIELD 20 | Commening Geographic Location |
commencing_geographic_loc |
| FIELD 21 | Year Left School | yr_left_school |
| FIELD 22 | Parent/Guardian 1 Highest Educational Attainment | prnt_grdn_1_hea_cd |
| FIELD 23 | Description associated with Parent/Guardian 1 Highest Educational Attainment. | description |
| FIELD 24 | Parent/Guardian 2 Highest Educational Attainment | prnt_grdn_2_hea_cd |
| FIELD 25 | Description associated with Parent/Guardian 2 Highest Educational Attainment Description |
description |
| Field Name | Field Description | Source |
| 5. Prior Education (The person's current prior education details.) | ||
| CREATION_DT | The Record's Creation Date. | System |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run. | Job Run parameter |
| ENR_CI_SEQUENCE_NUMBER | ||
| PERSON_ID | The Student Course Attempt to which this Record refers. | person.person_id |
| COURSE_CD | student_course_attempt.course_cd | |
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 5). | Extract Job (ENRJ3161) |
| FIELD1 | Postgraduate Course Code |
person_statistics.prior_post_grad |
| FIELD2 | Bachelor's Degree Course |
person_statistics.prior_degree |
| FIELD3 | Diploma/Assoc Dip (Not TAFE) |
person_statistics.prior_subdeg_notafe |
| FIELD4 | Diploma/Assoc Dip (TAFE) |
person_statistics.prior_subdeg_tafe |
| FIELD5 | Other TAFE Award |
person_statistics.prior_tafe_award |
| FIELD6 | Secondary Education (school) |
person_statistics.prior_seced_school |
| FIELD7 | Secondary Education (other) |
person_statistics.prior_seced_tafe |
| FIELD8 | Other Qualification |
person_statistics.prior_other_qual |
| FIELD9 | Undergraduate Institution | person_statistics.prior_ug_inst |
| FIELD10 | Highest Attain |
person_statistics.highest_attain |
| Field Name | Field Description | Source |
| 6. Disability Details (The person's current Disability details.) | ||
| CREATION_DT | The Record's Creation Date | System |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run. | Job Run parameter |
| ENR_CI_SEQUENCE_NUMBER | ||
| PERSON_ID | The Student Course Attempt to which this Record refers. | person.person_id |
| COURSE_CD | student_course_attempt.course_cd | |
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 6). | Extract Job (ENRJ3161) |
| FIELD1 | Disability Type |
person_diability.disability_type |
| FIELD2 | Disability Type Contact check box |
person_disability.contact_ind |
| Field Name | Field Description | Source |
| 7. Course Attempt Details (For each Student Course Attempt selected.) | ||
| CREATION_DT | The Record's Creation Date | System |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run. | Job Run parameter |
| ENR_CI_SEQUENCE_NUMBER | ||
| PERSON_ID | The Student Course Attempt to which this Record refers. | person.person_id |
| COURSE_CD | student_course_attempt.course_cd | |
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 7). | Extract Job (ENRJ3161) |
| FIELD1 | Course Code |
student_course_attempt.course_cd |
| FIELD2 | Course Short Title |
course_version.short_title |
| FIELD3 | Course Title |
course_version.title |
| FIELD4 | Course Attempt Location |
student_course_attempt.location_cd |
| FIELD5 | Location Forced check box |
course_offering_option.forced_location_ind |
| FIELD6 | Course Attempt Attendance Mode |
student_course_attempt.attendance_mode |
| FIELD7 | Attendance Mode Forced check box |
course_offering_option.forced_attendance_mode_ind |
| FIELD8 | Course Attempt Attendance Type |
student_course_attempt.attendance_type |
| FIELD9 | Attendance Type Forced check box |
course_offering_option.forced _attendance_type_ind |
| FIELD10 | Exam Location |
student_course_attempt.exam_location_cd |
| FIELD11 | Nominated Completion Year |
student_course_attempt.nominated_completion_yr |
| FIELD12 | Nominated Completion Period |
student_course_attempt.nominated_completion_perd |
| FIELD13 | Fee Category |
student_course_attempt.fee_cat |
| FIELD14 | Funding Source |
student_course_attempt.funding_source |
| FIELD15 | Correspondence Category |
student_course_attempt.correspondence_cat |
| FIELD16 | Publish Outcomes |
student_course_attempt.publish_outcomes_ind |
| FIELD17 | Course Type |
course_version.course_type |
| Field Name | Field Description | Source |
| 8. Unit Set Details (Selects all current and completed Unit Sets. Does not select Discontinued Unit Sets.) | ||
| CREATION_DT | The Record's Creation Date | System |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run. | Job Run parameter |
| ENR_CI_SEQUENCE_NUMBER | ||
| PERSON_ID | The Student Course Attempt to which this Record refers. | person.person_id |
| COURSE_CD | student_course_attempt.course_cd | |
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 8). | Extract Job (ENRJ3161) |
| FIELD1 | Unit Set Code |
student_unit_set_attempt.unit_set_cd |
| FIELD2 | Unit Set Title |
derived (char(60)) |
| FIELD3 | Unit Set Category |
unit_set.unit_set_cat |
| FIELD4 | Rank |
unit_set_cat.rank |
| FIELD5 | Confirmed check box |
student_unit_set_attempt.student_confirmed_ind |
| FIELD6 | Primary Unit Set check box |
student_unit_set_attempt.primary_set_ind |
| FIELD7 | Requirements Completed Date (DDMMYYYY) |
student_unit_set_attempt.rqrmnts_complete_dt |
| FIELD8 | Administrative check box |
unit_set.administrative_ind |
| Field Name | Field Description | Source |
| 9. Research Details (Candidature records matching the Student Course Attempt.) | ||
| CREATION_DT | The Record's Creation Date. | System |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run. | Job Run parameter |
| ENR_CI_SEQUENCE_NUMBER | ||
| PERSON_ID | The Student Course Attempt to which this Record refers. | person.person_id |
| COURSE_CD | student_course_attempt.course_cd | |
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 9). | Extract Job (ENRJ3161) |
| FIELD1 | Candidature Commencement Date (DDMMYYYY) |
sca.commencement_dt |
| FIELD2 | Minimum Submission Date (DDMMYYYY) |
candidature_v.derived_min_submission_dt |
| FIELD3 | Maximum Submission Date (DDMMYYYY) |
candidature_v.derived_max_submission_dt |
| FIELD4 | Current Attendance Precentage |
derived (num(6.3)) |
| Field Name | Field Description | Source |
| 10. Thesis Details (All Thesis Details for the Candidature where the Thesis is not logically deleted.) | ||
| CREATION_DT | The Record's Creation Date. | System |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run. | Job Run parameter |
| ENR_CI_SEQUENCE_NUMBER | ||
| PERSON_ID | The Student Course Attempt to which this Record refers. | person.person_id |
| COURSE_CD | student_course_attempt.course_cd | |
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 10). | Extract Job (ENRJ3161) |
| FIELD1 | Thesis Title |
thesis.title |
| FIELD2 | Final Result |
thesis.thesis_result_cd |
| FIELD3 | Thesis Status |
derived (char(10)) |
| Field Name | Field Description | Source |
| 11. Pre-Enrolment (All future Dated Enrolled or unconfirmed Student Unit Attempts for the Student Course Attempt.) | ||
| CREATION_DT | The Record's Creation Date. | System |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run. | Job Run parameter |
| ENR_CI_SEQUENCE_NUMBER | ||
| PERSON_ID | The Student Course Attempt to which this Record refers. | person.person_id |
| COURSE_CD | student_course_attempt.course_cd | |
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 11). | Extract Job (ENRJ3161) |
| FIELD1 | Unit Code |
student_unit_attempt.unit_cd |
| FIELD2 | Period |
student_unit_attempt.cal_type |
| FIELD3 | Location |
student_unit_attempt.location_cd |
| FIELD4 | Class |
student_unit_attempt.unit_class |
| FIELD5 | Unit Short Title |
unit_version.short_title |
| FIELD6 | Credit Points Enrolled |
unit_version.enrolled_credit_points |
| FIELD7 | EFTSL |
calculated (num(8.3)) |
| Field Name | Field Description | Source |
| 12. Advanced Standing Unit Level (All Advanced Standing Unit Level records for the Student Course Attempt.) | ||
| CREATION_DT | The Record's Creation Date. | System |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run. | Job Run parameter |
| ENR_CI_SEQUENCE_NUMBER | ||
| PERSON_ID | The Student Course Attempt to which this Record refers. | person.person_id |
| COURSE_CD | student_course_attempt.course_cd | |
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 12). | Extract Job (ENRJ3161) |
| FIELD1 | Course Code |
adv_stnd_unit_level.as_course_cd |
| FIELD2 | Course Short Title |
course_version.short_title |
| FIELD3 | Credit Points |
adv_stnd_unit_level.credit_points |
| FIELD4 | Unit Level |
adv_stnd_unit_level.unit_level |
| FIELD5 | Exemption Institution |
adv_stnd_exempt_inst_v.name |
| Field Name | Field Description | Source |
| 13. Advanced Standing Unit (All Advanced Standing Unit records for the Student Course Attempt.) | ||
| CREATION_DT | The Record's Creation Date. | System |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run. | Job Run parameter |
| ENR_CI_SEQUENCE_NUMBER | ||
| PERSON_ID | The Student Course Attempt to which this Record refers. | person.person_id |
| COURSE_CD | student_course_attempt.course_cd | |
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 13). | Extract Job (ENRJ3161) |
| FIELD1 | Course Code |
adv_stnd_unit.as_course_cd |
| FIELD2 | Course Short Title |
course_version.short_title |
| FIELD3 | Unit Code |
adv_stnd_unit.unit_cd |
| FIELD4 | Unit Short Title |
unit_version.short_title |
| FIELD5 | Recognition Type |
adv_stnd_unit.s_adv_stnd_recognition_type |
| FIELD6 | Credit Points achieved |
derived (num(6.3)) |
| FIELD7 | Unit Level |
unit_version.unit_level |
| FIELD8 | Exemption Institution |
adv_stnd_exempt_inst_v.name |
| Field Name | Field Description | Source |
| 14. Academic History (All past enrolled, completed or duplicate Student Unit Attempts. For example, enrolled in a Teaching Period where the Teaching Period's 'effective Enrolment Start Date Alias' Instance is less than the Current Date.) | ||
| CREATION_DT | The Record's Creation Date | System |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run | Job Run parameter |
| ENR_CI_SEQUENCE_NUMBER | ||
| PERSON_ID | The Student Course Attempt to which this Record refers | person.person_id |
| COURSE_CD | student_course_attempt.course_cd | |
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 14). | Extract Job (ENRJ3161) |
| FIELD1 | Year |
calculated (num(4)) |
| FIELD2 | Course Code |
student_unit_attempt.course_cd |
| FIELD3 | Course Short Title |
course_version.short_title |
| FIELD4 | Course Attempt Status |
student_course_attempt.course_attempt_status |
| FIELD5 | Course Discontinued Date (DDMMYYYY) |
student_course_attempt.discontinued_dt |
| FIELD6 | Unit Period |
student_unit_attempt.cal_type |
| FIELD7 | Unit Code |
student_unit_attempt.unit_cd |
| FIELD8 | Unit Short Title |
unit_version.short_title |
| FIELD9 | Unit Location |
student_unit_attempt. location_cd |
| FIELD10 | Credit Points Enrolled |
student_unit_attempt. override_enrolled_cp, or if this is NULL, unit_version.enrolled_credit_points |
| FIELD11 | Credit Points achieved |
If student_unit_attempt. override_enrolled_cp = 0 then unit_version. enrolled_credit_points is used , else student_unit_attempt. override_enrolled_cp is used. This field is only extracted if stdnt_unit_atmpt_outcome = system result of passed. |
| FIELD12 | Unit Level |
unit_version.unit_level |
| FIELD13 | Unit Grade |
stdnt_unit_atmpt_outcome. grade |
| FIELD14 | Min CP required for Course completion |
calculated (num(6.3)) |
| FIELD15 | Minimum number of additional Credit Points required for Course completion. |
calculated (num(6.3)) |
| Field Name | Field Description | Source |
| 15. Footer - Record Count | ||
| CREATION_DT | The Record's Creation Date | System |
| ENR_CAL_TYPE | The Enrolment Period for which ENRJ3161 was run. | Job Run parameter |
| ENR_CI_SEQUENCE_NUMBER | ||
| PERSON_ID | NULL | |
| COURSE_CD | ||
| RECORD_TYPE | The number identifying the Record Type of the Record (for example, 15). | Extract Job (ENRJ3161) |
| FIELD1 | Count of records of Type 2 |
calculated (number - 6) |
Last Modified on 9 September, 2009 5:08 PM
History Information
| Release Version | Project | Change to Document |
| 11.1.0.3 | 1600 - Compliance | Added Fields 21 - 25 under 'Statistical Details'. |
| (10th Jan 2005) | - | - |