WDT_EMAIL - Email Dimension
| Email dimension table provides the actual email address and related forwarding email address as applicable, for individual constituent emails. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_EMAIL_ATTRIBUTE - Email Attribute Dimension
| Email attribute dimension table provides information about email addresses. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_EMAIL_COMMENT - Email Comment Dimension
| Email comment dimension table provides comments about a constiutent's email address. 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_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. | | |
WFT_EMAIL - Email Fact Table
| Email fact table provides measures for all active or inactive email addresses associated with a constituent. | | |