WDT_ADDRESS_TYPE - Address Type Dimension
| Address type dimension table contains attributes for all addresses including type, 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 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_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 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_POSTAL - Postal Dimension
| Contains all data that is common to a postal code. | | |
WDT_STREET_ADDRESS - Street Address Dimension
| Street Address dimension table contains the street line information for each address of record. | | |
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. | | |