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

Description Contains detail information for each degree earned by a constituent from this or any other institution.
Key & Frequency One row per person per degree number.
Recommended Search Columns PERSON_UID
MAJOR1, DEGREE
COLLEGE, DEPARTMENT1

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name

ACADEMIC_YEAR Academic year associated with the academic period on this record.
APRADEG

APRADEG_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description.
STVACYR

STVACYR_DESC

ADDITIONAL_MAJORS_IND Indicates whether there are additional majors or subject areas for this academic outcome.
FUNCTION

AOKODSF.F_CHECK_FOR_MORE_MAJORS

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
NA

NA

BULLETIN_YEAR Academic year associated with the requirements completed for this graduation.
APRADEG

APRADEG_ACYR_CODE_BULLETIN

BULLETIN_YEAR_DESC Academic year description.
STVACYR

STVACYR_DESC

CAMPUS Campus associated with this degree.
APRADEG

APRADEG_CAMP_CODE

CAMPUS_DESC Institution campus name.
STVCAMP

STVCAMP_DESC

COLLEGE College, faculty or school to which the academic study for the student is associated.
APRADEG

APRADEG_COLL_CODE

COLLEGE_DESC College, faculty or school name.
STVCOLL

STVCOLL_DESC

DEGREE Degree or award code associated with the academic study.
APRADEG

APRADEG_DEGC_CODE

DEGREE_COMMENT Free form text comments about this degree.
APRADEG

APRADEG_COMMENTS

DEGREE_DATE Date the degree was awarded to the constituent.
APRADEG

APRADEG_DATE

DEGREE_DESC Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
STVDEGC

STVDEGC_DESC

DEGREE_NUMBER Internal sequence number.
APRADEG

APRADEG_SEQ_NO

DEPARTMENT1 Department responsible to verify the academic outcome requirements are completed.
APRADEG

APRADEG_DEPT_CODE

DEPARTMENT1_DESC Department name.
STVDEPT

STVDEPT_DESC

DEPARTMENT2 Department responsible to verify the academic outcome requirements are completed.
APRADEG

APRADEG_DEPT_CODE_2

DEPARTMENT2_DESC Department name.
STVDEPT

STVDEPT_DESC

DEPARTMENT_HONOR1 Departmental honors the constituent received with the associated degree.
APRADEG

APRADEG_HOND_CODE_1

DEPARTMENT_HONOR1_DESC Name of the departmental honor recorded.
STVHOND

STVHOND_DESC

DEPARTMENT_HONOR2 Departmental honors the constituent received with the associated degree.
APRADEG

APRADEG_HOND_CODE_2

DEPARTMENT_HONOR2_DESC Name of the departmental honor recorded.
STVHOND

STVHOND_DESC

DEPARTMENT_HONOR3 Departmental honors the constituent received with the associated degree.
APRADEG

APRADEG_HOND_CODE_3

DEPARTMENT_HONOR3_DESC Name of the departmental honor recorded.
STVHOND

STVHOND_DESC

DEPARTMENT_HONOR4 Departmental honors the constituent received with the associated degree.
APRADEG

APRADEG_HOND_CODE_4

DEPARTMENT_HONOR4_DESC Name of the departmental honor recorded.
STVHOND

STVHOND_DESC

DEPARTMENT_HONOR5 Departmental honors the constituent received with the associated degree.
APRADEG

APRADEG_HOND_CODE_5

DEPARTMENT_HONOR5_DESC Name of the departmental honor recorded.
STVHOND

STVHOND_DESC

FIRST_CONCENTRATION First concentration or focus of study within the student's major. This may be blank when concentrations are not being used, or when the major does not have a concentration.
APRADEG

APRADEG_MAJR_CODE_CONC_1

FIRST_CONCENTRATION_DESC Description of the first concentration on the major.
STVMAJR

STVMAJR_DESC

FIRST_MINOR Minor for the student within the academic study. This may be blank if no minor was specified.
APRADEG

APRADEG_MAJR_CODE_MINR_1

FIRST_MINOR_DESC Major or subject area of study description.
STVMAJR

STVMAJR_DESC

HONOR1 Honors the constituent received with the associated degree.
APRADEG

APRADEG_HONR_CODE

HONOR1_DESC Institutional honor (e.g., magna cum laude) associated with the institutional honor code.
STVHONR

STVHONR_DESC

HONOR2 Honors the constituent received with the associated degree.
APRADEG

APRADEG_HONR_CODE_2

HONOR2_DESC Institutional honor (e.g., magna cum laude) associated with the institutional honor code.
STVHONR

STVHONR_DESC

HONOR3 Honors the constituent received with the associated degree.
APRADEG

APRADEG_HONR_CODE_3

HONOR3_DESC Institutional honor (e.g., magna cum laude) associated with the institutional honor code.
STVHONR

STVHONR_DESC

HONOR4 Honors the constituent received with the associated degree.
APRADEG

APRADEG_HONR_CODE_4

HONOR4_DESC Institutional honor (e.g., magna cum laude) associated with the institutional honor code.
STVHONR

STVHONR_DESC

HONOR5 Honors the constituent received with the associated degree.
APRADEG

APRADEG_HONR_CODE_5

HONOR5_DESC Institutional honor (e.g., magna cum laude) associated with the institutional honor code.
STVHONR

STVHONR_DESC

ID Person's or organization's current identification number.
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INSTITUTION Institution at which the constituent earned the degree.
APRADEG

APRADEG_SBGI_CODE

INSTITUTION_DESC Source/background institution name.
STVSBGI

STVSBGI_DESC

INSTITUTION_IND Indicates whether the degree or award was earned at this institution.
CALCULATION

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

MAJOR1 Concentration of study or emphasis attached to the major for this academic study.
APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR1_DESC Name of the student's major subject area.
STVMAJR

STVMAJR_DESC

MAJOR2 Concentration of study or emphasis attached to the major for this academic study.
APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR2_DESC Name of the student's major subject area.
STVMAJR

STVMAJR_DESC

MAJOR3 Concentration of study or emphasis attached to the major for this academic study.
APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR3_DESC Name of the student's major subject area.
STVMAJR

STVMAJR_DESC

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

NA

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

NA

NAME Name of the person (last name, first name, middle initial) or organization.
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

APRADEG_PIDM

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

NA

SECOND_CONCENTRATION Second concentration or focus of study within the student's major. This may be blank when concentrations are not being used, or if the major does not have a concentration.
APRADEG

APRADEG_MAJR_CODE_CONC_2

SECOND_CONCENTRATION_DESC Student's concentration description.
STVMAJR

STVMAJR_DESC

SECOND_MAJOR_CONC_1 First concentration or focus of study within the student's major. This may be blank when concentrations are not being used, or if the major does not have a concentration.
APRADEG

APRADEG_MAJR_CODE_CONC_4

SECOND_MAJOR_CONC_1_DESC Student's concentration description.
STVMAJR

STVMAJR_DESC

SECOND_MAJOR_CONC_2 Second concentration or focus of study within this student's major. This may be blank if concentrations are not being used, or if the major does not have a concentration.
APRADEG

APRADEG_MAJR_CODE_CONC_5

SECOND_MAJOR_CONC_2_DESC Student's concentration description.
STVMAJR

STVMAJR_DESC

SECOND_MAJOR_CONC_3 Third concentration or focus of study within the student's major. This may be blank if concentrations are not being used, or if the major does not have a concentration.
APRADEG

APRADEG_MAJR_CODE_CONC_6

SECOND_MAJOR_CONC_3_DESC Student's concentration description.
STVMAJR

STVMAJR_DESC

SECOND_MINOR Second minor for the student within this academic study. This may be blank if no minor was specified.
APRADEG

APRADEG_MAJR_CODE_MINR_2

SECOND_MINOR_DESC Major or subject area of study description.
STVMAJR

STVMAJR_DESC

THIRD_CONCENTRATION Third concentration or focus of study within the student's major. This may be blank if concentrations are not being used, or if the major does not have a concentration.
APRADEG

APRADEG_MAJR_CODE_CONC_3

THIRD_CONCENTRATION_DESC Student's concentration description.
STVMAJR

STVMAJR_DESC

Ver: 8.3

Description	Contains detail information for each degree earned by a constituent from this or any other institution.
Key & Frequency	One row per person per degree number.
Recommended Search Columns	PERSON_UID MAJOR1, DEGREE COLLEGE, DEPARTMENT1

ODS Column	ODS Business Definition	Banner Source Name	Banner Source Column
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	APRADEG	APRADEG_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	STVACYR	STVACYR_DESC
ADDITIONAL_MAJORS_IND	Indicates whether there are additional majors or subject areas for this academic outcome.	FUNCTION	AOKODSF.F_CHECK_FOR_MORE_MAJORS
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	NA	NA
BULLETIN_YEAR	Academic year associated with the requirements completed for this graduation.	APRADEG	APRADEG_ACYR_CODE_BULLETIN
BULLETIN_YEAR_DESC	Academic year description.	STVACYR	STVACYR_DESC
CAMPUS	Campus associated with this degree.	APRADEG	APRADEG_CAMP_CODE
CAMPUS_DESC	Institution campus name.	STVCAMP	STVCAMP_DESC
COLLEGE	College, faculty or school to which the academic study for the student is associated.	APRADEG	APRADEG_COLL_CODE
COLLEGE_DESC	College, faculty or school name.	STVCOLL	STVCOLL_DESC
DEGREE	Degree or award code associated with the academic study.	APRADEG	APRADEG_DEGC_CODE
DEGREE_COMMENT	Free form text comments about this degree.	APRADEG	APRADEG_COMMENTS
DEGREE_DATE	Date the degree was awarded to the constituent.	APRADEG	APRADEG_DATE
DEGREE_DESC	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	STVDEGC	STVDEGC_DESC
DEGREE_NUMBER	Internal sequence number.	APRADEG	APRADEG_SEQ_NO
DEPARTMENT1	Department responsible to verify the academic outcome requirements are completed.	APRADEG	APRADEG_DEPT_CODE
DEPARTMENT1_DESC	Department name.	STVDEPT	STVDEPT_DESC
DEPARTMENT2	Department responsible to verify the academic outcome requirements are completed.	APRADEG	APRADEG_DEPT_CODE_2
DEPARTMENT2_DESC	Department name.	STVDEPT	STVDEPT_DESC
DEPARTMENT_HONOR1	Departmental honors the constituent received with the associated degree.	APRADEG	APRADEG_HOND_CODE_1
DEPARTMENT_HONOR1_DESC	Name of the departmental honor recorded.	STVHOND	STVHOND_DESC
DEPARTMENT_HONOR2	Departmental honors the constituent received with the associated degree.	APRADEG	APRADEG_HOND_CODE_2
DEPARTMENT_HONOR2_DESC	Name of the departmental honor recorded.	STVHOND	STVHOND_DESC
DEPARTMENT_HONOR3	Departmental honors the constituent received with the associated degree.	APRADEG	APRADEG_HOND_CODE_3
DEPARTMENT_HONOR3_DESC	Name of the departmental honor recorded.	STVHOND	STVHOND_DESC
DEPARTMENT_HONOR4	Departmental honors the constituent received with the associated degree.	APRADEG	APRADEG_HOND_CODE_4
DEPARTMENT_HONOR4_DESC	Name of the departmental honor recorded.	STVHOND	STVHOND_DESC
DEPARTMENT_HONOR5	Departmental honors the constituent received with the associated degree.	APRADEG	APRADEG_HOND_CODE_5
DEPARTMENT_HONOR5_DESC	Name of the departmental honor recorded.	STVHOND	STVHOND_DESC
FIRST_CONCENTRATION	First concentration or focus of study within the student's major. This may be blank when concentrations are not being used, or when the major does not have a concentration.	APRADEG	APRADEG_MAJR_CODE_CONC_1
FIRST_CONCENTRATION_DESC	Description of the first concentration on the major.	STVMAJR	STVMAJR_DESC
FIRST_MINOR	Minor for the student within the academic study. This may be blank if no minor was specified.	APRADEG	APRADEG_MAJR_CODE_MINR_1
FIRST_MINOR_DESC	Major or subject area of study description.	STVMAJR	STVMAJR_DESC
HONOR1	Honors the constituent received with the associated degree.	APRADEG	APRADEG_HONR_CODE
HONOR1_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	STVHONR	STVHONR_DESC
HONOR2	Honors the constituent received with the associated degree.	APRADEG	APRADEG_HONR_CODE_2
HONOR2_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	STVHONR	STVHONR_DESC
HONOR3	Honors the constituent received with the associated degree.	APRADEG	APRADEG_HONR_CODE_3
HONOR3_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	STVHONR	STVHONR_DESC
HONOR4	Honors the constituent received with the associated degree.	APRADEG	APRADEG_HONR_CODE_4
HONOR4_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	STVHONR	STVHONR_DESC
HONOR5	Honors the constituent received with the associated degree.	APRADEG	APRADEG_HONR_CODE_5
HONOR5_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	STVHONR	STVHONR_DESC
ID	Person's or organization's current identification number.	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INSTITUTION	Institution at which the constituent earned the degree.	APRADEG	APRADEG_SBGI_CODE
INSTITUTION_DESC	Source/background institution name.	STVSBGI	STVSBGI_DESC
INSTITUTION_IND	Indicates whether the degree or award was earned at this institution.	CALCULATION	DECODE(APRADEG_SBGI_CODE,AUBINST_SBGI_CODE,'Y','N')
MAJOR1	Concentration of study or emphasis attached to the major for this academic study.	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR1_DESC	Name of the student's major subject area.	STVMAJR	STVMAJR_DESC
MAJOR2	Concentration of study or emphasis attached to the major for this academic study.	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR2_DESC	Name of the student's major subject area.	STVMAJR	STVMAJR_DESC
MAJOR3	Concentration of study or emphasis attached to the major for this academic study.	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR3_DESC	Name of the student's major subject area.	STVMAJR	STVMAJR_DESC
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	APRADEG	APRADEG_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	NA	NA
SECOND_CONCENTRATION	Second concentration or focus of study within the student's major. This may be blank when concentrations are not being used, or if the major does not have a concentration.	APRADEG	APRADEG_MAJR_CODE_CONC_2
SECOND_CONCENTRATION_DESC	Student's concentration description.	STVMAJR	STVMAJR_DESC
SECOND_MAJOR_CONC_1	First concentration or focus of study within the student's major. This may be blank when concentrations are not being used, or if the major does not have a concentration.	APRADEG	APRADEG_MAJR_CODE_CONC_4
SECOND_MAJOR_CONC_1_DESC	Student's concentration description.	STVMAJR	STVMAJR_DESC
SECOND_MAJOR_CONC_2	Second concentration or focus of study within this student's major. This may be blank if concentrations are not being used, or if the major does not have a concentration.	APRADEG	APRADEG_MAJR_CODE_CONC_5
SECOND_MAJOR_CONC_2_DESC	Student's concentration description.	STVMAJR	STVMAJR_DESC
SECOND_MAJOR_CONC_3	Third concentration or focus of study within the student's major. This may be blank if concentrations are not being used, or if the major does not have a concentration.	APRADEG	APRADEG_MAJR_CODE_CONC_6
SECOND_MAJOR_CONC_3_DESC	Student's concentration description.	STVMAJR	STVMAJR_DESC
SECOND_MINOR	Second minor for the student within this academic study. This may be blank if no minor was specified.	APRADEG	APRADEG_MAJR_CODE_MINR_2
SECOND_MINOR_DESC	Major or subject area of study description.	STVMAJR	STVMAJR_DESC
THIRD_CONCENTRATION	Third concentration or focus of study within the student's major. This may be blank if concentrations are not being used, or if the major does not have a concentration.	APRADEG	APRADEG_MAJR_CODE_CONC_3
THIRD_CONCENTRATION_DESC	Student's concentration description.	STVMAJR	STVMAJR_DESC