SGHE Enterprise Data Warehouse
Banner EDW Source: EXPRESSION_0 - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACTIVE_EXCLUSION_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_EXCLUSION |
ACTIVE_EXCLUSION_COUNT |
EXCLUSION |
NO |
| ACTIVE_MATCHING_CLAIM_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_MATCHING_CLAIM |
ACTIVE_MATCHING_CLAIM_COUNT |
MATCHING CLAIM |
NO |
| ACTIVITY_COMMENT_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_ACT_COMMENT |
ACTIVITY_COMMENT |
ADVANCEMENT ACTIVITY |
NO |
| ACTIVITY_LEADERSHIP_COMMENT_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_ACT_COMMENT |
ACTIVITY_LEADERSHIP_COMMENT |
ADVANCEMENT ACTIVITY |
NO |
| ALL_PROSPECT_ENTITY_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONSTITUENT_ENTITY |
ALL_PROSPECT_ENTITY_COUNT |
CONSTITUENT ENTITY |
NO |
| ALUM_ENTITY_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONSTITUENT_ENTITY |
ALUM_ENTITY_COUNT |
CONSTITUENT ENTITY |
NO |
| ASSIGNED_ENTITY_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONSTITUENT_ENTITY |
ASSIGNED_ENTITY_COUNT |
CONSTITUENT ENTITY |
NO |
| CONTACTED_CONSTITUENT_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT |
CONTACTED_CONSTITUENT_COUNT |
CONTACT REPORT |
NO |
| CONTACTED_ENTITY_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONSTITUENT_ENTITY |
CONTACTED_ENTITY_COUNT |
CONSTITUENT ENTITY |
NO |
| CONTACTED_PROSPECT_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT |
CONTACTED_PROSPECT_COUNT |
CONTACT REPORT |
NO |
| CONTACT_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT |
CONTACT_COUNT |
CONTACT REPORT |
NO |
| CONTACT_CREDIT_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT_CREDIT |
CONTACT_CREDIT_COUNT |
CONTACT REPORT CREDIT |
NO |
| CONT_REP_CREDIT_GROUP_KEY_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT WFT_CONTACT_REPORT_CREDIT |
CONT_REP_CREDIT_GROUP_KEY CONT_REP_CREDIT_GROUP_KEY |
CONTACT REPORT CONTACT REPORT CREDIT |
NO NO |
| CONT_REP_ENTITY_GROUP_KEY_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT |
CONT_REP_ENTITY_GROUP_KEY |
CONTACT REPORT |
NO |
| CONT_REP_PROSPECT_GROUP_KEY_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT |
CONT_REP_PROSPECT_GROUP_KEY |
CONTACT REPORT |
NO |
| DESIGNATION_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_MATCHING_CLAIM |
DESIGNATION_COUNT |
MATCHING CLAIM |
NO |
| EMAIL_ADDRESS_STATUS_LD_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_EMAIL_ATTRIBUTE |
EMAIL_ADDRESS_STATUS_LD |
EMAIL |
NO |
| EMAIL_ADDRESS_STATUS_SD_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_EMAIL_ATTRIBUTE |
EMAIL_ADDRESS_STATUS_SD |
EMAIL |
NO |
| ENTITY_CONTACT_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT |
ENTITY_CONTACT_COUNT |
CONTACT REPORT |
NO |
| EXCLUSION_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_EXCLUSION |
EXCLUSION_COUNT |
EXCLUSION |
NO |
| EXCLUSION_RECORD_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_EXCLUSION |
EXCLUSION_RECORD_COUNT |
EXCLUSION |
NO |
| INACTIVE_EXCLUSION_IND_EXPRESSION |
NO |
FACT TABLE |
WFT_EXCLUSION |
INACTIVE_EXCLUSION_IND |
EXCLUSION |
NO |
| INTEREST_ASK_CONTACT_IND_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT |
INTEREST_ASK_CONTACT_IND |
CONTACT REPORT |
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 |
| MAILING_HISTORY_GROUP_KEY_EXPRESSION |
NO |
FACT TABLE |
WFT_MAILING_HISTORY |
MAILING_HISTORY_GROUP_KEY |
MAILING HISTORY |
NO |
| MAIL_PRINT_DATE_EXPRESSION |
NO |
FACT TABLE |
WFT_MAILING_HISTORY |
MAIL_PRINT_DATE |
MAILING HISTORY |
NO |
| MAIL_RECORD_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_MAILING_HISTORY |
MAIL_RECORD_COUNT |
MAILING HISTORY |
NO |
| MATCHING_CLAIM_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_MATCHING_CLAIM |
MATCHING_CLAIM_COUNT |
MATCHING CLAIM |
NO |
| MEMBERSHIP_INTEREST_GROUP_KEY_EXPRESSION |
NO |
FACT TABLE |
WFT_MEMBERSHIP |
MEMBERSHIP_INTEREST_GROUP_KEY |
MEMBERSHIP |
NO |
| MEMBER_START_DATE_EXPRESSION |
NO |
FACT TABLE |
WFT_MEMBERSHIP |
MEMBER_START_DATE |
MEMBERSHIP |
NO |
| MEMBER_STOP_DATE_EXPRESSION |
NO |
FACT TABLE |
WFT_MEMBERSHIP |
MEMBER_STOP_DATE |
MEMBERSHIP |
NO |
| PHONE_COMMENT_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_PHONE_COMMENT |
PHONE_COMMENT |
PHONE |
NO |
| PLEDGE_BATCH_NUMBER_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_PLEDGE_DETAIL |
PLEDGE_BATCH_NUMBER |
ANALYZE FUNDRAISING, PLEDGE |
NO |
| PRIMARY_PROSPECT_ENTITY_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONSTITUENT_ENTITY |
PRIMARY_PROSPECT_ENTITY_COUNT |
CONSTITUENT ENTITY |
NO |
| PROPOSAL_ASK_CONTACT_IND_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT |
PROPOSAL_ASK_CONTACT_IND |
CONTACT REPORT |
NO |
| PROPOSAL_CONTACT_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT |
PROPOSAL_CONTACT_COUNT |
CONTACT REPORT |
NO |
| PROPOSAL_PURPOSE_ASK_CONT_IND_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT |
PROPOSAL_PURPOSE_ASK_CONT_IND |
CONTACT REPORT |
NO |
| PROSPECT_CONTACT_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT |
PROSPECT_CONTACT_COUNT |
CONTACT REPORT |
NO |
| PROSPECT_ENTITY_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONSTITUENT_ENTITY |
PROSPECT_ENTITY_COUNT |
CONSTITUENT ENTITY |
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_VISIT_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT |
PROSPECT_VISIT_COUNT |
CONTACT REPORT |
NO |
| RATED_PROSPECT_ENTITY_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONSTITUENT_ENTITY |
RATED_PROSPECT_ENTITY_COUNT |
CONSTITUENT ENTITY |
NO |
| SOLICITOR_IND_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_ASSIGNMENT |
SOLICITOR_IND |
ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT |
NO |
| SOLICITOR_IND_LD_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_ASSIGNMENT |
SOLICITOR_IND_LD |
ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT |
NO |
| SOLICITOR_IND_SD_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_ASSIGNMENT |
SOLICITOR_IND_SD |
ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT |
NO |
| VISIT_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT |
VISIT_COUNT |
CONTACT REPORT |
NO |
| VISIT_CREDIT_COUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_CONTACT_REPORT_CREDIT |
VISIT_CREDIT_COUNT |
CONTACT REPORT CREDIT |
NO |