Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADDITIONAL_DEGREE_IND	Additional Degree Indicator	Indicates if there are more than 1 degrees.	VARCHAR2(1)		FUNCTION	MSKFUNC.F_GET_DEGREE_IND
ADMINISTRATIVE_GROUP	Administrative Group	Organization-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	Previous education first date of attendance. When there are multiple attendance periods for the same transfer institution, this reporting view will retrieve the earliest attend from date.	DATE		SORDEGR	SORDEGR_ATTEND_FROM
ATTEND_TO_DATE	Attend To Date	Previous education last date of attendance. When there are multiple attendance periods for the same transfer institution, this reporting view will retrieve the latest attend to date.	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(63)		STVDEGC	STVDEGC_ACAT_CODE
AWARD_CATEGORY_DESC	Award Category Description	Award category description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
COLLEGE	College	Identifies the college code associated with the post secondary institution.	VARCHAR2(63)		SORDEGR	SORDEGR_COLL_CODE
COLLEGE_DESC	College Description	Identifies the description of the college code.	VARCHAR2(255)		STVCOLL	STVCOLL_DESC
COLLEGE_PREP	College Prep	Indicates whether the prospect/applicant's secondary school program was college preparatory.	VARCHAR2(1)		SORHSCH	SORHSCH_COLL_PREP_IND
EDUCATION_ACTIVITY_DATE	Education Activity Date	Date record was inserted or updated.	DATE		SHRTRAM SHRTRIT SORHSCH SORPCOL	SHRTRAM_ACTIVITY_DATE SHRTRIT_ACTIVITY_DATE SORHSCH_ACTIVITY_DATE SORPCOL_ACTIVITY_DATE
EDUCATION_DATA_ORIGIN	Education Data Origin	Source system that created or updated the row	VARCHAR2(63)		SORHSCH SORPCOL	SORHSCH_DATA_ORIGIN SORPCOL_DATA_ORIGIN
EDUCATION_GOAL	Education Goal	Recorded education goal from the secondary or post secondary institution.	VARCHAR2(63)		SORDEGR	SORDEGR_EGOL_CODE
EDUCATION_GOAL_DESC	Education Goal Description	Educational goal description.	VARCHAR2(255)		STVEGOL	STVEGOL_DESC
EDUCATION_USER_ID	Education User ID	User who inserted or last updated the data.	VARCHAR2(63)		SORHSCH SORPCOL	SORHSCH_USER_ID SORPCOL_USER_ID
ID	ID	Person's or organization's current identification number.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INSTITUTION	Institution	Source/ background institution code for the high school or prior college.	VARCHAR2(63)		SHRTRIT	SHRTRIT_SBGI_CODE
INSTITUTION_DESC	Institution Description	Source/background institution name.	VARCHAR2(255)		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(255)		CONSTANT CONSTANT	'COLLEGE' 'HIGHSCHOOL'
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
OFFICIAL_TRANSCRIPT_IND	Official Transcript Indicator	Indicates whether the transcript was an official transcript.	VARCHAR2(1)		SHRTRIT	SHRTRIT_OFFICIAL_TRANS_IND
PERCENTILE	Percentile	Person's class percentile as related to class rank and size.	NUMBER		SORHSCH	SORHSCH_PERCENTILE
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER		SORHSCH SORPCOL	SORHSCH_PIDM SORPCOL_PIDM
POST_SECONDARY_DEGREE	Post Secondary Degree	First degree code associated with prior college.	VARCHAR2(63)		SORDEGR	SORDEGR_DEGC_CODE
POST_SECONDARY_DEGREE_DATE	Post Secondary Degree Date	First degree date associated with post secondary institution.	DATE		SORDEGR	SORDEGR_DEGC_DATE
POST_SECONDARY_DEGREE_DESC	Post Secondary Degree Description	Degree (e.g., bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code.	VARCHAR2(255)		STVDEGC	STVDEGC_DESC
POST_SECONDARY_DEGREE_SEQUENCE	Post Secondary Degree Sequence	First degree sequence associated with post secondary institution.	NUMBER		SORDEGR	SORDEGR_DEGR_SEQ_NO
POST_SECONDARY_DEGREE_YEAR	Post Secondary Degree Year	First degree year associated with post secondary institution.	VARCHAR2(63)		SORDEGR	SORDEGR_DEGC_YEAR
POST_SECONDARY_HONORS	Post Secondary Honors	Previous institution award honors earned and recorded for the person.	VARCHAR2(63)		SORDEGR	SORDEGR_HONR_CODE
POST_SECONDARY_HONORS_DESC	Post Secondary Honors Description	Previous institution honors description.	VARCHAR2(255)		STVHONR	STVHONR_DESC
POST_SECONDARY_MAJOR1	Post Secondary Major 1	First major code associated with the post secondary institution.	VARCHAR2(63)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR2	Post Secondary Major 2	Second major code associated with the post secondary institution.	VARCHAR2(63)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR3	Post Secondary Major 3	Third major code associated with the post secondary institution.	VARCHAR2(63)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC1	Post Secondary Major Description 1	First major code description associated with the post secondary institution.	VARCHAR2(255)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC2	Post Secondary Major Description 2	Second major code description associated with the post secondary institution.	VARCHAR2(255)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC3	Post Secondary Major Description 3	Third major code description associated with the post secondary institution.	VARCHAR2(255)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
PROGRAM_CLASSIFICATION1	Program Classification 1	Classification of Institutional Programs (CIP) code of the first major code associated with the post secondary institution.	VARCHAR2(63)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION1_DESC	Program Classification 1 Description	Classification of Institutional Programs (CIP) code for the first major code associated with the post secondary institution.	VARCHAR2(255)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION2	Program Classification 2	Classification of Institutional Programs (CIP) code of the second major code associated with the post secondary institution.	VARCHAR2(63)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION2_DESC	Program Classification 2 Description	Classification of Institutional Programs (CIP) code for the second major code associated with the post secondary institution.	VARCHAR2(255)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION3	Program Classification 3	Classification of Institutional Programs (CIP) code of the third major code associated with the post secondary institution.	VARCHAR2(63)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION3_DESC	Program Classification 3 Description	Classification of Institutional Programs (CIP) code description for the third major code associated with the post secondary institution.	VARCHAR2(255)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
REQUIREMENT	Requirement	Document or checklist item that is satisfied by entry of this information.	VARCHAR2(63)		SORHSCH SORPCOL	SORHSCH_ADMR_CODE SORPCOL_ADMR_CODE
REQUIREMENT_DESC	Requirement Description	Requirement description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
SCHOOL_GPA	School GPA - Grade Point Average or Average	Person's post secondary institution average or GPA.	VARCHAR2(63)		SORDEGR SORHSCH	SORDEGR_GPA_TRANSFERRED SORHSCH_GPA
SCHOOL_RANK	School Rank	Person's institution class rank.	NUMBER		SORHSCH	SORHSCH_CLASS_RANK
SCHOOL_SIZE	School Size	Size of the person's institution graduating class.	NUMBER		SORHSCH	SORHSCH_CLASS_SIZE
SECONDARY_DIPLOMA	Secondary Diploma	Person's secondary institution diploma type. For example, college preparatory, vocational, general, etc.	VARCHAR2(63)		SORHSCH	SORHSCH_DPLM_CODE
SECONDARY_DIPLOMA_DESC	Secondary Diploma Description	Secondary school diploma description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
SECONDARY_SCHOOL_GRAD_DATE	Secondary School Graduate Date	Person's graduation date from the secondary institution.	DATE		SORHSCH	SORHSCH_GRADUATION_DATE
TOTAL_TRANSFER_CREDITS	Total Transfer Credits	Number of transfer credits received from the previous post secondary institution.	NUMBER		FUNCTION	SOKODSF.F_CALC_TRANSFER_CREDITS
TRANSCRIPT_RECEIVED_DATE	Transcript Received Date	Date an academic transcript was received.	DATE		SHRTRIT	SHRTRIT_TRANS_DATE_RCVD
TRANSCRIPT_REVIEWED_DATE	Transcript Reviewed Date	Date an academic transcript was reviewed by the institution. This may be entered either under the prior college record or on the transfer course record so a function is used to determine the date the work at the previous post secondary institution was reviewed or credit awarded.	DATE		FUNCTION	F_GET_DATE_PREV_EDUCATION

Ver: 9.0