WDT_ADDRESS_TYPE - Address Type Dimension
| Address type dimension table contains the list of address types for addresses and its status and descriptions. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
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 information on the source(s) of information. This information is the multi-source code and its descriptions along with the process group and administrative group. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_POSTAL - Postal Dimension
| Postal dimension table provides all data that is common to a postal code. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_STREET_ADDRESS - Street Address Dimension
| Street address dimension table contains street information about an address. | | |
WFT_ADDRESS - Address Fact Table
| Address fact table provides information about the address type for a constituent, determining if the address is preferred, when the address is active, as well as seasonal measures. | | |