| RETURN TO BANNER EDW META DATA REPORTS LIST |
| 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_PROPOSAL - Proposal Dimension | Proposal dimension table contains descriptions and comments for a proposal. | ||
| WDT_PROPOSAL_PURPOSE - Proposal Purpose Dimension | Proposal purpose dimension table contains information specific to the proposal purpose/project. | ||
| 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. | ||
WFT_PROPOSAL_PURPOSE_STAGE - Proposal Purpose Stage Fact Table | Proposal purpose stage fact table provides measures for the start and end date of each stage and identifies the latest stage. For Banner this is currently loaded with only the latest proposal purpose stage. |