Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CONSTITUENT_PROFILE_KEY		NUMBER				NO
PROFILE_INTEREST	This code is used to record a measure of the entity������������������������s interest in the institution, a specific giving area, or giving vehicle.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
PROFILE_INTEREST_LD	Long description of the profile interest code.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
PROFILE_INTEREST_SD	Short description of the profile interest code.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
PROFILE_LEVEL	For Advance; represents the level of detail the data covers, as defined by the type of demographic data being maintained. For Banner; specifies the matching level of the external source code.	VARCHAR2(63)	AMREXRT	AMREXRT_EXT_LEVEL	NO	NO	CONSTITUENT PROFILE
PROFILE_LEVEL_LD	Long description for the level rating achieved.	VARCHAR2(255)	AMREXRT	AMREXRT_EXT_LEVEL	NO	NO	CONSTITUENT PROFILE
PROFILE_LEVEL_SD	Short description for the level rating achieved.	VARCHAR2(255)	AMREXRT	AMREXRT_EXT_LEVEL	NO	NO	CONSTITUENT PROFILE
PROFILE_RATING	Identifies what was applied to the profile record through the rating process.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
PROFILE_RATING_LD	Long description for the profile rating.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
PROFILE_RATING_SD	Short description for the profile rating.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
PROFILE_RATING_TYPE	Identifies the type of rating information; for example ���������������������General Demographic Information,��������������������� ���������������������Prospect Identification,��������������������� etc.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
PROFILE_RATING_TYPE_LD	Long description for the rating type.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
PROFILE_RATING_TYPE_SD	Short description for the rating type.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
PROFILE_SOURCE	Identifies the source from which the rating information was obtained. For Banner this code will always be for an external source.	VARCHAR2(63)	AMREXRT	AMREXRT_EXRS_CODE	NO	NO	CONSTITUENT PROFILE
PROFILE_SOURCE_LD	Long description for profile source.	VARCHAR2(255)	ATVEXRS	ATVEXRS_DESC	NO	NO	CONSTITUENT PROFILE
PROFILE_SOURCE_SD	Short description for profile source.	VARCHAR2(255)	ATVEXRS	ATVEXRS_DESC	NO	NO	CONSTITUENT PROFILE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'CONSTITUENT_PROFILE_D1B'	NO	NO	CONSTITUENT PROFILE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	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

Ver: 9.0