RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse Banner EDW Source: CONSTANT - NULL

Source Column Local Source Target Type Target Target Column Star Name Local Target
'A' NO

REPORTING VIEW

INTEREST

SOURCE

NA 

NO

'ADVANCEMENT' NO

REPORTING VIEW

INTEREST

SOURCE_DESC

NA 

NO

'CONSTITUENT_ENTITY_F1B' NO

FACT TABLE

WFT_CONSTITUENT_ENTITY

SYSTEM_LOAD_PROCESS

CONSTITUENT ENTITY 

NO

'CONSTITUENT_ENTITY_TYPE_F1B' NO

FACT TABLE

WFT_CONSTITUENT_ENTITY_TYPE

SYSTEM_LOAD_PROCESS

CONSTITUENT ENTITY TYPE 

NO

'CONTACT_REPORT_F1B' NO

FACT TABLE

WFT_CONTACT_REPORT

SYSTEM_LOAD_PROCESS

CONTACT REPORT 

NO

'DESIGNATION_ATTRIBUTE_F1B' NO

FACT TABLE

WFT_DESIGNATION_ATTRIBUTE

SYSTEM_LOAD_PROCESS

DESIGNATION ATTRIBUTE 

NO

'ENTITY_D1B' NO

DIMENSION TABLE

WDT_ENTITY

SYSTEM_LOAD_PROCESS

ADDRESS, ANALYZE FUNDRAISING, ASSIGNMENT, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE RESULT, PROSPECT ENTITY, PROSPECT INTEREST, RELATIONSHIP 

NO

'FUNDRAISING_INITIATIVE_D1B' NO

DIMENSION TABLE

WDT_FUNDRAISING_INITIATIVE

SYSTEM_LOAD_PROCESS

ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST 

NO

'GIFT_DETAIL_D1B' NO

DIMENSION TABLE

WDT_GIFT_DETAIL

SYSTEM_LOAD_PROCESS

ANALYZE FUNDRAISING, GIFT 

NO

'MANAGE_PROSPECT_PIPELINE_A1' NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

SYSTEM_LOAD_PROCESS

MANAGE PROSPECT PIPELINE 

NO

'MANAGE_PROSPECT_PIPELINE_A_A1' NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_A

SYSTEM_LOAD_PROCESS

MANAGE PROSPECT PIPELINE A 

NO

'N' NO        
'NO' NO

DIMENSION TABLE

WDT_CONSTITUENT_ENTITY_ATTRIB

WDT_CONSTITUENT_ENTITY_ATTRIB

WDT_CONSTITUENT_ENTITY_ATTRIB

WDT_CONSTITUENT_ENTITY_ATTRIB

WDT_CONSTITUENT_ENTITY_ATTRIB

WDT_CONSTITUENT_ENTITY_ATTRIB

WDT_CONSTITUENT_ENTITY_ATTRIB

WDT_CONSTITUENT_ENTITY_ATTRIB

WDT_GIFT

WDT_GIFT

WDT_GIFT

WDT_GIFT

WDT_PLEDGE

WDT_PLEDGE

WDT_PLEDGE

WDT_PLEDGE

WDT_PLEDGE

WDT_PLEDGE

WDT_PROPOSAL_ATTRIBUTE

WDT_PROPOSAL_ATTRIBUTE

WDT_PROSPECT_SHARED_ATTRIBUTE

WDT_PROSPECT_SHARED_ATTRIBUTE

WDT_PROSPECT_SHARED_ATTRIBUTE

WDT_PROSPECT_SHARED_ATTRIBUTE

WDT_PROSPECT_SHARED_ATTRIBUTE

WDT_PROSPECT_SHARED_ATTRIBUTE

ASSIGNED_IND_LD

ASSIGNED_IND_SD

MAJOR_PROSPECT_IND_LD

MAJOR_PROSPECT_IND_SD

PRIMARY_PROSPECT_ENTITY_IND_LD

PRIMARY_PROSPECT_ENTITY_IND_SD

PROGRAM_PROSPECT_IND_LD

PROGRAM_PROSPECT_IND_SD

GIFT_EXCLUDE_IND_LD

GIFT_EXCLUDE_IND_SD

REALIZED_BEQUEST_IND_LD

REALIZED_BEQUEST_IND_SD

PLEDGE_BINDING_IND_LD

PLEDGE_BINDING_IND_SD

PLEDGE_INSTALLMENT_IND_LD

PLEDGE_INSTALLMENT_IND_SD

PLEDGE_RECORDABLE_IND_LD

PLEDGE_RECORDABLE_IND_SD

PROPOSAL_PLAN_GIFT_IND_LD

PROPOSAL_PLAN_GIFT_IND_SD

MAJOR_PROSPECT_IND_LD

MAJOR_PROSPECT_IND_SD

PLANNED_GIVING_PROSPECT_IND_LD

PLANNED_GIVING_PROSPECT_IND_SD

PROSPECT_CONTACT_RESULT_IND_LD

PROSPECT_CONTACT_RESULT_IND_SD

ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, GIFT 

ANALYZE FUNDRAISING, GIFT 

ANALYZE FUNDRAISING, GIFT 

ANALYZE FUNDRAISING, GIFT 

ANALYZE FUNDRAISING, PLEDGE 

ANALYZE FUNDRAISING, PLEDGE 

ANALYZE FUNDRAISING, PLEDGE 

ANALYZE FUNDRAISING, PLEDGE 

ANALYZE FUNDRAISING, PLEDGE 

ANALYZE FUNDRAISING, PLEDGE 

CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL 

CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL 

MANAGE PROSPECT PIPELINE, PROSPECT 

MANAGE PROSPECT PIPELINE, PROSPECT 

MANAGE PROSPECT PIPELINE, PROSPECT 

MANAGE PROSPECT PIPELINE, PROSPECT 

MANAGE PROSPECT PIPELINE, PROSPECT 

MANAGE PROSPECT PIPELINE, PROSPECT 

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

'NOT APPLICABLE' NO

DIMENSION TABLE

WDT_CONTACT_REPORT

WDT_CONTACT_REPORT

WDT_CONTACT_REPORT

WDT_PROPOSAL

WDT_PROPOSAL

WDT_PROPOSAL

WDT_PROPOSAL_PURPOSE

CONTACTED_NAME

CONTACTED_SORT_NAME

REPRESENTATIVE_NAME

PROPOSAL_DESCRIPTION

PROPOSAL_TITLE

PROS_PGM_YR_ID

PROS_PGM_YR_ID

CONTACT REPORT, MANAGE PROSPECT PIPELINE 

CONTACT REPORT, MANAGE PROSPECT PIPELINE 

CONTACT REPORT, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE 

ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE 

ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE 

MANAGE PROSPECT PIPELINE B, PROPOSAL PURPOSE, PROPOSAL PURPOSE STAGE 

NO

NO

NO

NO

NO

NO

NO

'NOT AVAILABLE' NO

DIMENSION TABLE

WDT_STAFF

WDT_STAFF

STAFF_EMAIL_ADDRESS

STAFF_NAME_SORT

ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, MANAGE PROSPECT PIPELINE 

NO

NO

'PROPOSAL_PURPOSE_RESULT_F1B' NO

FACT TABLE

WFT_PROPOSAL_PURPOSE_RESULT

SYSTEM_LOAD_PROCESS

PROPOSAL PURPOSE RESULT 

NO

'PROPOSAL_PURPOSE_STAGE_F1B' NO

FACT TABLE

WFT_PROPOSAL_PURPOSE_STAGE

SYSTEM_LOAD_PROCESS

PROPOSAL PURPOSE STAGE 

NO

'PROPOSAL_STAGE_F1B' NO

FACT TABLE

WFT_PROPOSAL_STAGE

SYSTEM_LOAD_PROCESS

PROPOSAL STAGE 

NO

'PROSPECT_F1B' NO

FACT TABLE

WFT_PROSPECT

SYSTEM_LOAD_PROCESS

PROSPECT 

NO

'PROSPECT_INTEREST_F1B' NO

FACT TABLE

WFT_PROSPECT_INTEREST

SYSTEM_LOAD_PROCESS

PROSPECT INTEREST 

NO

'RELATIONSHIP_F1B' NO

FACT TABLE

WFT_RELATIONSHIP

SYSTEM_LOAD_PROCESS

RELATIONSHIP 

NO

'S' NO

REPORTING VIEW

INTEREST

SOURCE

NA 

NO

'STUDENT' NO

REPORTING VIEW

INTEREST

SOURCE_DESC

NA 

NO

'YES' NO

DIMENSION TABLE

WDT_ASSIGNMENT

WDT_ASSIGNMENT

WDT_STAFF

WDT_STAFF

ACTIVE_ASSIGNMENT_IND_LD

ACTIVE_ASSIGNMENT_IND_SD

STAFF_IND_LD

STAFF_IND_SD

ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, MANAGE PROSPECT PIPELINE 

NO

NO

NO

NO

0 NO

AGGREGATE FACT TABLE

























DIMENSION TABLE






















FACT TABLE

0 0000" FACE="Arial" SIZE="2">WFT_CONTACT_REPORT

WFT_CONTACT_REPORT

WFT_CONTACT_REPORT

WFT_CONTACT_REPORT

WFT_CONTACT_REPORT

WFT_MATCHING_CLAIM

WFT_MATCHING_CLAIM

WFT_MATCHING_CLAIM

WFT_MATCHING_CLAIM

WFT_MATCHING_CLAIM

WFT_MATCHING_CLAIM

WFT_PROPOSAL_STAGE

WFT_PROSPECT

WFT_PROSPECT

WFT_PROSPECT

WFT_PROSPECT_INTEREST

WFT_PROSPECT_INTEREST

WFT_PROSPECT_INTEREST

C CT_IND

PROSPECT_CONTACT_RESULT_IND

ADVANCEMENT_PROGRAM_KEY

AUTHOR_ENTITY_KEY

AUTHOR_ENTITY_UID

CONTACT_REPORT_UNIT_KEY

ID2_ENTITY_KEY

ID2_ENTITY_UID

REP_ID_ENTITY_KEY

REP_ID_ENTITY_UID

ADVANCEMENT_PROGRAM_KEY

CLASS_SCHOOL_KEY

CONSTITUENT_ENTITY_TYPE_KEY

FUNDRAISING_INITIATIVE_KEY

PROPOSAL_KEY

REUNION_CAMPAIGN_KEY

STAGE_ID

PROSPECT_CAMPAIGN_KEY

PROSPECT_RESULT_AMOUNT

PROSPECT_UNIT_KEY

ADVANCEMENT_PROGRAM_KEY

ADVANCEMENT_PROGRAM_YEAR_KEY

PROSPECT_INTEREST_UNIT_KEY

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE 

CONTACT REPORT, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, GIFT 

ANALYZE FUNDRAISING, GIFT 

ANALYZE FUNDRAISING, GIFT 

ANALYZE FUNDRAISING, GIFT 

ANALYZE FUNDRAISING, GIFT 

ANALYZE FUNDRAISING, GIFT 

ANALYZE FUNDRAISING, GIFT 

ANALYZE FUNDRAISING, MATCHING CLAIM 

ANALYZE FUNDRAISING, PLEDGE 

ANALYZE FUNDRAISING, PLEDGE 

ANALYZE FUNDRAISING, PLEDGE 

ANALYZE FUNDRAISING, PLEDGE 

ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE 

CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL 

MANAGE PROSPECT PIPELINE B, PROPOSAL PURPOSE, PROPOSAL PURPOSE STAGE 

MANAGE PROSPECT PIPELINE, PROSPECT 

MANAGE PROSPECT PIPELINE, PROSPECT 

MANAGE PROSPECT PIPELINE, PROSPECT 

CONTACT REPORT 

CONTACT REPORT 

CONTACT REPORT 

CONTACT REPORT 

CONTACT REPORT 

CONTACT REPORT 

CONTACT REPORT 

CONTACT REPORT 

MATCHING CLAIM 

MATCHING CLAIM 

MATCHING CLAIM 

MATCHING CLAIM 

MATCHING CLAIM 

MATCHING CLAIM 

PROPOSAL STAGE 

PROSPECT 

PROSPECT 

PROSPECT 

PROSPECT INTEREST 

PROSPECT INTEREST 

PROSPECT INTEREST 

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

00 NO        
1 NO

AGGREGATE FACT TABLE




DIMENSION TABLE




FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_A

WDT_ASSIGNMENT

WDT_GIFT_DETAIL

WDT_STAFF

WFT_PROPOSAL_PURPOSE_STAGE

WFT_PROPOSAL_STAGE

WFT_RELATIONSHIP

PROSPECT_INT_ASK_MADE_IND

ACTIVE_ASSIGNMENT_IND

MATCHING_GIFT_IND

STAFF_IND

LATEST_PROPOSAL_PURP_STAGE_IND

LATEST_PROPOSAL_STAGE_IND

CURRENT_SPOUSE_IND

MANAGE PROSPECT PIPELINE A 

ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, GIFT 

ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, MANAGE PROSPECT PIPELINE 

PROPOSAL PURPOSE STAGE 

PROPOSAL STAGE 

RELATIONSHIP 

NO

NO

NO

NO

NO

NO

NO

13 NO        
14 NO        
85 NO        
86 NO        
HARDCODED DESCRIPTIONS. NO

REPORTING VIEW

PORTFOLIO

AUTHORIZATION_STATUS_DESC

NA 

NO

LAST_PROSP_INT_ASK_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_A

LAST_PROSP_INT_ASK_DATE

MANAGE PROSPECT PIPELINE A 

NO

NULL NO

AGGREGATE FACT TABLE




DIMENSION TABLE







FACT TABLE






AGGREGATE FACT TABLE




DIMENSION TABLE







FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_A

WAT_MANAGE_PROSPECT_PIPELINE_A

WAT_MANAGE_PROSPECT_PIPELINE_A

WAT_MANAGE_PROSPECT_PIPELINE_A

WAT_MANAGE_PROSPECT_PIPELINE_A

WDT_ASSIGNMENT

WDT_ASSIGNMENT

WDT_ASSIGNMENT

WFT_CONSTITUENT_ENTITY

WFT_CONSTITUENT_ENTITY

WFT_CONSTITUENT_ENTITY

WFT_CONSTITUENT_ENTITY

WFT_CONSTITUENT_ENTITY_TYPE

WFT_PROSPECT

WAT_MANAGE_PROSPECT_PIPELINE_A

WAT_MANAGE_PROSPECT_PIPELINE_A

WAT_MANAGE_PROSPECT_PIPELINE_A

WAT_MANAGE_PROSPECT_PIPELINE_A

WAT_MANAGE_PROSPECT_PIPELINE_A

WDT_ASSIGNMENT

WDT_ASSIGNMENT

WDT_ASSIGNMENT

WFT_CONSTITUENT_ENTITY

WFT_CONSTITUENT_ENTITY

WFT_CONSTITUENT_ENTITY

WFT_CONSTITUENT_ENTITY

WFT_CONSTITUENT_ENTITY_TYPE

WFT_PROSPECT

ACTIVE_PROSPECT_INTEREST_COUNT

LAST_PROSP_INT_ASK_AMOUNT

PROSPECT_INTEREST_ASK_AMOUNT

PROSPECT_INTEREST_COUNT

PROSPECT_INTEREST_TARGET_AMT

ASSIGNMENT_PRIORITY

ASSIGNMENT_PRIORITY_LD

ASSIGNMENT_PRIORITY_SD

MAJOR_PROSPECT_ENTITY_COUNT

PG_PROSPECT_ENTITY_COUNT

PROGRAM_PROSPECT_ENTITY_COUNT

RATED_ENTITY_COUNT

XSEQUENCE

PROS_PGM_YR_ID

ACTIVE_PROSPECT_INTEREST_COUNT

LAST_PROSP_INT_ASK_AMOUNT

PROSPECT_INTEREST_ASK_AMOUNT

PROSPECT_INTEREST_COUNT

PROSPECT_INTEREST_TARGET_AMT

ASSIGNMENT_PRIORITY

ASSIGNMENT_PRIORITY_LD

ASSIGNMENT_PRIORITY_SD

MAJOR_PROSPECT_ENTITY_COUNT

PG_PROSPECT_ENTITY_COUNT

PROGRAM_PROSPECT_ENTITY_COUNT

RATED_ENTITY_COUNT

XSEQUENCE

PROS_PGM_YR_ID

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE 

CONSTITUENT ENTITY 

CONSTITUENT ENTITY 

CONSTITUENT ENTITY 

CONSTITUENT ENTITY 

CONSTITUENT ENTITY TYPE 

PROSPECT 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

MANAGE PROSPECT PIPELINE A 

ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE 

ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE 

CONSTITUENT ENTITY 

CONSTITUENT ENTITY 

CONSTITUENT ENTITY 

CONSTITUENT ENTITY 

CONSTITUENT ENTITY TYPE 

PROSPECT 

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

PROPOSAL_PURP_STAGE_END_DATE_EXPRESSION NO

FACT TABLE

WFT_PROPOSAL_PURPOSE_STAGE

PROPOSAL_PURP_STAGE_END_DATE

PROPOSAL PURPOSE STAGE 

NO

PROPOSAL_STAGE_END_DATE_EXPRESSION NO

FACT TABLE

WFT_PROPOSAL_STAGE

PROPOSAL_STAGE_END_DATE

PROPOSAL STAGE 

NO

PROSPECT_INTEREST_END_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_A

PROSPECT_INTEREST_END_DATE

MANAGE PROSPECT PIPELINE A 

NO

PROSPECT_INTEREST_START_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_A

PROSPECT_INTEREST_START_DATE

MANAGE PROSPECT PIPELINE A 

NO

PROSPECT_INTEREST_STATUS_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_A

PROSPECT_INTEREST_STATUS_DATE

MANAGE PROSPECT PIPELINE A 

NO

PROSPECT_INTEREST_TARGET_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_A

PROSPECT_INTEREST_TARGET_DATE

MANAGE PROSPECT PIPELINE A 

NO

PROSPECT_RESULT_DATE_EXPRESSION NO

FACT TABLE

WFT_PROSPECT

PROSPECT_RESULT_DATE

PROSPECT 

NO

PROSPECT_START_DATE_EXPRESSION NO

FACT TABLE

WFT_PROSPECT

PROSPECT_START_DATE

PROSPECT 

NO

PROSPECT_STOP_DATE_EXPRESSION NO

FACT TABLE

WFT_PROSPECT

PROSPECT_STOP_DATE

PROSPECT 

NO



Ver: 8.2