Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Common Composite View Reports

Banner Operational Data Store
Composite View Target: AS_PREVIOUS_DEGREE

Description Contains previous education degrees, majors, minors, concentration and other degree information.
Key & Frequency One row per person per institution per degree.

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

SORDEGR

SORDEGR_TERM_DEGREE

NO

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

SORDEGR

SORDEGR_ACTIVITY_DATE

NO

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

SORDEGR

SORDEGR_ATTEND_FROM

NO

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

SORDEGR

SORDEGR_ATTEND_TO

NO

NO
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(2)

STVDEGC

STVDEGC_ACAT_CODE

NO

NO
AWARD_CATEGORY_DESC Award category description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

SORDEGR

SORDEGR_COLL_CODE

NO

NO
COLLEGE_DESC College, faculty or school name. VARCHAR2(30)

STVCOLL

STVCOLL_DESC

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

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

SORDEGR

SORDEGR_DATA_ORIGIN

NO

NO
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(6)

SORDEGR

SORDEGR_DEGC_CODE

NO

NO
DEGREE_DATE Degree date associated with previous post secondary institution. DATE

SORDEGR

SORDEGR_DEGC_DATE

NO

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

STVDEGC

STVDEGC_DESC

NO

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

SORDEGR

SORDEGR_DEGC_YEAR

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

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

SORDEGR

SORDEGR_EGOL_CODE

NO

NO
EDUCATION_GOAL_DESC Educational goal description. VARCHAR2(30)

STVEGOL

STVEGOL_DESC

NO

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

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

NO

NO
FIRST_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(30)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

NO

NO
FIRST_MINOR_DESC Minor area of study description. VARCHAR2(30)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

NO

NO
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(6)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

NO
FIRST_PROGRAM_CLASSIF_DESC Program classification description. VARCHAR2(30)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

NO

NO
FOURTH_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(30)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

NO

NO
FOURTH_MINOR_DESC Minor area of study description. VARCHAR2(30)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

NO

NO
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(6)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

NO
FOURTH_PROGRAM_CLASSIF_DESC Program classification description. VARCHAR2(30)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

SORDEGR

SORDEGR_HONR_CODE

NO

NO
HONOR_DESC Description for the honor earned. VARCHAR2(30)

STVHONR

STVHONR_DESC

NO

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

SORDEGR

SORDEGR_SBGI_CODE

NO

NO
INSTITUTION_DESC Source/background institution name. VARCHAR2(30)

STVSBGI

STVSBGI_DESC

NO

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

STVSBGI

STVSBGI_TYPE_IND

NO

NO
INSTITUTION_TYPE_DESC Source/background institution name. VARCHAR2(30)

CONSTANT

COLLEGE

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

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

SORDEGR

SORDEGR_PIDM

NO

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

SORDEGR

SORDEGR_PRIMARY_IND

NO

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

SORDEGR

SORDEGR_GPA_TRANSFERRED

NO

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

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

NO

NO
SECOND_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(30)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

NO

NO
SECOND_MINOR_DESC Minor area of study description. VARCHAR2(30)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

NO

NO
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(6)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

NO
SECOND_PROGRAM_CLASSIF_DESC Program classification description. VARCHAR2(30)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

SORDEGR

SORDEGR_DEGR_SEQ_NO

NO

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

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

NO

NO
THIRD_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(30)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

NO

NO
THIRD_MINOR_DESC Minor area of study description. VARCHAR2(30)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

NO

NO
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(6)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

NO
THIRD_PROGRAM_CLASSIF_DESC Program classification description. VARCHAR2(30)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

SORDEGR

SORDEGR_HOURS_TRANSFERRED

NO

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

SORDEGR

SORDEGR_USER_ID

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: