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.0