Reporting View Target: DEGREE

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

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 Business Data Type Domain Value Source Name Source Column Local Source Local Target

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER
APRADEG

APRADEG_PIDM

NO
NO

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')

NO
NO

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

NA

NO
NO

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

NA

NO
NO

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

NA

NO
NO

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

NA

NO
NO

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

APRADEG_DEGC_CODE

NO
NO

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

NO
NO

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

APRADEG_COLL_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

APRADEG_DATE

NO
NO

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

APRADEG_ACYR_CODE

NO
NO

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

NO
NO

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

NA

NO
NO

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

APRADEG_SBGI_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

APRAMAJ_MAJR_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

APRAMAJ_MAJR_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

APRADEG_HONR_CODE

NO
NO

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

NO
NO

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

APRADEG_DEGC_CODE

NO
NO

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

NO
NO

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

APRADEG_COLL_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

APRADEG_DATE

NO
NO

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

APRADEG_ACYR_CODE

NO
NO

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

NO
NO

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

NA

NO
NO

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

APRADEG_SBGI_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

APRAMAJ_MAJR_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

APRAMAJ_MAJR_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

APRADEG_HONR_CODE

NO
NO

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

NO
NO

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

APRADEG_DEGC_CODE

NO
NO

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

NO
NO

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

APRADEG_COLL_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

APRADEG_DATE

NO
NO

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

APRADEG_ACYR_CODE

NO
NO

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

NO
NO

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

NA

NO
NO

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

APRADEG_SBGI_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

APRAMAJ_MAJR_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

APRAMAJ_MAJR_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

APRADEG_HONR_CODE

NO
NO

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

NO
NO

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

SYSDATE

NO
NO

Ver: 9.2

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	Local Source	Local Target
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	APRADEG	APRADEG_PIDM	NO	NO
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')	NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
DEGREE_1	Degree 1	Degree or award code associated with the academic study.	VARCHAR2(63)	APRADEG	APRADEG_DEGC_CODE	NO	NO
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	NO	NO
COLLEGE_1	College 1	College, faculty or school to which the academic study for the student is associated.	VARCHAR2(63)	APRADEG	APRADEG_COLL_CODE	NO	NO
COLLEGE_DESC_1	College Description 1	College, faculty or school name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DEGREE_DATE_1	Degree Date 1	Date the degree was awarded to the constituent.	DATE	APRADEG	APRADEG_DATE	NO	NO
ACADEMIC_YEAR_1	Academic Year 1	Academic year associated with the academic period on this record.	VARCHAR2(63)	APRADEG	APRADEG_ACYR_CODE	NO	NO
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	NO	NO
DEGREE_LEVEL_DESC_1	Degree Level Description 1	Level description.	VARCHAR2(255)	NA	NA	NO	NO
INSTITUTION_1	Institution 1	Institution at which the constituent earned the degree.	VARCHAR2(63)	APRADEG	APRADEG_SBGI_CODE	NO	NO
INSTITUTION_DESC_1	Institution Description 1	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MAJOR1_1	Major 1 1	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE	NO	NO
MAJOR1_DESC_1	Major 1 Description 1	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MAJOR2_1	Major 2 1	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE	NO	NO
MAJOR2_DESC_1	Major 2 Description 1	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
HONOR1_1	Honor 1 1	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE	NO	NO
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	NO	NO
DEGREE_2	Degree 2	Degree or award code associated with the academic study.	VARCHAR2(63)	APRADEG	APRADEG_DEGC_CODE	NO	NO
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	NO	NO
COLLEGE_2	College 2	College, faculty or school to which the academic study for the student is associated.	VARCHAR2(63)	APRADEG	APRADEG_COLL_CODE	NO	NO
COLLEGE_DESC_2	College Description 2	College, faculty or school name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DEGREE_DATE_2	Degree Date 2	Date the degree was awarded to the constituent.	DATE	APRADEG	APRADEG_DATE	NO	NO
ACADEMIC_YEAR_2	Academic Year 2	Academic year associated with the academic period on this record.	VARCHAR2(63)	APRADEG	APRADEG_ACYR_CODE	NO	NO
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	NO	NO
DEGREE_LEVEL_DESC_2	Degree Level Description 2	Level description.	VARCHAR2(255)	NA	NA	NO	NO
INSTITUTION_2	Institution 2	Institution at which the constituent earned the degree.	VARCHAR2(63)	APRADEG	APRADEG_SBGI_CODE	NO	NO
INSTITUTION_DESC_2	Institution Description 2	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MAJOR1_2	Major 1 2	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE	NO	NO
MAJOR1_DESC_2	Major 1 Description 2	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MAJOR2_2	Major 2 2	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE	NO	NO
MAJOR2_DESC_2	Major 2 Description 2	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
HONOR1_2	Honor 1 2	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE	NO	NO
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	NO	NO
DEGREE_3	Degree 3	Degree or award code associated with the academic study.	VARCHAR2(63)	APRADEG	APRADEG_DEGC_CODE	NO	NO
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	NO	NO
COLLEGE_3	College 3	College, faculty or school to which the academic study for the student is associated.	VARCHAR2(63)	APRADEG	APRADEG_COLL_CODE	NO	NO
COLLEGE_DESC_3	College Description 3	College, faculty or school name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DEGREE_DATE_3	Degree Date 3	Date the degree was awarded to the constituent.	DATE	APRADEG	APRADEG_DATE	NO	NO
ACADEMIC_YEAR_3	Academic Year 3	Academic year associated with the academic period on this record.	VARCHAR2(63)	APRADEG	APRADEG_ACYR_CODE	NO	NO
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	NO	NO
DEGREE_LEVEL_DESC_3	Degree Level Description 3	Level description.	VARCHAR2(255)	NA	NA	NO	NO
INSTITUTION_3	Institution 3	Institution at which the constituent earned the degree.	VARCHAR2(63)	APRADEG	APRADEG_SBGI_CODE	NO	NO
INSTITUTION_DESC_3	Institution Description 3	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MAJOR1_3	Major 1 3	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE	NO	NO
MAJOR1_DESC_3	Major 1 Description 3	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MAJOR2_3	Major 2 3	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE	NO	NO
MAJOR2_DESC_3	Major 2 Description 3	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
HONOR1_3	Honor 1 3	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE	NO	NO
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	NO	NO
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE	NA	SYSDATE	NO	NO