| RETURN TO BANNER EDW META DATA REPORTS LIST |
| WDT_ENTITY - Entity Dimension | Entity dimension table provides information about a person or organization. It uses the cleansing rules in the EDW for the short and long descriptions. | ||
| 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 an institution source value when the optional multi-source feature has been applied. Institution source VALUES have a short and long description. Data in this dimension may optionally include a process-oriented identifier and an administrative-oriented identifier for the record used to determine access authorization to this record. The cleansing rules are used in the EDW for the short and long descriptions. | ||
| WDT_PROPOSAL - Proposal Dimension | Proposal dimension table contains descriptions and comments for a proposal. | ||
| WDT_PROSPECT - Prospect Dimension | Prospect dimension table identifying information about the prospect such as ID and name. | ||
| WDT_STREET_ADDRESS - Street Address Dimension | Street Address dimension table contains the street line information for each address of record. | ||
WFT_PROPOSAL_PURPOSE_RESULT - Proposal Purpose Result Fact Table | Proposal purpose result fact table provides proposal measures to determine the first result, last result, the result date and result amount. |