Banner EDW Source: WFT_PROSPECT_INTEREST

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
ADVANCEMENT_PROGRAM_KEY	NO	AGGREGATE FACT TABLE	WAT_MANAGE_PROSPECT_PIPELINE_A	ADVANCEMENT_PROGRAM_KEY	MANAGE PROSPECT PIPELINE A	NO
ADVANCEMENT_PROGRAM_YEAR_KEY	NO	AGGREGATE FACT TABLE	WAT_MANAGE_PROSPECT_PIPELINE_A	ADVANCEMENT_PROGRAM_YEAR_KEY	MANAGE PROSPECT PIPELINE A	NO
FUNDRAISING_INITIATIVE_KEY	NO	AGGREGATE FACT TABLE	WAT_MANAGE_PROSPECT_PIPELINE_A	FUNDRAISING_INITIATIVE_KEY	MANAGE PROSPECT PIPELINE A	NO
PROSPECT_INTEREST_ID	NO	AGGREGATE FACT TABLE	WAT_MANAGE_PROSPECT_PIPELINE_A WAT_MANAGE_PROSPECT_PIPELINE_A	PROSPECT_INTEREST_COUNT PROSPECT_INTEREST_ID	MANAGE PROSPECT PIPELINE A MANAGE PROSPECT PIPELINE A	NO NO
PROSPECT_INTEREST_STAGE_KEY	NO	AGGREGATE FACT TABLE	WAT_MANAGE_PROSPECT_PIPELINE_A	PROSPECT_INTEREST_STAGE_KEY	MANAGE PROSPECT PIPELINE A	NO
PROSPECT_INTEREST_UNIT_KEY	NO	AGGREGATE FACT TABLE	WAT_MANAGE_PROSPECT_PIPELINE_A	PROSPECT_INTEREST_UNIT_KEY	MANAGE PROSPECT PIPELINE A	NO
PROSPECT_INT_ACTIVE_IND	NO	AGGREGATE FACT TABLE	WAT_MANAGE_PROSPECT_PIPELINE_A	PROSPECT_INTEREST_ACTIVE_IND	MANAGE PROSPECT PIPELINE A	NO
PROSPECT_INT_ASK_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_MANAGE_PROSPECT_PIPELINE_A	PROSPECT_INTEREST_ASK_AMOUNT	MANAGE PROSPECT PIPELINE A	NO
PROSPECT_INT_LATEST_ASK	NO	AGGREGATE FACT TABLE	WAT_MANAGE_PROSPECT_PIPELINE_A	LAST_PROSP_INT_ASK_AMOUNT	MANAGE PROSPECT PIPELINE A	NO
PROSPECT_INT_TARGET_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_MANAGE_PROSPECT_PIPELINE_A	PROSPECT_INTEREST_TARGET_AMT	MANAGE PROSPECT PIPELINE A	NO

Ver: 9.0