Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD_DEGREE	Academic Period when the degree was earned.	VARCHAR2(1)	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
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(2)	STVDEGC	STVDEGC_ACAT_CODE
AWARD_CATEGORY_DESC	Award category description.	VARCHAR2(30)	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(2)	SORDEGR	SORDEGR_COLL_CODE
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(30)	STVCOLL	STVCOLL_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DATA_SOURCE	Source system that created or updated this degree row.	VARCHAR2(30)	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(6)	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(30)	STVDEGC	STVDEGC_DESC
DEGREE_YEAR	Degree year associated with previous post secondary institution.	VARCHAR2(4)	SORDEGR	SORDEGR_DEGC_YEAR
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
EDUCATION_GOAL	Recorded education goal from the previous post secondary institution.	VARCHAR2(2)	SORDEGR	SORDEGR_EGOL_CODE
EDUCATION_GOAL_DESC	Educational goal description.	VARCHAR2(30)	STVEGOL	STVEGOL_DESC
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
FIRST_CONCENTRATION_DESC	Concentration or study emphasis description.	VARCHAR2(30)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
FIRST_MAJOR	First subject area or major focus recorded for the student's curriculum.	VARCHAR2(4)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
FIRST_MAJOR_DESC	Major or subject area of study description.	VARCHAR2(30)	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(4)	FUNCTION	SOKODSF.F_GET_SORMINR_DATA
FIRST_MINOR_DESC	Minor area of study description.	VARCHAR2(30)	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(6)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
FIRST_PROGRAM_CLASSIF_DESC	Program classification description.	VARCHAR2(30)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
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
FOURTH_CONCENTRATION_DESC	Concentration or study emphasis description.	VARCHAR2(30)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
FOURTH_MAJOR	Fourth subject area or major focus recorded for the student's curriculum.	VARCHAR2(4)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
FOURTH_MAJOR_DESC	Major or subject area of study description.	VARCHAR2(30)	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(4)	FUNCTION	SOKODSF.F_GET_SORMINR_DATA
FOURTH_MINOR_DESC	Minor area of study description.	VARCHAR2(30)	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(6)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
FOURTH_PROGRAM_CLASSIF_DESC	Program classification description.	VARCHAR2(30)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
HONOR	Indentifies when an honor classification was earned with this degree.	VARCHAR2(6)	SORDEGR	SORDEGR_HONR_CODE
HONOR_DESC	Description for the honor earned.	VARCHAR2(30)	STVHONR	STVHONR_DESC
INSTITUTION	Source/ background institution code for the high school or prior college.	VARCHAR2(6)	SORDEGR	SORDEGR_SBGI_CODE
INSTITUTION_DESC	Source/background institution name.	VARCHAR2(30)	STVSBGI	STVSBGI_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(30)	CONSTANT	COLLEGE
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
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
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(4)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
SECOND_CONCENTRATION_DESC	Concentration or study emphasis description.	VARCHAR2(30)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
SECOND_MAJOR	Major subject area of the person's academic study.	VARCHAR2(4)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
SECOND_MAJOR_DESC	Major or subject area of study description.	VARCHAR2(30)	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(4)	FUNCTION	SOKODSF.F_GET_SORMINR_DATA
SECOND_MINOR_DESC	Minor area of study description.	VARCHAR2(30)	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(6)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
SECOND_PROGRAM_CLASSIF_DESC	Program classification description.	VARCHAR2(30)	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(4)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
THIRD_CONCENTRATION_DESC	Concentration or study emphasis description.	VARCHAR2(30)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
THIRD_MAJOR	Third subject area or major focus recorded for the student's curriculum.	VARCHAR2(4)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
THIRD_MAJOR_DESC	Major or subject area of study description.	VARCHAR2(30)	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(4)	FUNCTION	SOKODSF.F_GET_SORMINR_DATA
THIRD_MINOR_DESC	Minor area of study description.	VARCHAR2(30)	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(6)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
THIRD_PROGRAM_CLASSIF_DESC	Program classification description.	VARCHAR2(30)	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(30)	SORDEGR	SORDEGR_USER_ID
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: