TESTAMUR_EXTRACT_V

Field Name

Field Description

Data Source

CREATION_DT

Extract Creation Date

System

GRD_CAL_TYPE

Graduation Ceremony Round

Job run parameter

GRD_CI_SEQUENCE_NUMBER

ORG_UNIT_CD

Organisational Unit

Job run parameter

OU_START_DT

LOCATION_CD

Student Course Attempt Location Code

Job run parameter

COURSE_TYPE

Course Type

Job run parameter

COMBINED_DEGREE

Combined Degree Inclusion/Exclusion

Job run parameter

Ceremony Number

Ceremony Number

Job run parameter

AWARD_CD

Award Code

Job run parameter

S_GRADUAND_TYPE

System Graduand Type

Job run parameter

S_AWARD_TYPE

System Award Type

Job run parameter

TESTAMUR_TYPE

Testamur Type

Job run parameter

PERSON_ID_GROUP_ID

Person ID Group Code

Job run parameter

PERSON_ID

Individual Person ID

Job run parameter

PRODUCTION_MODE

Production Mode

Job run parameter

REGISTER_CORRESPONDENCE

Register Correspondence Selection

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

TESTAMUR_RECORD_V

Field Name

Field Description

Source

 CREATION_DT

The Extract record's Creation Date

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

 PERSON_ID

The ID number of the Graduand

graduand.person_id (numbers - 10)

 CREATE_DT

The Creation Date of the subject Graduand record

graduand.create_dt (date(DD/MM/YYYY HH24:MI:SS))

 GRD_CAL_TYPE

The Ceremony Round to which the record belongs

job parameter (characters - 10), (numbers - 6)

 GRD_CI_SEQUENCE_NUMBER

 AWARD_CD

The Code of the Graduand Award to which this record refers

graduand.award_cd (characters - 10)

 RECORD_TYPE

The name identifying the type of the record (i.e. MAIN)

extract job (GRDJ6000) (numbers - 1)

 FIELD1

System Graduand Type

graduand.s_graduand_type (characters - 10)

 FIELD2

System Award Type

award.s_award_type (characters - 10)

 FIELD3

Testamur Type

award.testamur_type (characters - 10)

 FIELD4

Student Course Attempt's Course Type

course_version.course_type (characters - 10)

 FIELD5

Graduation Name (name for including on Testamur)

graduand.graduation_name (characters - 80)

 FIELD6

Award Title

award.award_title (characters - 90)

 FIELD7

Conferral Date

graduand.conferral_dt (DD/MM/YYYY)

 FIELD8

Code of the Graduand's Course Attempt

graduand.course_cd (characters - 6)

 FIELD9

Course Code of the Award the Graduand is to receive (this may differ to FIELD8 where the Graduand is receiving an Award for an Alternative Exit)

graduand.award_course_cd (characters - 6)

 FIELD10

Ceremony Number

graduand_award_ceremony .ceremony_number (numbers - 3)

 FIELD11

Order in Presentation

graduand_award_ceremony .order_in_presentation (numbers - 4)

 FIELD12

Testamur Number

table name. tstmr_sequence_number (numbers - 9)

 FIELD13

Honours Level Description

honours_level.description (characters - 90)

 FIELD14

Surname

person.surname (characters - 30)

 FIELD15

Given Name

first preferred given name from person.given_names

 FIELD16

Unit Set Title

derived using enrp_get_us_title (characters - 90)

 FIELD17

Unit Set Category

unit_set.unit_set_cat (characters - 10)

 FIELD18

Unit Set Code

student_unit_set_attempt .unit_set_cd

 FIELD19

Unit Set Title

derived using enrp_get_us_title (characters - 90)

 FIELD20

Unit Set Category

unit_set.unit_set_cat (characters - 10)

 FIELD21

Unit Set Code

student_unit_set_attempt .unit_set_cd

 FIELD22

Unit Set Title

derived using enrp_get_us_title (characters - 90)

 FIELD23

Unit Set Category

unit_set.unit_set_cat (characters - 10)

 FIELD24

Unit Set Code

student_unit_set_attempt .unit_set_cd

 FIELD25

Unit Set Title

derived using enrp_get_us_title (characters - 90)

 FIELD26

Unit Set Category

unit_set.unit_set_cat (characters - 10)

 FIELD27

Unit Set Code

student_unit_set_attempt .unit_set_cd

 FIELD28

Unit Set Title

derived using enrp_get_us_title (characters - 90)

 FIELD29

Unit Set Category

unit_set.unit_set_cat (characters - 10)

 FIELD30

Unit Set Code

student_unit_set_attempt .unit_set_cd

 FIELD31

Unit Set Title

derived using enrp_get_us_title (characters - 90)

 FIELD32

Unit Set Category

unit_set.unit_set_cat (characters - 10)

 FIELD33

Unit Set Code

student_unit_set_attempt .unit_set_cd

 FIELD34

Unit Set Title

derived using enrp_get_us_title (characters - 90)

 FIELD35

Unit Set Category

unit_set.unit_set_cat (characters - 10)

 FIELD36

Unit Set Code

student_unit_set_attempt .unit_set_cd

 FIELD37

Unit Set Title

derived using enrp_get_us_title (characters - 90)

 FIELD38

Unit Set Category

unit_set.unit_set_cat (characters - 10)

 FIELD39

Unit Set Code

student_unit_set_attempt .unit_set_cd

 FIELD40

Unit Set Title

derived using enrp_get_us_title (characters - 90)

 FIELD41

Unit Set Category

unit_set.unit_set_cat (characters - 10)

 FIELD42

Unit Set Code

student_unit_set_attempt .unit_set_cd