Banner EDW Source: EXP_REPLACE_NULL_VALUES

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_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_INSTITUTION	CONS_YRS_OF_PARTICIPATION	RQPP YEARLY INSTITUTION	NO
CUMUL_TOTAL_PARTICIP_AMT_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_INSTITUTION	CUMUL_TOTAL_PARTICIP_AMT CUMUL_TOTAL_PARTICIP_AMT CUMUL_TOTAL_PARTICIP_AMT	RQPP YEARLY DES COLL RQPP YEARLY DES DEPT RQPP YEARLY INSTITUTION	NO NO NO
GIVING_ACTIVITY_IND_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_INSTITUTION	GIVING_ACTIVITY_IND GIVING_ACTIVITY_IND GIVING_ACTIVITY_IND	RQPP YEARLY DES DEPT RQPP YEARLY DES COLL RQPP YEARLY INSTITUTION	NO NO NO
MATCH_CLAIM_AMT_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_INSTITUTION WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_DES_COLL	MATCH_CLAIM_AMT MATCH_CLAIM_AMT MATCH_CLAIM_AMT	RQPP YEARLY INSTITUTION RQPP YEARLY DES DEPT RQPP YEARLY DES COLL	NO NO NO
MATCH_HARD_CREDIT_AMT_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_INSTITUTION WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_DES_DEPT	MATCH_HARD_CREDIT_AMT MATCH_HARD_CREDIT_AMT MATCH_HARD_CREDIT_AMT	RQPP YEARLY INSTITUTION RQPP YEARLY DES COLL RQPP YEARLY DES DEPT	NO NO NO
MATCH_SOFT_CREDIT_AMT_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_INSTITUTION	MATCH_SOFT_CREDIT_AMT MATCH_SOFT_CREDIT_AMT MATCH_SOFT_CREDIT_AMT	RQPP YEARLY DES COLL RQPP YEARLY DES DEPT RQPP YEARLY INSTITUTION	NO NO NO
OUTRIGHT_GIFT_HARD_CREDIT_AMT_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_INSTITUTION WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_DES_DEPT	OUTRIGHT_GIFT_HARD_CREDIT_AMT OUTRIGHT_GIFT_HARD_CREDIT_AMT OUTRIGHT_GIFT_HARD_CREDIT_AMT	RQPP YEARLY INSTITUTION RQPP YEARLY DES COLL RQPP YEARLY DES DEPT	NO NO NO
OUTRIGHT_GIFT_SOFT_CREDIT_AMT_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_INSTITUTION	OUTRIGHT_GIFT_SOFT_CREDIT_AMT OUTRIGHT_GIFT_SOFT_CREDIT_AMT OUTRIGHT_GIFT_SOFT_CREDIT_AMT	RQPP YEARLY DES COLL RQPP YEARLY DES DEPT RQPP YEARLY INSTITUTION	NO NO NO
PARTICIP_DONOR_IND_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_INSTITUTION WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_DES_DEPT	PARTICIP_DONOR_IND PARTICIP_DONOR_IND PARTICIP_DONOR_IND	RQPP YEARLY INSTITUTION RQPP YEARLY DES COLL RQPP YEARLY DES DEPT	NO NO NO
PLEDGED_HARD_CREDIT_AMT_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_INSTITUTION	PLEDGED_HARD_CREDIT_AMT PLEDGED_HARD_CREDIT_AMT PLEDGED_HARD_CREDIT_AMT	RQPP YEARLY DES DEPT RQPP YEARLY DES COLL RQPP YEARLY INSTITUTION	NO NO NO
PLEDGED_SOFT_CREDIT_AMT_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_INSTITUTION WAT_RQPP_YEARLY_DES_DEPT	PLEDGED_SOFT_CREDIT_AMT PLEDGED_SOFT_CREDIT_AMT PLEDGED_SOFT_CREDIT_AMT	RQPP YEARLY DES COLL RQPP YEARLY INSTITUTION RQPP YEARLY DES DEPT	NO NO NO
PLEDGE_PAYMENT_HARD_CREDIT_AMT_EXPRESSIO N	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_INSTITUTION WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_DES_COLL	PLEDGE_PAYMENT_HARD_CREDIT_AMT PLEDGE_PAYMENT_HARD_CREDIT_AMT PLEDGE_PAYMENT_HARD_CREDIT_AMT	RQPP YEARLY INSTITUTION RQPP YEARLY DES DEPT RQPP YEARLY DES COLL	NO NO NO
PLEDGE_PAYMENT_SOFT_CREDIT_AMT_EXPRESSIO N	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_INSTITUTION WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_DES_COLL	PLEDGE_PAYMENT_SOFT_CREDIT_AMT PLEDGE_PAYMENT_SOFT_CREDIT_AMT PLEDGE_PAYMENT_SOFT_CREDIT_AMT	RQPP YEARLY INSTITUTION RQPP YEARLY DES DEPT RQPP YEARLY DES COLL	NO NO NO
TOTAL_PARTICIPATION_AMT_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_INSTITUTION	TOTAL_PARTICIPATION_AMT TOTAL_PARTICIPATION_AMT TOTAL_PARTICIPATION_AMT	RQPP YEARLY DES DEPT RQPP YEARLY DES COLL RQPP YEARLY INSTITUTION	NO NO NO
TOTAL_PARTICIP_AMT_1_YR_PRIOR_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_INSTITUTION WAT_RQPP_YEARLY_DES_COLL	TOTAL_PARTICIP_AMT_1_YR_PRIOR TOTAL_PARTICIP_AMT_1_YR_PRIOR TOTAL_PARTICIP_AMT_1_YR_PRIOR	RQPP YEARLY DES DEPT RQPP YEARLY INSTITUTION RQPP YEARLY DES COLL	NO NO NO
TOTAL_PARTICIP_AMT_2_YR_PRIOR_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_INSTITUTION	TOTAL_PARTICIP_AMT_2_YR_PRIOR TOTAL_PARTICIP_AMT_2_YR_PRIOR TOTAL_PARTICIP_AMT_2_YR_PRIOR	RQPP YEARLY DES COLL RQPP YEARLY DES DEPT RQPP YEARLY INSTITUTION	NO NO NO
TOTAL_PARTICIP_AMT_3_YR_PRIOR_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_INSTITUTION WAT_RQPP_YEARLY_DES_DEPT	TOTAL_PARTICIP_AMT_3_YR_PRIOR TOTAL_PARTICIP_AMT_3_YR_PRIOR TOTAL_PARTICIP_AMT_3_YR_PRIOR	RQPP YEARLY DES COLL RQPP YEARLY INSTITUTION RQPP YEARLY DES DEPT	NO NO NO

Ver: 9.0