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 Definition Database Data Type Source Name Source Column

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

APRADEG_ACYR_CODE

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

APRADEG_ACYR_CODE

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

APRADEG_ACYR_CODE

ACTIVITY_DATE Date record was inserted or updated. DATE
NA

SYSDATE

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

NA

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, faculty or school to which the academic study for the student is associated. VARCHAR2(63)
APRADEG

APRADEG_COLL_CODE

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, faculty or school name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

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

APRADEG_DEGC_CODE

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

APRADEG_DEGC_CODE

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

APRADEG_DEGC_CODE

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

APRADEG_DATE

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

APRADEG_DATE

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

APRADEG_DATE

DEGREE_DESC_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 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 code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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 Level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc. VARCHAR2(63)
NA

NA

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 Level description. VARCHAR2(255)
NA

NA

DEGREE_LEVEL_DESC_2 Level description. VARCHAR2(255)
NA

NA

DEGREE_LEVEL_DESC_3 Level description. VARCHAR2(255)
NA

NA

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

APRADEG_HONR_CODE

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

APRADEG_HONR_CODE

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

APRADEG_HONR_CODE

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

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

APRADEG_SBGI_CODE

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

APRADEG_SBGI_CODE

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

APRADEG_SBGI_CODE

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

INSTITUTION_IND 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 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(63)
APRAMAJ

APRAMAJ_MAJR_CODE

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

APRAMAJ_MAJR_CODE

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

APRAMAJ_MAJR_CODE

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

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

APRAMAJ_MAJR_CODE

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

APRAMAJ_MAJR_CODE

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

APRAMAJ_MAJR_CODE

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

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

NA

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

NA

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

APRADEG_PIDM

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

NA

Ver: 9.1

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 Definition	Database Data Type	Source Name	Source Column
ACADEMIC_YEAR_1	Academic year associated with the academic period on this record.	VARCHAR2(63)	APRADEG	APRADEG_ACYR_CODE
ACADEMIC_YEAR_2	Academic year associated with the academic period on this record.	VARCHAR2(63)	APRADEG	APRADEG_ACYR_CODE
ACADEMIC_YEAR_3	Academic year associated with the academic period on this record.	VARCHAR2(63)	APRADEG	APRADEG_ACYR_CODE
ACTIVITY_DATE	Date record was inserted or updated.	DATE	NA	SYSDATE
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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, faculty or school to which the academic study for the student is associated.	VARCHAR2(63)	APRADEG	APRADEG_COLL_CODE
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, faculty or school name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COLLEGE_DESC_2	College, faculty or school name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COLLEGE_DESC_3	College, faculty or school name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DEGREE_1	Degree or award code associated with the academic study.	VARCHAR2(63)	APRADEG	APRADEG_DEGC_CODE
DEGREE_2	Degree or award code associated with the academic study.	VARCHAR2(63)	APRADEG	APRADEG_DEGC_CODE
DEGREE_3	Degree or award code associated with the academic study.	VARCHAR2(63)	APRADEG	APRADEG_DEGC_CODE
DEGREE_DATE_1	Date the degree was awarded to the constituent.	DATE	APRADEG	APRADEG_DATE
DEGREE_DATE_2	Date the degree was awarded to the constituent.	DATE	APRADEG	APRADEG_DATE
DEGREE_DATE_3	Date the degree was awarded to the constituent.	DATE	APRADEG	APRADEG_DATE
DEGREE_DESC_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 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 code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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	Level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc.	VARCHAR2(63)	NA	NA
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	Level description.	VARCHAR2(255)	NA	NA
DEGREE_LEVEL_DESC_2	Level description.	VARCHAR2(255)	NA	NA
DEGREE_LEVEL_DESC_3	Level description.	VARCHAR2(255)	NA	NA
HONOR1_1	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE
HONOR1_2	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE
HONOR1_3	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE
HONOR1_DESC_1	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
HONOR1_DESC_2	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
HONOR1_DESC_3	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_1	Institution at which the constituent earned the degree.	VARCHAR2(63)	APRADEG	APRADEG_SBGI_CODE
INSTITUTION_2	Institution at which the constituent earned the degree.	VARCHAR2(63)	APRADEG	APRADEG_SBGI_CODE
INSTITUTION_3	Institution at which the constituent earned the degree.	VARCHAR2(63)	APRADEG	APRADEG_SBGI_CODE
INSTITUTION_DESC_1	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_DESC_2	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_DESC_3	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_IND	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	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR1_2	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR1_3	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR1_DESC_1	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MAJOR1_DESC_2	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MAJOR1_DESC_3	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MAJOR2_1	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR2_2	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR2_3	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR2_DESC_1	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MAJOR2_DESC_2	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MAJOR2_DESC_3	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	APRADEG	APRADEG_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA