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	COMBINED ADMISSIONS SOURCE
ADMISSIONS_SOURCE_COUNT	Count of admission sources.	NUMBER	ETL_GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE
ADMISSIONS_SOURCE_KEY	Key of the institution dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE
ADMS_APPL_SRCE_GROUP_KEY	Unique identifier for the application source.	NUMBER	ETL_GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE
ADMS_RECR_SRCE_GROUP_KEY	Unique identifier for the recruitment source.	NUMBER	ETL_GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE
COMB_ADMS_SRCE_GROUP_KEY	Unique identifier for the combined admissions source.	NUMBER	ETL_GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE
INITIAL_SOURCE_IND	Specifies whether the source type is the initial source of the application.	NUMBER	ETL_GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE
OVERALL_INITIAL_SOURCE_IND	Specifies whether the source type is the overall initial source of the application.	NUMBER	ETL_GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	ADMISSIONS_SOURCE RECRUITMENT_SOURCE	PERSON_UID PERSON_UID	NO NO	NO	COMBINED ADMISSIONS SOURCE  COMBINED ADMISSIONS SOURCE
PRIMARY_SOURCE_IND	Specifies whether the source type is the primary source of the application.	NUMBER	ADMISSIONS_SOURCE RECRUITMENT_SOURCE	PRIMARY_SOURCE_IND PRIMARY_SOURCE_IND	NO NO	NO	COMBINED ADMISSIONS SOURCE  COMBINED ADMISSIONS SOURCE
RECORD_NUMBER_KEY	Key for the recruit or admissions application record number linked to the sequence dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE
RECORD_TYPE	Identifies the Banner Record Type associated with the rule used to associate this funnel status to this prospective student. If you want to link data in the Recruiting and Admissions Performance product, the record type must be either RECRUIT or ADMISSIONS.	VARCHAR2(20)	ETL_GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE
SOURCE_REPORTED_DATE	Date the source or the reason for the recruitment information record was reported.	DATE	ADMISSIONS_SOURCE RECRUITMENT_SOURCE	DATE_SOURCE_REPORTED DATE_SOURCE_REPORTED	NO NO	NO	COMBINED ADMISSIONS SOURCE  COMBINED ADMISSIONS SOURCE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL_GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL_GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE

Ver: 9.0