Transcript Object

The Transcript object contains data concerning student's academic history. This object contains one record for each UO or transfer course in the academic history of every student who is included in the Student Data Warehouse.

---

Warehouse ID

Warehouse identification code. A unique identifying value for all persons in the Student Data Warehouse.

Data Type: Number

Example: 123456

Source: derived

Inst Transfer Flag

Flag indicating whether the course is from UO or another institution: 'I' = UO (Institutional), 'T' = other institution (Transfer).

Data Type: 1 Character

Example: I

Source: Derived

Transcript Term

Code representing term UO course was taken or transfer course was accepted into Banner. Format YYYYTT, where YYYY = academic year and TT = term. '01' = Fall, '02' = Winter, '03' = Spring, '04' = Summer, '05' = Fall Semester, '06' = Spring Semester, '07' = Summer Semester.

Data Type: 6 Characters

Example: 199502

Source: shrtckn_term_code, shrtram_term_code_entered

Val Table: Term

Notes: Comes from shrtckn for UO courses, shrtram for transfer course.

Transfer Term

Code representing term the transfer course was taken, null for UO courses. Format YYYYTT, where YYYY = academic year and TT = term. '01' = Fall, '02' = Winter, '03' = Spring, '04' = Summer, '05' = Fall Semester, '06' = Spring Semester, '07' = Summer Semester.

Data Type: 6 Characters

Example: 199502

Source: shrtrce_term_code_eff

Val Table: Term

College Code

College code associated with the college offering the student's course or equivalent transfer course.

Data Type: 2 Characters

Example: 16

Source: shrtckn_coll_code, stvdept_coll_code

Val Table: College

Notes: Comes from shrtckn for UO courses, stvdept for transfer course equivalent.

Dept Code

Department code associated with the department offering the student's course or equivalent transfer course.

Data Type: 4 Characters

Example: ME

Source: shrtckn_dept_code, stvsubj_dept_code

Val Table: Department

Notes: Comes from shrtckn for UO courses, stvsubj for transfer course equivalent.

Subj Code

Subject code associated with the course or equivalent transfer course.

Data Type: 4 Characters

Example: ME

Source: shrtckn_subj_code, shrtrce_subj_code

Val Table: Subject

Notes: Comes from shrtckn for UO courses, shrtrce for transfer course equivalent.

Course Numb

Course number associated with the course or equivalent transfer course. It may include an alpha suffix.

Data Type: 4 Characters

Example: 481

Source: shrtckn_crse_numb, shrtrce_crse_numb

Notes: Comes from shrtckn for UO courses, shrtrce for transfer course equivalent.

CRN

Course Reference Number (CRN) assigned to each UO course section for the term. UO courses only. There is a unique CRN assigned to each course offered in a term. The same CRN may be reused for a course offered in another term.

Data Type: 5 Characters

Example: 24686

Source: shrtckn_crn

Title

Title of the course or equivalent transfer course.

Data Type: 30 Characters

Example: Physical Metallurgy

Source: shrtckn_crse_title,shrtrce_course_title

Notes: Comes from shrtckn for UO courses, shrtrce for transfer course equivalent.

Credit Hours

Credit hours associated with the course or equivalent transfer course.

Data Type: 3 Digit number plus 2 decimal places

Example: 3

Source: shrtckg_credit_hours, shrtrce_credit_hours

Notes: Comes from shrtckg for UO courses, shrtrce for transfer course equivalent.

Repeat Flag

Flag indicating that credit has been deducted for the course because the course was not repeatable or the student had previously taken a course at a higher level. Codes indicate how the course is treated in GPA and totals calculation. E = excluded from GPA and credit totals, M = included in GPA but not in credit totals, Null = First Time Taken. UO courses only.

Data Type: 1 Character

Example: Y

Source: shrtckn_repeat_course_ind

Grading Mode

Grading mode associated with the student's registration in the course or transfer equivalent course.

Data Type: 1 Character

Example: P

Source: shrtckg_gmod_code, shrtrce_gmod_code

Notes: Comes from shrtckg for UO courses, shrtrce for transfer course equivalent.

Grade

Grade code recorded for the UO course or transfer equivalent course.

Data Type: 3 Characters

Example: A-

Source: shrtckg_grde_code_final, shrtrce_grde_code

Notes: Comes from shrtckg for UO courses, shrtrce for transfer course equivalent. The shrtckg grade is the record for the given _pidm, _term_code, and _tckn_seq_no with the maximum _final_grde_seq_no.

GPA Hours

Credit hours for this course or equivalent transfer course that apply to the student's GPA. Only UO courses are used to calculate the official UO GPA.

Data Type: 3 Digit number plus 2 decimal places

Example: 3

Source: Derived

Notes: If the shrgrde_gpa_ind for this course = 'Y' then this field is the same as Credit Hours, if shrgrde_gpa_ind = 'N' then this field contains 0.

Grade Numeric Value

Numeric representation of grade or equivalent grade, used for grade comparisons.

Data Type: 2 Digit number

Example: 3.5

Source: shrgrde_numeric_value

Grade Points

Calculated grade points (by multiplying credit hours and quality points used for GPA calculations) for this course or equivalent transfer course.

Data Type: 2 Digit number plus 2 decimal places

Example: 11.1

Source: derived

Notes: Calculated by multiplying shrgrde_quality_points * shrtckg_credit_hours for UO courses, or shrtrce_credit_hours for transfer courses.

Original Grade

Grade code recorded originally for the course. UO courses only.

Data Type: 3 Characters

Example: -A

Source: shrtckg_grde_code_final

Notes: From the shrtckg record for this course with the _final_grde_seq_no of 1.

Count In GPA Flag

Flag indicating whether or not this course counts in calculating the student's GPA. 'Y' = Counts (Yes), Null = Does Not Count.

Data Type: 1 Character

Example: -A

Source: shrgrde_gpa_ind

Course Level

Level to which the student's UO or transfer equivalent course is applied: 'UG' = Undergraduate, 'GR' = Graduate/Professional, 'LW' = Law.

Data Type: 2 Characters

Example: 1

Source: shrtckl_levl_code, shrtrce_levl_code

Val Table: Level

Notes: Comes from shrtckl for UO courses, shrtrce for transfer course equivalent.

Course Attributes

Concatenation of all Attribute Codes for a course, or its transfer equivalent, separated by '|' (pipe characters). These codes identify courses in the student's transcript which meet specific general university requirements. See the validation table for a complete listing of possible codes.

Data Type: 100 Characters

Example: |CSW3|CPCD|CPLA|

Val Table: Course Attribute

Source: scrattr_attr_code, shrtatt_attr_code

Notes: Comes from scrattr for UO courses, shrtatt for transfer course equivalent.

Instructor ID

Instructor Identification Number. UO courses only.

Data Type: 9 Characters

Example: 734619460

Source: spriden_id

Instructor Name

Instructor's name formatted as "Last name, First name Middle name". If the person has only one name, a comma is not included. UO courses only.

Data Type: 30 Characters

Example: Johnson, Timothy K

Source: derived

Transfer Title

Original course title on the transfer institution transcript.

Data Type: 30 Characters

Example: Modern History

Source: shrtrcr_tcrse_title

Transfer Subj Code

Original subject code on the transfer institution transcript.

Data Type: 60 Characters

Example: HIST

Source: shrtrcr_trans_course_name

Transfer Course Numb

Original course number on the transfer institution transcript.

Data Type: 60 Characters

Example: 189

Source: shrtrcr_trans_course_numbers

Transfer Hours

Original credit hours on the transfer institution transcript.

Data Type: 3 Digit number plus 2 decimal places

Example: 49

Source: shrtrcr_trans_credit_hours

Transfer Grade

Original grade on the transfer institution transcript.

Data Type: 3 Characters

Example: B

Source: shrtrcr_trans_grade

Institution Code

Source/Background Institution (SBGI) Code that identifies the transfer institution. Null for UO courses.

Data Type: 6 Characters

Example: 003218A

Source: shrtrit_sbgi_code

Val Table: Institution

Institution Desc

Name of transfer institution. Null for UO courses.

Data Type: 30 Characters

Example: Chemeketa Comm. College

Source: stvsbgi_desc

Val Table: Institution