WDT_ADVANCEMENT_APPEAL - Advancement Appeal Dimension
| Advancement appeal dimension table provides information about advancement appeals. 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_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_CLASS_SCHOOL - Class School Dimension
| Class school dimension table contains the preferred class year and school for a constituent. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_CONSTITUENT_ENTITY_TYPE - Constituent Entity Type Dimension
| Constituent entity type dimension table provides donor information about the constituent such as the CFAE, if this is a person or organization, alumni, board member, student, faculty, etc. 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_GIVING_ATTRIBUTE - Giving Attribute Dimension
| Giving attribute dimension table provides gift detail information indicating transaction type and donor association for pledges, pledge soft credit, pledge hard credit, gifts, gift hard credit, gift soft credit, pledge payments, pledge payment soft credit, pledge payment hard credit, matching claims, matching gifts, and matching gift soft credit. Determines gift or pledge or matching gift or matching claim and associated giving vehicles and special handling. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_MATCHING_CLAIM - Matching Claim Dimension
| Matching claim detail dimension table provides common attribute information about matching claims such as claim status, claim paid status, claim active status, and if claim form was received. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_MATCHING_CLAIM_DETAIL - Matching Claim Detail Dimension
| Matching claim detail dimension table provides attribute information about matching claims such as gift number and gift sequence. | | |
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_REUNION_CAMPAIGN - Reunion Campaign Dimension
| Reunion campaign dimension table provides information about campaigns for reunions and the associated type. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_YEAR_OF_GIVING - Year Of Giving Dimension
| Year of giving dimension table provides common attribute information for the fiscal year. | | |
WFT_MATCHING_CLAIM - Matching Claim Fact Table
| Matching claim fact table provides measures such as matching companies, donors matched, claim amounts, gift date, receipt date, status date, and match form received date, as well as counts for matching claims, active matching claims, and designations. | | |