Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADDITIONAL_DEGREE_IND	Indicates if there are more than 1 degrees.	VARCHAR2(1)	FUNCTION	MSKFUNC.F_GET_DEGREE_IND	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
ATTEND_PERIOD_FROM_DATE	Previous education first date of attendance for attendance period.	DATE	SHRTRAM SORDEGR	SHRTRAM_ATTN_BEGIN_DATE SORDEGR_ATTEND_FROM	NO NO	NO
ATTEND_PERIOD_TO_DATE	Previous education last date of attendance for attendance period..	DATE	SHRTRAM SORDEGR	SHRTRAM_ATTN_END_DATE SORDEGR_ATTEND_TO	NO NO	NO
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	NO	NO
COLLEGE_DESC	Description of the college code associated with the post secondary institution.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC	NO	NO
COLLEGE_PREP	Indicates whether the prospect/applicant's secondary school program was college preparatory.	VARCHAR2(1)	SORHSCH	SORHSCH_COLL_PREP_IND	NO	NO
EDUCATION_ACTIVITY_DATE	Identifies the last date this record was created or updated.	DATE	SHRTRAM SHRTRIT SORHSCH SORPCOL	SHRTRAM_ACTIVITY_DATE SHRTRIT_ACTIVITY_DATE SORHSCH_ACTIVITY_DATE SORPCOL_ACTIVITY_DATE	NO NO NO NO	NO
EDUCATION_GOAL	Recorded education goal from the secondary or post secondary institution.	VARCHAR2(63)	SORDEGR	SORDEGR_EGOL_CODE	NO	NO
EDUCATION_GOAL_DESC	Educational goal description.	VARCHAR2(255)	STVEGOL	STVEGOL_DESC	NO	NO
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	NO	NO
INSTITUTION	Source/ background institution code for the high school or prior college.	VARCHAR2(63)	SHRTRIT SORHSCH SORPCOL	SHRTRIT_SBGI_CODE SORHSCH_SBGI_CODE SORPCOL_SBGI_CODE	NO NO NO	NO
INSTITUTION_DESC	Source/background institution name.	VARCHAR2(255)	STVSBGI	STVSBGI_DESC	NO	NO
INSTITUTION_TYPE	Identifies a type for the source/background institution to be used for reporting.	VARCHAR2(1)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
INSTITUTION_TYPE_DESC	Source/background institution type identified as either a secondary or post-secondary school.	VARCHAR2(255)	CONSTANT CONSTANT	COLLEGE HIGH SCHOOL	NO NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
OFFICIAL_TRANSCRIPT_IND	Indicates whether the transcript was an official transcript.	VARCHAR2(1)	SHRTRIT SORPCOL	SHRTRIT_OFFICIAL_TRANS_IND SORPCOL_OFFICIAL_TRANS	NO NO	NO
PERCENTILE	Person's class percentile as related to class rank and size.	NUMBER	SORHSCH	SORHSCH_PERCENTILE	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SHRTRIT SORHSCH SORPCOL	SHRTRIT_PIDM SORHSCH_PIDM SORPCOL_PIDM	NO NO NO	NO
POST_SECONDARY_DEGREE	First degree date associated with post secondary institution.	VARCHAR2(63)	SHRTRAM SORDEGR	SHRTRAM_DEGC_CODE SORDEGR_DEGC_CODE	NO NO	NO
POST_SECONDARY_DEGREE_DATE	First degree date associated with post secondary institution.	DATE	SORDEGR	SORDEGR_DEGC_DATE	NO	NO
POST_SECONDARY_DEGREE_DESC	Degree (e.g., bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code.	VARCHAR2(255)	STVDEGC	STVDEGC_DESC	NO	NO
POST_SECONDARY_DEGREE_SEQUENCE	First degree sequence associated with post secondary institution.	NUMBER	SORDEGR	SORDEGR_DEGR_SEQ_NO	NO	NO
POST_SECONDARY_DEGREE_YEAR	First degree year associated with post secondary institution.	VARCHAR2(63)	SORDEGR	SORDEGR_DEGC_YEAR	NO	NO
POST_SECONDARY_HONORS	Previous institution award honors earned and recorded for the person.	VARCHAR2(63)	SORDEGR	SORDEGR_HONR_CODE	NO	NO
POST_SECONDARY_HONORS_DESC	Previous institution honors description.	VARCHAR2(255)	STVHONR	STVHONR_DESC	NO	NO
POST_SECONDARY_MAJOR1	First major code associated with the post secondary institution.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
POST_SECONDARY_MAJOR2	Second major code associated with the post secondary institution.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
POST_SECONDARY_MAJOR3	Third major code associated with the post secondary institution.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
POST_SECONDARY_MAJOR_DESC1	First major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
POST_SECONDARY_MAJOR_DESC2	Second major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
POST_SECONDARY_MAJOR_DESC3	Third major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
PROGRAM_CLASSIFICATION1	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	NO	NO
PROGRAM_CLASSIFICATION1_DESC	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	NO	NO
PROGRAM_CLASSIFICATION2	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	NO	NO
PROGRAM_CLASSIFICATION2_DESC	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	NO	NO
PROGRAM_CLASSIFICATION3	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	NO	NO
PROGRAM_CLASSIFICATION3_DESC	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	NO	NO
SCHOOL_GPA	Person's secondary or post secondary school average or GPA.	VARCHAR2(63)	SORDEGR SORHSCH	SORDEGR_GPA_TRANSFERRED SORHSCH_GPA	NO NO	NO
SCHOOL_RANK	Person's institution class rank.	NUMBER	SORHSCH	SORHSCH_CLASS_RANK	NO	NO
SCHOOL_SIZE	Size of the person's institution graduating class.	NUMBER	SORHSCH	SORHSCH_CLASS_SIZE	NO	NO
SECONDARY_DIPLOMA	Person's secondary institution diploma type. For example, college preparatory, vocational, general, etc.	VARCHAR2(63)	SORHSCH	SORHSCH_DPLM_CODE	NO	NO
SECONDARY_DIPLOMA_DESC	Secondary school diploma description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SECONDARY_SCHOOL_GRAD_DATE	Person's graduation date from the secondary institution.	DATE	SORHSCH	SORHSCH_GRADUATION_DATE	NO	NO
SEQUENCE_NUMBER	Sequence number of the attendance period from the transfer institution.	NUMBER	SHRTRAM	SHRTRAM_SEQ_NO	NO	NO
TRANSCRIPT_RECEIVED_DATE	Date an academic transcript was received.	DATE	CALCULATION SORHSCH	NVL (SHRTRIT_TRANS_DATE_RCVD, SORPCOL_TRANS_RECV_DATE) SORHSCH_TRANS_RECV_DATE	NO NO	NO
TRANSCRIPT_REVIEWED_DATE	Date an academic transcript was reviewed by the institution.	DATE	CALCULATION	NVL(SHRTRAM_ACCEPTANCE_DATE, SORPCOL_TRANS_REV_DATE)	NO	NO
TRANSFER_CREDITS_ATTENDANCE	Number of transfer credits received from the previous post secondary institution for the attendance period.	NUMBER	FUNCTION	SOKODSF.F_CALC_TRANSFER_CREDITS	NO	NO

Ver: 9.2