Banner EDW Source: EXP_LY_RETENTION_STATUSES

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
PREV_YR_DONOR_ACQUIRED_IND_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_INSTITUTION WAT_RQPP_YEARLY_DES_DEPT	PREV_YR_DONOR_ACQUIRED_IND PREV_YR_DONOR_ACQUIRED_IND PREV_YR_DONOR_ACQUIRED_IND	RQPP YEARLY DES COLL RQPP YEARLY INSTITUTION RQPP YEARLY DES DEPT	NO NO NO
PREV_YR_DONOR_LAPSED_IND_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_INSTITUTION	PREV_YR_DONOR_LAPSED_IND PREV_YR_DONOR_LAPSED_IND PREV_YR_DONOR_LAPSED_IND	RQPP YEARLY DES DEPT RQPP YEARLY DES COLL RQPP YEARLY INSTITUTION	NO NO NO
PREV_YR_DONOR_REACTIVATED_IND_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_INSTITUTION WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_DES_DEPT	PREV_YR_DONOR_REACTIVATED_IND PREV_YR_DONOR_REACTIVATED_IND PREV_YR_DONOR_REACTIVATED_IND	RQPP YEARLY INSTITUTION RQPP YEARLY DES COLL RQPP YEARLY DES DEPT	NO NO NO
PREV_YR_DONOR_RETAINED_IND_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_INSTITUTION	PREV_YR_DONOR_RETAINED_IND PREV_YR_DONOR_RETAINED_IND PREV_YR_DONOR_RETAINED_IND	RQPP YEARLY DES COLL RQPP YEARLY DES DEPT RQPP YEARLY INSTITUTION	NO NO NO

Ver: 9.0