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_PROPOSAL - Proposal Dimension
| Proposal dimension table contains descriptions and comments for a proposal. | | |
WDT_PROPOSAL_ATTRIBUTE - Proposal Attribute Dimension
| Proposal attribute dimension contains attributes specific to the proposal, like proposal type, funding type, submit type, active proposal status, etc. 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. | | |
WFT_PROPOSAL - Proposal Fact Table
| Proposal fact table provides proposal measures counting proposals granted, proposals assigned, if the proposal was granted or assigned, if an ask was made, proposal start and stop dates, total of all result amounts, pledge amounts, gift amounts, pledge payment amounts, the actual proposal ask amount, last ask amount, last ask date, targeted and granted amounts. | | |