Banner EDW Source: EXP_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
DONOR_ACQUIRED_IND_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_INSTITUTION WAT_RQPP_YEARLY_DES_DEPT	DONOR_ACQUIRED_IND DONOR_ACQUIRED_IND DONOR_ACQUIRED_IND	RQPP YEARLY DES COLL RQPP YEARLY INSTITUTION RQPP YEARLY DES DEPT	NO NO NO
DONOR_LAPSED_IND_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_INSTITUTION	DONOR_LAPSED_IND DONOR_LAPSED_IND DONOR_LAPSED_IND	RQPP YEARLY DES COLL RQPP YEARLY DES DEPT RQPP YEARLY INSTITUTION	NO NO NO
DONOR_NEW_RETAINED_IND_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_INSTITUTION	DONOR_NEW_RETAINED_IND DONOR_NEW_RETAINED_IND DONOR_NEW_RETAINED_IND	RQPP YEARLY DES DEPT RQPP YEARLY DES COLL RQPP YEARLY INSTITUTION	NO NO NO
DONOR_NON_IND_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_INSTITUTION WAT_RQPP_YEARLY_DES_DEPT	DONOR_NON_IND DONOR_NON_IND DONOR_NON_IND	RQPP YEARLY DES COLL RQPP YEARLY INSTITUTION RQPP YEARLY DES DEPT	NO NO NO
DONOR_REACTIVATED_IND_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_INSTITUTION WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_DES_COLL	DONOR_REACTIVATED_IND DONOR_REACTIVATED_IND DONOR_REACTIVATED_IND	RQPP YEARLY INSTITUTION RQPP YEARLY DES DEPT RQPP YEARLY DES COLL	NO NO NO
DONOR_RETAINED_IND_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_INSTITUTION	DONOR_RETAINED_IND DONOR_RETAINED_IND DONOR_RETAINED_IND	RQPP YEARLY DES COLL RQPP YEARLY DES DEPT RQPP YEARLY INSTITUTION	NO NO NO

Ver: 9.0