ACAD_TRANS_EXTRACT_V

Field Name

Field Description

Data Source

CREATION_DT

the Creation Date of Extract

system (dd/mm/yyyy hh:mi:ss)

ORG_UNIT_CD

the Organisational Unit

job run parameter (char(10))

OU_START_DT

Organisational Unit Start Date

job run parameter (dd/mm/yyyy)

COURSE_GROUP_CD

Course Group Code

job run parameter (char(10))

COURSE_CD

Course Code

job run parameter (char(6))

LIMIT_COURSE_IND

'Y' indicates the Extraction was limited to the Course Code above. 'N' indicates all the courses the students have done were extracted.

job run parameter (Y or N)

LOCATION_CD

Course Location

job run parameter (char(10))

ATTENDANCE_MODE

the Course Attendance

job run parameter (char(2))

AWARD_IND

'Y' indicates Award Courses were extracted. 'N' indicates non-Award Courses were extracted.

job run parameter (Y or N)

COURSE_ATTEMPT_STATUS1

the first Course Attempt Status selected.

job run parameter (char(10))

COURSE_ATTEMPT_STATUS2

the second Course Attempt Status selected

job run parameter (char(10))

COURSE_ATTEMPT_STATUS3

the third Course Attempt Status selected

job run parameter (char(10))

PROGRESSION_STATUS

Progression Status

job run parameter (char(10))

Graduand_STATUS

Graduand Status

job run parameter (char(10))

PERSON_ID_GROUP_ID

Person ID Group

job run parameter (char(6))

EXCLUDE_UNIT_CAT

exclude a Category of Unit from processing

job run parameter (char(10))

SPEC_PERSON_ID1

specific Person ID 1

job run parameter (num(10))

SPEC_COURSE_CD1

specific Course Code 1

job run parameter (char(6))

SPEC_PERSON_ID2

specific Person ID 2

job run parameter (num(10))

SPEC_COURSE_CD2

specific Course Code 2

job run parameter (char(6))

SPEC_PERSON_ID3

specific Person ID 3

job run parameter (num(10))

SPEC_COURSE_CD3

specific Course Code 3

job run parameter (char(6))

SPEC_PERSON_ID4

specific Person ID 4

job run parameter (num(10))

SPEC_COURSE_CD4

specific Course Code 4

job run parameter (char(6))

SPEC_PERSON_ID5

specific Person ID 5

job run parameter (num(10))

SPEC_COURSE_CD5

specific Course Code 5

job run parameter (char(6))

SPEC_PERSON_ID6

specific Person ID 6

job run parameter (num(10))

SPEC_COURSE_CD6

specific Course Code 6

job run parameter (char(6))

INC_RELATED_CRS_IND

include related courses

job run parameter (Y or N)

REGISTER_CORRESPONDENCE

Register Correspondence

job run parameter (Y or N)

REQUEST_JOB_RUN_ID

System generated ID number of the request job run

passed by Job Scheduler (num(10))

REQUEST_NUM

the request number this extract was run in

derived from request_job_run_id

ACAD_TRANS_RECORD_V

Note: All references to source database tables and columns are in italics. Field Names in light blue are key fields, specifically included for sorting purposes.

Field Name

Field Description

Max Length

Type

Source / Value

1. PERSON

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

blank

blank

RECORD_TYPE

Record Type

blank

blank

'PERSON'

FIELD1

Person ID

10

num

person.person_id

FIELD2

Surname

person.surname

FIELD3

Title

10

char

person.title

FIELD4

Given Names

40

char

person.given_names

FIELD5

Preferred Given Name

30

char

person .preferred_given_name

FIELD6

Birth Date

blank

date

person.birth_dt

Field Name

Field Description

Max Length

Type

Source / Value

2. ADDRESS

PERSON_ID

The Student ID

 10

num 

 person.person_id

SURNAME

The Student's Surname

 30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

 40

char

 person.given_names

COURSE_CD

blank

blank

blank

RECORD_TYPE

Record Type

blank

blank

'ADDRESS'

FIELD1

Address Line 1

40

char

Current correspondence address

person_address.addr_line_1

FIELD2

Address Line 2

person_address.addr_line_2

FIELD3

Address Line 3

person_address.addr_line_3

FIELD4

Address Line 4

person_address.addr_line_4

FIELD5

Address Line 5

person_address.addr_line_5

FIELD6

Australian Postcode

person_address.aust_postcode

FIELD7

Overseas Postcode

person_address.os_code

FIELD8

Address Type

10

char

person_address.addr_type

FIELD9

Start Date

blank

person_address.start_dt

FIELD10

End Date

blank

person_address.end_dt

Field Name

Field Description

Max Length

Type

Source / Value

3. PERSON-NOTES

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

blank

blank

blank

ank

RECORD_TYPE

Record Type

blank

blank

'PERSON-NOTES'

FIELD1

Person Note Type

10

char

person_note .pe_note_type

FIELD2

Person Note Type Description

60

char

person_note_type .description

FIELD3

Note Text

2000

char 

person_note and note .note_text

Field Name

Field Description

Max Length

Type

Source / Value

4. COURSE

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

The Student Course Attempt Code

6

char 

 student_course_attempt .course_cd

RECORD_TYPE

Record Type

blank

blank

'COURSE'

FIELD1

Course Code

6

char

student_course_attempt .course_cd

FIELD2

Course Version Number

student_course_attemp t .version_number

FIELD3

Course Title

90

 char

course_version.title

FIELD4

Course Short Title

40

char

course_version .short_title

FIELD5

org_unit_cd

10

 char

course_version .responsible_org_unit_cd

FIELD6

ou_start_dt

blank

 date

course_version .responsible_ou_start

FIELD7

Attendance Type

2

char

student_course_attempt .attendance_type

FIELD8

Attendance Mode

2

char 

student_course_attempt .attendance_mode

FIELD9

Derived Attendance Type

2

char

student_course_attempt .derived_att_type

FIELD10

Derived Attendance Mode

2

 char

student_course_attempt .derived_att_mode

FIELD11

Location

10

 char

student_course_attempt .location_cd

FIELD12

Commencement Date

blank

 date

student_course_attempt .commencement_dt

FIELD13

Course Attempt Status

10

 char

student_course_attempt .course_attempt_status

FIELD14

Progression Status

10

 char

student_course_attempt .progression_status

FIELD15

Progression Status Description

60

 char

s_progression_status .description

FIELD16

Course Requirements Complete Date

blank

 date

student_course_attempt .course_rqrmnts_complete_dt

FIELD17

Discontinued Date

blank

 date

student_course_attempt .discontinued_dt

FIELD18

Lapsed Date

blank

 date

student_course_attempt .lapsed_dt

FIELD19

Course GPA

6,3

num

Calculated by prgp_get_sca_gpa

FIELD20

Course WAM

6,3

num

Calculated by prgp_get_sca_wam

FIELD21

Limit Course check box

1

char 

parameter

FIELD22

Include related courses check box

1

char 

parameter

FIELD23

Results blocked for course check box

1

char

derived by enrk_val_encumb .enrp_val_blk_result

Field Name

Field Description

Max Length

Type

Source / Value

5. UNIT-SET

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

The Student Course Attempt Code

6

char 

 student_course_attempt .course_cd

RECORD_TYPE

Record Type

blank

blank

'UNIT-SET'

FIELD1

Unit Set Code

10

char 

student_unit_set_attempt .unit_set_cd

FIELD2

Unit Set Version Number

3

num 

student_unit_set_attempt .us_version_number

FIELD3

Student Unit Set Attempt Sequence Number

6

num 

student_unit_set_attempt .sequence_number

FIELD4

Unit Set Title

90

char 

enrp_get_us_title

FIELD5

Unit Set Category

10

char 

unit_set .unit_set_cat

FIELD6

Unit Set Category Description

60

 char

unit_set_cat .description

FIELD7

Unit Set Category Rank

3

 num

unit_set_cat .rank

FIELD8

Selection Date

blank

 date

student_unit_set_attempt .selection_dt

FIELD9

End Date

blank

date 

student_unit_set_attempt .end_dt

FIELD10

Primary Set check box

1

char 

student_unit_set_attempt .primary_set_ind

FIELD11

Requirements Complete check box

1

char 

student_unit_set_attempt .rqrmnts_complete_ind

FIELD12

Requirements Complete Date

blank

 date

student_unit_set_attempt .rqrmnts_complete_dt

Field Name

Field Description

Max Length

Type

Source / Value

6. ADV-STAND-UNIT- LEVEL

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

The Student Course Attempt Code

6

char 

 student_course_attempt .course_cd

RECORD_TYPE

Record Type

blank

blank

'ADV-STAND-UNIT- LEVEL'

FIELD1

Unit Level

1

char 

from adv_stnd_unit_level .unit_level only when granted

FIELD2

Unit Level Description

60

 char

unit_level.description

FIELD3

Credit Points

6

 num

adv_stnd_unit_level .credit_points

FIELD4

Comments

2000

char

adv_stnd_unit_level .comments

Field Name

Field Description

Max Length

Type

Source / Value

7. ADV-STAND-UNIT

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

The Student Course Attempt Code

6

char 

 student_course_attempt .course_cd

RECORD_TYPE

Record Type

blank

blank

'ADV-STAND-UNIT'

FIELD1

Unit Code

10

char 

adv_stnd_unit .unit_cd

FIELD2

Version Number

3

 num

adv_stnd_unit .version_number

FIELD3

Unit Title

90

char 

unit_version.title

FIELD4

unit short title

40

 char

unit_version.short_title

FIELD5

Unit Level

1

 char

unit_version.unit_level

FIELD6

Unit Level description

60

 char

unit_level.description

FIELD7

Achievable Credit Points

6

 num

unit_version .achievable_credit_points

FIELD8

Comments

2000 

char

adv_stnd_unit .comments

Field Name

Field Description

Max Length

Type

Source / Value

8. UNIT

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

The Student Course Attempt Code

6

char 

 student_course_attempt .course_cd

RECORD_TYPE

Record Type

blank

blank

'UNIT'

FIELD1

Unit Code

10

char 

student_unit_attempt .unit_cd

FIELD2

Unit Version Number

3

num 

Student_unit_attempt .version_number

FIELD3

Unit Title

90

num 

If there is a sua .alternative_title it is used, otherwise unit_version.title is used.

FIELD4

Unit Short Title

40

char 

unit_version.short_title

FIELD5

Teaching Calendar Type

10

char 

Student_unit_attempt .cal_type

FIELD6

Teaching Calendar Sequence Number

6

num 

Student_unit_attempt .ci_sequence_number

FIELD7

Teaching Calendar Alternate Code (semester)

10

char 

cal_instance.alternate_code

FIELD8

Teaching Calendar Start Date

blank

date 

Student_unit_attempt .ci_start_dt

FIELD9

Teaching Calendar End Date

blank

date 

Student_unit_attempt .ci_end_dt

FIELD10

Parent Academic Calendar Type

10

 char

cal_instance .cal_type

FIELD11

Parent Academic Calendar Sequence Number

6

 num

cal_instance .sequence_number

FIELD12

Parent Academic Calendar Alternate Code (year)

10

char 

cal_instance .alternate_code

FIELD13

Unit Attempt Status

10

char 

student_unit_attempt .unit_attempt_status

FIELD14

Discontinued Date

blank

 date

student_unit_attempt .discontinued_dt

FIELD15

Unit Level

1

 char

unit_version .unit_level

FIELD16

Unit Level Description

60

 char

unit_level .description

FIELD17

Research Unit check box

1

 char

unit_version .research_unit_ind

FIELD18

Achievable Credit Points

6,3

num 

if sua .override_achievable_cp exists use it, else if uv .achievable_credit_points exists use that, else use uv .enrolled_credit_points

FIELD19

Achieved Credit Points

6,3

num 

inqp_get_sua_achvd

FIELD20

s_result_type

10

char 

assp_get_sua_outcome

FIELD21

Final Grade

5

 char

if there is an external grade use it otherwise use the grade from assp_get_sua_outcome

FIELD22

Final Mark

3

num 

assp_get_sua_outcome

FIELD23

Grading Schema Code

10

char 

assp_get_sua_outcome

FIELD24

Grading Schema Version Number

3

num 

assp_get_sua_outcome

FIELD25

Outcome Date

blank

date 

assp_get_sua_outcome

FIELD26

Origin Course CD

6

char 

assp_get_sua_outcome

FIELD27

Comments

2000

char 

grading_schema .comments

FIELD28

Grade leading to supplementary exam

5

 char

stdnt_unit_atmpt_outcome .grade

FIELD29

Mark leading to supplementary exam

3

 num

stdnt_unit_atmpt_outcome .mark to final result

Field Name

Field Description

Max Length

Type

Source / Value

9. COURSE-INTERMISSION

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

The Student Course Attempt Code

6

char 

 student_course_attempt .course_cd

RECORD_TYPE

Record Type

blank

blank

'COURSE-INTERMISSION'

FIELD1

Start Date

blank

 date

student_course_intermission .start_dt

FIELD2

End Date

blank

date 

student_course_intermission .end_dt

FIELD3

Voluntary check box

1

char 

student_course_intermission .voluntary_ind

FIELD4

Comments

2000

char 

student_course_intermission .comments

Field Name

Field Description

Max Length

Type

Source / Value

10. COURSE-TRANSFER

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

The Student Course Attempt Code

6

char 

 student_course_attempt .course_cd

RECORD_TYPE

Record Type

blank

blank

'COURSE-TRANSFER'

FIELD1

Transferred From Course Code

6

 char

student_course_transfer .transfer_course_cd

FIELD2

Transfer Date

blank

date 

student_course_transfer .transfer_dt

FIELD3

Comments

2000

 char

student_course_transfer .comments

Field Name

Field Description

Max Length

Type

Source / Value

11. UNIT-TRANSFER

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

The Student Course Attempt Code

6

char 

 student_course_attempt .course_cd

RECORD_TYPE

Record Type

blank

blank

'UNIT-TRANSFER'

FIELD1

Transferred From Course Code

6

char 

student_unit_transfer .transfer_course_cd

FIELD2

Transfer Date

blank

date 

student_unit_transfer .transfer_dt

FIELD3

Unit Code

10

char 

student_unit_transfer .unit_cd

FIELD4

Teaching Calendar Type

10

char 

student_unit_transfer .cal_type

FIELD5

Teaching Calendar Sequence Number

6

num 

student_unit_transfer .ci_sequence_number

Field Name

Field Description

Max Length

Type

Source / Value

12. PROGRESSION

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

The Student Course Attempt Code

6

char 

 student_course_attempt .course_cd

RECORD_TYPE

Record Type

blank

blank

'PROGRESSION'

FIELD1

Progression Calendar Type

10

char

cal_instance .cal_type - progression

FIELD2

Progression Calendar Sequence Number

6

 num

cal_instance .sequence_number - progression

FIELD3

Progression Calendar Alternate Code

10

char 

cal_instance .alternate_code - progression

FIELD4

Progression Calendar Start Date

blank

 date

cal_instance .start_dt - progression

FIELD5

Progression Calendar End Date

blank

 date

cal_instance .end_dt - progression

FIELD6

Prog Cal Type Description

60

 char

cal_type .description

FIELD7

Prog Cal Type Abbreviation

30

 char

cal_type .abbreviation

FIELD8

Parent Academic Calendar Type

10 

char

cal_instance .cal_type - academic

FIELD9

Parent Academic Calendar Sequence Number

6

 num

cal_instance .sequence_number - academic

FIELD10

Parent Academic Calendar Alternate Code (year)

10

char

cal_instance .alternate_code - academic

FIELD11

Period GPA

6,3

num 

from prgp_get_std_gpa

FIELD12

Period WAM

6,3

 num

from prgp_get_std_wam

Field Name

Field Description

Max Length

Type

Source / Value

13. GRADUATION

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

The Student Course Attempt Code

6

char 

 student_course_attempt .course_cd

RECORD_TYPE

Record Type

blank

blank

'GRADUATION'

FIELD1

Creation Date

blank

date 

graduand.create_dt

FIELD2

Graduand Calendar Type

10

char 

graduand.grd_cal_type

FIELD3

Graduand Calendar Sequence Number

6

num 

graduand .grd_ci_sequence_number

FIELD4

Award Course Code

6

char 

graduand .award_course_cd

FIELD5

Award Course Version Number

3

num 

graduand .award_crs_version_number

FIELD6

Award Course Title

90

 char

course_version .title

FIELD7

Award Course Short Title

40

 char

course_version .short_title.

FIELD8

Award Code

10

char 

graduand.award_cd

FIELD9

Award Title

90

char 

award.award_title

FIELD10

Honours Level

3

char 

graduand.honours_level

FIELD11

Honours Level Description

60

char 

honours_level .description.

FIELD12

Conferral Date

blank

date 

graduand.conferral_dt

FIELD13

Graduand Status

10

char 

graduand.graduand_status

FIELD14

Graduand Approval Status

10

char 

graduand.graduand_appr_status

FIELD15

Surrendered for Course Code

6

char 

graduand.sur_for_course_cd

FIELD16

Surrendered for Course Version

3

num

graduand.sur_for_crs_version_number

FIELD17

Surrendered for Award Code

10

char 

graduand.sur_for_award_cd

FIELD18

Comments

2000

char 

graduand.comments

Field Name

Field Description

Max Length

Type

Source / Value

14. ENCUMBRANCE

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

The Student Course Attempt Code

6

char 

 student_course_attempt .course_cd

RECORD_TYPE

Record Type

blank

blank

'ENCUMBRANCE'

FIELD1

Encumbrance Start Date

blank

 date

enrp_get_excld_crs

FIELD2

Encumbrance Expiry Date

blank

 date

enrp_get_excld_crs

Field Name

Field Description

Max Length

Type

Source / Value

15. SPECIAL-AWARD

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

The Student Course Attempt Code

6

char 

 student_course_attempt .course_cd

RECORD_TYPE

Record Type

blank

blank

'SPECIAL-AWARD'

FIELD1

Award Code

30

 char

special_award .award_code

FIELD2

Award Title

90

 char

award.award_title

FIELD3

System Award Type

10

char 

award.s_award_type

FIELD4

Award Date

blank

 date

special_award .award_dt

FIELD5

Comments

2000

 char

special_award .comments

Field Name

Field Description

Max Length

Type

Source / Value

16. SCA-SPECIAL-RQRMNTS

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

The Student Course Attempt Code

6

char 

 student_course_attempt .course_cd

RECORD_TYPE

Record Type

blank

blank

'SCA-SPECIAL-RQRMNTS'

FIELD1

Special Requirement Code

10

char 

student_crs_spcl_rqrmnt .special_requirement_cd

FIELD2

Special Requirement Description

60

 char

special_requirement .description

FIELD3

Completed Date

blank

date 

student_crs_spcl_rqrmnt .completed_dt

FIELD4

Expiry Date

blank

 date

student_crs_spcl_rqrmnt .expiry_dt

FIELD5

Reference

10

char 

student_crs_spcl_rqrmnt .reference

FIELD6

Comments

2000 

char 

student_crs_spcl_rqrmnt .comments

Field Name

Field Description

Max Length

Type

Source / Value

17. STDNT-CRS-ATMPT-NOTE

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

COURSE_CD

The Student Course Attempt Code

6

char 

 student_course_attempt .course_cd

RECORD_TYPE

Record Type

blank

blank

'STDNT-CRS-ATMPT-NOTE'

FIELD1

Enrolment Note Type

10

 char

student_crs_atmpt_note .enr_note_type

FIELD2

Enrolment Note Type Description

60

 char

enr_note_type .description

FIELD3

Note Text

2000

char 

student_crs_atmpt_note and note .note_text

Field Name

Field Description

Max Length

Type

Source / Value

18. RESEARCH

PERSON_ID

The Student ID

10

num 

 person.person_id

SURNAME

The Student's Surname

30

char

 person.surname

GIVEN_NAMES

The Student's Given Name/s

40

char

 person.given_names

NVL(ca.sca_course_cd,ca.acai_nominated_course_cd)

blank

6

char 

 If not empty use ca .sca_course_cd else use ca .acai_nominated_course_cd

RECORD_TYPE

Record Type

blank

blank

'RESEARCH'

FIELD1

Candidature Sequence Number

6

num 

thesis .ca_sequence_number

FIELD2

Thesis Sequence Number

6

num 

thesis .sequence_number

FIELD3

Thesis Title

200

char 

thesis.title

FIELD4

Final Title check box

1

char

thesis .final_title_ind

FIELD5

Thesis Result code

10

char 

thesis .thesis_result_cd

FIELD6

Thesis Result description

60

 char

thesis_result .description

FIELD7

Expected Submission Date

blank

 date

thesis .expected_submission_dt

FIELD8

Library Lodgement Date

blank

date 

thesis .library_lodgement_dt