|
|
|
|
|
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.
|
Record Type |
Field Name |
Field Description |
Source |
|
|
1 (Header) |
||||
|
|
CREATION_DT |
the record's creation date |
system (date(DD/MM/YYYY HH24:MI:SS)) |
|
|
|
ENR_CAL_TYPE |
the enrolment period for which ENRJ3161 was run |
(char(10)) job run parameter (num(6)) |
|
|
|
ENR_CI_SEQUENCE_NUMBER |
|||
|
|
PERSON_ID |
NULL |
|
|
|
|
COURSE_CD |
|||
|
|
RECORD_TYPE |
the number identifying the record type of the record (i.e. 1) |
extract job (ENRJ3161) (char(10)) |
|
|
|
FIELD1 |
comment |
job parameter (char(30)) |
|
|
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 student_course_attempt.course_cd |
|
|
|
COURSE_CD |
|||
|
|
RECORD_TYPE |
the number identifying the record type of the record (i.e. 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 |
birthdate(DDMMYYYY) |
person.birth_dt |
|
|
|
FIELD8 |
email address |
person.email_addr |
|
|
|
FIELD9 |
enrolment/re-enrolment indicator |
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. |
|
|
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 student_course_attempt.course_cd |
|
|
|
COURSE_CD |
|||
|
|
RECORD_TYPE |
the number identifying the record type of the record (i.e. 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 indicator |
calculated (char(1)) |
|
|
|
FIELD14 |
person address start date (DDMMYYYY) |
person_addr.start_dt |
|
|
|
FIELD15 |
person address end date (DDMMYYYY) |
person_addr.end_dt |
|
|
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 student_course_attempt.course_cd |
|
|
|
COURSE_CD |
|||
|
|
RECORD_TYPE |
the number identifying the record type of the record (i.e. 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 |
DEST disability code |
derived (char(8)) |
|
|
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 student_course_attempt.course_cd |
|
|
|
COURSE_CD |
|||
|
|
RECORD_TYPE |
the number identifying the record type of the record (i.e. 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 |
|
|
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 student_course_attempt.course_cd |
|
|
|
COURSE_CD |
|||
|
|
RECORD_TYPE |
the number identifying the record type of the record (i.e. 6) |
extract job (ENRJ3161) |
|
|
|
FIELD1 |
disability type |
person_diability.disability_type |
|
|
|
FIELD2 |
disability type contact indicator |
person_disability.contact_ind |
|
|
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 student_course_attempt.course_cd |
|
|
|
COURSE_CD |
|||
|
|
RECORD_TYPE |
the number identifying the record type of the record (i.e. 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 indicator |
course_offering_option.forced_location_ind |
|
|
|
FIELD6 |
course attempt attendance mode |
student_course_attempt.attendance_mode |
|
|
|
FIELD7 |
attendance mode forced indicator |
course_offering_option.forced_attendance_mode_ind |
|
|
|
FIELD8 |
course attempt attendance type |
student_course_attempt.attendance_type |
|
|
|
FIELD9 |
attendance type forced indicator |
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 |
|
|
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 student_course_attempt.course_cd |
|
|
|
COURSE_CD |
|||
|
|
RECORD_TYPE |
the number identifying the record type of the record (i.e. 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 indicator |
student_unit_set_attempt.student_confirmed_ind |
|
|
|
FIELD6 |
primary unit set indicator |
student_unit_set_attempt.primary_set_ind |
|
|
|
FIELD7 |
requirements completed date (DDMMYYYY) |
student_unit_set_attempt.rqrmnts_complete_dt |
|
|
|
FIELD8 |
administrative indicator |
unit_set.administrative_ind |
|
|
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 student_course_attempt.course_cd |
|
|
|
COURSE_CD |
|||
|
|
RECORD_TYPE |
the number identifying the record type of the record (i.e. 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)) |
|
|
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 student_course_attempt.course_cd |
|
|
|
COURSE_CD |
|||
|
|
RECORD_TYPE |
the number identifying the record type of the record (i.e. 10) |
extract job (ENRJ3161) |
|
|
|
FIELD1 |
thesis title |
thesis.title |
|
|
|
FIELD2 |
final result |
thesis.thesis_result_cd |
|
|
|
FIELD3 |
thesis status |
derived (char(10)) |
|
|
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 student_course_attempt.course_cd |
|
|
|
COURSE_CD |
|||
|
|
RECORD_TYPE |
the number identifying the record type of the record (i.e. 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 |
EFTSU |
calculated (num(8.3)) |
|
|
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 student_course_attempt.course_cd |
|
|
|
COURSE_CD |
|||
|
|
RECORD_TYPE |
the number identifying the record type of the record (i.e. 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 |
|
|
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 student_course_attempt.course_cd |
|
|
|
COURSE_CD |
|||
|
|
RECORD_TYPE |
the number identifying the record type of the record (i.e. 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 |
|
|
14 (Academic History) All past enrolled, completed or duplicate student unit attempts (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 student_course_attempt.course_cd |
|
|
|
COURSE_CD |
|||
|
|
RECORD_TYPE |
the number identifying the record type of the record (i.e. 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)) |
|
|
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 (i.e. 15) |
extract job (ENRJ3161) |
|
|
|
FIELD1 |
count of records of type 2 |
calculated (num(6)) |
|
Updated 30 January 2002