Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period or time frame associated with the source for this recruitment record.	VARCHAR2(63)	SRRRSRC	SRRRSRC_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(4)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
DATE_SOURCE_REPORTED	Date the source or the reason for the recruitment information record was reported.	DATE	SRRRSRC	SRRRSRC_ACTIVITY_DATE
DEGREE	Degree or award code associated with the academic study.	VARCHAR2(63)	NA	NA
DEGREE_DESC	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(255)	NA	NA
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INSTITUTION	Source/background institution associated with the prospect.	VARCHAR2(63)	SRRRSRC	SRRRSRC_SBGI_CODE
INSTITUTION_DESC	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MAJOR	First major to which applicant is applying.	VARCHAR2(63)	NA	NA
MAJOR_DESC	Name of the student's major subject area.	VARCHAR2(255)	NA	NA
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SRRRSRC	SRRRSRC_PIDM
PRIMARY_SOURCE_IND	Specifies whether the source type is the primary source of the prospect.	VARCHAR2(1)	SRRRSRC	SRRRSRC_PRIMARY_SRCE_IND
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM	Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements.	VARCHAR2(63)	NA	NA
PROGRAM_CLASSIFICATION	Program classification associated with the major subject area of study for this outcome. Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government.	VARCHAR2(63)	NA	NA
PROGRAM_CLASSIFICATION_DESC	Program classification description.	VARCHAR2(255)	NA	NA
PROGRAM_DESC	Program or course of study description.	VARCHAR2(255)	NA	NA
RECRUIT_NUMBER	Internal sequence number for the source, secondary or post secondary institution.	NUMBER	SRRRSRC	SRRRSRC_ADMIN_SEQNO
START_DATE	Start date.	DATE	NA	NA
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(255)	NA	NA

Ver: 8.1