| RETURN TO BANNER EDW META DATA REPORTS LIST |
| Source Column | Local Source | Target Type | Target | Target Column | Star Name | Local Target |
|---|---|---|---|---|---|---|
| 'A' | NO | REPORTING VIEW |
NA | NO |
||
| 'ADVANCEMENT' | NO | REPORTING VIEW |
NA | NO |
||
| 'CONSTITUENT_ENTITY_F1B' | NO | FACT TABLE |
CONSTITUENT ENTITY | NO |
||
| 'CONSTITUENT_ENTITY_TYPE_F1B' | NO | FACT TABLE |
CONSTITUENT ENTITY TYPE | NO |
||
| 'CONTACT_REPORT_F1B' | NO | FACT TABLE |
CONTACT REPORT | NO |
||
| 'DESIGNATION_ATTRIBUTE_F1B' | NO | FACT TABLE |
DESIGNATION ATTRIBUTE | NO |
||
| 'ENTITY_D1B' | NO | DIMENSION TABLE |
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 |
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 |
ANALYZE FUNDRAISING, GIFT | NO |
||
| 'MANAGE_PROSPECT_PIPELINE_A1' | NO | AGGREGATE FACT TABLE |
MANAGE PROSPECT PIPELINE | NO |
||
| 'MANAGE_PROSPECT_PIPELINE_A_A1' | NO | AGGREGATE FACT TABLE |
MANAGE PROSPECT PIPELINE A | NO |
||
| 'N' | NO | |||||
| 'NO' | NO | DIMENSION TABLE |
PRIMARY_PROSPECT_ENTITY_IND_LD PRIMARY_PROSPECT_ENTITY_IND_SD PLANNED_GIVING_PROSPECT_IND_LD PLANNED_GIVING_PROSPECT_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 |
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 |
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 |
PROPOSAL PURPOSE RESULT | NO |
||
| 'PROPOSAL_PURPOSE_STAGE_F1B' | NO | FACT TABLE |
PROPOSAL PURPOSE STAGE | NO |
||
| 'PROPOSAL_STAGE_F1B' | NO | FACT TABLE |
PROPOSAL STAGE | NO |
||
| 'PROSPECT_F1B' | NO | FACT TABLE |
PROSPECT | NO |
||
| 'PROSPECT_INTEREST_F1B' | NO | FACT TABLE |
PROSPECT INTEREST | NO |
||
| 'RELATIONSHIP_F1B' | NO | FACT TABLE |
RELATIONSHIP | NO |
||
| 'S' | NO | REPORTING VIEW |
NA | NO |
||
| 'STUDENT' | NO | REPORTING VIEW |
NA | NO |
||
| 'YES' | NO | DIMENSION TABLE |
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 | C CT_IND | 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 |
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 |
NA | NO |
||
| LAST_PROSP_INT_ASK_DATE_EXPRESSION | NO | AGGREGATE FACT TABLE |
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 WAT_MANAGE_PROSPECT_PIPELINE_A WAT_MANAGE_PROSPECT_PIPELINE_A WAT_MANAGE_PROSPECT_PIPELINE_A WAT_MANAGE_PROSPECT_PIPELINE_A |
ACTIVE_PROSPECT_INTEREST_COUNT |
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 |
PROPOSAL PURPOSE STAGE | NO |
||
| PROPOSAL_STAGE_END_DATE_EXPRESSION | NO | FACT TABLE |
PROPOSAL STAGE | NO |
||
| PROSPECT_INTEREST_END_DATE_EXPRESSION | NO | AGGREGATE FACT TABLE |
MANAGE PROSPECT PIPELINE A | NO |
||
| PROSPECT_INTEREST_START_DATE_EXPRESSION | NO | AGGREGATE FACT TABLE |
MANAGE PROSPECT PIPELINE A | NO |
||
| PROSPECT_INTEREST_STATUS_DATE_EXPRESSION | NO | AGGREGATE FACT TABLE |
MANAGE PROSPECT PIPELINE A | NO |
||
| PROSPECT_INTEREST_TARGET_DATE_EXPRESSION | NO | AGGREGATE FACT TABLE |
MANAGE PROSPECT PIPELINE A | NO |
||
| PROSPECT_RESULT_DATE_EXPRESSION | NO | FACT TABLE |
PROSPECT | NO |
||
| PROSPECT_START_DATE_EXPRESSION | NO | FACT TABLE |
PROSPECT | NO |
||
| PROSPECT_STOP_DATE_EXPRESSION | NO | FACT TABLE |
PROSPECT | NO |