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	ADMINISTRATOR
ADMINISTRATOR_DEMOGRAPHIC_KEY	Key for the demographic dimension joined to the administrator UID.	NUMBER	ETL GENERATED	NA	NO	NO	ADMINISTRATOR
ADMINISTRATOR_ROLE_KEY	Key for the administrator role dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMINISTRATOR
ADMINISTRATOR_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	ADMINISTRATOR	ADMINISTRATOR_UID	NO	NO	ADMINISTRATOR
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMINISTRATOR
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMINISTRATOR
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	ADMINISTRATOR	PERSON_UID	NO	NO	ADMINISTRATOR
RECORD_NUMBER	Key for the recruit number or application number joined with the sequence number dimension.	NUMBER	ADMINISTRATOR	APPLICATION_RECRUIT_NUMBER	NO	NO	ADMINISTRATOR
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(10)	ETL GENERATED	DECODE(MODULE,'A','ADMISSIONS','R','RECRUIT', NULL)	NO	NO	ADMINISTRATOR
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	ADMINISTRATOR
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	ADMINISTRATOR

Ver: 9.0