WAT_RQPP_YEARLY_DES_DEPT - Rqpp Yearly Des Dept Fact Table
| Research and Qualify Potential Prospects Yearly Designation Department aggregate table builds on the data relationships and core population within the Research and Qualify Potential Prospects business concept. This table contains one row per year of giving per available constituent per designation-department and contains pre-summarized donor participation metrics for each available constituent by year of giving for the designation-department in context. | | |
WDT_DESIGNATION_DEPT - Designation Dept Dimension
| Designation department dimension table includes the designation department and description for those designation departments that have yearly donor participation metrics loaded in the WAT_RQPP_YEARLY_DES_DEPT aggregate fact table. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_DONOR_SUMMARY - Donor Summary Dimension
| Donor summary dimension table contains summary giving information for a donor. | | |
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_FISCAL_DATE - Fiscal Date Dimension
| The Fiscal Date Dimension table provides information on the time frame for which the rest of the associated dimension and fact tables are storing the information in the star. | | |
WDT_GIVING_TOTAL - Giving Total Dimension
| Giving total dimension table contains summary giving information for a donor by fiscal year. The columns refer to both annual and non-annual information. If the fiscal years of the allocation types (both annual and non-annual) do not match, then the information in these records will consist of overlapping calendar time periods from the same fiscal years. | | |
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_YEAR_OF_GIVING - Year Of Giving Dimension
| Year of giving dimension table provides common attribute information for the fiscal year. | | |