Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ADVANCE_ID	Advance's entity identification.	VARCHAR2(10)	NO SOURCE	NO SOURCE	NO	NO
BANNER_PIDM	Banner's system generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	SPRIDEN	SPRIDEN_PIDM	NO	NO	CONTACT REPORT, MANAGE PROSPECT PIPELINE
SYSTEM_ID_01	Unique Identifier for a source system other than Banner or Advance	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_ID_02	Unique Identifier for a source system other than Banner or Advance	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_ID_03	Unique Identifier for a source system other than Banner or Advance	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_ID_04	Unique Identifier for a source system other than Banner or Advance	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_ID_05	Unique Identifier for a source system other than Banner or Advance	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	WAREHOUSE_ENTITY_SOURCE	'BANNER'	NO	NO
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_NAME_01	Source system name for sources other than Banner or Advance	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_NAME_02	Source system name for sources other than Banner or Advance	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_NAME_03	Source system name for sources other than Banner or Advance	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_NAME_04	Source system name for sources other than Banner or Advance	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_NAME_05	Source system name for sources other than Banner or Advance	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
WAREHOUSE_ENTITY_UID	System generated, unique, internal primary key for warehouse entity uid.	NUMBER	NO SOURCE	NO SOURCE	NO	NO

Ver: 9.0