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_STUDENT_ACTIVITY - Student Activity Dimension
| Student activity dimension table provides information about a student activity. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_STUDENT_ACTIVITY_ATTRIB - Student Activity Attrib Dimension
| Student activity attribute dimension table provides additional attributes related to the constituent's participation in this activity including level of participation and leadership role or office held. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_STUDENT_ACTIVITY_COMMENT - Student Activity Comment Dimension
| Student activity comment dimension table provides comments related a constituent's particiaption in an activity. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WFT_ADV_STUDENT_ACTIVITY - Adv Student Activity Fact Table
| Advancement student activity fact table provides measures for each student related activity in which a constituent has participated, including activity counts and participation start and stop dates. | | |