WDT_CAMPAIGN - Campaign Dimension
| Campaign dimension table identifies all campaigns and common information as the campaign type, if the campaign is active, and if to include the campaign in giving. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_MULTI_SOURCE - Multi Source Dimension
| Multi-source Dimension table provides information on the source(s) of information. This information is the multi-source code and its descriptions along with the process group and administrative group. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_PROSPECT - Prospect Dimension
| Prospect dimension table identifying information about the prospect such as ID and name. | | |
WDT_PROSPECT_ATTRIBUTE - Prospect Attribute Dimension
| Prospect attribute dimension table contains attributes for that prospect such as type, group, classification, affiliation, referral, status, etc. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_PROSPECT_SHARED_ATTRIBUTE - Prospect Shared Attribute Dimension
| Prospect shared attribute dimension table contains attributes shared between prospects and program prospects. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_STAGE - Stage Dimension
| Stage dimension table contains the various stages that a prospect/program prospect, prospect proposal, or prospect interest can be in. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_UNIT - Unit Dimension
| Unit dimension table identifies schools or units and descriptions. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WFT_PROSPECT - Prospect Fact Table
| Prospect fact table provides measures counting prospects, how many prospects are active, rated, major, or planned giving, start and end dates, rated amount, result amount, rated entry date, result date, target date and if the prospect has assigned staff. | | |