WAT_MANAGE_PROSPECT_PIPELINE_B - Manage Prospect Pipeline B Fact Table
| Manage prospect pipeline B aggregate table is the central table of the Manage Prospect Pipeline B aggregate star. It is based on data from the following fact tables: WFT_PROSPECT, WFT_PROPOSAL, WFT_PROPOSAL_PURPOSE. This is defined as one row per prospect, per proposal or per proposal purpose. It is used to manage all attributes associated to a prospect and their related proposal or proposal purposes. | | |
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_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_DONOR_SUMMARY - Donor Summary Dimension
| Donor summary dimension table contains summary giving information for a donor. | | |
WDT_FISCAL_DATE - Fiscal Date Dimension
| The Fiscal Date Dimension table provides information on the time frame for which the rest of the associated dimension and fact tables are storing the information in the star. | | |
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_TOTAL - Giving Total Dimension
| Giving total dimension table contains summary giving information for a donor by fiscal year. The columns refer to both annual and non-annual information. If the fiscal years of the allocation types (both annual and non-annual) do not match, then the information in these records will consist of overlapping calendar time periods from the same fiscal years. | | |
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_PROPOSAL_PURPOSE - Proposal Purpose Dimension
| Proposal purpose dimension table contains information specific to the proposal purpose/project. | | |
WDT_PROSPECT - Prospect Dimension
| Prospect dimension table identifying information about the prospect such as ID and name. | | |
WDT_STAGE - Stage Dimension
| Stage dimension table contains the various stages that a prospect/program prospect, prospect proposal, or prospect interest can be in. 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. | | |