WDT_ADMINISTRATION - Administration Dimension
| Administration Dimension table provides information for the person and their reporting structure within the institution. This information includes employer code, home organization and home chart of accounts. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_DEMOGRAPHIC - Demographic Dimension
| Demographic Dimension table provides information for the person that is consistent whether this is an employee, inquirer, applicant, student or graduand 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_EMPLOYMENT_HISTORY - Employment History Dimension
| Employment History Dimension table provides information on the employers for the person that are stored in the system. This information includes employer name and type of industry for the company. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_HR_APPLICANT - Hr Applicant Dimension
| HR Applicant Dimension table provides information on the person that is applying for employment. This information includes whether or not they attended this institution (alumnus), if they are currently employed and how they learned of the position. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_HR_APPLICANT_STATUS - Hr Applicant Status Dimension
| HR Applicant Status Dimension table provides information on the person that where they are in the process of applying for employment. This information includes whether or not they have a formal application, had an interview, were offered the position and have accepted and started employment in the position. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_HR_REQUISITION - Hr Requisition Dimension
| HR Requisition Dimension table provides information on the position that has been advertised. This information includes number of days the position has been open, mid point of the salary, whether it is full time or part time, etc.. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_INSTITUTION - Institution Dimension
| Contains all data that is common to an institution. | | |
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.One row per multi_source per process group per admistrative group. | | |
WDT_POSITION - Position Dimension
| Position Dimension table provides information on the position as defined for the applicant or employee. This information includes position status, position class, contract type and campus, etc. . It uses the cleansing rules in the EDW for the short and long descriptions. | | |
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_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_TIME - Time Dimension
| Time Dimension table provides information on the time frame for which the rest of the associated dimension and fact table are storing the information in the star. The time dimension may be based either on a calendar, academic, financial aid or fiscal year, The time frame will go down at least one and sometimes two layers to periods and or sub periods of time. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WFT_EMPLOYMENT_APPLICATION - Employment Application Fact Table
| Employment 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 requisition number. | | |