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_FINANCIAL_AID_BUDGET_GRP - Financial Aid Budget Grp Dimension
| Financial Aid Budget Group Dimension table provides information on the financial aid applicant's budget group assigned for the financial aid year. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_FINANCIAL_AID_PACKAGE_GRP - Financial Aid Package Grp Dimension
| Financial Aid Package Group Dimension table provides information on the financial aid applicant's package group assigned for the financial aid year. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_FINANCIAL_AID_YEAR - Financial Aid Year Dimension
| The Financial Aid Year dimension provides information on the financial aid year. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_INDICATOR - Indicator Dimension
| The Indicator dimension provides the default yes and no options for indicators. | | |
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. | | |
WFT_FINAID_APPLICATION - Finaid Application Fact Table
| Financial Aid Application fact table provides information about the financial aid applicant for the aid year. This information includes needs analysis measures calculated within the ERP by both the federal methodology and the institutional methodology as well as some overall data about the applicant for the financial aid year. | | |