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

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 Local Source Local Target

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

APRADEG_ACYR_CODE

NO
NO

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)
STVACYR

STVACYR_DESC

NO
NO

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

NO
NO

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

NA

NO
NO

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

APRADEG_ACYR_CODE_BULLETIN

NO
NO

BULLETIN_YEAR_DESC Academic year description. VARCHAR2(255)
STVACYR

STVACYR_DESC

NO
NO

CAMPUS Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc. VARCHAR2(63)
APRADEG

APRADEG_CAMP_CODE

NO
NO

CAMPUS_DESC Institution campus name. VARCHAR2(255)
STVCAMP

STVCAMP_DESC

NO
NO

COLLEGE First level of the institution organization structure that owns the student or the academic instruction for a student course. VARCHAR2(63)
APRADEG

APRADEG_COLL_CODE

NO
NO

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

STVCOLL_DESC

NO
NO

DEGREE Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme. VARCHAR2(63)
APRADEG

APRADEG_DEGC_CODE

NO
NO

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

APRADEG_COMMENTS

NO
NO

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

APRADEG_DATE

NO
NO

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

STVDEGC_DESC

NO
NO

DEGREE_NUMBER Internal sequence number. NUMBER
APRADEG

APRADEG_SEQ_NO

NO
NO

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

APRADEG_DEPT_CODE

NO
NO

DEPARTMENT1_DESC Department name. VARCHAR2(255)
STVDEPT

STVDEPT_DESC

NO
NO

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

APRADEG_DEPT_CODE_2

NO
NO

DEPARTMENT2_DESC Department name. VARCHAR2(255)
STVDEPT

STVDEPT_DESC

NO
NO

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

APRADEG_HOND_CODE_1

NO
NO

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

STVHOND_DESC

NO
NO

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

APRADEG_HOND_CODE_2

NO
NO

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

STVHOND_DESC

NO
NO

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

APRADEG_HOND_CODE_3

NO
NO

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

STVHOND_DESC

NO
NO

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

APRADEG_HOND_CODE_4

NO
NO

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

STVHOND_DESC

NO
NO

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

APRADEG_HOND_CODE_5

NO
NO

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

STVHOND_DESC

NO
NO

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

NO
NO

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

STVMAJR_DESC

NO
NO

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

NO
NO

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

STVMAJR_DESC

NO
NO

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

APRADEG_HONR_CODE

NO
NO

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

STVHONR_DESC

NO
NO

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

APRADEG_HONR_CODE_2

NO
NO

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

STVHONR_DESC

NO
NO

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

APRADEG_HONR_CODE_3

NO
NO

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

STVHONR_DESC

NO
NO

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

APRADEG_HONR_CODE_4

NO
NO

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

STVHONR_DESC

NO
NO

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

APRADEG_HONR_CODE_5

NO
NO

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

STVHONR_DESC

NO
NO

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

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

APRADEG_SBGI_CODE

NO
NO

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

STVSBGI_DESC

NO
NO

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

NO
NO

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

APRAMAJ_MAJR_CODE

NO
NO

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

STVMAJR_DESC

NO
NO

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

APRAMAJ_MAJR_CODE

NO
NO

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

STVMAJR_DESC

NO
NO

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

APRAMAJ_MAJR_CODE

NO
NO

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

STVMAJR_DESC

NO
NO

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 Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NO
NO

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

MGKFUNC.F_GET_PERSON_INFO

NO
NO

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

APRADEG_PIDM

NO
NO

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

NA

NO
NO

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

NO
NO

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

STVMAJR_DESC

NO
NO

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

NO
NO

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

STVMAJR_DESC

NO
NO

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

NO
NO

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

STVMAJR_DESC

NO
NO

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

NO
NO

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

STVMAJR_DESC

NO
NO

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

NO
NO

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

STVMAJR_DESC

NO
NO

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

NO
NO

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

STVMAJR_DESC

NO
NO

Ver: 9.2

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	Local Source	Local Target
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	APRADEG	APRADEG_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC	NO	NO
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	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
BULLETIN_YEAR	Academic year associated with the requirements completed for this graduation.	VARCHAR2(63)	APRADEG	APRADEG_ACYR_CODE_BULLETIN	NO	NO
BULLETIN_YEAR_DESC	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC	NO	NO
CAMPUS	Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.	VARCHAR2(63)	APRADEG	APRADEG_CAMP_CODE	NO	NO
CAMPUS_DESC	Institution campus name.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC	NO	NO
COLLEGE	First level of the institution organization structure that owns the student or the academic instruction for a student course.	VARCHAR2(63)	APRADEG	APRADEG_COLL_CODE	NO	NO
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC	NO	NO
DEGREE	Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.	VARCHAR2(63)	APRADEG	APRADEG_DEGC_CODE	NO	NO
DEGREE_COMMENT	Free form text comments about this degree.	VARCHAR2(2000)	APRADEG	APRADEG_COMMENTS	NO	NO
DEGREE_DATE	Date the degree was awarded to the constituent.	DATE	APRADEG	APRADEG_DATE	NO	NO
DEGREE_DESC	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(255)	STVDEGC	STVDEGC_DESC	NO	NO
DEGREE_NUMBER	Internal sequence number.	NUMBER	APRADEG	APRADEG_SEQ_NO	NO	NO
DEPARTMENT1	Department responsible to verify the academic outcome requirements are completed.	VARCHAR2(63)	APRADEG	APRADEG_DEPT_CODE	NO	NO
DEPARTMENT1_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC	NO	NO
DEPARTMENT2	Department responsible to verify the academic outcome requirements are completed.	VARCHAR2(63)	APRADEG	APRADEG_DEPT_CODE_2	NO	NO
DEPARTMENT2_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC	NO	NO
DEPARTMENT_HONOR1	Departmental honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HOND_CODE_1	NO	NO
DEPARTMENT_HONOR1_DESC	Name of the departmental honor recorded.	VARCHAR2(255)	STVHOND	STVHOND_DESC	NO	NO
DEPARTMENT_HONOR2	Departmental honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HOND_CODE_2	NO	NO
DEPARTMENT_HONOR2_DESC	Name of the departmental honor recorded.	VARCHAR2(255)	STVHOND	STVHOND_DESC	NO	NO
DEPARTMENT_HONOR3	Departmental honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HOND_CODE_3	NO	NO
DEPARTMENT_HONOR3_DESC	Name of the departmental honor recorded.	VARCHAR2(255)	STVHOND	STVHOND_DESC	NO	NO
DEPARTMENT_HONOR4	Departmental honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HOND_CODE_4	NO	NO
DEPARTMENT_HONOR4_DESC	Name of the departmental honor recorded.	VARCHAR2(255)	STVHOND	STVHOND_DESC	NO	NO
DEPARTMENT_HONOR5	Departmental honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HOND_CODE_5	NO	NO
DEPARTMENT_HONOR5_DESC	Name of the departmental honor recorded.	VARCHAR2(255)	STVHOND	STVHOND_DESC	NO	NO
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	NO	NO
FIRST_CONCENTRATION_DESC	Description of the first concentration on the major.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
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	NO	NO
FIRST_MINOR_DESC	Major or subject area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
HONOR1	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE	NO	NO
HONOR1_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	STVHONR	STVHONR_DESC	NO	NO
HONOR2	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE_2	NO	NO
HONOR2_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	STVHONR	STVHONR_DESC	NO	NO
HONOR3	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE_3	NO	NO
HONOR3_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	STVHONR	STVHONR_DESC	NO	NO
HONOR4	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE_4	NO	NO
HONOR4_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	STVHONR	STVHONR_DESC	NO	NO
HONOR5	Honors the constituent received with the associated degree.	VARCHAR2(63)	APRADEG	APRADEG_HONR_CODE_5	NO	NO
HONOR5_DESC	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.	VARCHAR2(255)	STVHONR	STVHONR_DESC	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
INSTITUTION	Institution at which the constituent earned the degree.	VARCHAR2(63)	APRADEG	APRADEG_SBGI_CODE	NO	NO
INSTITUTION_DESC	Source/background institution name.	VARCHAR2(255)	STVSBGI	STVSBGI_DESC	NO	NO
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')	NO	NO
MAJOR1	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE	NO	NO
MAJOR1_DESC	Name of the student's major subject area.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
MAJOR2	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE	NO	NO
MAJOR2_DESC	Name of the student's major subject area.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
MAJOR3	Concentration of study or emphasis attached to the major for this academic study.	VARCHAR2(63)	APRAMAJ	APRAMAJ_MAJR_CODE	NO	NO
MAJOR3_DESC	Name of the student's major subject area.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
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	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	APRADEG	APRADEG_PIDM	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
SECOND_CONCENTRATION_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
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	NO	NO
SECOND_MAJOR_CONC_1_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
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	NO	NO
SECOND_MAJOR_CONC_2_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
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	NO	NO
SECOND_MAJOR_CONC_3_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
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	NO	NO
SECOND_MINOR_DESC	Major or subject area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
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	NO	NO
THIRD_CONCENTRATION_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO