Reporting View Target: DEGREE

Go To View:	RETURN TO REPORTING VIEW 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

Target Column Business Definition Database Data Type Source Name Source Column

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

APRADEG_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)
STVACYR

STVACYR_DESC

ADDITIONAL_MAJORS_IND Indicates whether there are additional majors or subject areas for this academic outcome. VARCHAR2(63)
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. VARCHAR2(255)
NA

NA

BULLETIN_YEAR Academic year associated with the requirements completed for this graduation. VARCHAR2(63)
APRADEG

APRADEG_ACYR_CODE_BULLETIN

BULLETIN_YEAR_DESC Academic year description. VARCHAR2(255)
STVACYR

STVACYR_DESC

CAMPUS Campus associated with this degree. VARCHAR2(63)
APRADEG

APRADEG_CAMP_CODE

CAMPUS_DESC Institution campus name. VARCHAR2(255)
STVCAMP

STVCAMP_DESC

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

APRADEG_COLL_CODE

COLLEGE_DESC College, faculty or school name. VARCHAR2(255)
STVCOLL

STVCOLL_DESC

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

APRADEG_DEGC_CODE

DEGREE_COMMENT Free form text comments about this degree. VARCHAR2(2000)
APRADEG

APRADEG_COMMENTS

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

APRADEG_DATE

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

STVDEGC_DESC

DEGREE_NUMBER Internal sequence number. NUMBER
APRADEG

APRADEG_SEQ_NO

DEPARTMENT1 Department responsible to verify the academic outcome requirements are completed. VARCHAR2(63)
APRADEG

APRADEG_DEPT_CODE

DEPARTMENT1_DESC Department name. VARCHAR2(255)
STVDEPT

STVDEPT_DESC

DEPARTMENT2 Department responsible to verify the academic outcome requirements are completed. VARCHAR2(63)
APRADEG

APRADEG_DEPT_CODE_2

DEPARTMENT2_DESC Department name. VARCHAR2(255)
STVDEPT

STVDEPT_DESC

DEPARTMENT_HONOR1 Departmental honors the constituent received with the associated degree. VARCHAR2(63)
APRADEG

APRADEG_HOND_CODE_1

DEPARTMENT_HONOR1_DESC Name of the departmental honor recorded. VARCHAR2(255)
STVHOND

STVHOND_DESC

DEPARTMENT_HONOR2 Departmental honors the constituent received with the associated degree. VARCHAR2(63)
APRADEG

APRADEG_HOND_CODE_2

DEPARTMENT_HONOR2_DESC Name of the departmental honor recorded. VARCHAR2(255)
STVHOND

STVHOND_DESC

DEPARTMENT_HONOR3 Departmental honors the constituent received with the associated degree. VARCHAR2(63)
APRADEG

APRADEG_HOND_CODE_3

DEPARTMENT_HONOR3_DESC Name of the departmental honor recorded. VARCHAR2(255)
STVHOND

STVHOND_DESC

DEPARTMENT_HONOR4 Departmental honors the constituent received with the associated degree. VARCHAR2(63)
APRADEG

APRADEG_HOND_CODE_4

DEPARTMENT_HONOR4_DESC Name of the departmental honor recorded. VARCHAR2(255)
STVHOND

STVHOND_DESC

DEPARTMENT_HONOR5 Departmental honors the constituent received with the associated degree. VARCHAR2(63)
APRADEG

APRADEG_HOND_CODE_5

DEPARTMENT_HONOR5_DESC Name of the departmental honor recorded. VARCHAR2(255)
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. VARCHAR2(63)
APRADEG

APRADEG_MAJR_CODE_CONC_1

FIRST_CONCENTRATION_DESC Description of the first concentration on the major. VARCHAR2(255)
STVMAJR

STVMAJR_DESC

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

APRADEG_MAJR_CODE_MINR_1

FIRST_MINOR_DESC Major or subject area of study description. VARCHAR2(255)
STVMAJR

STVMAJR_DESC

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

APRADEG_HONR_CODE

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

STVHONR_DESC

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

APRADEG_HONR_CODE_2

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

STVHONR_DESC

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

APRADEG_HONR_CODE_3

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

STVHONR_DESC

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

APRADEG_HONR_CODE_4

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

STVHONR_DESC

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

APRADEG_HONR_CODE_5

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

STVHONR_DESC

ID Person's or organization's current identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

APRADEG_SBGI_CODE

INSTITUTION_DESC Source/background institution name. VARCHAR2(255)
STVSBGI

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

APRAMAJ_MAJR_CODE

MAJOR1_DESC Name of the student's major subject area. VARCHAR2(255)
STVMAJR

STVMAJR_DESC

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

APRAMAJ_MAJR_CODE

MAJOR2_DESC Name of the student's major subject area. VARCHAR2(255)
STVMAJR

STVMAJR_DESC

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

APRAMAJ_MAJR_CODE

MAJOR3_DESC Name of the student's major subject area. VARCHAR2(255)
STVMAJR

STVMAJR_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

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

MGKFUNC.F_GET_PERSON_INFO

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

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. VARCHAR2(63)
APRADEG

APRADEG_MAJR_CODE_CONC_2

SECOND_CONCENTRATION_DESC Student's concentration description. VARCHAR2(255)
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. VARCHAR2(63)
APRADEG

APRADEG_MAJR_CODE_CONC_4

SECOND_MAJOR_CONC_1_DESC Student's concentration description. VARCHAR2(255)
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. VARCHAR2(63)
APRADEG

APRADEG_MAJR_CODE_CONC_5

SECOND_MAJOR_CONC_2_DESC Student's concentration description. VARCHAR2(255)
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. VARCHAR2(63)
APRADEG

APRADEG_MAJR_CODE_CONC_6

SECOND_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(255)
STVMAJR

STVMAJR_DESC

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

APRADEG_MAJR_CODE_MINR_2

SECOND_MINOR_DESC Major or subject area of study description. VARCHAR2(255)
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. VARCHAR2(63)
APRADEG

APRADEG_MAJR_CODE_CONC_3

THIRD_CONCENTRATION_DESC Student's concentration description. VARCHAR2(255)
STVMAJR

STVMAJR_DESC

Ver: 8.1

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

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	APRADEG	APRADEG_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ADDITIONAL_MAJORS_IND	Indicates whether there are additional majors or subject areas for this academic outcome.	VARCHAR2(63)	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.	VARCHAR2(255)	NA	NA
BULLETIN_YEAR	Academic year associated with the requirements completed for this graduation.	VARCHAR2(63)	APRADEG	APRADEG_ACYR_CODE_BULLETIN
BULLETIN_YEAR_DESC	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
CAMPUS	Campus associated with this degree.	VARCHAR2(63)	APRADEG	APRADEG_CAMP_CODE
CAMPUS_DESC	Institution campus name.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC
COLLEGE	College, faculty or school to which the academic study for the student is associated.	VARCHAR2(63)	APRADEG	APRADEG_COLL_CODE
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
DEGREE	Degree or award code associated with the academic study.	VARCHAR2(63)	APRADEG	APRADEG_DEGC_CODE
DEGREE_COMMENT	Free form text comments about this degree.	VARCHAR2(2000)	APRADEG	APRADEG_COMMENTS
DEGREE_DATE	Date the degree was awarded to the constituent.	DATE	APRADEG	APRADEG_DATE
DEGREE_DESC	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(255)	STVDEGC	STVDEGC_DESC
DEGREE_NUMBER	Internal sequence number.	NUMBER	APRADEG	APRADEG_SEQ_NO
DEPARTMENT1	Department responsible to verify the academic outcome requirements are completed.	VARCHAR2(63)	APRADEG	APRADEG_DEPT_CODE
DEPARTMENT1_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
DEPARTMENT2	Department responsible to verify the academic outcome requirements are completed.	VARCHAR2(63)	APRADEG	APRADEG_DEPT_CODE_2
DEPARTMENT2_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
DEPARTMENT_HONOR1	Departmental honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HOND_CODE_1
DEPARTMENT_HONOR1_DESC	Name of the departmental honor recorded.	VARCHAR2(255)	STVHOND	STVHOND_DESC
DEPARTMENT_HONOR2	Departmental honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HOND_CODE_2
DEPARTMENT_HONOR2_DESC	Name of the departmental honor recorded.	VARCHAR2(255)	STVHOND	STVHOND_DESC
DEPARTMENT_HONOR3	Departmental honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HOND_CODE_3
DEPARTMENT_HONOR3_DESC	Name of the departmental honor recorded.	VARCHAR2(255)	STVHOND	STVHOND_DESC
DEPARTMENT_HONOR4	Departmental honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HOND_CODE_4
DEPARTMENT_HONOR4_DESC	Name of the departmental honor recorded.	VARCHAR2(255)	STVHOND	STVHOND_DESC
DEPARTMENT_HONOR5	Departmental honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HOND_CODE_5
DEPARTMENT_HONOR5_DESC	Name of the departmental honor recorded.	VARCHAR2(255)	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.	VARCHAR2(63)	APRADEG	APRADEG_MAJR_CODE_CONC_1
FIRST_CONCENTRATION_DESC	Description of the first concentration on the major.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
FIRST_MINOR	Minor for the student within the academic study. This may be blank if no minor was specified.	VARCHAR2(63)	APRADEG	APRADEG_MAJR_CODE_MINR_1
FIRST_MINOR_DESC	Major or subject area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
HONOR1	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE
HONOR1_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	STVHONR	STVHONR_DESC
HONOR2	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE_2
HONOR2_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	STVHONR	STVHONR_DESC
HONOR3	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE_3
HONOR3_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	STVHONR	STVHONR_DESC
HONOR4	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE_4
HONOR4_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	STVHONR	STVHONR_DESC
HONOR5	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE_5
HONOR5_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	STVHONR	STVHONR_DESC
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INSTITUTION	Institution at which the constituent earned the degree.	VARCHAR2(63)	APRADEG	APRADEG_SBGI_CODE
INSTITUTION_DESC	Source/background institution name.	VARCHAR2(255)	STVSBGI	STVSBGI_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	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR1_DESC	Name of the student's major subject area.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
MAJOR2	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR2_DESC	Name of the student's major subject area.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
MAJOR3	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR3_DESC	Name of the student's major subject area.	VARCHAR2(255)	STVMAJR	STVMAJR_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
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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
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.	VARCHAR2(63)	APRADEG	APRADEG_MAJR_CODE_CONC_2
SECOND_CONCENTRATION_DESC	Student's concentration description.	VARCHAR2(255)	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.	VARCHAR2(63)	APRADEG	APRADEG_MAJR_CODE_CONC_4
SECOND_MAJOR_CONC_1_DESC	Student's concentration description.	VARCHAR2(255)	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.	VARCHAR2(63)	APRADEG	APRADEG_MAJR_CODE_CONC_5
SECOND_MAJOR_CONC_2_DESC	Student's concentration description.	VARCHAR2(255)	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.	VARCHAR2(63)	APRADEG	APRADEG_MAJR_CODE_CONC_6
SECOND_MAJOR_CONC_3_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
SECOND_MINOR	Second minor for the student within this academic study. This may be blank if no minor was specified.	VARCHAR2(63)	APRADEG	APRADEG_MAJR_CODE_MINR_2
SECOND_MINOR_DESC	Major or subject area of study description.	VARCHAR2(255)	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.	VARCHAR2(63)	APRADEG	APRADEG_MAJR_CODE_CONC_3
THIRD_CONCENTRATION_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC