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_ADVANCEMENT_PROGRAM - Advancement Program Dimension
| Advancement program dimension table contains a list of programs that may be linked to prospects. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_ADVANCEMENT_PROGRAM_YEAR - Advancement Program Year Dimension
| Advancement program year dimension table contains a list of years that a prospect may be linked to. | | |
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_COMMITTEE - Committee Dimension
| Committee dimension table provided a list of committees a constituent is participating. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_DESIGNATION - Designation Dimension
| Designation Dimension table provides information regarding the reasons a gift was given to the institution. This information includes the type, intended receiving college, purpose, etc. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_DESIGNATION_DETAIL - Designation Detail Dimension
| Designation detail dimension table provides information about a designation, including name, type, status and purpose. 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_FUNDRAISING_INITIATIVE - Fundraising Initiative Dimension
| Fundraising initiative dimension table provides information about proposal projects/purposes/interests. 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_PROPOSAL - Proposal Dimension
| Proposal dimension table contains descriptions and comments for a proposal. | | |
WDT_PROSPECT - Prospect Dimension
| Prospect dimension table identifying information about the prospect such as ID and name. | | |
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_ASSIGNMENT - Assignment Fact Table
| Assignment fact table provides information about the staff assignments to a prospect or entity. | | |