WAT_STUDENT_PROGRESS - Student Progress Fact Table
| Student Progress Aggregate Table. | | |
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_BANNER_COMMUNICATION - Banner Communication Dimension
| Banner Communication dimension table provides data about the communication and or material type, whether it was part of a communication plan, published or generated and what Banner processing initiated the request (recruitment, admissions, advancement, financial aid, etc.). | | |
WDT_CONTACT - Contact Dimension
| Contact dimension table provides data on the types of contacts tracked. | | |
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_ENROLLMENT_STATUS - Enrollment Status Dimension
| Enrollment Status Dimension table provides information for the person that includes the time frame status of enrollment. This information includes whether they intended to study full or part time, whether or not they are currently enrolled and their current time status based on the institution defined rules. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
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_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_GRADUATION_MULTI_YEAR - Graduation Multi Year Dimension
| Graduation Multi Year dimension provides a set of indicators that identify the year from the initial academic period in which the student is awarded a degree, award, etc. | | |
WDT_INSTITUTION - Institution Dimension
|
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_POSTAL - Postal Dimension
| Postal dimension table provides all data that is common to a postal code. | | |
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_RETENTION - Retention Dimension
| Retention Dimension table contains indicators that identify the student's overall, student level, program and college retention status. | | |
WDT_RETENTION_MULTI_YEAR - Retention Multi Year Dimension
| Retention Multi Year dimension provides a set of indicators that identify the year from the initial academic period is the student retained, not retained or exclude in headcounts and retention rate calculations. | | |
WDT_RETENTION_TIME - Retention Time Dimension
| Retention Time Dimension table uses institution defined rules to identify the like and sequential academic periods for tracking retention headcounts and rates. | | |
WDT_SECONDARY_SCHOOL - Secondary School Dimension
| Secondary School Dimension table provides information on the secondary or high school which the person attended. This information includes name of the school and type of diploma earned. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_STREET_ADDRESS - Street Address Dimension
| Street Address dimension table contains the street line information for each address of record. | | |
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_PERFORMANCE - Student Performance Dimension
| Student Performance Dimension table provides information for the person that includes basic academic standing and achievement coded values assigned to the student. This information includes academic standing, overrides, dean's list, etc.. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_STUDENT_STATUS - Student Status Dimension
| Student Status Dimension table provides as set of indicators based on the student satisfying or not satisfying a number of criteria that may be used to divide and classify students into various common attributes for reporting. This information includes enrolled, new student, academic outcome awarded, cooperative education, developmental, continuing education, etc. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_TEST - Test Dimension
| Test dimension table provides all test data. | | |