Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_TIME_KEY	Key of the Academic Time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	APPLICATION REQUIREMENT
APPLICATION_NUMBER_KEY	Key for the application number linked to the sequence dimension.	NUMBER	ETL GENERATED	NA	NO	NO	APPLICATION REQUIREMENT
APPLICATION_REQR_GROUP_KEY	Application Reqr Group KEY.	NUMBER				NO
APPLICATION_REQUIREMENT_KEY	Key for the application requirement dimension.	NUMBER	ETL GENERATED	NA	NO	NO	APPLICATION REQUIREMENT
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	APPLICATION REQUIREMENT
FIRST_REQUEST_DATE	Date on which the requirement was first requested from the applicant.	DATE	ADMISSIONS_REQUIREMENT	FIRST_REQUEST_DATE	NO	NO	APPLICATION REQUIREMENT
MOST_RECENT_REQUEST_DATE	Date on which the requirement was last requested from the applicant.	DATE	ADMISSIONS_REQUIREMENT	MOST_RECENT_REQUEST_DATE	NO	NO	APPLICATION REQUIREMENT
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	APPLICATION REQUIREMENT
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	ADMISSIONS_REQUIREMENT	PERSON_UID	NO	NO	APPLICATION REQUIREMENT
REQUIREMENT_COMPLETED_IND	Indicates the requirement is complete. Indicator is based on a the entry of the received date.	NUMBER	ADMISSIONS_REQUIREMENT	COMPLETED_IND	NO	NO	APPLICATION REQUIREMENT
REQUIREMENT_DEADLINE_DATE	Date the specific requirement must be received from an applicant to continue admissions processing.	DATE	ADMISSIONS_REQUIREMENT	REQUIREMENT_DEADLINE_DATE	NO	NO	APPLICATION REQUIREMENT
REQUIREMENT_MANDATORY_IND	Indicates whether this requirement is mandatory or optional.	NUMBER	ADMISSIONS_REQUIREMENT	REQUIREMENT_MANDATORY_IND	NO	NO	APPLICATION REQUIREMENT
REQUIREMENT_RECEIVED_DATE	Date the requirement was received from the applicant.	DATE	ADMISSIONS_REQUIREMENT	REQUIREMENT_RECEIVED_DATE	NO	NO	APPLICATION REQUIREMENT
REQUIREMENT_REQUESTED_COUNT	Number of times the specific requirement has been requested from the applicant.	NUMBER	ADMISSIONS_REQUIREMENT	REQUIREMENT_REQUESTED_COUNT	NO	NO	APPLICATION REQUIREMENT
REQUIREMENT_WAIVED_IND	Indicates whether the requirement was waived.	NUMBER	ADMISSIONS_REQUIREMENT	WAIVED_IND	NO	NO	APPLICATION REQUIREMENT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	APPLICATION REQUIREMENT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	APPLICATION REQUIREMENT

Ver: 9.0