Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACTIVE_EVALUATION_IND	Indicates if this evaluation is active or inactive; 1= Active, 0 = Inactive. For Banner this indicator is always 1.	NUMBER	CONSTANT_0	1	NO	NO	CONSTITUENT EVALUATION
ADVANCEMENT_PROGRAM_KEY		NUMBER	CONSTANT_0	0	NO	NO	CONSTITUENT EVALUATION
ADVANCEMENT_PROGRAM_YEAR_KEY		NUMBER	CONSTANT_0	0	NO	NO	CONSTITUENT EVALUATION
CONSTITUENT_EVALUATION_KEY		NUMBER	CLN_CONSTITUENT_EVALUATION	CONSTITUENT_EVALUATION_KEY	NO	NO	CONSTITUENT EVALUATION
CONSTITUENT_EVAL_COUNT_KEY		NUMBER	GROUP_COUNT_EXPRESSION	CONSTITUENT_EVAL_COUNT_KEY_EXPRESSION	NO	NO	CONSTITUENT EVALUATION
CONSTITUENT_EVAL_DETAIL_KEY		NUMBER	CLN_CONSTITUENT_EVAL_DETAIL	CONSTITUENT_EVAL_DETAIL_KEY	NO	NO	CONSTITUENT EVALUATION
CONSTITUENT_EVAL_GROUP_KEY		NUMBER	GROUP_COUNT_EXPRESSION	CONSTITUENT_EVAL_GROUP_KEY_EXPRESSION	NO	NO	CONSTITUENT EVALUATION
ENTITY_KEY	System generated, unique, internal primary key for an entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	CONSTITUENT EVALUATION
ENTITY_UID	System generated unique internal identification number assigned to this person or organization.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	CONSTITUENT EVALUATION
EVALUATION_AMOUNT	Rated amount for this evaluation.	NUMBER	ATVRATE	ATVRATE_RATE_AMT	NO	NO	CONSTITUENT EVALUATION
EVALUATION_DATE	For Advance; date of the actual evaluation, date the evaluation was made or received or the date the evaluation is to become effective. For Banner; the date the record was added or last modified.	DATE	GROUP_COUNT_EXPRESSION	EVALUATION_DATE_EXPRESSION	NO	NO	CONSTITUENT EVALUATION
EVALUATION_DAYS	For Advance: Days since this evaluation was added (based on Profile Date). For Banner: Days since this prospect rating was added/modified (based on Activity Date).	NUMBER	GROUP_COUNT_EXPRESSION	EVALUATION_DAYS_EXPRESSION	NO	NO	CONSTITUENT EVALUATION
EVALUATOR_ENTITY_KEY		NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	CONSTITUENT EVALUATION
EVALUATOR_ENTITY_UID	System generated, unique, internal identification number assigned to this evaluator.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	CONSTITUENT EVALUATION
EVALUATOR_STAFF_KEY		NUMBER	CLN_STAFF	STAFF_KEY	NO	NO	CONSTITUENT EVALUATION
EVALUATOR_UNIT_KEY		NUMBER	CONSTANT_0	0	NO	NO	CONSTITUENT EVALUATION
MULTI_SOURCE_KEY		NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	CONSTITUENT EVALUATION
PGM_PROSPECT_EVAL_GROUP_KEY		NUMBER	NO SOURCE	NO SOURCE	NO	NO
PRIMARY_EVALUATION_IND	Indicates if this is the primary rating for the prospect; 1= Primary, 0= Non-Primary. For Advance this indicator is always 1.	NUMBER	GROUP_COUNT_EXPRESSION	PRIMARY_EVALUATION_IND_EXPRESSION	NO	NO	CONSTITUENT EVALUATION
PROSPECT_EVAL_GROUP_KEY		NUMBER	GROUP_COUNT_EXPRESSION	PROSPECT_EVAL_GROUP_KEY_EXPRESSION	NO	NO	CONSTITUENT EVALUATION
PROSPECT_KEY		NUMBER	CLN_PROSPECT	PROSPECT_KEY	NO	NO	CONSTITUENT EVALUATION
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	LOAD_PROCESS	'CONSTITUENT_EVALUATION_F1B'	NO	NO	CONSTITUENT EVALUATION
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
USER_MEASURE_01		NUMBER	NO SOURCE	NO SOURCE	NO	NO
USER_MEASURE_02		NUMBER	NO SOURCE	NO SOURCE	NO	NO
USER_MEASURE_03		NUMBER	NO SOURCE	NO SOURCE	NO	NO
USER_MEASURE_04		NUMBER	NO SOURCE	NO SOURCE	NO	NO
USER_MEASURE_05		NUMBER	NO SOURCE	NO SOURCE	NO	NO

Ver: 9.0