WAT_RQPP_ENTITY - Rqpp Entity Fact Table
| Research and Qualify Potential Prospects Entity aggregate table illustrates the data relationships and core population within the Research and Qualify Potential Prospects business concept and Analyze Constituent Giving business concept. The core population is all constituents past and present. This aggregate table contains one row per constituent and is used to analyze all attributes associated with a constituent. | | |
WDT_CLASS_SCHOOL - Class School Dimension
| Class school dimension table contains the preferred class year and school for a constituent. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_CONSTITUENT_ENTITY_ATTRIB - Constituent Entity Attrib Dimension
| Constituent entity attribute dimension table provides common indicative information about a constituent such as if they are a donor, if they have ever been contacted, or have a staff member assigned. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_CONSTITUENT_ENTITY_TYPE - Constituent Entity Type Dimension
| Constituent entity type dimension table provides donor information about the constituent such as the CFAE, if this is a person or organization, alumni, board member, student, faculty, etc. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_DEMOGRAPHIC - Demographic Dimension
| Demographic Dimension table provides information for the person that is consistent whether this is an employee, inquirer, applicant, student or graduand at the institution. This information includes gender, ethnicity, age range and family income range. It uses the cleansing rules in the EDW for the short and long descriptions as well as the definition . | | |
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. | | |