Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD_DEGREE	Academic Period Degree	Academic Period when the degree was earned.	VARCHAR2(63)	SORDEGR	SORDEGR_TERM_DEGREE
ACTIVITY_DATE	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 Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ATTEND_FROM_DATE	Attend From Date	First date of attendance of the previous post secondary degree.	DATE	SORDEGR	SORDEGR_ATTEND_FROM
ATTEND_TO_DATE	Attend To Date	Last date of attendance of the previous post secondary degree.	DATE	SORDEGR	SORDEGR_ATTEND_TO
AWARD_CATEGORY	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	Award category description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COLLEGE	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 Description	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
DATA_SOURCE	Data Source	Source system that created or updated this degree row.	VARCHAR2(255)	SORDEGR	SORDEGR_DATA_ORIGIN
DEGREE	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	Degree date associated with previous post secondary institution.	DATE	SORDEGR	SORDEGR_DEGC_DATE
DEGREE_DESC	Degree Description	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	Degree year associated with previous post secondary institution.	VARCHAR2(63)	SORDEGR	SORDEGR_DEGC_YEAR
EDUCATION_GOAL	Education Goal	Recorded education goal from the previous post secondary institution.	VARCHAR2(63)	SORDEGR	SORDEGR_EGOL_CODE
EDUCATION_GOAL_DESC	Education Goal Description	Educational goal description.	VARCHAR2(255)	STVEGOL	STVEGOL_DESC
FIRST_CONCENTRATION	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	First Concentration Description	Concentration or study emphasis description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
FIRST_MAJOR	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	First Major Description	Major or subject area of study description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
FIRST_MINOR	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	First Minor Description	Minor area of study description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMINR_DATA
FIRST_PROGRAM_CLASSIFICATION	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	First Program Classification Description	Program classification description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
FOURTH_CONCENTRATION	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	Fourth Concentration Description	Concentration or study emphasis description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
FOURTH_MAJOR	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	Fourth Major Description	Major or subject area of study description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
FOURTH_MINOR	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	Fourth Minor Description	Minor area of study description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMINR_DATA
FOURTH_PROGRAM_CLASSIFICATION	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	Fourth Program Classification Description	Program classification description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
HONOR	Honor	Indentifies when an honor classification was earned with this degree.	VARCHAR2(63)	SORDEGR	SORDEGR_HONR_CODE
HONOR_DESC	Honor Description	Description for the honor earned.	VARCHAR2(255)	STVHONR	STVHONR_DESC
ID	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	Institution	Source/ background institution code for the high school or prior college.	VARCHAR2(63)	SORDEGR	SORDEGR_SBGI_CODE
INSTITUTION_DESC	Institution_Desc	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_TYPE	Institution Type	Identifies a type for the source/background institution to be used for reporting.	VARCHAR2(1)	STVSBGI	STVSBGI_TYPE_IND
INSTITUTION_TYPE_DESC	Institution Type Description	Source/background institution name.	VARCHAR2(255)	CONSTANT	COLLEGE
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SORDEGR	SORDEGR_PIDM
PRIMARY_IND	Primary Indicator	Inidicates this is primary curriculum for the degree.	VARCHAR2(1)	SORDEGR	SORDEGR_PRIMARY_IND
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
SCHOOL_GPA	School GPA - Grade Point Average or Average	Person's previous post secondary school average or GPA.	NUMBER	SORDEGR	SORDEGR_GPA_TRANSFERRED
SECOND_CONCENTRATION	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	Second Concentration Description	Concentration or study emphasis description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
SECOND_MAJOR	Second Major	Major subject area of the person's academic study.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
SECOND_MAJOR_DESC	Second Major Description	Major or subject area of study description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
SECOND_MINOR	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	Second Minor Description	Minor area of study description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMINR_DATA
SECOND_PROGRAM_CLASSIFICATION	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	Second Program Classification Description	Program classification description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
SEQUENCE_NUMBER	Sequence Number	Sequence number of the degree from the previous post secondary institution.	NUMBER	SORDEGR	SORDEGR_DEGR_SEQ_NO
THIRD_CONCENTRATION	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	Third Concentration Description	Concentration or study emphasis description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
THIRD_MAJOR	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	Third Major Description	Major or subject area of study description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
THIRD_MINOR	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	Third Minor Description	Minor area of study description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMINR_DATA
THIRD_PROGRAM_CLASSIFICATION	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	Third Program Classification Description	Program classification description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
TRANSFER_HOURS	Transfer Hours	Number of transfer credits received from the previous post secondary institution.	NUMBER	SORDEGR	SORDEGR_HOURS_TRANSFERRED
USER_ID	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: 9.2