WAT_MANAGE_PROSPECT_PIPELINE - Manage Prospect Pipeline Fact Table
| Manage prospect pipeline aggregate table is the central table of the Manage Prospect Pipeline aggregate star. It is based on data from the following fact tables: WFT_PROSPECT and WFT_PROPOSAL. This is defined as one row per prospect, per proposal. If the prospect does not have any assigned proposals, the prospect is still included in this table. It is used to manage all attributes associated to a prospect and their proposal information. | | |
WDT_ADDRESS_TYPE - Address Type Dimension
| Address type dimension table contains attributes for all addresses including type, status and descriptions. 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_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_ASSIGNMENT - Assignment Dimension
| Assignment dimension table contains attributes of the staff assigned directly to a prospect or to a prospect via a proposal assignment. Data includes the type of assignment, if the staff is a solicitor and if the assignment is active. 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_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_CONTACT_REPORT - Contact Report Dimension
| Contact report dimension table contains information specific to each contact for all constituent and prospect contacts. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_CONTACT_REPORT_ATTRIBUTE - Contact Report Attribute Dimension
| Contact report attribute dimension table provides attributes associated with all constituent and prospect contacts. 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_DONOR_SUMMARY - Donor Summary Dimension
| Donor summary dimension table contains summary giving information for a donor. | | |
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_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_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_NON_ENTITY_RELATION - Non Entity Relation Dimension
| Non-Entity Relation dimension table provides information about a person or organization who is a non-entity. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_POSTAL - Postal Dimension
| Contains all data that is common to a postal code. | | |
WDT_PROGRAM_PROSPECT_ATTRIBUTE - Program Prospect Attribute Dimension
| Program prospect attribute dimension table provides program information for that prospect. 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_PROPOSAL_ATTRIBUTE - Proposal Attribute Dimension
| Proposal attribute dimension contains attributes specific to the proposal, like proposal type, funding type, submit type, active proposal status, etc. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_PROSPECT - Prospect Dimension
| Prospect dimension table identifying information about the prospect such as ID and name. | | |
WDT_PROSPECT_ATTRIBUTE - Prospect Attribute Dimension
| Prospect attribute dimension table contains attributes for that prospect such as type, group, classification, affiliation, referral, status, etc. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_PROSPECT_SHARED_ATTRIBUTE - Prospect Shared Attribute Dimension
| Prospect shared attribute dimension table contains attributes shared between prospects and program prospects. 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_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_STREET_ADDRESS - Street Address Dimension
| Street Address dimension table contains the street line information for each address of record. | | |
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_WAREHOUSE_ENTITY - Warehouse Entity Dimension
| Warehouse entity dimension table contains cross reference entity information between different source ERPs. As an example, this is where the true pidm for Banner is stored or the true id_number for Advance is stored. A one-up number is generated for the UID. This way if the person exists in both source systems, it allows that person to exist as a single entity, rather than one separate to each Advance and Banner. | | |