Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CONTACT_COUNT_KEY	Key for the contact attribute count.	NUMBER	ETL GENERATED	NA	NO	NO	CONTACT
CONTACT_DATE	Date of the contact. This is linked to the calendar date dimension.	DATE	CONTACT	CONTACT_DATE	NO	NO	CONTACT
CONTACT_GROUP_KEY	Unique identifier for all the Banner contacts recorded for this person.	NUMBER	ETL GENERATED	NA	NO	NO	CONTACT
CONTACT_KEY	Key of the contact dimension.	NUMBER	ETL GENERATED	NA	NO	NO	CONTACT
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	CONTACT
FIRST_CONTACT_IND	Indicator of whether this is the first contact for this person. This is linked to the indicator dimension.	NUMBER	CONTACT	CONTACT_DATE	NO	NO	CONTACT
LATEST_CONTACT_IND	Indicator of whether this is the latest contact for this person. This is linked to the indicator dimension.	NUMBER	CONTACT	CONTACT_DATE	NO	NO	CONTACT
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	CONTACT
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	CONTACT	PERSON_UID	NO	NO	CONTACT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	CONTACT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	CONTACT

Ver: 9.0