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

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_INSTRUCTOR

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

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
HOME_COLLEGE Faculty members employment home college. College is the first or highest layer of the institutions organization. VARCHAR2(63)

FACULTY

HOME_COLLEGE

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

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

FACULTY

HOME_COLLEGE_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

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

FACULTY

HOME_COLLEGE_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

HOME_DEPARTMENT Faculty members employment home department. Department is the third layer of the institutions organization. VARCHAR2(63)

FACULTY

HOME_DEPARTMENT

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

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

FACULTY

HOME_DEPARTMENT_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

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

FACULTY

HOME_DEPARTMENT_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

INSTRUCTOR_KEY Key for the instructor dimension NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

INSTRUCTOR_NAME Full name of the faculty member. Displayed as first name middle name and then last name. VARCHAR2(255)

PERSON

FULL_NAME_FMIL

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

INSTRUCTOR_UID System internally generated ID to uniquely identify the person. NUMBER

FACULTY

PERSON_UID

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