RETURN TO BANNER EDW META DATA REPORTS LIST


Student Course Attribute 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_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_ATTRIBUTE - Course Attribute Dimension
Course Attribute Dimension table contains data that is a characteristic of how the student course may be used in satisfying degree completion or in grouping for reporting.
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_COURSE_ATTRIBUTE - Student Course Attribute Fact Table
Student Course Attribute Dimension table provides data about the student course attributes associated with a course recorded for the student. Student course attributes facilitate grouping the student courses used to complete academic requirements and or reporting groups of students with specific types of courses such as developmental courses.

Source Reports:

COURSE_CATALOG
EDW CLEANSING PROCESS
ETL_GENERATED
PERSON
PERSON
SCHEDULE_OFFERING
STUDENT_COURSE
STUDENT_COURSE_ATTRIBUTE
TELEPHONE
YEAR_TYPE_DEFINITION


Ver: 9.0