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