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_MEMBERSHIP - Membership Dimension
| Membership dimension table provides information about the membership, including type, category, source, period and member status. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_MEMBERSHIP_INTEREST - Membership Interest Dimension
| Membership interest dimension table identifies the member interest and corresponding interest type, group and college. 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_PROPOSAL - Proposal Dimension
| Proposal dimension table contains descriptions and comments for a proposal. | | |
WDT_STREET_ADDRESS - Street Address Dimension
| Street Address dimension table contains the street line information for each address of record. | | |
WFT_MEMBERSHIP_INTEREST - Membership Interest Fact Table
| Membership interest fact table provides measures for each interest associated to a constituent's memberships, including membership number and distinct count of member interests. | | |