Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: ADVANCEMENT_DEGREE_SLOT_KSU

Description Uses data from the DEGREE reporting view. Displays a subset of information for up to 5 degrees earned by a constituent, starting with the oldest academic year, degree date and degree level based on the defined display rule(s) with an internal group of KSUDEGREE and a delivered or institution defined internal code (KSU institution degrees only) .
Key & Frequency One row per entity
Recommended Search Columns ENTITY_UID

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

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

APRADEG

APRADEG_ACYR_CODE

ACADEMIC_YEAR_5 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

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

APRADEG

APRADEG_COLL_CODE

COLLEGE_5 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

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

CURR_COLLEGE_DESC_1 College is now named VARCHAR2(255)

FUNCTION

FUNCTIONS_ADVANCEMENT_KSU.F_ADV_CURRENT_COLLEGE

CURR_COLLEGE_DESC_2 College is now named VARCHAR2(255)

FUNCTION

FUNCTIONS_ADVANCEMENT_KSU.F_ADV_CURRENT_COLLEGE

CURR_COLLEGE_DESC_3 College is now named VARCHAR2(255)

FUNCTION

FUNCTIONS_ADVANCEMENT_KSU.F_ADV_CURRENT_COLLEGE

CURR_COLLEGE_DESC_4 College is now named VARCHAR2(255)

FUNCTION

FUNCTIONS_ADVANCEMENT_KSU.F_ADV_CURRENT_COLLEGE

CURR_COLLEGE_DESC_5 College is now named VARCHAR2(255)

FUNCTION

FUNCTIONS_ADVANCEMENT_KSU.F_ADV_CURRENT_COLLEGE

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_4 Degree or award code associated with the academic study. VARCHAR2(63)

APRADEG

APRADEG_DEGC_CODE

DEGREE_5 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_DATE_4 Date the degree was awarded to the constituent. DATE

APRADEG

APRADEG_DATE

DEGREE_DATE_5 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_DESC_4 Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

STVDEGC

STVDEGC_LEVEL_ONE

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

STVDEGC

STVDEGC_LEVEL_ONE

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

STVDEGC

STVDEGC_LEVEL_ONE

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

STVDEGC

STVDEGC_LEVEL_ONE

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

STVDEGC

STVDEGC_LEVEL_ONE

DEGREE_LEVEL_DESC_1 Level description. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

DEGREE_LEVEL_DESC_2 Level description. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

DEGREE_LEVEL_DESC_3 Level description. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

DEGREE_LEVEL_DESC_4 Level description. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

DEGREE_LEVEL_DESC_5 Level description. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

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_4 Honors the constituent received with the associated degree. VARCHAR2(63)

APRADEG

APRADEG_HONR_CODE

HONOR1_5 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

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

FUNCTION

GOKODSF.F_GET_DESC

HONOR1_DESC_5 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_4 Institution at which the constituent earned the degree. VARCHAR2(63)

APRADEG

APRADEG_SBGI_CODE

INSTITUTION_5 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_DESC_4 Source/background institution name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

INSTITUTION_DESC_5 Source/background institution name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR1_5 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

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

FUNCTION

GOKODSF.F_GET_DESC

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

APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR2_5 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

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

APRADEG

APRADEG_PIDM



Ver: 8.4.1