WDT_ADDRESS_TYPE - Address Type Dimension
| Address type dimension table contains the list of address types for addresses and its status and descriptions. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
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 graduate 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_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_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_POSTAL - Postal Dimension
| Postal dimension table provides all data that is common to a postal code. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_STREET_ADDRESS - Street Address Dimension
| Street address dimension table contains street information about an address. | | |
WFT_CONSTITUENT_ENTITY - Constituent Entity Fact Table
| Constituent entity fact table provides information about the constituent, providing several measures to count if the constituent had been contacted, assigned staff, rated, is a prospect, and an alumni, etc. | | |