WAT_MANAGE_PROSPECT_PIPELINE_A - Manage Prospect Pipeline A Fact Table
| Manage prospect pipeline A aggregate table is the central table of the Manage Prospect Pipeline A aggregate star. It is based on data from the following fact tables: WFT_PROSPECT and WFT_PROSPECT_INTEREST. This is defined as one row per prospect, per interest. It is used to manage all attributes associated to a prospect and their interest information. | | |
WDT_ADVANCEMENT_PROGRAM - Advancement Program Dimension
| Advancement program dimension table contains a list of programs that may be linked to prospects. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_ADVANCEMENT_PROGRAM_YEAR - Advancement Program Year Dimension
| Advancement program year dimension table contains a list of years that a prospect may be linked to. | | |
WDT_FUNDRAISING_INITIATIVE - Fundraising Initiative Dimension
| Fundraising initiative dimension table provides information about proposal projects/purposes/interests. 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_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. | | |