RETURN TO EDW META DATA REPORTS LIST


Graduation Completion 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_GRADUATION - Graduation Dimension
Graduation Dimension table provides information for the person that is specific to a particular completion of award requirements. This information includes campus, cohort and enrolled time status (full time, part time, etc.) at the time of graduation, etc. 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_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_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_GRADUATION_COMPLETION - Graduation Completion Fact Table
Graduation Completion 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 outcome number (award).

Source Reports:

ACADEMIC_OUTCOME
ACADEMIC_STUDY
EDW CLEANSING PROCESS
ENROLLMENT
ETL GENERATED
PERSON
STUDENT
STUDENT_COHORT
YEAR_TYPE_DEFINITION


Ver: 3.1