Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD_DEGREE	Academic Period Degree	Academic Period when the degree was earned.	VARCHAR2(1)		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
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	Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.	VARCHAR2(2)		STVDEGC	STVDEGC_ACAT_CODE
AWARD_CATEGORY_DESC	Award Category Description	Award category description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
COLLEGE	College	College, faculty or school to which the academic study for the student is associated.	VARCHAR2(2)		SORDEGR	SORDEGR_COLL_CODE
COLLEGE_DESC	College Description	College, faculty or school name.	VARCHAR2(30)		STVCOLL	STVCOLL_DESC
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DATA_SOURCE	Data Source	Source system that created or updated this degree row.	VARCHAR2(30)		SORDEGR	SORDEGR_DATA_ORIGIN
DEGREE	Degree	Degree associated with the previous post secondary institution.	VARCHAR2(6)		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(30)		STVDEGC	STVDEGC_DESC
DEGREE_YEAR	Degree Year	Degree year associated with previous post secondary institution.	VARCHAR2(4)		SORDEGR	SORDEGR_DEGC_YEAR
DOMAIN_VALUE	Domain Value	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
EDUCATION_GOAL	Education Goal	Recorded education goal from the previous post secondary institution.	VARCHAR2(2)		SORDEGR	SORDEGR_EGOL_CODE
EDUCATION_GOAL_DESC	Education Goal Description	Educational goal description.	VARCHAR2(30)		STVEGOL	STVEGOL_DESC
FIRST_CONCENTRATION	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	First Concentration Description	Concentration or study emphasis description.	VARCHAR2(30)		FUNCTION	SOKODSF.F_GET_SORCONC_DATA
FIRST_MAJOR	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	First Major Description	Major or subject area of study description.	VARCHAR2(30)		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(4)		FUNCTION	SOKODSF.F_GET_SORMINR_DATA
FIRST_MINOR_DESC	First Minor Description	Minor area of study description.	VARCHAR2(30)		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(6)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
FIRST_PROGRAM_CLASSIF_DESC	First Program Classification Description	Program classification description.	VARCHAR2(30)		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(4)		FUNCTION	SOKODSF.F_GET_SORCONC_DATA
FOURTH_CONCENTRATION_DESC	Fourth Concentration Description	Concentration or study emphasis description.	VARCHAR2(30)		FUNCTION	SOKODSF.F_GET_SORCONC_DATA
FOURTH_MAJOR	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	Fourth Major Description	Major or subject area of study description.	VARCHAR2(30)		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(4)		FUNCTION	SOKODSF.F_GET_SORMINR_DATA
FOURTH_MINOR_DESC	Fourth Minor Description	Minor area of study description.	VARCHAR2(30)		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(6)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
FOURTH_PROGRAM_CLASSIF_DESC	Fourth Program Classification Description	Program classification description.	VARCHAR2(30)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
HONOR	Honor	Indentifies when an honor classification was earned with this degree.	VARCHAR2(6)		SORDEGR	SORDEGR_HONR_CODE
HONOR_DESC	Honor Description	Description for the honor earned.	VARCHAR2(30)		STVHONR	STVHONR_DESC
INSTITUTION	Institution	Source/ background institution code for the high school or prior college.	VARCHAR2(6)		SORDEGR	SORDEGR_SBGI_CODE
INSTITUTION_DESC	Institution Description	Source/background institution name.	VARCHAR2(30)		STVSBGI	STVSBGI_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(30)		CONSTANT	COLLEGE
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)		SORDEGR	SORDEGR_PIDM
PRIMARY_IND	Primary Indicator	Inidicates this is primary curriculum for the degree	VARCHAR2(1)		SORDEGR	SORDEGR_PRIMARY_IND
SCHOOL_GPA	School GPA - Grade Point Average or Average	Person's previous post secondary school average or GPA.	NUMBER(23,9)		SORDEGR	SORDEGR_GPA_TRANSFERRED
SECOND_CONCENTRATION	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	Second Concentration Description	Concentration or study emphasis description.	VARCHAR2(30)		FUNCTION	SOKODSF.F_GET_SORCONC_DATA
SECOND_MAJOR	Second Major	Second subject area or major focus recorded for the student's curriculum.	VARCHAR2(4)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
SECOND_MAJOR_DESC	Second Major Description	Major or subject area of study description.	VARCHAR2(30)		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(4)		FUNCTION	SOKODSF.F_GET_SORMINR_DATA
SECOND_MINOR_DESC	Second Minor Description	Minor area of study description.	VARCHAR2(30)		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(6)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
SECOND_PROGRAM_CLASSIF_DESC	Second Program Classification Description	Program classification description.	VARCHAR2(30)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
SEQUENCE_NUMBER	Sequence Number	Sequence number of the degree from the previous post secondary institution.	NUMBER(2)		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(4)		FUNCTION	SOKODSF.F_GET_SORCONC_DATA
THIRD_CONCENTRATION_DESC	Third Concentration Description	Concentration or study emphasis description.	VARCHAR2(30)		FUNCTION	SOKODSF.F_GET_SORCONC_DATA
THIRD_MAJOR	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	Third Major Description	Major or subject area of study description.	VARCHAR2(30)		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(4)		FUNCTION	SOKODSF.F_GET_SORMINR_DATA
THIRD_MINOR_DESC	Third Minor Description	Minor area of study description.	VARCHAR2(30)		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(6)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
THIRD_PROGRAM_CLASSIF_DESC	Third Program Classification Description	Program classification description.	VARCHAR2(30)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
TRANSFER_HOURS	Transfer Hours	Number of transfer credits received from the previous post secondary institution.	NUMBER(11,3)		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(30)		SORDEGR	SORDEGR_USER_ID
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: