Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_TIME_KEY	Key for the Academic Time dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE INSTRUCTOR
COURSE_REFERENCE_NUMBER_KEY	Key for the Course Reference Number dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE INSTRUCTOR
CRN_INSTRUCTOR_COUNT	Count of unique Insturctor UID (PIDM) for a CRN within an academic period.	NUMBER	CALCULATION	INSTRUCTOR_KEY * 1000000 + ACADEMIC_TIME_KEY * 100 + MULTI_SOURCE_KEY	NO	NO	COURSE INSTRUCTOR
INSTRUCTOR_CRN_COUNT	Count of unique CRNs for an instructor within an academic period.	NUMBER	CALCULATION	COURSE_REFERENCE_NUMBER_KEY * 1000000 + ACADEMIC_TIME_KEY * 100 + MULTI_SOURCE_KEY	NO	NO	COURSE INSTRUCTOR
INSTRUCTOR_GROUP_KEY	Unique identifier for all the Instructors for a course (CRN) within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE INSTRUCTOR
INSTRUCTOR_KEY	Key for the Instructor dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE INSTRUCTOR
MULTI_SOURCE_KEY	Key for the Multi Source dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE INSTRUCTOR
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE INSTRUCTOR
PRIMARY_INSTRUCTOR_IND	Indicats whether an instructor is the primary instructor for a course (CRN) in an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE INSTRUCTOR
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL_GENERATED	NA	NO	NO	COURSE INSTRUCTOR
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL_GENERATED	NA	NO	NO	COURSE INSTRUCTOR

Ver: 9.0