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_NON_ENTITY_RELATION - Non Entity Relation Dimension
| Non-Entity Relation dimension table provides information about a person or organization who is a non-entity. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_RELATIONSHIP - Relationship Dimension
| Relationship dimension table provides attributes about a constituent's relationships such as the relationship description and spouse, household, employer, matching gift indicators. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WFT_RELATIONSHIP - Relationship Fact Table
| Relationship fact table provides relationship measures for a constituent and its relationships. | | |