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 INSTITUTION
AVAIL_CONST_IND		NUMBER	CONSTANT	1	NO	NO	RQPP YEARLY INSTITUTION
CONS_YRS_OF_PARTICIPATION		NUMBER	EXP_REPLACE_NULL_VALUES	CONS_YRS_OF_PARTICIPATION_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
CUMUL_TOTAL_PARTICIP_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	CUMUL_TOTAL_PARTICIP_AMT_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
DONOR_10_YR_IND		NUMBER	EXP_3_5_7_10_IND	DONOR_10_YR_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
DONOR_3_YR_IND		NUMBER	EXP_3_5_7_10_IND	DONOR_3_YR_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
DONOR_5_YR_IND		NUMBER	EXP_3_5_7_10_IND	DONOR_5_YR_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
DONOR_7_YR_IND		NUMBER	EXP_3_5_7_10_IND	DONOR_7_YR_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
DONOR_ACQUIRED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_ACQUIRED_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
DONOR_CONST_IND		NUMBER	EXP_DOWNGRADE_UPGRADE_CONST	DONOR_CONST_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
DONOR_DOWNGRADE_IND		NUMBER	EXP_DOWNGRADE_UPGRADE_CONST	DONOR_DOWNGRADE_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
DONOR_LAPSED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_LAPSED_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
DONOR_NEW_RETAINED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_NEW_RETAINED_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
DONOR_NON_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_NON_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
DONOR_REACTIVATED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_REACTIVATED_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
DONOR_RETAINED_IND		NUMBER	EXP_RETENTION_STATUSES	DONOR_RETAINED_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
DONOR_UPGRADE_IND		NUMBER	EXP_DOWNGRADE_UPGRADE_CONST	DONOR_UPGRADE_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
ENTITY_KEY	System generated, unique, internal primary key for an entity.	NUMBER	AGGREGATOR AGG_LAST_YOG_2BAK	ENTITY_KEY DONOR_ENTITY_KEY	NO NO	NO	RQPP YEARLY INSTITUTION  RQPP YEARLY INSTITUTION
ENTITY_UID		NUMBER	TMP_WAT_RQPP_ENTITY_YEAR	ENTITY_UID	NO	NO	RQPP YEARLY INSTITUTION
GIVING_ACTIVITY_IND		NUMBER	EXP_REPLACE_NULL_VALUES	GIVING_ACTIVITY_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
LONG_LAPSE_IND		NUMBER	EXP_SHORT_LONG_LAPSE	LONG_LAPSE_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
LYBUNT_IND		NUMBER	EXP_LYBUNT_SYBUNT	LYBUNT_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
MATCH_CLAIM_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	MATCH_CLAIM_AMT_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
MATCH_HARD_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	MATCH_HARD_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
MATCH_SOFT_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	MATCH_SOFT_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
MULTI_SOURCE_KEY		NUMBER	TMP_WAT_RQPP_AFP_CYOG	MULTI_SOURCE_KEY	NO	NO	RQPP YEARLY INSTITUTION
OUTRIGHT_GIFT_HARD_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	OUTRIGHT_GIFT_HARD_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
OUTRIGHT_GIFT_SOFT_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	OUTRIGHT_GIFT_SOFT_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
PARTICIPATION_DONOR_COUNT		NUMBER	EXPRESSION_COUNT	PARTICIPATION_DONOR_COUNT_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
PARTICIP_DONOR_IND		NUMBER	EXP_REPLACE_NULL_VALUES	PARTICIP_DONOR_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
PLEDGED_HARD_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	PLEDGED_HARD_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
PLEDGED_SOFT_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	PLEDGED_SOFT_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
PLEDGE_PAYMENT_HARD_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	PLEDGE_PAYMENT_HARD_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
PLEDGE_PAYMENT_SOFT_CREDIT_AMT		NUMBER	EXP_REPLACE_NULL_VALUES	PLEDGE_PAYMENT_SOFT_CREDIT_AMT_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
PREV_YR_DONOR_ACQUIRED_IND		NUMBER	EXP_LY_RETENTION_STATUSES	PREV_YR_DONOR_ACQUIRED_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
PREV_YR_DONOR_CONSTANT_IND		NUMBER	EXP_LY_UPGR_DOWNGR_CONST	PREV_YR_DONOR_CONSTANT_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
PREV_YR_DONOR_DOWNGRADE_IND		NUMBER	EXP_LY_UPGR_DOWNGR_CONST	PREV_YR_DONOR_DOWNGRADE_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
PREV_YR_DONOR_LAPSED_IND		NUMBER	EXP_LY_RETENTION_STATUSES	PREV_YR_DONOR_LAPSED_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
PREV_YR_DONOR_REACTIVATED_IND		NUMBER	EXP_LY_RETENTION_STATUSES	PREV_YR_DONOR_REACTIVATED_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
PREV_YR_DONOR_RETAINED_IND		NUMBER	EXP_LY_RETENTION_STATUSES	PREV_YR_DONOR_RETAINED_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
PREV_YR_DONOR_UPGRADE_IND		NUMBER	EXP_LY_UPGR_DOWNGR_CONST	PREV_YR_DONOR_UPGRADE_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
PREV_YR_PARTICIP_DONOR_IND		NUMBER	EXP_LY_RETENTION_CONDITIONS	PREV_YR_PARTICIP_DONOR_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
SHORT_LAPSE_IND		NUMBER	EXP_SHORT_LONG_LAPSE	SHORT_LAPSE_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
SYBUNT_IND		NUMBER	EXP_LYBUNT_SYBUNT	SYBUNT_IND_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT	'RQPP_YEARLY_INSTITUTION_A1'	NO	NO	RQPP YEARLY INSTITUTION
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 INSTITUTION
TOTAL_PARTICIP_AMT_1_YR_PRIOR		NUMBER	EXP_REPLACE_NULL_VALUES	TOTAL_PARTICIP_AMT_1_YR_PRIOR_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
TOTAL_PARTICIP_AMT_2_YR_PRIOR		NUMBER	EXP_REPLACE_NULL_VALUES	TOTAL_PARTICIP_AMT_2_YR_PRIOR_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
TOTAL_PARTICIP_AMT_3_YR_PRIOR		NUMBER	EXP_REPLACE_NULL_VALUES	TOTAL_PARTICIP_AMT_3_YR_PRIOR_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
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_AFP_CYOG	YEAR_OF_GIVING	NO	NO	RQPP YEARLY INSTITUTION
YEAR_OF_GIVING_KEY		NUMBER	CLN_YEAR_OF_GIVING	YEAR_OF_GIVING_KEY	NO	NO	RQPP YEARLY INSTITUTION
YOG_LATEST_PARTICIP_AMT		NUMBER	EXP_LATEST_GIVING_YR_AMT	YOG_LATEST_PARTICIP_AMT_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION
YOG_LATEST_PARTICIP_YEAR		NUMBER	EXP_LATEST_GIVING_YR_AMT	YOG_LATEST_PARTICIP_YEAR_EXPRESSION	NO	NO	RQPP YEARLY INSTITUTION

Ver: 9.0