RETURN TO DIMENSION TABLE REPORTS LIST
Academic Program Course Star Course Registration Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_COURSE

Description 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.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
COURSE_CAMPUS Campus scheduling the offering. VARCHAR2(63)

STUDENT_COURSE

CAMPUS

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_CAMPUS_LD Long description of the campus. VARCHAR2(255)

STUDENT_COURSE

CAMPUS_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_CAMPUS_SD Short description of the campus. VARCHAR2(255)

STUDENT_COURSE

CAMPUS_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_COLLEGE College, School or Faculty responsible for the instruction in the offering. VARCHAR2(63)

STUDENT_COURSE

COLLEGE

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_COLLEGE_LD Long name of the first layer of the institution's organization. VARCHAR2(255)

STUDENT_COURSE

COLLEGE_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_COLLEGE_SD Short name of the first layer of the institution's organization. VARCHAR2(255)

STUDENT_COURSE

COLLEGE_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_DEPARTMENT Department responsible for the instruction in the offering. VARCHAR2(63)

STUDENT_COURSE

DEPARTMENT

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_DEPARTMENT_LD Long name of the third layer of the institution's organization. VARCHAR2(255)

STUDENT_COURSE

DEPARTMENT_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_DEPARTMENT_SD Short name of the third layer of the institution's organization. VARCHAR2(255)

STUDENT_COURSE

DEPARTMENT_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_DIVISION Optional Division of the institution responsible for the instruction in the offering. VARCHAR2(63)

STUDENT_COURSE

DIVISION

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_DIVISION_LD Long name of the second layer of the institution's organization. VARCHAR2(255)

STUDENT_COURSE

DIVISION_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_DIVISION_SD Short name of the second layer of the institution's organization. VARCHAR2(255)

STUDENT_COURSE

DIVISION_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_IDENTIFICATION Course subject and course number combined VARCHAR2(255)

STUDENT_COURSE

COURSE_IDENTIFICATION

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_KEY Key for the course dimension NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_LEVEL Level of study for the student's program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc. VARCHAR2(63)

STUDENT_COURSE

COURSE_LEVEL

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_LEVEL_LD Long description for level of study. VARCHAR2(255)

STUDENT_COURSE

COURSE_LEVEL_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_LEVEL_SD Short description for level of study. VARCHAR2(255)

STUDENT_COURSE

COURSE_LEVEL_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_NUMBER Course number assigned to the course to identify the course content. This might be logical groupings like 100s or 1000s to identify first year courses, etc. VARCHAR2(63)

STUDENT_COURSE

COURSE_NUMBER

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_TITLE_LONG Long Course Title. VARCHAR2(255)

STUDENT_COURSE

TITLE_LONG_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

COURSE_TITLE_SHORT Short Course Title. VARCHAR2(255)

STUDENT_COURSE

TITLE_SHORT_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

PROGRAM_CLASSIFICATION Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting. VARCHAR2(63)

COURSE_CATALOG

CLASSIFICATION_INSTRUCT_PROG

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

PROGRAM_CLASSIFICATION_LD Long text describing the area of study. For example description associated with the CIP codes used in Integrated Postsecondary Education Data System (IPEDS) reporting in the US. VARCHAR2(255)

COURSE_CATALOG

CLASS_INSTRUCT_PROG_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

PROGRAM_CLASSIFICATION_SD Short text describing the area of study. For example description associated with the CIP codes used in Integrated Postsecondary Education Data System (IPEDS) reporting in the US. VARCHAR2(255)

COURSE_CATALOG

CLASS_INSTRUCT_PROG_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

SCHEDULE Teaching method for the instruction in this scheduled offering. Examples may include lecture, lab, internet, etc. VARCHAR2(63)

STUDENT_COURSE

SCHEDULE

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

SCHEDULE_LD Long description of the schedule or instruction type. VARCHAR2(255)

STUDENT_COURSE

SCHEDULE_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

SCHEDULE_SD Short description of the schedule or instruction type. VARCHAR2(255)

STUDENT_COURSE

SCHEDULE_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

SUBJECT Subject code and area of study for the course. VARCHAR2(63)

STUDENT_COURSE

SUBJECT

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

SUBJECT_LD Long description of the subject area. VARCHAR2(255)

STUDENT_COURSE

SUBJECT_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

SUBJECT_SD Short description of the subject area. VARCHAR2(255)

STUDENT_COURSE

SUBJECT_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION



Ver: 3.1