Banner EDW Source: WAT_RQPP_YEARLY_INSTITUTION

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
CONS_YRS_OF_PARTICIPATION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY WAT_RQPP_ENTITY	CUR_YR_CONS_YRS_OF_PARTICIP PRIOR_YR_CONS_YRS_OF_PARTICIP	RQPP ENTITY RQPP ENTITY	NO NO
DONOR_ACQUIRED_IND	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY WAT_RQPP_ENTITY	CURR_DONOR_ACQUIRED_IND PRIOR_DONOR_ACQUIRED_IND	RQPP ENTITY RQPP ENTITY	NO NO
DONOR_CONST_IND	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY WAT_RQPP_ENTITY	CURR_DONOR_CONST_IND PRIOR_DONOR_CONST_IND	RQPP ENTITY RQPP ENTITY	NO NO
DONOR_DOWNGRADE_IND	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY WAT_RQPP_ENTITY	PRIOR_DONOR_DOWNGRADE_IND CURR_DONOR_DOWNGRADE_IND	RQPP ENTITY RQPP ENTITY	NO NO
DONOR_LAPSED_IND	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY WAT_RQPP_ENTITY	CURR_DONOR_LAPSED_IND PRIOR_DONOR_LAPSED_IND	RQPP ENTITY RQPP ENTITY	NO NO
DONOR_NEW_RETAINED_IND	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY WAT_RQPP_ENTITY	PRIOR_DONOR_NEW_RETAINED_IND CURR_DONOR_NEW_RETAINED_IND	RQPP ENTITY RQPP ENTITY	NO NO
DONOR_NON_IND	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY WAT_RQPP_ENTITY	CURR_DONOR_NON_IND PRIOR_DONOR_NON_IND	RQPP ENTITY RQPP ENTITY	NO NO
DONOR_REACTIVATED_IND	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY WAT_RQPP_ENTITY	CURR_DONOR_REACTIVATED_IND PRIOR_DONOR_REACTIVATED_IND	RQPP ENTITY RQPP ENTITY	NO NO
DONOR_RETAINED_IND	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY WAT_RQPP_ENTITY	PRIOR_DONOR_RETAINED_IND CURR_DONOR_RETAINED_IND	RQPP ENTITY RQPP ENTITY	NO NO
DONOR_UPGRADE_IND	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY WAT_RQPP_ENTITY	CURR_DONOR_UPGRADE_IND PRIOR_DONOR_UPGRADE_IND	RQPP ENTITY RQPP ENTITY	NO NO
ENTITY_KEY	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	ENTITY_KEY	RQPP ENTITY	NO
LONG_LAPSE_IND	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	CUR_YR_LONG_LAPSE_IND	RQPP ENTITY	NO
LYBUNT_IND	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY WAT_RQPP_ENTITY	CUR_YR_LYBUNT_IND PRIOR_YR_LYBUNT_IND	RQPP ENTITY RQPP ENTITY	NO NO
MULTI_SOURCE_KEY	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	MULTI_SOURCE_KEY	RQPP ENTITY	NO
SHORT_LAPSE_IND	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	CUR_YR_SHORT_LAPSE_IND	RQPP ENTITY	NO
SYBUNT_IND	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY WAT_RQPP_ENTITY	CUR_YR_SYBUNT_IND PRIOR_YR_SYBUNT_IND	RQPP ENTITY RQPP ENTITY	NO NO

Ver: 9.0