Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_STUDY_KEY	Key for the academic study dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
ACADEMIC_TIME_KEY	Key of the Academic Time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
ADMISSIONS_CYCLE_DAY	Provides a count of days from the user-defined Admissions Cycle Start Date for the Academic Period in Period in context and the prospective student���s Admissions Recruitment Date(s).	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
ADMISSIONS_CYCLE_MONTH	For future use.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
ADMISSIONS_CYCLE_WEEK	Provides a count of 7 day intervals from the user-defined Admissions Cycle Start Date for the Academic Period in context and the prospective student���s Admissions Recruitment Date(s).	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
ADMS_RECR_SRCE_GROUP_KEY	Group key for Admissions Recruitment Source.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
FINANCIAL_AID_STATUS_KEY	Key for the financial aid status dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
FINANCIAL_AID_YEAR_KEY	Key for the financial aid year dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RECRUITMENT_INFORMATION	PERSON_UID	NO	NO	ADMISSIONS RECRUITMENT
PRE_STUDENT_STATUS_KEY	Key for the pre-student status dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
PRIMARY_RECRUIT_RECORD_IND	Indicates whether this record is the current or most recent recruiting record. Only one record per term may be selected.	NUMBER	RECRUITMENT_INFORMATION	PRIMARY_RECRUIT_RECORD_IND	NO	NO	ADMISSIONS RECRUITMENT
RECRUIT_ADD_DATE	Date the record was added.	DATE	RECRUITMENT_INFORMATION	DATE_ADDED	NO	NO	ADMISSIONS RECRUITMENT
RECRUIT_NUMBER_KEY	Key for the recruit number joined with the sequence number dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
STUDENT_KEY	Key for the Student dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
STUDENT_RECRUITMENT_KEY	Key for the student recruitment dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	ADMISSIONS RECRUITMENT

Ver: 9.0