WAT_ANALYZE_FUNDRAISING - Analyze Fundraising Fact Table
| Analyze fundraising aggregate table is the central table of the Analyze Fundraising aggregate star. It is based on data from the following fact tables: WFT_GIFT, WFT_PLEDGE, WFT_MATCHING_CLAIM. This is defined as one row per campaign, per campaign designation, per transaction (such as gift, pledge, or matching claim), per donor association (such as primary donor, hard credit recipient, soft credit recipient, or match donor.) It is used to analyze all donor gift and pledge activities. | | |
WDT_ADDRESS_TYPE - Address Type Dimension
| Address type dimension table contains the list of address types for addresses and its status and descriptions. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
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_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_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_CAMPAIGN - Campaign Dimension
| Campaign dimension table identifies all campaigns and common information as the campaign type, if the campaign is active, and if to include the campaign in giving. 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_ATTRIB - Constituent Entity Attrib Dimension
| Constituent entity attribute dimension table provides common indicative information about a constituent such as if they are a donor, if they have ever been contacted, or have a staff member assigned. 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_DEMOGRAPHIC - Demographic Dimension
| Demographic Dimension table provides information for the person that is consistent whether this is an employee, inquirer, applicant, student or graduate at the institution. This information includes gender, ethnicity, age range and family income range. It uses the cleansing rules in the EDW for the short and long descriptions as well as the definition. | | |
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_GOAL - Fundraising Goal Dimension
| Fundraising goal dimension table provides goal information about the goal type, goal identifiers and goal amount. 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_GIFT - Gift Dimension
| Gift dimension table provides common attribute information about outright gifts, pledge payment gifts and matching gifts; their types, payment types, gift classification, if a credit card payment is used, if the gift was anonymous, a bequest, if gift was acknowledged, has a match claim, and information for Council for Aid to Education Voluntary Support of Education (VSE) reporting, etc.. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_GIFT_DETAIL - Gift Detail Dimension
| Gift detail dimension table provides gift detail information about outright gifts, pledge payments, matching gifts and matching soft credit such as the gift number, matching gift number, gift check, number, comments, if this is a gift, matching gifting, or pledge payment etc. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_GIFT_REPORTING_INDICATOR - Gift Reporting Indicator Dimension
| Gift reporting indicators dimension table provides information about various gift indicators such as to ignore the transaction, total, gift, pledge, match, payment exception, expectancy, life income, outside trust, gift in kind, etc.. 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 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_PLEDGE - Pledge Dimension
| Pledge dimension table provides common attribute information about pledges, such as pledge type, pledge status, pledge paid status, electronic funds transfer type, if pledge is binding or recordable, pledge categories, if the pledge is active, anonymous, conditional, has been adjusted, to be included in giving, or is and installment, etc.. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_PLEDGE_DETAIL - Pledge Detail Dimension
| Pledge detail dimension table provides common attribute information about pledges such as the pledge number and pledge sequence, batch feed number and comments. | | |
WDT_POSTAL - Postal Dimension
| Postal dimension table provides all data that is common to a postal code. 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_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_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_STREET_ADDRESS - Street Address Dimension
| Street address dimension table contains street information about an address. | | |
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. | | |
WDT_YEAR_OF_GIVING - Year Of Giving Dimension
| Year of giving dimension table provides common attribute information for the fiscal year. | | |