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