Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
APPLICATION_STATUS	Most current status of the application, whether the status is determined by institution or student.	VARCHAR2(63)	ADMISSIONS_APPLICATION	APPLICATION_STATUS	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
APPLICATION_STATUS_LD	Application status description.	VARCHAR2(255)	ADMISSIONS_APPLICATION	APPLICATION_STATUS_DESC	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
APPLICATION_STATUS_SD	Application status description.	VARCHAR2(255)	ADMISSIONS_APPLICATION	APPLICATION_STATUS_DESC	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
INSTITUTION_ATTENDING	Institution the student decided to attend rather than the home institution.	VARCHAR2(63)	ADMISSIONS_APPLICATION	INSTITUTION_ATTENDING	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
INSTITUTION_ATTENDING_LD	Source/background institution name.	VARCHAR2(255)	ADMISSIONS_APPLICATION	INSTITUTION_ATTENDING_DESC	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
INSTITUTION_ATTENDING_SD	Source/background institution name.	VARCHAR2(255)	ADMISSIONS_APPLICATION	INSTITUTION_ATTENDING_DESC	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
PRIMARY_SOURCE	Source identified by the person at their first contact with the institution as having referred the person to this institution. Usually either the secondary or post-secondary school or newspaper advertisement.	VARCHAR2(63)	ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION	PRIMARY_SOURCE PRIMARY_SOURCE	NO NO	NO	ADMISSIONS APPLICATION  RECRUITING AND ADMISSION
PRIMARY_SOURCE_LD	Long description or name of the primary source of referral to the institution.	VARCHAR2(255)	ADMISSIONS_APPLICATION	PRIMARY_SOURCE_DESC	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
PRIMARY_SOURCE_SD	Short description or name of the primary source of referral to the institution.	VARCHAR2(255)	ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION	PRIMARY_SOURCE_DESC PRIMARY_SOURCE_DESC	NO NO	NO	ADMISSIONS APPLICATION  RECRUITING AND ADMISSION
RECRUITER	Recruiter assigned to the prospect's recruiting record.	VARCHAR2(63)	ADMISSIONS_APPLICATION	RECRUITER	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
RECRUITER_LD	Assigned recruiter's name.	VARCHAR2(255)	ADMISSIONS_APPLICATION	RECRUITER_DESC	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
RECRUITER_SD	Assigned recruiter's name.	VARCHAR2(255)	ADMISSIONS_APPLICATION	RECRUITER_DESC	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
RECRUIT_TYPE	Identifies the type of recruit used to classify this prospect.	VARCHAR2(63)	ADMISSIONS_APPLICATION	RECRUIT_TYPE	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
RECRUIT_TYPE_LD	Recruit type description.	VARCHAR2(255)	ADMISSIONS_APPLICATION	RECRUIT_TYPE_DESC	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
RECRUIT_TYPE_SD	Recruit type description.	VARCHAR2(255)	ADMISSIONS_APPLICATION	RECRUIT_TYPE_DESC	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
STUDENT_APPLICATION_KEY	Key for the student application dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
WITHDRAWAL_REASON	Reason the applicant withdraws an application or chooses not to attend this institution.	VARCHAR2(63)	ADMISSIONS_APPLICATION	WITHDRAWAL_REASON	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
WITHDRAWAL_REASON_LD	Reason for withdrawal description.	VARCHAR2(255)	ADMISSIONS_APPLICATION	WITHDRAWAL_REASON_DESC	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
WITHDRAWAL_REASON_SD	Reason for withdrawal description.	VARCHAR2(255)	ADMISSIONS_APPLICATION	WITHDRAWAL_REASON_DESC	NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION

Ver: 8.1