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_GIFT_SOCIETY - Gift Society Dimension
| Gift society dimension table provides information about the gift society, including society, type, category, affiliated college and member status. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_GIFT_SOCIETY_PREMIUM - Gift Society Premium Dimension
| Gift society premium dimension table identifies the premium type and description. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_GIFT_SOCIETY_YEAR - Gift Society Year Dimension
| Gift society year dimension table identifies the gift society year and corresponding start and end dates. 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_GIFT_SOCIETY_PREMIUM - Gift Society Premium Fact Table
| Gift society premium fact table provides measures for each premium applicable to a donor's gift society association, including premium date, cost and value. | | |