Reporting View Target: DEGREE

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: DEGREE_SLOT

Description Uses data from the DEGREE reporting view. Displays a subset of information for up to 3 degrees earned by a constituent, starting with the most recent degree. There are currently no associated display rules.
Key & Frequency One row per person per institution indicator.
Recommended Search Columns PERSON_UID, INSTITUTION_IND
ACTIVITY_DATE

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACADEMIC_YEAR_1 Academic Year 1 Academic year associated with the academic period on this record. VARCHAR2(63)
APRADEG

APRADEG_ACYR_CODE

ACADEMIC_YEAR_2 Academic Year 2 Academic year associated with the academic period on this record. VARCHAR2(63)
APRADEG

APRADEG_ACYR_CODE

ACADEMIC_YEAR_3 Academic Year 3 Academic year associated with the academic period on this record. VARCHAR2(63)
APRADEG

APRADEG_ACYR_CODE

ACTIVITY_DATE Activity Date Date record was inserted or updated. DATE
NA

SYSDATE

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

COLLEGE_1 College 1 College, faculty or school to which the academic study for the student is associated. VARCHAR2(63)
APRADEG

APRADEG_COLL_CODE

COLLEGE_2 College 2 College, faculty or school to which the academic study for the student is associated. VARCHAR2(63)
APRADEG

APRADEG_COLL_CODE

COLLEGE_3 College 3 College, faculty or school to which the academic study for the student is associated. VARCHAR2(63)
APRADEG

APRADEG_COLL_CODE

COLLEGE_DESC_1 College Description 1 College, faculty or school name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

COLLEGE_DESC_2 College Description 2 College, faculty or school name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

COLLEGE_DESC_3 College Description 3 College, faculty or school name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

DEGREE_1 Degree 1 Degree or award code associated with the academic study. VARCHAR2(63)
APRADEG

APRADEG_DEGC_CODE

DEGREE_2 Degree 2 Degree or award code associated with the academic study. VARCHAR2(63)
APRADEG

APRADEG_DEGC_CODE

DEGREE_3 Degree 3 Degree or award code associated with the academic study. VARCHAR2(63)
APRADEG

APRADEG_DEGC_CODE

DEGREE_DATE_1 Degree Date 1 Date the degree was awarded to the constituent. DATE
APRADEG

APRADEG_DATE

DEGREE_DATE_2 Degree Date 2 Date the degree was awarded to the constituent. DATE
APRADEG

APRADEG_DATE

DEGREE_DATE_3 Degree Date 3 Date the degree was awarded to the constituent. DATE
APRADEG

APRADEG_DATE

DEGREE_DESC_1 Degree Description 1 Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

DEGREE_DESC_2 Degree Description 2 Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

DEGREE_DESC_3 Degree Description 3 Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

DEGREE_LEVEL_1 Degree Level 1 Level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc. VARCHAR2(63)
NA

NA

DEGREE_LEVEL_2 Degree Level 2 Level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc. VARCHAR2(63)
NA

NA

DEGREE_LEVEL_3 Degree Level 3 Level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc. VARCHAR2(63)
NA

NA

DEGREE_LEVEL_DESC_1 Degree Level Description 1 Level description. VARCHAR2(255)
NA

NA

DEGREE_LEVEL_DESC_2 Degree Level Description 2 Level description. VARCHAR2(255)
NA

NA

DEGREE_LEVEL_DESC_3 Degree Level Description 3 Level description. VARCHAR2(255)
NA

NA

HONOR1_1 Honor 1 1 Honors the constituent received with the associated degree. VARCHAR2(63)
APRADEG

APRADEG_HONR_CODE

HONOR1_2 Honor 1 2 Honors the constituent received with the associated degree. VARCHAR2(63)
APRADEG

APRADEG_HONR_CODE

HONOR1_3 Honor 1 3 Honors the constituent received with the associated degree. VARCHAR2(63)
APRADEG

APRADEG_HONR_CODE

HONOR1_DESC_1 Honor 1 Description 1 Institutional honor (e.g., magna cum laude) associated with the institutional honor code. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

HONOR1_DESC_2 Honor 1 Description 2 Institutional honor (e.g., magna cum laude) associated with the institutional honor code. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

HONOR1_DESC_3 Honor 1 Description 3 Institutional honor (e.g., magna cum laude) associated with the institutional honor code. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

INSTITUTION_1 Institution 1 Institution at which the constituent earned the degree. VARCHAR2(63)
APRADEG

APRADEG_SBGI_CODE

INSTITUTION_2 Institution 2 Institution at which the constituent earned the degree. VARCHAR2(63)
APRADEG

APRADEG_SBGI_CODE

INSTITUTION_3 Institution 3 Institution at which the constituent earned the degree. VARCHAR2(63)
APRADEG

APRADEG_SBGI_CODE

INSTITUTION_DESC_1 Institution Description 1 Source/background institution name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

INSTITUTION_DESC_2 Institution Description 2 Source/background institution name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

INSTITUTION_DESC_3 Institution Description 3 Source/background institution name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

INSTITUTION_IND Institution Indicator Indicates whether the degree or award was earned at this institution. VARCHAR2(1)
CALCULATION

DECODE(APRADEG_SBGI_CODE,AUBINST_SBGI_CODE,'Y','N')

MAJOR1_1 Major 1 1 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(63)
APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR1_2 Major 1 2 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(63)
APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR1_3 Major 1 3 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(63)
APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR1_DESC_1 Major 1 Description 1 Name of the student's major subject area. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

MAJOR1_DESC_2 Major 1 Description 2 Name of the student's major subject area. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

MAJOR1_DESC_3 Major 1 Description 3 Name of the student's major subject area. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

MAJOR2_1 Major 2 1 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(63)
APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR2_2 Major 2 2 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(63)
APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR2_3 Major 2 3 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(63)
APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR2_DESC_1 Major 2 Description 1 Name of the student's major subject area. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

MAJOR2_DESC_2 Major 2 Description 2 Name of the student's major subject area. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

MAJOR2_DESC_3 Major 2 Description 3 Name of the student's major subject area. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

PERSON_UID Person UID System generated Banner unique ID which gets assigned to all person and non-person records within Banner. NUMBER
APRADEG

APRADEG_PIDM

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

Ver: 9.0

Description	Uses data from the DEGREE reporting view. Displays a subset of information for up to 3 degrees earned by a constituent, starting with the most recent degree. There are currently no associated display rules.
Key & Frequency	One row per person per institution indicator.
Recommended Search Columns	PERSON_UID, INSTITUTION_IND ACTIVITY_DATE

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_YEAR_1	Academic Year 1	Academic year associated with the academic period on this record.	VARCHAR2(63)	APRADEG	APRADEG_ACYR_CODE
ACADEMIC_YEAR_2	Academic Year 2	Academic year associated with the academic period on this record.	VARCHAR2(63)	APRADEG	APRADEG_ACYR_CODE
ACADEMIC_YEAR_3	Academic Year 3	Academic year associated with the academic period on this record.	VARCHAR2(63)	APRADEG	APRADEG_ACYR_CODE
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE	NA	SYSDATE
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
COLLEGE_1	College 1	College, faculty or school to which the academic study for the student is associated.	VARCHAR2(63)	APRADEG	APRADEG_COLL_CODE
COLLEGE_2	College 2	College, faculty or school to which the academic study for the student is associated.	VARCHAR2(63)	APRADEG	APRADEG_COLL_CODE
COLLEGE_3	College 3	College, faculty or school to which the academic study for the student is associated.	VARCHAR2(63)	APRADEG	APRADEG_COLL_CODE
COLLEGE_DESC_1	College Description 1	College, faculty or school name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COLLEGE_DESC_2	College Description 2	College, faculty or school name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COLLEGE_DESC_3	College Description 3	College, faculty or school name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DEGREE_1	Degree 1	Degree or award code associated with the academic study.	VARCHAR2(63)	APRADEG	APRADEG_DEGC_CODE
DEGREE_2	Degree 2	Degree or award code associated with the academic study.	VARCHAR2(63)	APRADEG	APRADEG_DEGC_CODE
DEGREE_3	Degree 3	Degree or award code associated with the academic study.	VARCHAR2(63)	APRADEG	APRADEG_DEGC_CODE
DEGREE_DATE_1	Degree Date 1	Date the degree was awarded to the constituent.	DATE	APRADEG	APRADEG_DATE
DEGREE_DATE_2	Degree Date 2	Date the degree was awarded to the constituent.	DATE	APRADEG	APRADEG_DATE
DEGREE_DATE_3	Degree Date 3	Date the degree was awarded to the constituent.	DATE	APRADEG	APRADEG_DATE
DEGREE_DESC_1	Degree Description 1	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DEGREE_DESC_2	Degree Description 2	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DEGREE_DESC_3	Degree Description 3	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DEGREE_LEVEL_1	Degree Level 1	Level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc.	VARCHAR2(63)	NA	NA
DEGREE_LEVEL_2	Degree Level 2	Level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc.	VARCHAR2(63)	NA	NA
DEGREE_LEVEL_3	Degree Level 3	Level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc.	VARCHAR2(63)	NA	NA
DEGREE_LEVEL_DESC_1	Degree Level Description 1	Level description.	VARCHAR2(255)	NA	NA
DEGREE_LEVEL_DESC_2	Degree Level Description 2	Level description.	VARCHAR2(255)	NA	NA
DEGREE_LEVEL_DESC_3	Degree Level Description 3	Level description.	VARCHAR2(255)	NA	NA
HONOR1_1	Honor 1 1	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE
HONOR1_2	Honor 1 2	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE
HONOR1_3	Honor 1 3	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE
HONOR1_DESC_1	Honor 1 Description 1	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
HONOR1_DESC_2	Honor 1 Description 2	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
HONOR1_DESC_3	Honor 1 Description 3	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_1	Institution 1	Institution at which the constituent earned the degree.	VARCHAR2(63)	APRADEG	APRADEG_SBGI_CODE
INSTITUTION_2	Institution 2	Institution at which the constituent earned the degree.	VARCHAR2(63)	APRADEG	APRADEG_SBGI_CODE
INSTITUTION_3	Institution 3	Institution at which the constituent earned the degree.	VARCHAR2(63)	APRADEG	APRADEG_SBGI_CODE
INSTITUTION_DESC_1	Institution Description 1	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_DESC_2	Institution Description 2	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_DESC_3	Institution Description 3	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_IND	Institution Indicator	Indicates whether the degree or award was earned at this institution.	VARCHAR2(1)	CALCULATION	DECODE(APRADEG_SBGI_CODE,AUBINST_SBGI_CODE,'Y','N')
MAJOR1_1	Major 1 1	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR1_2	Major 1 2	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR1_3	Major 1 3	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR1_DESC_1	Major 1 Description 1	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MAJOR1_DESC_2	Major 1 Description 2	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MAJOR1_DESC_3	Major 1 Description 3	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MAJOR2_1	Major 2 1	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR2_2	Major 2 2	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR2_3	Major 2 3	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR2_DESC_1	Major 2 Description 1	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MAJOR2_DESC_2	Major 2 Description 2	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MAJOR2_DESC_3	Major 2 Description 3	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PERSON_UID	Person UID	System generated Banner unique ID which gets assigned to all person and non-person records within Banner.	NUMBER	APRADEG	APRADEG_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA