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_CONTACT_REPORT - Contact Report Dimension
| Contact report dimension table contains all prospect contacts. | | |
WDT_CONTACT_REPORT_ATTRIBUTE - Contact Report Attribute Dimension
| Contact report attribute dimension table contains all prospect contacts and information about the contact. 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_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_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_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_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_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. | | |
WFT_CONTACT_REPORT - Contact Report Fact Table
| Contact report fact table provides measures for the contacts made with a entity. What was the last amount, how many contact, which was the last contact or first contact made regarding proposals, proposal purposes, general prospecting, and general contacts. | | |