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_SD ACADEMIC_PERIOD_LD	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_SD ACADEMIC_YEAR_LD	COURSE INSTRUCTOR COURSE INSTRUCTOR	NO NO
ADMINISTRATIVE_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	ADMINISTRATIVE_GROUP	COURSE INSTRUCTOR	NO
COURSE_REFERENCE_NUMBER	NO	DIMENSION TABLE	WDT_COURSE_REFERENCE_NUMBER	COURSE_REFERENCE_NUMBER	COURSE INSTRUCTOR	NO
INSTRUCTOR_NAME	NO	DIMENSION TABLE	WDT_INSTRUCTOR	INSTRUCTOR_NAME	STUDENT COURSE	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_LD MULTI_SOURCE_SD	COURSE INSTRUCTOR COURSE INSTRUCTOR	NO NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	COURSE INSTRUCTOR	NO
SUB_ACADEMIC_PERIOD	NO	DIMENSION TABLE	WDT_TIME	SUB_ACADEMIC_PERIOD	EMPLOYEE POSITION	NO

Ver: 9.0