|
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
D a t a D i c t i o n a r y
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
This page was last updated on February 15, 2000.
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
|
|
