Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
AVAILABLE_CONSTITUENT_COUNT		NUMBER	EXPRESSION	AVAILABLE_CONSTITUENT_COUNT_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
AVAIL_CONST_IND		NUMBER	CONSTANT	1	NO	NO	RQPP YEARLY DES DEPT
CONS_YRS_OF_PARTICIPATION		NUMBER	TMP_WAT_RQPP_DES_DEPT_INT	CONS_YOG	NO	NO	RQPP YEARLY DES DEPT
CUMUL_TOTAL_PARTICIP_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	CUMUL_TOTAL_PARTICIP_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
DESIGNATION_DEPT_KEY		NUMBER	TMP_WAT_RQPP_DES_DEPT_INT	DES_DEPT_KEY	NO	NO	RQPP YEARLY DES DEPT
DONOR_10_YR_IND		NUMBER	EXP_3_5_7_10	DONOR_10_YR_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
DONOR_3_YR_IND		NUMBER	EXP_3_5_7_10	DONOR_3_YR_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
DONOR_5_YR_IND		NUMBER	EXP_3_5_7_10	DONOR_5_YR_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
DONOR_7_YR_IND		NUMBER	EXP_3_5_7_10	DONOR_7_YR_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
DONOR_ACQUIRED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_ACQUIRED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
DONOR_CONST_IND		NUMBER	EXP_DOWNGRADE_UPGRADE_CONST	DONOR_CONST_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
DONOR_DOWNGRADE_IND		NUMBER	EXP_DOWNGRADE_UPGRADE_CONST	DONOR_DOWNGRADE_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
DONOR_LAPSED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_LAPSED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
DONOR_NEW_RETAINED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_NEW_RETAINED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
DONOR_NON_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_NON_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
DONOR_REACTIVATED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_REACTIVATED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
DONOR_RETAINED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_RETAINED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
DONOR_UPGRADE_IND		NUMBER	EXP_DOWNGRADE_UPGRADE_CONST	DONOR_UPGRADE_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
ENTITY_KEY	System generated, unique, internal primary key for an entity.	NUMBER	TMP_WAT_RQPP_DES_DEPT_INT	ENTITY_KEY	NO	NO	RQPP YEARLY DES DEPT
ENTITY_UID		NUMBER	TMP_WAT_RQPP_DES_DEPT_INT	ENTITY_UID	NO	NO	RQPP YEARLY DES DEPT
GIVING_ACTIVITY_IND		NUMBER	EXP_REPLACE_NULL_VALUES	GIVING_ACTIVITY_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
LONG_LAPSE_IND		NUMBER	EXP_SHORT_LONG_LAPSE	LONG_LAPSE_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
LYBUNT_IND		NUMBER	EXP_LYBUNT_SYBUNT	LYBUNT_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
MATCH_CLAIM_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	MATCH_CLAIM_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
MATCH_HARD_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	MATCH_HARD_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
MATCH_SOFT_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	MATCH_SOFT_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
MULTI_SOURCE_KEY		NUMBER	TMP_WAT_RQPP_DES_DEPT_INT	MULTI_SOURCE_KEY	NO	NO	RQPP YEARLY DES DEPT
OUTRIGHT_GIFT_HARD_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	OUTRIGHT_GIFT_HARD_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
OUTRIGHT_GIFT_SOFT_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	OUTRIGHT_GIFT_SOFT_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
PARTICIPATION_DONOR_COUNT		NUMBER	EXPRESSION	PARTICIPATION_DONOR_COUNT_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
PARTICIP_DONOR_IND		NUMBER	EXP_REPLACE_NULL_VALUES	PARTICIP_DONOR_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
PLEDGED_HARD_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	PLEDGED_HARD_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
PLEDGED_SOFT_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	PLEDGED_SOFT_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
PLEDGE_PAYMENT_HARD_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	PLEDGE_PAYMENT_HARD_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
PLEDGE_PAYMENT_SOFT_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	PLEDGE_PAYMENT_SOFT_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
PREV_YR_DONOR_ACQUIRED_IND		NUMBER	EXP_LY_RETENTION_STATUSES	PREV_YR_DONOR_ACQUIRED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
PREV_YR_DONOR_CONSTANT_IND		NUMBER	EXP_LY_DOWN_UPGR_CONST	PREV_YR_DONOR_CONSTANT_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
PREV_YR_DONOR_DOWNGRADE_IND		NUMBER	EXP_LY_DOWN_UPGR_CONST	PREV_YR_DONOR_DOWNGRADE_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
PREV_YR_DONOR_LAPSED_IND		NUMBER	EXP_LY_RETENTION_STATUSES	PREV_YR_DONOR_LAPSED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
PREV_YR_DONOR_REACTIVATED_IND		NUMBER	EXP_LY_RETENTION_STATUSES	PREV_YR_DONOR_REACTIVATED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
PREV_YR_DONOR_RETAINED_IND		NUMBER	EXP_LY_RETENTION_STATUSES	PREV_YR_DONOR_RETAINED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
PREV_YR_DONOR_UPGRADE_IND		NUMBER	EXP_LY_DOWN_UPGR_CONST	PREV_YR_DONOR_UPGRADE_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
PREV_YR_PARTICIP_DONOR_IND		NUMBER	EXP_LY_RETENTION_CONDITIONS	PREV_YR_PARTICIP_DONOR_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
SHORT_LAPSE_IND		NUMBER	EXP_SHORT_LONG_LAPSE	SHORT_LAPSE_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
SYBUNT_IND		NUMBER	EXP_LYBUNT_SYBUNT	SYBUNT_IND_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT	'RQPP_YEARLY_DES_COLL_A1'	NO	NO	RQPP YEARLY DES DEPT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
TOTAL_PARTICIPATION_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	TOTAL_PARTICIPATION_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
TOTAL_PARTICIP_AMT_1_YR_PRIOR		NUMBER	EXP_REPLACE_NULL_VALUES	TOTAL_PARTICIP_AMT_1_YR_PRIOR_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
TOTAL_PARTICIP_AMT_2_YR_PRIOR		NUMBER	EXP_REPLACE_NULL_VALUES	TOTAL_PARTICIP_AMT_2_YR_PRIOR_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
TOTAL_PARTICIP_AMT_3_YR_PRIOR		NUMBER	EXP_REPLACE_NULL_VALUES	TOTAL_PARTICIP_AMT_3_YR_PRIOR_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
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
YEAR_OF_GIVING		NUMBER	TMP_WAT_RQPP_DES_DEPT_INT	YEAR_OF_GIVING	NO	NO	RQPP YEARLY DES DEPT
YEAR_OF_GIVING_KEY		NUMBER	CLN_YEAR_OF_GIVING	YEAR_OF_GIVING_KEY	NO	NO	RQPP YEARLY DES DEPT
YOG_LATEST_PARTICIP_AMT		NUMBER	EXP_LATEST_GIVING_YR_AMT	YOG_LATEST_PARTICIP_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT
YOG_LATEST_PARTICIP_YEAR		NUMBER	EXP_LATEST_GIVING_YR_AMT	YOG_LATEST_PARTICIP_YEAR_EXPRESSION	NO	NO	RQPP YEARLY DES DEPT

Ver: 9.0