RETURN TO EDW META DATA REPORTS LIST


Recruiting And Admission Star Report

Target Reports:

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_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_FINANCIAL_AID_STATUS - Financial Aid Status Dimension
Financial Aid Status Dimension table provides information on the processing steps completed for financial aid. This information includes award offered, accepted, declined or canceled and paid. It uses the cleansing rules in the EDW for the short and long descriptions.
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_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 - Pre Student Dimension
Pre-Student Dimension table provides information for the person who may be inquiring or applying to study at the institution. This information includes academic percentile (secondary school rank/size) and the test scores identified for the student level load of data. It uses the cleansing rules in the EDW for the short and long descriptions as well as the definition of the ranges for each particular test score and the academic percentile.
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_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_STUDENT_APPLICATION - Student Application Dimension
Student Application Dimension table provides information for the individual that has completed an admission application. This will be the data on the admission application record that identifies the cohort, applicant type and student population to which this person is to be tracked. 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_RECRUITING_AND_ADMISSION - Recruiting And Admission Fact Table
Recruiting and Admission 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.

Source Reports:

ACADEMIC_OUTCOME
ADMISSIONS_APPLICATION
ADMISSIONS_COHORT
AWARD_BY_PERSON
EDW CLEANSING PROCESS
EMPLOYMENT_HISTORY
ETL GENERATED
INSTITUTION
PERSON
PRE_STUDENT
RECRUITMENT_INFORMATION
TEST
YEAR_TYPE_DEFINITION


Ver: 3.1