RETURN TO EDW META DATA REPORTS LIST


Advancement Gift Star Report

Target Reports:

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_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_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.

Source Reports:

CAMPAIGN_GIVING_HISTORY
CONSTITUENT
DESIGNATION_GIVING_HISTORY
DONOR_CATEGORY
EDW CLEANSING PROCESS
ETL GENERATED
GIFT
GIFT_AUXILIARY
ORGANIZATIONAL_CONSTITUENT
PERSON
PLEDGE
YEAR_TYPE_DEFINITION


Ver: 3.1