RETURN TO BANNER EDW META DATA REPORTS LIST


Student Cohort Star Report

Target Reports:

WDT_ACADEMIC_TIME - Academic Time Dimension
Academic Time dimension provides information about Academic period, year and aid year.
WDT_COHORT - Cohort Dimension
Cohort dimension table contains institution defined values recorded in Banner to group students within an academic period. The groups wants to track from admission to graduation.
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_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.

WFT_STUDENT_COHORT - Student Cohort Fact Table
All current cohort codes associated with the student record. Use the Student Cohort star schema to understand trends over academic periods. Analyze the number and types of cohorts being used and how the persons with those cohorts perform. The student cohort data includes academic period end which implies the time frame expected as the completion academic period. This data will be joined with other star schemas for analysis.

Source Reports:

ADMISSIONS_COHORT
CALCULATION
CALCULATION
CALCULATION
EDW CLEANSING PROCESS
ETL_GENERATED
FUNCTION
FUNCTION
FUNCTION
PERSON
PERSON
PERSON
PERSON
PERSON_SENSITIVE_RACE
PERSON_VETERAN
STUDENT
STUDENT_COHORT
TELEPHONE
VISA
YEAR_TYPE_DEFINITION


Ver: 9.0