Degree

D a t a D i c t i o n a r y

Degree Object

The Degree object contains data concerning student's degree activity. This object contains one record for every Banner degree record for every student who is present in the Student Data Warehouse. The Degree object also contains degree records for students who have no registration activity, and would not otherwise be in the warehouse, but only for terms which are loaded in the warehouse. Records for degrees applied for (AP), awarded (AW), complete/pending award (CP), denied (DE), and pulled (PU) are included. Banner records for degrees sought (SO) are not included in the Student Data Warehouse. (Note: Full transfer degree information is available only for UO Law Students).
Warehouse ID: Warehouse identification code. A unique identifying value for all persons in the Student Data Warehouse. Used for COUNT and DISTINCT queries.; Data Type: Number; Example: 123456; Source: derived
Inst Transfer Flag: Flag representing whether this degree is associated with the University of Oregon or not: 'I' = UO (institutional), 'T' = Other institution (transfer).; Data Type: 1 Character; Example: T; Source: derived
Degree Level: Level to which the degree applies: 'UG' for Undergraduate, 'GR' for Graduate, 'LW' for Law.; Data Type: 2 Characters; Example: UG; Source: shrdgmr_levl_code, derived; Val Table: Level; Notes: Comes from shrdgmr for UO degrees, is derived from stvdegc_dlev_code for transfer degrees: 24 becomes 'UG', 31 and degc_code = 'JD' becomes 'LW', 31 and degc_code <> 'JD' becomes 'GR', 41 and degc_code = 'CERT' becomes 'UG', 41 and degc_code = 'GCERT' becomes 'GR', >= 42 becomes 'GR'. For all degrees, levl_code of 'NG' or 'NU' is ignored.
Degree Code: Code describing the type of degree awarded (BS, BA, etc.).; Data Type: 6 Characters; Example: MBA; Source: shrdgmr_degc_code, sordegr_degc_code; Val Table: Degree Type; Notes: Comes from shrdgmr for UO degrees, comes from sordegr for transfer degrees.
Degree Desc: Description of the Degree Code.; Data Type: 30 Characters; Example: Master of Business Admin.; Source: stvdegc_desc
Degree Status: Code denoting the status of the degree. 'AP' = applied for degree, 'AW' = degree awarded, 'CP' = application complete but not yet awarded, 'DE' = application denied, failed to meet degree requirements, 'PU' = application pulled. All degree records from other institutions have a value of 'AW'.; Data Type: 2 Characters; Example: 'AW'; Source: SHRDGMR_DEGS_CODE, derived; Val Table: Degree Status; Notes: Comes from SHRDGMR for UO degrees, is 'AW' for transfer degrees.
Degree Status Desc: Description of the Degree Status Code.; Data Type: 30 Characters; Example: Awarded; Source: stvdegs_desc; Val Table: Degree Status
ACAT Code: Degree Award Category Code. This code groups degrees by category type (e.g. 24 = Bachelor's degree).; Data Type: 2 Characters; Example: 24; Source: stvdegc_acat_code; Val Table: Degree Category
ACAT Desc: Degree Award Category Code Description.; Data Type: 30 Characters; Example: Doctoral Degree; Source: stvacat_desc; Val Table: Degree Category
Degree Inst Honor Codes: Indicates whether there are Institutional Honors associated with this degree such as 'C' for Cum Laude, 'M' for Magna Cum Laude, 'S' for Summa Cum Laude, & 'H' for Honors College. Multiple codes are separated by '|' (pipe characters).; Data Type: 20 Characters; Example: |M|S|; Source: shrdgih_honr_code, sordegr_honr_code; Val Table: Institution Honors; Notes: Comes from shrdgih for UO degrees, sordegr for transfer degrees.
Degree Inst Honor Descs: Descriptions of Degree Institutional Honor Codes. Multiple descriptions are separated by '|' (pipe characters), and correspond in order to the '|' (pipe character)separated Honor Codes.; Data Type: 120 Characters; Example: |Magna Cum Laude|Summa Cum Laude|; Source: derived from stvhonr_desc
Degree Dept Honor Codes: Indicates whether there are Departmental Honors associated with this degree, such as '1' for the department of the student's 1st major for the degree, or '2' for the department of the student's 2nd major for the degree. A student may earn departmental honors in up to four majors for one degree. Multiple codes are separated by '|' (pipe characters). UO degrees only.; Data Type: 30 Characters; Example: |1|3|; Source: derived from shrdgdh_hond_code; Val Table: Department Honors
Degree Dept Honor Descs: Descriptions of Degree Department Honor Codes. Multiple descriptions are separated by '|' (pipe characters), and correspond in order to the '|' (pipe character) separated Honor Codes. UO degrees only.; Data Type: 120 Characters; Example: |1st Major|3rd Major|; Source: stvhond_desc
Degree Date: Anticipated or awarded degree date.; Data Type: Date; Example: 04-SEP-87; Source: shrdgmr_grad_date, sordegr_degc_date; Notes: Comes from shrdgmr for UO degrees, comes from sordegr for non-UO degrees.
Degree Term: Anticipated or awarded degree term. 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. UO degrees only.; Data Type: 6 Characters; Example: 199301; Source: shrdgmr_term_code_sturec; Val Table: Term
Degree Major 1 College: College awarding the degree or college(s) associated with awarded major(s).; Data Type: 2 Characters; Example: MU; Source: stvdept_code, sordegr_coll_code; Val Table: College; Notes: Comes from stvdept for UO degrees (via stvmajr), comes from sordegr for transfer degrees.
Degree Major 1: First major associated with the degree.; Data Type: 4 Characters; Example: ARCH; Source: derived, sormajr_majr_code; Val Table: Major-Minor; Notes: Comes from shrdgmr for UO degrees, comes from sormajr for transfer degrees.; For UO degrees, the 4 available major fields, shrdgmr_major_code_1, shrdgmr_major_code_2, shrdgmr_majr_code_1_2, shrdgmr_majr_code_2_2, are all scanned and mapped to Degree Major code fields, so that Degree Major 1 is filled first, then Degree Major 2, etc, regardless of which of the shrdgmr fields contain values. For non-UO degrees, the records found in sormajr are inserted.
Degree Major 2 College: College awarding the degree or college(s) associated with awarded major(s).; Data Type: 2 Characters; Example: MU; Source: stvdept, sordegr_coll_code; Val Table: College; Notes: Comes from stvdept for UO degrees (via stvmajr), comes from sordegr for transfer degrees.
Degree Major 2: Second major associated with the degree.; Data Type: 4 Characters; Example: ARCH; Source: derived, sormajr_majr_code; Val Table: Major-Minor; Notes: Comes from shrdgmr for UO degrees, comes from sormajr for transfer degrees. See the notes for Degree Major 1.
Degree Major 3 College: College awarding the degree or college(s) associated with awarded major(s).; Data Type: 2 Characters; Example: MU; Source: stvdept, sordegr_coll_code; Val Table: College; Notes: Comes from stvdept for UO degrees (via stvmajr), comes from sordegr for transfer degrees.
Degree Major 3: Third major associated with the degree.; Data Type: 4 Characters; Example: ARCH; Source: derived, sormajr_majr_code; Val Table: Major-Minor; Notes: Comes from shrdgmr for UO degrees, comes from sormajr for transfer degrees. See the notes for Degree Major 1.
Degree Major 4 College: College awarding the degree or college(s) associated with awarded major(s).; Data Type: 2 Characters; Example: MU; Source: stvdept, sordegr_coll_code; Val Table: College; Notes: Comes from stvdept for UO degrees (via stvmajr), comes from sordegr for transfer degrees.
Degree Major 4: Fourth major associated with the degree.; Data Type: 4 Characters; Example: ARCH; Source: derived, sormajr_majr_code; Val Table: Major-Minor; Notes: Comes from shrdgmr for UO degrees, comes from sormajr for transfer degrees. See the notes for Degree Major 1.
Degree Minor 1 College: College awarding the degree or college(s) associated with awarded minor (s).; Data Type: 2 Characters; Example: AA; Source: stvdept, sordegr_coll_code; Val Table: College; Notes: Comes from stvdept for UO degrees (via stvmajr), comes from sordegr for transfer degrees.
Degree Minor 1: First minor associated with the degree.; Data Type: 4 Characters; Example: HIST; Source: shrdgmr_majr_code_minr_1, sorminr_majr_code_minr; Val Table: Major-Minor; Notes: Comes from shrdgmr for UO degrees, comes from sorminr for transfer degrees. For UO degrees, the 4 available minor fields, shrdgmr_minr_code_1, shrdgmr_minr_code_2, shrdgmr_minr_code_1_2, shrdgmr_minr_code_2_2, are all scanned and mapped to Degree Minor code fields, so that Degree Minor 1 is filled first, then Degree Minor 2, etc, regardless of which of the shrdgmr fields contain values.
Degree Minor 2 College: College awarding the degree or college(s) associated with awarded minor (s).; Data Type: 2 Characters; Example: AA; Source: stvdept, sordegr_coll_code; Val Table: College; Notes: Comes from stvdept for UO degrees (via stvmajr), comes from sordegr for transfer degrees.
Degree Minor 2: Second minor associated with the degree.; Data Type: 4 Characters; Example: HIST; Source: derived, sorminr_majr_code_minr; Val Table: Major-Minor; Notes: Comes from shrdgmr for UO degrees, comes from sorminr for transfer degrees. See notes for Degree Minor 1.
Degree Minor 3 College: College awarding the degree or college(s) associated with awarded minor (s).; Data Type: 2 Characters; Example: AA; Source: stvdept, sordegr_coll_code; Val Table: College; Notes: Comes from stvdept for UO degrees (via stvmajr), comes from sordegr for transfer degrees.
Degree Minor 3: Third minor associated with the degree.; Data Type: 4 Characters; Example: HIST; Source: derived, sorminr_majr_code_minr; Val Table: Major-Minor; Notes: Comes from shrdgmr for UO degrees, comes from sorminr for transfer degrees. See notes for Degree Minor 1.
Degree Minor 4 College: College awarding the degree or college(s) associated with awarded minor (s).; Data Type: 2 Characters; Example: AA; Source: stvdept, sordegr_coll_code; Val Table: College; Notes: Comes from stvdept for UO degrees (via stvmajr), comes from sordegr for transfer degrees.
Degree Minor 4: Fourth minor associated with the degree.; Data Type: 4 Characters; Example: HIST; Source: derived, sorminr_majr_code_minr; Val Table: Major-Minor; Notes: Comes from shrdgmr for UO degrees, comes from sorminr for transfer degrees. See notes for Degree Minor 1.
All Degree Majors: All degree major codes joined together and separated by '|' (pipe characters); Data Type: 32 Characters; Example: |MATH|CIS|; Source: derived; Val Table: Major-Minor
All Degree Major Colleges: All of the major colleges for the student's degree, separated by '|' (pipe characters).; Data Type: 16 Characters; Example: |AA|JO|; Source: derived; Val Table: College
All Degree Minors: All degree minor codes joined together and separated by '|' (pipe characters); Data Type: 32 Characters; Example: |MATH|CIS|; Source: derived; Val Table: Major-Minor
All Degree Minor Colleges: All of the minor colleges for the student's degree, separated by '|' (pipe characters).; Data Type: 16 Characters; Example: |AA|JO|; Source: derived; Val Table: College
Institution Code: Source/Background Institution (SBGI) Code that identifies the institution where the applicant received this degree. Null for UO degrees.; Data Type: 7 Characters; Example: 002128; Source: sordegr_sbgi_code; Val Table: Educational Institution
Institution Desc: Description of Institution Code. Null for UO degrees.; Data Type: 30 Characters; Example: Boston College; Source: stvsbgi_desc
Degree Application Date: Degree application date; Data Type: Date
Postbac Flag: This is 'Y' when a P-UG or a GR applies for (is awarded) an undergraduate degree.; Data Type: 1 Character

This page was last updated on May 20, 2003.


� 2002; University of Oregon, Eugene OR 97403; (541) 346-1000
Comments? hilton@oregon.uoregon.edu