RETURN TO BANNER EDW META DATA REPORTS LIST
Rqpp Yearly Des Coll Star  

SGHE Enterprise Data Warehouse
Aggregate Fact Table Target: WAT_RQPP_YEARLY_DES_COLL

Description Research and Qualify Potential Prospects Yearly Designation College aggregate table builds on the data relationships and core population within the Research and Qualify Potential Prospects business concept. This table contains one row per year of giving per available constituent per designation-college and contains pre-summarized donor participation metrics for each available constituent by year of giving for the designation-college in context.

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 DES COLL
AVAIL_CONST_IND   NUMBER

CONSTANT

1

NO

NO RQPP YEARLY DES COLL
CONS_YRS_OF_PARTICIPATION   NUMBER

TMP_WAT_RQPP_DES_COLL_INT

CONS_YOG

NO

NO RQPP YEARLY DES COLL
CUMUL_TOTAL_PARTICIP_AMT   NUMBER

EXP_REPLACE_NULL_VALUES

CUMUL_TOTAL_PARTICIP_AMT_EXPRESSION

NO

NO RQPP YEARLY DES COLL
DESIGNATION_COLLEGE_KEY   NUMBER

TMP_WAT_RQPP_DES_COLL_INT

DES_COLL_KEY

NO

NO RQPP YEARLY DES COLL
DONOR_10_YR_IND   NUMBER

3_5_7_10_REPEAT_DONOR

DONOR_10_YR_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
DONOR_3_YR_IND   NUMBER

3_5_7_10_REPEAT_DONOR

DONOR_3_YR_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
DONOR_5_YR_IND   NUMBER

3_5_7_10_REPEAT_DONOR

DONOR_5_YR_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
DONOR_7_YR_IND   NUMBER

3_5_7_10_REPEAT_DONOR

DONOR_7_YR_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
DONOR_ACQUIRED_IND   NUMBER

EXP_RETENTION_STATUSES

DONOR_ACQUIRED_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
DONOR_CONST_IND   NUMBER

EXP_DOWNGRADE_UPGRADE_CONST

DONOR_CONST_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
DONOR_DOWNGRADE_IND   NUMBER

EXP_DOWNGRADE_UPGRADE_CONST

DONOR_DOWNGRADE_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
DONOR_LAPSED_IND   NUMBER

EXP_RETENTION_STATUSES

DONOR_LAPSED_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
DONOR_NEW_RETAINED_IND   NUMBER

EXP_RETENTION_STATUSES

DONOR_NEW_RETAINED_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
DONOR_NON_IND   NUMBER

EXP_RETENTION_STATUSES

DONOR_NON_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
DONOR_REACTIVATED_IND   NUMBER

EXP_RETENTION_STATUSES

DONOR_REACTIVATED_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
DONOR_RETAINED_IND   NUMBER

EXP_RETENTION_STATUSES

DONOR_RETAINED_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
DONOR_UPGRADE_IND   NUMBER

EXP_DOWNGRADE_UPGRADE_CONST

DONOR_UPGRADE_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
ENTITY_KEY System generated, unique, internal primary key for an entity. NUMBER

TMP_WAT_RQPP_DES_COLL_INT

ENTITY_KEY

NO

NO RQPP YEARLY DES COLL
ENTITY_UID   NUMBER

TMP_WAT_RQPP_DES_COLL_INT

ENTITY_UID

NO

NO RQPP YEARLY DES COLL
GIVING_ACTIVITY_IND   NUMBER

EXP_REPLACE_NULL_VALUES

GIVING_ACTIVITY_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
LONG_LAPSE_IND   NUMBER

EXP_SHORT_LONG_LAPSE

LONG_LAPSE_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
LYBUNT_IND   NUMBER

EXP_LYBUNT_SYBUNT

LYBUNT_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
MATCH_CLAIM_AMT   NUMBER

EXP_REPLACE_NULL_VALUES

MATCH_CLAIM_AMT_EXPRESSION

NO

NO RQPP YEARLY DES COLL
MATCH_HARD_CREDIT_AMT   NUMBER

EXP_REPLACE_NULL_VALUES

MATCH_HARD_CREDIT_AMT_EXPRESSION

NO

NO RQPP YEARLY DES COLL
MATCH_SOFT_CREDIT_AMT   NUMBER

EXP_REPLACE_NULL_VALUES

MATCH_SOFT_CREDIT_AMT_EXPRESSION

NO

NO RQPP YEARLY DES COLL
MULTI_SOURCE_KEY   NUMBER

TMP_WAT_RQPP_DES_COLL_INT

MULTI_SOURCE_KEY

NO

NO RQPP YEARLY DES COLL
OUTRIGHT_GIFT_HARD_CREDIT_AMT   NUMBER

EXP_REPLACE_NULL_VALUES

OUTRIGHT_GIFT_HARD_CREDIT_AMT_EXPRESSION

NO

NO RQPP YEARLY DES COLL
OUTRIGHT_GIFT_SOFT_CREDIT_AMT   NUMBER

EXP_REPLACE_NULL_VALUES

OUTRIGHT_GIFT_SOFT_CREDIT_AMT_EXPRESSION

NO

NO RQPP YEARLY DES COLL
PARTICIPATION_DONOR_COUNT   NUMBER

EXPRESSION_COUNT

PARTICIPATION_DONOR_COUNT_EXPRESSION

NO

NO RQPP YEARLY DES COLL
PARTICIP_DONOR_IND   NUMBER

EXP_REPLACE_NULL_VALUES

PARTICIP_DONOR_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
PLEDGED_HARD_CREDIT_AMT   NUMBER

EXP_REPLACE_NULL_VALUES

PLEDGED_HARD_CREDIT_AMT_EXPRESSION

NO

NO RQPP YEARLY DES COLL
PLEDGED_SOFT_CREDIT_AMT   NUMBER

EXP_REPLACE_NULL_VALUES

PLEDGED_SOFT_CREDIT_AMT_EXPRESSION

NO

NO RQPP YEARLY DES COLL
PLEDGE_PAYMENT_HARD_CREDIT_AMT   NUMBER

EXP_REPLACE_NULL_VALUES

PLEDGE_PAYMENT_HARD_CREDIT_AMT_EXPRESSION

NO

NO RQPP YEARLY DES COLL
PLEDGE_PAYMENT_SOFT_CREDIT_AMT   NUMBER

EXP_REPLACE_NULL_VALUES

PLEDGE_PAYMENT_SOFT_CREDIT_AMT_EXPRESSION

NO

NO RQPP YEARLY DES COLL
PREV_YR_DONOR_ACQUIRED_IND   NUMBER

EXP_LY_RETENTION_STATUSES

PREV_YR_DONOR_ACQUIRED_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
PREV_YR_DONOR_CONSTANT_IND   NUMBER

EXP_LY_DOWN_UPGR_CONST

PREV_YR_DONOR_CONSTANT_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
PREV_YR_DONOR_DOWNGRADE_IND   NUMBER

EXP_LY_DOWN_UPGR_CONST

PREV_YR_DONOR_DOWNGRADE_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
PREV_YR_DONOR_LAPSED_IND   NUMBER

EXP_LY_RETENTION_STATUSES

PREV_YR_DONOR_LAPSED_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
PREV_YR_DONOR_REACTIVATED_IND   NUMBER

EXP_LY_RETENTION_STATUSES

PREV_YR_DONOR_REACTIVATED_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
PREV_YR_DONOR_RETAINED_IND   NUMBER

EXP_LY_RETENTION_STATUSES

PREV_YR_DONOR_RETAINED_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
PREV_YR_DONOR_UPGRADE_IND   NUMBER

EXP_LY_DOWN_UPGR_CONST

PREV_YR_DONOR_UPGRADE_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
PREV_YR_PARTICIP_DONOR_IND   NUMBER

EXP_LY_RET_CONDITIONS

PREV_YR_PARTICIP_DONOR_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
SHORT_LAPSE_IND   NUMBER

EXP_SHORT_LONG_LAPSE

SHORT_LAPSE_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
SYBUNT_IND   NUMBER

EXP_LYBUNT_SYBUNT

SYBUNT_IND_EXPRESSION

NO

NO RQPP YEARLY DES COLL
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

CONSTANT

'RQPP_YEARLY_DES_COLL_A1'

NO

NO RQPP YEARLY DES COLL
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 DES COLL
TOTAL_PARTICIP_AMT_1_YR_PRIOR   NUMBER

EXP_REPLACE_NULL_VALUES

TOTAL_PARTICIP_AMT_1_YR_PRIOR_EXPRESSION

NO

NO RQPP YEARLY DES COLL
TOTAL_PARTICIP_AMT_2_YR_PRIOR   NUMBER

EXP_REPLACE_NULL_VALUES

TOTAL_PARTICIP_AMT_2_YR_PRIOR_EXPRESSION

NO

NO RQPP YEARLY DES COLL
TOTAL_PARTICIP_AMT_3_YR_PRIOR   NUMBER

EXP_REPLACE_NULL_VALUES

TOTAL_PARTICIP_AMT_3_YR_PRIOR_EXPRESSION

NO

NO RQPP YEARLY DES COLL
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_DES_COLL_INT

YEAR_OF_GIVING

NO

NO RQPP YEARLY DES COLL
YEAR_OF_GIVING_KEY   NUMBER

CLN_YEAR_OF_GIVING

YEAR_OF_GIVING_KEY

NO

NO RQPP YEARLY DES COLL
YOG_LATEST_PARTICIP_AMT   NUMBER

EXP_LATEST_GIVING_YR_AMT

YOG_LATEST_PARTICIP_AMT_EXPRESSION

NO

NO RQPP YEARLY DES COLL
YOG_LATEST_PARTICIP_YEAR   NUMBER

EXP_LATEST_GIVING_YR_AMT

YOG_LATEST_PARTICIP_YEAR_EXPRESSION

NO

NO RQPP YEARLY DES COLL


Ver: 9.0