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 APPLICATION
ACADEMIC_TIME_KEY	Key of the Academic Time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
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 Application Date(s).	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
ADMISSIONS_CYCLE_MONTH	For future use.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
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 Application Date(s).	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
ADMS_APPL_SRCE_GROUP_KEY	Group keu for Admissions Application Source.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
APPLICATION_COMPLETE_IND	Indicates if the admissions application is complete and ready for review.	NUMBER	ADMISSIONS_APPLICATION	COMPLETE_IND	NO	NO	ADMISSIONS APPLICATION
APPLICATION_DATE	Date of application.	DATE	ADMISSIONS_APPLICATION	APPLICATION_DATE	NO	NO	ADMISSIONS APPLICATION
APPLICATION_FEE_RECEIVED_DATE	Date application fee has been assessed.	DATE	ADMISSIONS_APPLICATION	APPLICATION_FEE_RECEIVED_DATE	NO	NO	ADMISSIONS APPLICATION
APPLICATION_FEE_REQUIRED_IND	Indicates whether an application fee has been assessed.	NUMBER	ADMISSIONS_APPLICATION	APPLICATION_FEE_REQUIRED_IND	NO	NO	ADMISSIONS APPLICATION
APPLICATION_NUMBER_KEY	Key for the application number linked to the sequence dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
APPLICATION_RANKING_KEY	Key for the application ranking linked to the sequence dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
APPLICATION_STATUS_DATE	Date associated with the most current status of the application.	DATE	ADMISSIONS_APPLICATION	APPLICATION_STATUS_DATE	NO	NO	ADMISSIONS APPLICATION
APPLICATION_SUPL_DATA_KEY	Key for the application supplemental data dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
APPLICATION_SUPL_IND_KEY	Key for the application supplemental indicator dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
FINANCIAL_AID_STATUS_KEY	Key for the financial aid status dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
FINANCIAL_AID_YEAR_KEY	Key for the financial aid year dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	ADMISSIONS_APPLICATION	PERSON_UID	NO	NO	ADMISSIONS APPLICATION
POSTAL_KEY	Key for the postal dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
PRE_STUDENT_STATUS_KEY	Key for the pre-student status dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
STUDENT_APPLICATION_KEY	Key for the student application dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
STUDENT_KEY	Key for the Student dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION
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
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION

Ver: 9.0