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_EMAIL_TYPE - Email Type Dimension
| Email type dimension table provides the email types associated with email addresses. 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_MAIL_CODE - Mail Code Dimension
| Mail code dimension table identifies the mailing or solicitation code and description. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_MAIL_CONTROL - Mail Control Dimension
| Mail control dimension table identifies the mailing list control code and description. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_MAIL_LIST_ATTRIBUTE - Mail List Attribute Dimension
| Mail list attribute dimension table provides information about the mailing lists to which constituents are assigned. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_MAIL_LIST_COMMENT - Mail List Comment Dimension
| Mail list comment dimension table provides comments about a constituent's assigned mailing lists. 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_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_MAILING_LIST - Mailing List Fact Table
| Mailing list fact table provides measures for all current or past mailing lists to which a constituent has been assigned. | | |