WDT_CONTACT_REPORT - Contact Report Dimension
| Contact report dimension table contains information specific to each contact for all constituent and prospect contacts. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_CONTACT_REPORT_CREDIT - Contact Report Credit Dimension
| Contact report credit dimension table provides attributes associated with all contacts made with a constituent or prospect for which a fundraiser will receive credit. 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_STAFF - Staff Dimension
| Staff dimension table contains information about the staff assigned to a prospect. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_UNIT - Unit Dimension
| Unit dimension table identifies schools or units and descriptions. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WFT_CONTACT_REPORT_CREDIT - Contact Report Credit Fact Table
| Contact report credit fact table provides measures for all contacts made with a constituent or prospect for which a fundraiser will receive credit. How many overall contact credits, how many visit contact credits, which credit recipient is the contact author, contact date and credit recipient ID. | | |