Banner EDW Source: INSTRUCTIONAL_ASSIGNMENT

	RETURN TO BANNER EDW META DATA REPORTS LIST
	(Banner ODS Target Report)

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
ACADEMIC_PERIOD	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_PERIOD	COURSE INSTRUCTOR	NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD	COURSE INSTRUCTOR COURSE INSTRUCTOR	NO NO
ACADEMIC_YEAR	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_YEAR	COURSE INSTRUCTOR	NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD	COURSE INSTRUCTOR COURSE INSTRUCTOR	NO NO
ADMINISTRATIVE_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	ADMINISTRATIVE_GROUP	COURSE INSTRUCTOR	NO
ASSIGNMENT_TYPE	NO
ASSIGNMENT_TYPE_DESC	NO
CATEGORY	NO
CONTRACT_TYPE	NO
CONTRACT_TYPE_DESC	NO
COURSE_REFERENCE_NUMBER	NO	DIMENSION TABLE	WDT_COURSE_REFERENCE_NUMBER	COURSE_REFERENCE_NUMBER	COURSE INSTRUCTOR	NO
INSTRUCTOR_FIRST_NAME	NO
INSTRUCTOR_ID	NO
INSTRUCTOR_LAST_NAME	NO
INSTRUCTOR_NAME	NO	DIMENSION TABLE	WDT_INSTRUCTOR	INSTRUCTOR_NAME	STUDENT COURSE	NO
JOB_SUFFIX	NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	COURSE INSTRUCTOR	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_SD MULTI_SOURCE_LD	COURSE INSTRUCTOR COURSE INSTRUCTOR	NO NO
PERCENT_RESPONSIBILITY	NO
PERSON_UID	NO
POSITION	NO
PRIMARY_IND	NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	COURSE INSTRUCTOR	NO
SESSION_PERCENTAGE	NO
SUB_ACADEMIC_PERIOD	NO
SUB_ACADEMIC_PERIOD_DESC	NO
WEEKLY_CONTACT_HOURS	NO
WORKLOAD_ADJUST	NO

Ver: 8.4.3