Dimension Table Target: WDT

	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: 8.1

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