WDT_ACADEMIC_STUDY - Academic Study Dimension
| Academic Study Dimension table provides information for the program of study for the individual. This may be the data on the admission application or the academic outcome record that identifies the major subject area and sought award or degree, etc. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_ACADEMIC_TIME - Academic Time Dimension
| Academic Time dimension provides information about the academic period, year and aid year. | | |
WDT_APPLICATION_SUPL_DATA - Application Supl Data Dimension
| Application Supplemental Data dimension table provides information for the person as data captured specific to institution additional definition. This information includes a descriptive label and the data value captured for a person associated with an academic period and application number. The data may as desired have an institution defined set of cleansing values that may standardize or group data into ranges depending on the type of data defined at an institution. | | |
WDT_APPLICATION_SUPL_IND - Application Supl Ind Dimension
| Application Supplemental Indicator dimension table provides information for the person as data captured specific to institution additional definition. This information includes a descriptive label and either a yes or a no value for a person associated with an academic period and application number. Cleansing rules can define a specific label associated with the yes value and a different label for the no value to be used on reports. | | |
WDT_CALENDAR_DATE - Calendar Date Dimension
| 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_STATUS - Financial Aid Status Dimension
| Financial Aid Status dimension table provides data on whether or not a person applied for, was offered, accepted, etc. financial aid. | | |
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
| Indicator dimension table provides the default yes and no options for indicators. | | |
WDT_MULTI_SOURCE - Multi Source Dimension
| Multi-source Dimension table provides information on the sources) 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_POSTAL - Postal Dimension
| Postal dimension table provides all data that is common to a postal code. | | |
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. | | |
WDT_PRE_STUDENT_STATUS - Pre Student Status Dimension
| Pre-Student Status Dimension table provides information on the processing steps completed for those applying to study at the institution. This information includes inquired, applied, admitted, accepted and enrolled. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_SEQUENCE - Sequence Dimension
| Sequence dimension table provides the set of sequence numbers. | | |
WDT_STUDENT - Student Dimension
| Student Dimension table provides information for the person as the student for the time frame. This information includes student population (New first time, continuing, re-admit, etc.), year of study or student class, residency (in district or out) and campus affiliation. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_STUDENT_APPLICATION - Student Application Dimension
| Student Application dimension table provides data specific to an admissions application. For example, the application status and the primary source for the application number. | | |
WFT_ADMISSIONS_APPLICATION - Admissions Application Fact Table
| Admission Application fact table provides measures that may be compared and displayed based on the dimensions in this star schema. This set of measures is stored per person per time frame per application. | | |