RETURN TO REPORTING VIEW REPORTS LIST
Advancement Reporting View Reports

SGHE 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.
Recommended Search Columns PERSON_UID, INSTITUTION_IND
ACTIVITY_DATE

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_YEAR_1 Academic year associated with the academic period on this record. VARCHAR2(63)

APRADEG

APRADEG_ACYR_CODE

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

APRADEG

APRADEG_ACYR_CODE

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

APRADEG

APRADEG_ACYR_CODE

ACTIVITY_DATE Date record was inserted or updated. DATE

NA

SYSDATE

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

NA

NA

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

APRADEG

APRADEG_COLL_CODE

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

APRADEG

APRADEG_COLL_CODE

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

APRADEG

APRADEG_COLL_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

APRADEG

APRADEG_DEGC_CODE

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

APRADEG

APRADEG_DEGC_CODE

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

APRADEG

APRADEG_DEGC_CODE

DEGREE_DATE_1 Date the degree was awarded to the constituent. DATE

APRADEG

APRADEG_DATE

DEGREE_DATE_2 Date the degree was awarded to the constituent. DATE

APRADEG

APRADEG_DATE

DEGREE_DATE_3 Date the degree was awarded to the constituent. DATE

APRADEG

APRADEG_DATE

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

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

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

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

NA

NA

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

NA

NA

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

NA

NA

DEGREE_LEVEL_DESC_1 Level description. VARCHAR2(255)

NA

NA

DEGREE_LEVEL_DESC_2 Level description. VARCHAR2(255)

NA

NA

DEGREE_LEVEL_DESC_3 Level description. VARCHAR2(255)

NA

NA

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

APRADEG

APRADEG_HONR_CODE

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

APRADEG

APRADEG_HONR_CODE

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

APRADEG

APRADEG_HONR_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

APRADEG

APRADEG_SBGI_CODE

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

APRADEG

APRADEG_SBGI_CODE

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

APRADEG

APRADEG_SBGI_CODE

INSTITUTION_DESC_1 Source/background institution name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

INSTITUTION_DESC_2 Source/background institution name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

INSTITUTION_DESC_3 Source/background institution name. VARCHAR2(255)

FUNCTION

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

APRAMAJ

APRAMAJ_MAJR_CODE

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

APRAMAJ

APRAMAJ_MAJR_CODE

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

APRAMAJ

APRAMAJ_MAJR_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

APRAMAJ

APRAMAJ_MAJR_CODE

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

APRAMAJ

APRAMAJ_MAJR_CODE

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

APRAMAJ

APRAMAJ_MAJR_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

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

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



Ver: 3.1