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

SGHE Banner Operational Data Store
Reporting View Target: PREVIOUS_DEGREE

Description Contains previous education degrees, majors, minors, concentration and other degree information. There will be multiple records for a person and institution if more than one degree was awarded or sought at that institution.
Key & Frequency One row per person per institution per degree.
Recommended Search Columns PERSON_UID, INSTITUTION, DEGREE
FIRST_MAJOR, DEGREE, PERSON_UID

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD_DEGREE Academic Period when the degree was earned. VARCHAR2(63)

SORDEGR

SORDEGR_TERM_DEGREE

ACTIVITY_DATE Date this previous post secondary degree was created or last updated in the source system. DATE

SORDEGR

SORDEGR_ACTIVITY_DATE

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

NA

NA

ATTEND_FROM_DATE First date of attendance of the previous post secondary degree. DATE

SORDEGR

SORDEGR_ATTEND_FROM

ATTEND_TO_DATE Last date of attendance of the previous post secondary degree. DATE

SORDEGR

SORDEGR_ATTEND_TO

AWARD_CATEGORY Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc. VARCHAR2(63)

STVDEGC

STVDEGC_ACAT_CODE

AWARD_CATEGORY_DESC Award category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORDEGR

SORDEGR_COLL_CODE

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

STVCOLL

STVCOLL_DESC

DATA_SOURCE Source system that created or updated this degree row. VARCHAR2(255)

SORDEGR

SORDEGR_DATA_ORIGIN

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)

SORDEGR

SORDEGR_DEGC_CODE

DEGREE_DATE Degree date associated with previous post secondary institution. DATE

SORDEGR

SORDEGR_DEGC_DATE

DEGREE_DESC Degree (e.g., bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DEGREE_YEAR Degree year associated with previous post secondary institution. VARCHAR2(63)

SORDEGR

SORDEGR_DEGC_YEAR

EDUCATION_GOAL Recorded education goal from the previous post secondary institution. VARCHAR2(63)

SORDEGR

SORDEGR_EGOL_CODE

EDUCATION_GOAL_DESC Educational goal description. VARCHAR2(255)

STVEGOL

STVEGOL_DESC

FIRST_CONCENTRATION Concentration or study emphasis attached to the first major for the student's academic study. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

FIRST_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

FIRST_MAJOR First subject area or major focus recorded for the student's curriculum. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

FIRST_MINOR First minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

FIRST_MINOR_DESC Minor area of study description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

FIRST_PROGRAM_CLASSIFICATION Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

FIRST_PROGRAM_CLASSIF_DESC Program classification description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

FOURTH_CONCENTRATION Concentration or study emphasis attached to the fourth major for the student's academic study. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

FOURTH_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

FOURTH_MAJOR Fourth subject area or major focus recorded for the student's curriculum. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

FOURTH_MINOR Fourth minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

FOURTH_MINOR_DESC Minor area of study description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

FOURTH_PROGRAM_CLASSIFICATION Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

FOURTH_PROGRAM_CLASSIF_DESC Program classification description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

HONOR Indentifies when an honor classification was earned with this degree. VARCHAR2(63)

SORDEGR

SORDEGR_HONR_CODE

HONOR_DESC Description for the honor earned. VARCHAR2(255)

STVHONR

STVHONR_DESC

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

INSTITUTION Source/ background institution code for the high school or prior college. VARCHAR2(63)

SORDEGR

SORDEGR_SBGI_CODE

INSTITUTION_DESC Source/background institution name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

INSTITUTION_TYPE Identifies a type for the source/background institution to be used for reporting. VARCHAR2(1)

STVSBGI

STVSBGI_TYPE_IND

INSTITUTION_TYPE_DESC Source/background institution name. VARCHAR2(255)

CONSTANT

COLLEGE

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

SORDEGR

SORDEGR_PIDM

PRIMARY_IND Inidicates this is primary curriculum for the degree. VARCHAR2(1)

SORDEGR

SORDEGR_PRIMARY_IND

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

NA

NA

SCHOOL_GPA Person's previous post secondary school average or GPA. NUMBER

SORDEGR

SORDEGR_GPA_TRANSFERRED

SECOND_CONCENTRATION Concentration or study emphasis attached to the second major for the student's academic study. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

SECOND_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

SECOND_MAJOR Major subject area of the person's academic study. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

SECOND_MINOR Second minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

SECOND_MINOR_DESC Minor area of study description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

SECOND_PROGRAM_CLASSIFICATION Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

SECOND_PROGRAM_CLASSIF_DESC Program classification description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

SEQUENCE_NUMBER Sequence number of the degree from the previous post secondary institution. NUMBER

SORDEGR

SORDEGR_DEGR_SEQ_NO

THIRD_CONCENTRATION Concentration or study emphasis attached to the third major for the student's academic study. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

THIRD_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

THIRD_MAJOR Third subject area or major focus recorded for the student's curriculum. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

THIRD_MINOR Third minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

THIRD_MINOR_DESC Minor area of study description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

THIRD_PROGRAM_CLASSIFICATION Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

THIRD_PROGRAM_CLASSIF_DESC Program classification description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

TRANSFER_HOURS Number of transfer credits received from the previous post secondary institution. NUMBER

SORDEGR

SORDEGR_HOURS_TRANSFERRED

USER_ID User Id that created or last updated this previous post secondary degree in the source system. VARCHAR2(63)

SORDEGR

SORDEGR_USER_ID



Ver: 8.5