Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
CONTACTS_COUNT	Contacts Count	Count the number of contacts made by the institution and recorded for this pre student.	NUMBER		FUNCTION	MSKFUNC.F_COUNT_CONTACTS
FIRST_CONTACT	First Contact	Type of the earliest contact of the pre-student.	VARCHAR2(63)		SORCONT	SORCONT_CTYP_CODE
FIRST_CONTACT_DATE	First Contact Date	First contact of the pre-student by date.	DATE		SORCONT	SORCONT_CONTACT_DATE
FIRST_CONTACT_DESC	First Contact Description	First contact description.	VARCHAR2(255)		STVCTYP	STVCTYP_DESC
HOLD_COUNT	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
ID	ID	Person's or organization's current identification number.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INTERESTS_COUNT	Interests Count	Count the number of extracurricular interests recorded for this person.	NUMBER		FUNCTION	MSKFUNC.F_COUNT_INTERESTS
LATEST_CONTACT	Latest Contact	Type of last contact that has been made with the pre-student.	VARCHAR2(63)		SORCONT	SORCONT_CTYP_CODE
LATEST_CONTACT_DATE	Latest Contact Date	Date of the last contact of the pre-student.	DATE		SORCONT	SORCONT_CONTACT_DATE
LATEST_CONTACT_DESC	Latest Contact Description	Last contact description.	VARCHAR2(255)		STVCTYP	STVCTYP_DESC
LATEST_POST_SECONDARY_DESC	Latest Post Secondary Description	Source/background institution name.	VARCHAR2(255)		STVSBGI	STVSBGI_DESC
LATEST_POST_SECONDARY_SCHOOL	Latest Post Secondary School	Source/background institution code for the prior college.	VARCHAR2(63)		FUNCTION	SOKODSF.F_SORPCOL_INFO
LATEST_SECONDARY_SCHOOL	Latest Secondary School	Most recent secondary school of the prospect/applicant identified by graduation date.	VARCHAR2(63)		SORHSCH	SORHSCH_SBGI_CODE
LATEST_SECONDARY_SCHOOL_DESC	Latest Secondary School Description	Source/background institution name.	VARCHAR2(255)		STVSBGI	STVSBGI_DESC
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
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER		SARADAP SRBRECR	SARADAP_PIDM SRBRECR_PIDM
POST_SECONDARY_DEGREE1	Post Secondary Degree 1	First degree code associated with prior college.	VARCHAR2(63)		SORDEGR	SORDEGR_DEGC_CODE
POST_SECONDARY_DEGREE2	Post Secondary Degree 2	First degree code associated with prior college.	VARCHAR2(63)		SORDEGR	SORDEGR_DEGC_CODE
POST_SECONDARY_DEGREE_DATE1	Post Secondary Degree Date 1	First degree date associated with post secondary institution.	DATE		SORDEGR	SORDEGR_DEGC_DATE
POST_SECONDARY_DEGREE_DATE2	Post Secondary Degree Date 2	First degree date associated with post secondary institution.	DATE		SORDEGR	SORDEGR_DEGC_DATE
POST_SECONDARY_DEGREE_DESC1	Post Secondary Degree Description 1	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
POST_SECONDARY_DEGREE_DESC2	Post Secondary Degree Description 2	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
POST_SECONDARY_MAJOR1	Post Secondary Major 1	First major code associated with the post secondary institution.	VARCHAR2(63)		SORMAJR	SORMAJR_MAJR_CODE_MAJOR
POST_SECONDARY_MAJOR2	Post Secondary Major 2	Second major code associated with the post secondary institution.	VARCHAR2(63)		SORMAJR	SORMAJR_MAJR_CODE_MAJOR
POST_SECONDARY_MAJOR3	Post Secondary Major 3	Third major code associated with the post secondary institution.	VARCHAR2(63)		SORMAJR	SORMAJR_MAJR_CODE_MAJOR
POST_SECONDARY_MAJOR_DESC1	Post Secondary Major Description 1	First major code description associated with the post secondary institution.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
POST_SECONDARY_MAJOR_DESC2	Post Secondary Major Description 2	Second major code description associated with the post secondary institution.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
POST_SECONDARY_MAJOR_DESC3	Post Secondary Major Description 3	Third major code description associated with the post secondary institution.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
POST_SECONDARY_SCHOOL_COUNT	Post Secondary School Count	Count of post secondary schools.	NUMBER		FUNCTION	MSKFUNC.F_COUNT_INSTITUTION_TYPES
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)		NA	NA
PROGRAM_CLASSIFICATION1_DESC	Program Classification 1 Description	Classification of Institutional Programs (CIP) code description for the first major code associated with the post secondary institution.	VARCHAR2(255)		NA	NA
PROGRAM_CLASSIFICATION2	Program Classification 2	Classification of Institutional Programs (CIP) code of the second major code associated with the post secondary institution.	VARCHAR2(63)		NA	NA
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)		NA	NA
PROGRAM_CLASSIFICATION3	Program Classification 3	Classification of Institutional Programs (CIP) code of the third major code associated with the post secondary institution.	VARCHAR2(63)		NA	NA
PROGRAM_CLASSIFICATION3_DESC	Program Classification 3 Description	Classification of Institutional Programs (CIP) code for the third major code associated with the post secondary institution.	VARCHAR2(255)		NA	NA
PS_ATTEND_FROM_DATE	Ps Attend From Date	First date of attendance at the post secondary institution.	DATE		FUNCTION	SOKODSF.F_SORPCOL_INFO
PS_ATTEND_TO_DATE	Ps Attend To Date	Last date of attendance at the post secondary institution.	DATE		FUNCTION	SOKODSF.F_SORPCOL_INFO
PS_GPA_TRANSFERRED	Ps GPA - Grade Point Average or Average Transferred	Person's post secondary institution average or GPA.	VARCHAR2(63)		FUNCTION	SOKODSF.F_SORPCOL_INFO
PS_OFFICIAL_TRANSCRIPT_IND	Ps Official Transcript Indicator	Indicates whether the transcript was an official transcript.	VARCHAR2(1)		SORPCOL	SORPCOL_OFFICIAL_TRANS
PS_SCHOOL_PERCENTILE	Ps School Percentile	Prospect/applicant's class percentile as related to class rank and size at the previous institution.	NUMBER		NA	NA
PS_SCHOOL_RANK	Ps School Rank	Prospect/applicant's previous institution class rank.	NUMBER		NA	NA
PS_SCHOOL_SIZE	Ps School Size	Size of the prospect/applicant's previous institution graduating class.	NUMBER		NA	NA
PS_TRANSCRIPT_RECEIVED_DATE	Ps Transcript Received Date	Date an academic transcript was received.	DATE		FUNCTION	SOKODSF.F_SORPCOL_INFO
PS_TRANSCRIPT_REVIEWED_DATE	Ps Transcript Reviewed Date	Date an academic transcript was reviewed.	DATE		FUNCTION	SOKODSF.F_SORPCOL_INFO
SECONDARY_ATTEND_FROM_DATE	Secondary Attend From Date	Date the high school was attended from.	DATE		NA	NA
SECONDARY_ATTEND_TO_DATE	Secondary Attend To Date	Date the high school was attended to.	DATE		NA	NA
SECONDARY_SCHOOL_COUNT	Secondary School Count	Count of the secondary schools recorded as attended for this person.	NUMBER		FUNCTION	MSKFUNC.F_COUNT_INSTITUTION_TYPES
SECONDARY_SCHOOL_DIPLOMA	Secondary School Diploma	Person's secondary institution diploma type. For example, college preparatory, vocational, general, etc.	VARCHAR2(63)		SORHSCH	SORHSCH_DPLM_CODE
SECONDARY_SCHOOL_DIPLOMA_DESC	Secondary School Diploma Description	Secondary school diploma description.	VARCHAR2(255)		STVDPLM	STVDPLM_DESC
SECONDARY_SCHOOL_GRAD_DATE	Secondary School Graduate Date	Person's graduation date from the secondary institution.	DATE		SORHSCH	SORHSCH_GRADUATION_DATE
SECONDARY_SCHOOL_PERCENTILE	Secondary School Percentile	Person's class percentile as related to class rank and size.	NUMBER		SORHSCH	SORHSCH_PERCENTILE
SECONDARY_SCHOOL_RANK	Secondary School Rank	Person's institution class rank.	NUMBER		SORHSCH	SORHSCH_CLASS_RANK
SECONDARY_SCHOOL_REPORTED_GPA	Secondary School Reported GPA - Grade Point Average or Average	Person's secondary institution average or GPA.	VARCHAR2(63)		SORHSCH	SORHSCH_GPA
SECONDARY_SCHOOL_SIZE	Secondary School Size	Size of the person's institution graduating class.	NUMBER		SORHSCH	SORHSCH_CLASS_SIZE
SECONDARY_SUBJECT_COUNT	Secondary Subject Count	Count of the secondary school subjects recorded for this person.	NUMBER		FUNCTION	MSKFUNC.F_COUNT_SECONDARY_SUBJECTS
SEC_OFFICIAL_TRANSCRIPT_IND	Sec Official Transcript Indicator	Indicates whether the most recent secondary institution transcript was an official transcript.	VARCHAR2(1)		NA	NA
SEC_TRANSCRIPT_RECEIVED_DATE	Sec Transcript Received Date	Date an secondary school academic transcript was received.	DATE		SORHSCH	SORHSCH_TRANS_RECV_DATE
SEC_TRANSCRIPT_REVIEWED_DATE	Sec Transcript Reviewed Date	Date an academic transcript was reviewed by the institution.	DATE		NA	NA
TEST_COUNT	Test Count	Count of the number of test scores recorded for this person.	NUMBER		FUNCTION	MSKFUNC.F_COUNT_TESTS

Ver: 9.0