WDT_CALENDAR_DATE - Calendar Date Dimension
| The Calendar 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. The time frame will go down at least one and sometimes two layers to periods and or sub periods of time. | | |
WDT_DEMOGRAPHIC - Demographic Dimension
| Demographic Dimension table provides information for the person that is consistent whether this is an employee, inquirer, applicant, student or graduate 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 of the ranges in this dimension. | | |
WDT_GEOGRAPHIC_REGION - Geographic Region Dimension
| Geographic Region dimension table contains all data related to institution defined divisions of geographic groups and regions. These may be the same across the institution or different as identified by different divisions of the institution. Institutions define a load parameter to determine the data by data warehouse product. | | |
WDT_INDICATOR - Indicator Dimension
| The Indicator dimension provides the default yes and no options for indicators. | | |
WDT_INSTITUTION - Institution Dimension
| Contains all data that is common to an institution. | | |
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. | | |
WDT_PERSON - Person Dimension
| Person Dimension table provides information on an individual. | | |
WDT_POST_SECONDARY_SCHOOL - Post Secondary School Dimension
| Post Secondary School Dimension table provides information on the post secondary school (college, university, trade school, etc after high school) that the person attended. This information includes name of the school and type of degree or award earned and the major subject area of study. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WFT_POST_SECONDARY_SCHOOL - Post Secondary School Fact Table
| Post Secondary School fact table provides measures that may be used to compare and display data regarding prior institution experience. | | |