WDT_ADVANCEMENT_OFFICE - Advancement Office Dimension
| Advancement office dimension table contains a list of advancement offices used in prospect tracking. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_ASSIGNMENT - Assignment Dimension
| Assignment dimension table contains attributes of the staff assigned directly to a prospect or to a prospect via a proposal assignment. Data includes the type of assignment, if the staff is a solicitor and if the assignment is active. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_CAMPAIGN - Campaign Dimension
| Campaign Dimension table provides information regarding campaigns run by the institution. This information includes the name given to the campaign and the type of campaign. 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_PROSPECT - Prospect Dimension
| Prospect dimension table identifying information about the prospect such as ID and name. | | |
WDT_PROSPECT_ATTRIBUTE - Prospect Attribute Dimension
| Prospect attribute dimension table contains attributes for that prospect such as type, group, classification, affiliation, referral, status, etc. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_PROSPECT_SHARED_ATTRIBUTE - Prospect Shared Attribute Dimension
| Prospect shared attribute dimension table contains attributes shared between prospects and program prospects. It uses the cleansing rules 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_STAGE - Stage Dimension
| Stage dimension table contains the various stages that a prospect/program prospect, prospect proposal, or prospect interest can be in. 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_PROSPECT - Prospect Fact Table
| Prospect fact table provides measures counting prospects, how many prospects are active, rated, major, or planned giving, start and end dates, rated amount, result amount, rated entry date, result date, target date and if the prospect has assigned staff. | | |