Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
AVAILABLE_CONSTITUENT_COUNT		NUMBER	EXPRESSION_COUNT	AVAILABLE_CONSTITUENT_COUNT_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
AVAIL_CONST_IND		NUMBER	CONSTANT	1	NO	NO	RQPP YEARLY DES COLL
CONS_YRS_OF_PARTICIPATION		NUMBER	TMP_WAT_RQPP_DES_COLL_INT	CONS_YOG	NO	NO	RQPP YEARLY DES COLL
CUMUL_TOTAL_PARTICIP_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	CUMUL_TOTAL_PARTICIP_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
DESIGNATION_COLLEGE_KEY		NUMBER	TMP_WAT_RQPP_DES_COLL_INT	DES_COLL_KEY	NO	NO	RQPP YEARLY DES COLL
DONOR_10_YR_IND		NUMBER	3_5_7_10_REPEAT_DONOR	DONOR_10_YR_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
DONOR_3_YR_IND		NUMBER	3_5_7_10_REPEAT_DONOR	DONOR_3_YR_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
DONOR_5_YR_IND		NUMBER	3_5_7_10_REPEAT_DONOR	DONOR_5_YR_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
DONOR_7_YR_IND		NUMBER	3_5_7_10_REPEAT_DONOR	DONOR_7_YR_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
DONOR_ACQUIRED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_ACQUIRED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
DONOR_CONST_IND		NUMBER	EXP_DOWNGRADE_UPGRADE_CONST	DONOR_CONST_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
DONOR_DOWNGRADE_IND		NUMBER	EXP_DOWNGRADE_UPGRADE_CONST	DONOR_DOWNGRADE_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
DONOR_LAPSED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_LAPSED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
DONOR_NEW_RETAINED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_NEW_RETAINED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
DONOR_NON_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_NON_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
DONOR_REACTIVATED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_REACTIVATED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
DONOR_RETAINED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_RETAINED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
DONOR_UPGRADE_IND		NUMBER	EXP_DOWNGRADE_UPGRADE_CONST	DONOR_UPGRADE_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
ENTITY_KEY	System generated, unique, internal primary key for an entity.	NUMBER	TMP_WAT_RQPP_DES_COLL_INT	ENTITY_KEY	NO	NO	RQPP YEARLY DES COLL
ENTITY_UID		NUMBER	TMP_WAT_RQPP_DES_COLL_INT	ENTITY_UID	NO	NO	RQPP YEARLY DES COLL
GIVING_ACTIVITY_IND		NUMBER	EXP_REPLACE_NULL_VALUES	GIVING_ACTIVITY_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
LONG_LAPSE_IND		NUMBER	EXP_SHORT_LONG_LAPSE	LONG_LAPSE_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
LYBUNT_IND		NUMBER	EXP_LYBUNT_SYBUNT	LYBUNT_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
MATCH_CLAIM_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	MATCH_CLAIM_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
MATCH_HARD_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	MATCH_HARD_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
MATCH_SOFT_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	MATCH_SOFT_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
MULTI_SOURCE_KEY		NUMBER	TMP_WAT_RQPP_DES_COLL_INT	MULTI_SOURCE_KEY	NO	NO	RQPP YEARLY DES COLL
OUTRIGHT_GIFT_HARD_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	OUTRIGHT_GIFT_HARD_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
OUTRIGHT_GIFT_SOFT_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	OUTRIGHT_GIFT_SOFT_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
PARTICIPATION_DONOR_COUNT		NUMBER	EXPRESSION_COUNT	PARTICIPATION_DONOR_COUNT_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
PARTICIP_DONOR_IND		NUMBER	EXP_REPLACE_NULL_VALUES	PARTICIP_DONOR_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
PLEDGED_HARD_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	PLEDGED_HARD_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
PLEDGED_SOFT_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	PLEDGED_SOFT_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
PLEDGE_PAYMENT_HARD_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	PLEDGE_PAYMENT_HARD_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
PLEDGE_PAYMENT_SOFT_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	PLEDGE_PAYMENT_SOFT_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
PREV_YR_DONOR_ACQUIRED_IND		NUMBER	EXP_LY_RETENTION_STATUSES	PREV_YR_DONOR_ACQUIRED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
PREV_YR_DONOR_CONSTANT_IND		NUMBER	EXP_LY_DOWN_UPGR_CONST	PREV_YR_DONOR_CONSTANT_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
PREV_YR_DONOR_DOWNGRADE_IND		NUMBER	EXP_LY_DOWN_UPGR_CONST	PREV_YR_DONOR_DOWNGRADE_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
PREV_YR_DONOR_LAPSED_IND		NUMBER	EXP_LY_RETENTION_STATUSES	PREV_YR_DONOR_LAPSED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
PREV_YR_DONOR_REACTIVATED_IND		NUMBER	EXP_LY_RETENTION_STATUSES	PREV_YR_DONOR_REACTIVATED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
PREV_YR_DONOR_RETAINED_IND		NUMBER	EXP_LY_RETENTION_STATUSES	PREV_YR_DONOR_RETAINED_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
PREV_YR_DONOR_UPGRADE_IND		NUMBER	EXP_LY_DOWN_UPGR_CONST	PREV_YR_DONOR_UPGRADE_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
PREV_YR_PARTICIP_DONOR_IND		NUMBER	EXP_LY_RET_CONDITIONS	PREV_YR_PARTICIP_DONOR_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
SHORT_LAPSE_IND		NUMBER	EXP_SHORT_LONG_LAPSE	SHORT_LAPSE_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
SYBUNT_IND		NUMBER	EXP_LYBUNT_SYBUNT	SYBUNT_IND_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
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 COLL
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 COLL
TOTAL_PARTICIP_AMT_1_YR_PRIOR		NUMBER	EXP_REPLACE_NULL_VALUES	TOTAL_PARTICIP_AMT_1_YR_PRIOR_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
TOTAL_PARTICIP_AMT_2_YR_PRIOR		NUMBER	EXP_REPLACE_NULL_VALUES	TOTAL_PARTICIP_AMT_2_YR_PRIOR_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
TOTAL_PARTICIP_AMT_3_YR_PRIOR		NUMBER	EXP_REPLACE_NULL_VALUES	TOTAL_PARTICIP_AMT_3_YR_PRIOR_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
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_COLL_INT	YEAR_OF_GIVING	NO	NO	RQPP YEARLY DES COLL
YEAR_OF_GIVING_KEY		NUMBER	CLN_YEAR_OF_GIVING	YEAR_OF_GIVING_KEY	NO	NO	RQPP YEARLY DES COLL
YOG_LATEST_PARTICIP_AMT		NUMBER	EXP_LATEST_GIVING_YR_AMT	YOG_LATEST_PARTICIP_AMT_EXPRESSION	NO	NO	RQPP YEARLY DES COLL
YOG_LATEST_PARTICIP_YEAR		NUMBER	EXP_LATEST_GIVING_YR_AMT	YOG_LATEST_PARTICIP_YEAR_EXPRESSION	NO	NO	RQPP YEARLY DES COLL

Ver: 9.0