RETURN TO BANNER EDW META DATA REPORTS LIST


Race Star Report

Target Reports:

WDT_ACADEMIC_TIME - Academic Time Dimension
The Academic Time dimension provides information about the academic period, year and aid year.
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_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_RACE - Race Dimension
Race dimension table defines both the race category and the race along with their associated descriptions. It uses the cleansing rules in the EDW for the short and long descriptions in this dimension.

WFT_RACE - Race Fact Table
Race fact table contains one row per person per race value stored for that person. This data includes the confirmed date when the data is verified with the person. Data in this fact is used to calculate the data for the race/ethnicity indicators including the RACE_ETHNICITY_CONFIRM_IND on the WDT_DEMOGRAPHIC dimension table.

Source Reports:

ADMISSIONS_APPLICATION
CALCULATION
CALCULATION
CALCULATION
EDW CLEANSING PROCESS
ETL GENERATED
ETL GENERATED
ETL GENERATED
ETL GENERATED
FUNCTION
FUNCTION
FUNCTION
PERSON
PERSON
PERSON
PERSON
PERSON_SENSITIVE_RACE
PERSON_SENSITIVE_RACE
STUDENT
TELEPHONE
VISA
VISA
YEAR_TYPE_DEFINITION


Ver: 9.0