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 the staff assigned to a prospect through normal assignment or through a proposal and attributed noting the type of assignment, if the staff is a solicitor, if the assignment if active and the assignment priority. 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 committee's 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 intended receiving college, department, campus, division, purpose, etc. 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 information on the source(s) of information. This information is the multi-source code and its descriptions along with the process group and administrative group. It uses the cleansing rules 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. | | |