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_CONSTITUENT - Constituent Dimension
| Constituent Dimension table provides information for the person or entity (organization) that has given or is being solicited for gifts to the institution. This information includes identification of whether this is an individual or organization, whether they have given in the time frame, and preferences identified for the constituent. 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 graduand 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 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 regarding the reasons a gift was given to the institution. This information includes the type, status, purpose, etc.. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_GIFT - Gift Dimension
| Gift Dimension table provides details regarding the gift. This information includes information on the type of gift, whether there is an auxiliary or matching gift and the method by which the gift was received. 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.One row per multi_source per process group per admistrative group. | | |
WDT_PLEDGE - Pledge Dimension
| Pledge Dimension table provides information on whether the gift was the result of a pledge. This information includes type of pledge, method of pledge and amount of pledge, etc.. It uses the cleansing rules in the EDW for the short and long descriptions and for the ranges for the original and outstanding pledge amounts. | | |
WDT_PLEDGE_RANGE - Pledge Range Dimension
|
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_TIME - Time Dimension
| Time Dimension table provides information on the time frame for which the rest of the associated dimension and fact table are storing the information in the star. The time dimension may be based either on a calendar, academic, financial aid or fiscal year, The time frame will go down at least one and sometimes two layers to periods and or sub periods of time. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WFT_ADVANCEMENT_GIFT - Advancement Gift Fact Table
| Advancement Gift Fact table provides measures that may be compared and displayed based on the dimensions in this star schema. This set of measures is stored per person or entity per time frame per gift number and optionally pledge number. | | |