WDT_ADDRESS_TYPE - Address Type Dimension
| Address type dimension table contains attributes for all addresses including type, 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 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_PHONE - Phone Dimension
| Phone dimension table provides the actual phone number and other detail information for each constituent phone number. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_PHONE_COMMENT - Phone Comment Dimension
| Phone comment dimension table provides comments about a constiutent's phone number. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_PHONE_TYPE - Phone Type Dimension
| Phone type dimension table provides the phone number types and status associated with a constituent's phone numbers. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WFT_PHONE - Phone Fact Table
| Phone fact table provides measures for each active or inactive telephone number associated with a constituent. | | |