RETURN TO BANNER EDW META DATA REPORTS LIST


Student Activity Star Report

Target Reports:

WDT_ACADEMIC_TIME - Academic Time Dimension
Academic Time dimension provides information about the academic period, year and aid year.
WDT_ACTIVITY - Activity Dimension
Contains attributes about an activity associated with a person within a time frame. Details include the activity codes that permit the activities to be grouped different ways for reporting purposes that include activity type and activity category.
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_ACTIVITY - Student Activity Fact Table
Current version of all activities for each academic period for a student. Use the Student Activity star schema to understand the numbers for the academic period grouping by the categories and types defined with the student activity. This data may be joined with other star schemas for analysis.

Source Reports:

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


Ver: 9.0