RETURN TO EDW META DATA REPORTS LIST


Academic Program Course Star Report

Target Reports:

WDT_ACADEMIC_PROGRAM - Academic Program Dimension
Academic Program Dimension table provides information for the program of study for the individual. This is the data in the academic study record that identifies the sought award or degree, etc.. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_CONCENTRATION - Concentration Dimension
Concentration Dimension table provides information for the concentration. This information includes the program classification, department and major the concentration is attached to (where appropriate). It uses the cleansing rules in the EDW for the short and long descriptions.
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_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_ENROLLMENT_STATUS - Enrollment Status Dimension
Enrollment Status Dimension table provides information for the person that includes the time frame status of enrollment. This information includes whether they intended to study full or part time, whether or not they are currently enrolled and their current time status based on the institution defined rules. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_INSTRUCTOR - Instructor Dimension
Instructor Dimension table provides information for the person who is providing the instruction for the schedule offering. This information includes instructor name and home college and department. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_MAJOR - Major Dimension
Major Dimension table information for the major. This information includes the program classification and department. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_MINOR - Minor Dimension
Minor Dimension table provides information for the minor. This information includes the program classification and department. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_MULTI_SOURCE - Multi Source Dimension
Multi Source Dimension table provides an institution source value when the optional multi-source feature has been applied. Institution source VALUES have a short and long description. Data in this dimension may optionally include a process-oriented identifier and an administrative-oriented identifier for the record used to determine access authorization to this record. The cleansing rules are used in the EDW for the short and long descriptions.One row per multi_source per process group per admistrative group.
WDT_REGISTRATION - Registration Dimension
Registration Dimension table provides information for the person that includes the time frame registration status for a schedule offering. This information includes final grade if assigned, type of grading (regular, Pass/Fail, Audit, etc.) and section registration status. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_TIME - Time Dimension
Time Dimension table provides information on the time frame for which the rest of the associated dimension and fact table are storing the information in the star. The time dimension may be based either on a calendar, academic, financial aid or fiscal year, The time frame will go down at least one and sometimes two layers to periods and or sub periods of time. It uses the cleansing rules in the EDW for the short and long descriptions.

WFV_ACADEMIC_PROGRAM_COURSE - Academic Program Course Fact Table
Academic Program Course 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 per academic program for the schedule offering.

Source Reports:

ACADEMIC_STUDY
COURSE_CATALOG
EDW CLEANSING PROCESS
ENROLLMENT
ETL GENERATED
FACULTY
FUNCTION
NA
PERSON
STUDENT_COURSE
YEAR_TYPE_DEFINITION


Ver: 3.1