RETURN TO BANNER EDW META DATA REPORTS LIST


Academic Outcome Star Report

Target Reports:

WDT_ACADEMIC_OUTCOME - Academic Outcome 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_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_ACADEMIC_TIME - Academic Time Dimension
Academic Time dimension provides information about the academic period, year and aid year.
WDT_CALENDAR_DATE - Calendar Date Dimension
The Calendar Date Dimension table provides information on the time frame for which the rest of the associated dimension and fact tables are storing the information in the star. The time frame will go down at least one and sometimes two layers to periods and or sub periods of time.
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_ACADEMIC_OUTCOME - Academic Outcome Fact Table
Academic Outcome Fact table provides information and details for each academic outcome (award, degree, diploma, certificate, etc.) sought and awarded by the institution.

Source Reports:

ACADEMIC_OUTCOME
CALCULATION
CALCULATION
CALCULATION
EDW CLEANSING PROCESS
ETL GENERATED
ETL GENERATED
ETL GENERATED
ETL GENERATED
ETL_GENERATED
FUNCTION
FUNCTION
FUNCTION
PERSON
PERSON
PERSON_SENSITIVE
PERSON_SENSITIVE_RACE
PERSON_VETERAN
STUDENT
TELEPHONE
VISA
YEAR_TYPE_DEFINITION
YEAR_TYPE_DEFINITION


Ver: 9.0