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 Local Source Local Target
ACADEMIC_YEAR_1 Academic year associated with the academic period on this record. VARCHAR2(63)

APRADEG

APRADEG_ACYR_CODE

NO

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

APRADEG

APRADEG_ACYR_CODE

NO

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

APRADEG

APRADEG_ACYR_CODE

NO

NO
ACTIVITY_DATE Date record was inserted or updated. DATE

NA

SYSDATE

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

APRADEG

APRADEG_COLL_CODE

NO

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

APRADEG

APRADEG_COLL_CODE

NO

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

APRADEG

APRADEG_COLL_CODE

NO

NO
COLLEGE_DESC_1 College, faculty or school name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

APRADEG

APRADEG_DEGC_CODE

NO

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

APRADEG

APRADEG_DEGC_CODE

NO

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

APRADEG

APRADEG_DEGC_CODE

NO

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

APRADEG

APRADEG_DATE

NO

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

APRADEG

APRADEG_DATE

NO

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

APRADEG

APRADEG_DATE

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
DEGREE_LEVEL_1 Level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc. VARCHAR2(63)

NA

NA

NO

NO
DEGREE_LEVEL_2 Level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc. VARCHAR2(63)

NA

NA

NO

NO
DEGREE_LEVEL_3 Level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc. VARCHAR2(63)

NA

NA

NO

NO
DEGREE_LEVEL_DESC_1 Level description. VARCHAR2(255)

NA

NA

NO

NO
DEGREE_LEVEL_DESC_2 Level description. VARCHAR2(255)

NA

NA

NO

NO
DEGREE_LEVEL_DESC_3 Level description. VARCHAR2(255)

NA

NA

NO

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

APRADEG

APRADEG_HONR_CODE

NO

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

APRADEG

APRADEG_HONR_CODE

NO

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

APRADEG

APRADEG_HONR_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

APRADEG

APRADEG_SBGI_CODE

NO

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

APRADEG

APRADEG_SBGI_CODE

NO

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

APRADEG

APRADEG_SBGI_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

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

APRAMAJ

APRAMAJ_MAJR_CODE

NO

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

APRAMAJ

APRAMAJ_MAJR_CODE

NO

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

APRAMAJ

APRAMAJ_MAJR_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

APRAMAJ

APRAMAJ_MAJR_CODE

NO

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

APRAMAJ

APRAMAJ_MAJR_CODE

NO

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

APRAMAJ

APRAMAJ_MAJR_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_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
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


Ver: 9.2