Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
AFFINITY_RATING	General affinity rating for the constituent, prospect or program prospect, for example, High, Negative, Unknown.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
AFFINITY_RATING_LD	Long description for the affinity rating.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
AFFINITY_RATING_SD	Short description for the affinity rating.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
CONSTITUENT_EVALUATION_KEY		NUMBER				NO
EVALUATION_RATING	Evaluation rating assigned to the constituent, prospect or program prospect. Example: $1,000 - 10,000, or High, Medium, Low.	VARCHAR2(63)	AMRPRRT	AMRPRRT_RATE_CODE	NO	NO	CONSTITUENT EVALUATION
EVALUATION_RATING_LD	Long description for the evaluation rating.	VARCHAR2(255)	ATVRATE	ATVRATE_DESC	NO	NO	CONSTITUENT EVALUATION
EVALUATION_RATING_SD	Short description for the evaluation rating.	VARCHAR2(255)	ATVRATE	ATVRATE_DESC	NO	NO	CONSTITUENT EVALUATION
EVALUATION_SOURCE	The source or origin of the evaluation information.	VARCHAR2(63)	AMRPRRT	AMRPRRT_RSCR_CODE	NO	NO	CONSTITUENT EVALUATION
EVALUATION_SOURCE_LD	Long description for the evaluation source.	VARCHAR2(255)	ATVRSCR	ATVRSCR_DESC	NO	NO	CONSTITUENT EVALUATION
EVALUATION_SOURCE_SD	Short description for the evaluation source.	VARCHAR2(255)	ATVRSCR	ATVRSCR_DESC	NO	NO	CONSTITUENT EVALUATION
EVALUATION_TYPE	This identifies the type of evaluation recorded for the prospect or the program prospect.	VARCHAR2(63)	AMRPRRT	AMRPRRT_RTGT_CODE	NO	NO	CONSTITUENT EVALUATION
EVALUATION_TYPE_LD	Long description for the evaluation type.	VARCHAR2(255)	ATVRTGT	ATVRTGT_DESC	NO	NO	CONSTITUENT EVALUATION
EVALUATION_TYPE_SD	Short description for the evaluation type.	VARCHAR2(255)	ATVRTGT	ATVRTGT_DESC	NO	NO	CONSTITUENT EVALUATION
GIVING_CAPACITY	General giving capacity rating for the constituent, prospect or program prospect, for example: High, medium, low.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
GIVING_CAPACITY_LD	Long description for the giving capacity rating.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
GIVING_CAPACITY_SD	Short description for the giving capacity rating.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
PARTICIPATION_RATING	Provides an assessment or estimate of the level of interest in participating as a volunteer or committee member, for example: High volunteer level, Low volunteer level.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
PARTICIPATION_RATING_LD	Long description for the evaluation interest rating.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
PARTICIPATION_RATING_SD	Short description for the evaluation interest rating.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'CONSTITUENT_EVALUATION_D1B'	NO	NO	CONSTITUENT EVALUATION
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