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_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. | | |
WFT_PROSPECT_STAGE - Prospect Stage Fact Table
| Prospect stage fact table provides measures for the start and end date of each stage and indentifies the latest stage. For Banner this is currently loaded with only the latest prospect stage. | | |