RETURN TO BANNER EDW META DATA REPORTS LIST


Course Section Star Report

Target Reports:

WDT_ACADEMIC_TIME - Academic Time Dimension
Academic Time dimension provides information about Academic period, year and aid year.
WDT_COURSE - Course Dimension
Course Dimension table provides information for the course or subject offering scheduled. This information includes course identification (ex. ENG 110), Course title long and short, Program classification or government reporting code, subject area and the organization within the institution responsible for providing the instructional content. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_COURSE_REFERENCE_NUMBER - Course Reference Number Dimension
Course Reference Number Dimension table provides the valid course reference numbers that have been used in combination with an academic period to identify a section or unique course offering.
WDT_COURSE_SECTION - Course Section Dimension
Course Section Dimension Table provides information specific to the section instruction and if the section is graded.
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_SUB_ACADEMIC_PERIOD - Sub Academic Period Dimension
Sub Academic Time Dimension table provides information about the a part of academic period.

WFT_COURSE_SECTION - Course Section Fact Table
Course Section 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 course reference number for the course section.

Source Reports:

COURSE_CATALOG
COURSE_SCHEDULE
EDW CLEANSING PROCESS
ETL_GENERATED
FUNCTION
FUNCTION
FUNCTION
SCHEDULE_OFFERING
STUDENT_COURSE
YEAR_TYPE_DEFINITION


Ver: 9.0