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_SPECIAL_PURPOSE - Special Purpose Dimension
| Special purpose dimension table identifies the special purpose and description. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_SPECIAL_PURPOSE_TYPE - Special Purpose Type Dimension
| Special purpose type dimension table identifies the special purpose type and description. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WFT_SPECIAL_PURPOSE - Special Purpose Fact Table
| Special purpose fact table provides measures for each special purpose associated with a constituent, including counts and assignment date. | | |