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: