Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
CONTACTS_COUNT	Count the number of contacts made by the institution and recorded for this pre student.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_CONTACTS	NO	NO
FIRST_CONTACT	Type of the earliest contact of the pre-student.	VARCHAR2(63)	SORCONT	SORCONT_CTYP_CODE	NO	NO
FIRST_CONTACT_DATE	First contact of the pre-student by date.	DATE	SORCONT	SORCONT_CONTACT_DATE	NO	NO
FIRST_CONTACT_DESC	First contact description.	VARCHAR2(255)	STVCTYP	STVCTYP_DESC	NO	NO
HOLD_COUNT	Count of the number of holds or restrictions to institution activities recorded for this person. Included may be stop of registration, receipt of a transcript or processing of graduation, etc.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_HOLDS	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
INTERESTS_COUNT	Count the number of extracurricular interests recorded for this person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_INTERESTS	NO	NO
LATEST_CONTACT	Type of last contact that has been made with the pre-student.	VARCHAR2(63)	SORCONT	SORCONT_CTYP_CODE	NO	NO
LATEST_CONTACT_DATE	Date of the last contact of the pre-student.	DATE	SORCONT	SORCONT_CONTACT_DATE	NO	NO
LATEST_CONTACT_DESC	Last contact description.	VARCHAR2(255)	STVCTYP	STVCTYP_DESC	NO	NO
LATEST_POST_SECONDARY_DESC	Source/background institution name.	VARCHAR2(255)	STVSBGI	STVSBGI_DESC	NO	NO
LATEST_POST_SECONDARY_SCHOOL	Source/background institution code for the prior college.	VARCHAR2(63)	FUNCTION	SOKODSF.F_SORPCOL_INFO	NO	NO
LATEST_SECONDARY_SCHOOL	Most recent secondary school of the prospect/applicant identified by graduation date.	VARCHAR2(63)	SORHSCH	SORHSCH_SBGI_CODE	NO	NO
LATEST_SECONDARY_SCHOOL_DESC	Source/background institution name.	VARCHAR2(255)	STVSBGI	STVSBGI_DESC	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
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SARADAP SRBRECR	SARADAP_PIDM SRBRECR_PIDM	NO NO	NO
POST_SECONDARY_DEGREE1	First degree code associated with prior college.	VARCHAR2(63)	SORDEGR	SORDEGR_DEGC_CODE	NO	NO
POST_SECONDARY_DEGREE2	First degree code associated with prior college.	VARCHAR2(63)	SORDEGR	SORDEGR_DEGC_CODE	NO	NO
POST_SECONDARY_DEGREE_DATE1	First degree date associated with post secondary institution.	DATE	SORDEGR	SORDEGR_DEGC_DATE	NO	NO
POST_SECONDARY_DEGREE_DATE2	First degree date associated with post secondary institution.	DATE	SORDEGR	SORDEGR_DEGC_DATE	NO	NO
POST_SECONDARY_DEGREE_DESC1	Degree (e.g., bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
POST_SECONDARY_DEGREE_DESC2	Degree (e.g., bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
POST_SECONDARY_MAJOR1	First major code associated with the post secondary institution.	VARCHAR2(63)	SORMAJR	SORMAJR_MAJR_CODE_MAJOR	NO	NO
POST_SECONDARY_MAJOR2	Second major code associated with the post secondary institution.	VARCHAR2(63)	SORMAJR	SORMAJR_MAJR_CODE_MAJOR	NO	NO
POST_SECONDARY_MAJOR3	Third major code associated with the post secondary institution.	VARCHAR2(63)	SORMAJR	SORMAJR_MAJR_CODE_MAJOR	NO	NO
POST_SECONDARY_MAJOR_DESC1	First major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
POST_SECONDARY_MAJOR_DESC2	Second major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
POST_SECONDARY_MAJOR_DESC3	Third major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
POST_SECONDARY_SCHOOL_COUNT	Count of post secondary schools.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_INSTITUTION_TYPES	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)	NA	NA	NO	NO
PROGRAM_CLASSIFICATION1_DESC	Classification of Institutional Programs (CIP) code description for the first major code associated with the post secondary institution.	VARCHAR2(255)	NA	NA	NO	NO
PROGRAM_CLASSIFICATION2	Classification of Institutional Programs (CIP) code of the second major code associated with the post secondary institution.	VARCHAR2(63)	NA	NA	NO	NO
PROGRAM_CLASSIFICATION2_DESC	Classification of Institutional Programs (CIP) code for the second major code associated with the post secondary institution.	VARCHAR2(255)	NA	NA	NO	NO
PROGRAM_CLASSIFICATION3	Classification of Institutional Programs (CIP) code of the third major code associated with the post secondary institution.	VARCHAR2(63)	NA	NA	NO	NO
PROGRAM_CLASSIFICATION3_DESC	Classification of Institutional Programs (CIP) code for the third major code associated with the post secondary institution.	VARCHAR2(255)	NA	NA	NO	NO
PS_ATTEND_FROM_DATE	First date of attendance at the post secondary institution.	DATE	FUNCTION	SOKODSF.F_SORPCOL_INFO	NO	NO
PS_ATTEND_TO_DATE	Last date of attendance at the post secondary institution.	DATE	FUNCTION	SOKODSF.F_SORPCOL_INFO	NO	NO
PS_GPA_TRANSFERRED	Person's post secondary institution average or GPA.	VARCHAR2(63)	FUNCTION	SOKODSF.F_SORPCOL_INFO	NO	NO
PS_OFFICIAL_TRANSCRIPT_IND	Indicates whether the transcript was an official transcript.	VARCHAR2(1)	SORPCOL	SORPCOL_OFFICIAL_TRANS	NO	NO
PS_SCHOOL_PERCENTILE	Prospect/applicant's class percentile as related to class rank and size at the previous institution.	NUMBER	NA	NA	NO	NO
PS_SCHOOL_RANK	Prospect/applicant's previous institution class rank.	NUMBER	NA	NA	NO	NO
PS_SCHOOL_SIZE	Size of the prospect/applicant's previous institution graduating class.	NUMBER	NA	NA	NO	NO
PS_TRANSCRIPT_RECEIVED_DATE	Date an academic transcript was received.	DATE	FUNCTION	SOKODSF.F_SORPCOL_INFO	NO	NO
PS_TRANSCRIPT_REVIEWED_DATE	Date an academic transcript was reviewed.	DATE	FUNCTION	SOKODSF.F_SORPCOL_INFO	NO	NO
SECONDARY_ATTEND_FROM_DATE	Date the high school was attended from.	DATE	NA	NA	NO	NO
SECONDARY_ATTEND_TO_DATE	Date the high school was attended to.	DATE	NA	NA	NO	NO
SECONDARY_SCHOOL_COUNT	Count of the secondary schools recorded as attended for this person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_INSTITUTION_TYPES	NO	NO
SECONDARY_SCHOOL_DIPLOMA	Person's secondary institution diploma type. For example, college preparatory, vocational, general, etc.	VARCHAR2(63)	SORHSCH	SORHSCH_DPLM_CODE	NO	NO
SECONDARY_SCHOOL_DIPLOMA_DESC	Secondary school diploma description.	VARCHAR2(255)	STVDPLM	STVDPLM_DESC	NO	NO
SECONDARY_SCHOOL_GRAD_DATE	Person's graduation date from the secondary institution.	DATE	SORHSCH	SORHSCH_GRADUATION_DATE	NO	NO
SECONDARY_SCHOOL_PERCENTILE	Person's class percentile as related to class rank and size.	NUMBER	SORHSCH	SORHSCH_PERCENTILE	NO	NO
SECONDARY_SCHOOL_RANK	Person's institution class rank.	NUMBER	SORHSCH	SORHSCH_CLASS_RANK	NO	NO
SECONDARY_SCHOOL_REPORTED_GPA	Person's secondary institution average or GPA.	VARCHAR2(63)	SORHSCH	SORHSCH_GPA	NO	NO
SECONDARY_SCHOOL_SIZE	Size of the person's institution graduating class.	NUMBER	SORHSCH	SORHSCH_CLASS_SIZE	NO	NO
SECONDARY_SUBJECT_COUNT	Count of the secondary school subjects recorded for this person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_SECONDARY_SUBJECTS	NO	NO
SEC_OFFICIAL_TRANSCRIPT_IND	Indicates whether the most recent secondary institution transcript was an official transcript.	VARCHAR2(1)	NA	NA	NO	NO
SEC_TRANSCRIPT_RECEIVED_DATE	Date an secondary school academic transcript was received.	DATE	SORHSCH	SORHSCH_TRANS_RECV_DATE	NO	NO
SEC_TRANSCRIPT_REVIEWED_DATE	Date an academic transcript was reviewed by the institution.	DATE	NA	NA	NO	NO
TEST_COUNT	Count of the number of test scores recorded for this person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_TESTS	NO	NO

Ver: 9.2