Top of GRD | Index | Table of Contents | Feedback | ![]() |
Testamur Extract - View Details
Testamur Extract View Details
The table shows the fields presented by this view.
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 View Details
The table contains descriptions of the fields in each testamur record. Fields in blue text are 'key' fields provided for ease of sorting.
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 |
Last Modified on 4 March, 2004