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 (num(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 (char(10)), (num(6))

 GRD_CI_SEQUENCE_NUMBER

 AWARD_CD

the code of the graduand award to which this record refers

graduand.award_cd (char(10))

 RECORD_TYPE

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

extract job (GRDJ6000) (num(1))

 FIELD1

system graduand type

graduand.s_graduand_type (char(10))

 FIELD2

system award type

award.s_award_type (char(10))

 FIELD3

testamur type

award.testamur_type (char(10))

 FIELD4

student course attempt's course type

course_version.course_type (char(10))

 FIELD5

graduation name (name for including on testamur)

graduand.graduation_name (char(80))

 FIELD6

award title

award.award_title (char(90))

 FIELD7

conferral date

graduand.conferral_dt (DD/MM/YYYY)

 FIELD8

code of the graduand's course attempt

graduand.course_cd (char(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 (char(6))

 FIELD10

ceremony number

graduand_award_ceremony .ceremony_number (num(3))

 FIELD11

order in presentation

graduand_award_ceremony .order_in_presentation (num(4))

 FIELD12

testamur number

table name. tstmr_sequence_number (num(9))

 FIELD13

honours level description

honours_level.description (char(90))

 FIELD14

surname

person.surname (char(30))

 FIELD15

given name

first preferred given name from person.given_names

 FIELD16

unit set title

derived using enrp_get_us_title (char(90))

 FIELD17

unit set category

unit_set.unit_set_cat (char(10))

 FIELD18

unit set code

student_unit_set_attempt .unit_set_cd

 FIELD19

unit set title

derived using enrp_get_us_title (char(90))

 FIELD20

unit set category

unit_set.unit_set_cat (char(10))

 FIELD21

unit set code

student_unit_set_attempt .unit_set_cd

 FIELD22

unit set title

derived using enrp_get_us_title (char(90))

 FIELD23

unit set category

unit_set.unit_set_cat (char(10))

 FIELD24

unit set code

student_unit_set_attempt .unit_set_cd

 FIELD25

unit set title

derived using enrp_get_us_title (char(90))

 FIELD26

unit set category

unit_set.unit_set_cat (char(10))

 FIELD27

unit set code

student_unit_set_attempt .unit_set_cd

 FIELD28

unit set title

derived using enrp_get_us_title (char(90))

 FIELD29

unit set category

unit_set.unit_set_cat (char(10))

 FIELD30

unit set code

student_unit_set_attempt .unit_set_cd

 FIELD31

unit set title

derived using enrp_get_us_title (char(90))

 FIELD32

unit set category

unit_set.unit_set_cat (char(10))

 FIELD33

unit set code

student_unit_set_attempt .unit_set_cd

 FIELD34

unit set title

derived using enrp_get_us_title (char(90))

 FIELD35

unit set category

unit_set.unit_set_cat (char(10))

 FIELD36

unit set code

student_unit_set_attempt .unit_set_cd

 FIELD37

unit set title

derived using enrp_get_us_title (char(90))

 FIELD38

unit set category

unit_set.unit_set_cat (char(10))

 FIELD39

unit set code

student_unit_set_attempt .unit_set_cd

 FIELD40

unit set title

derived using enrp_get_us_title (char(90))

 FIELD41

unit set category

unit_set.unit_set_cat (char(10))

 FIELD42

unit set code

student_unit_set_attempt .unit_set_cd