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

SGHE Enterprise Data Warehouse Banner EDW Source: STUDENT_COURSE_ATTRIBUTE - NULL

Source Column Local Source Target Type Target Target Column Star Name Local Target
ACADEMIC_PERIOD NO

DIMENSION TABLE

WDT_ACADEMIC_TIME

ACADEMIC_PERIOD

STUDENT COURSE ATTRIBUTE 

NO

ACADEMIC_PERIOD_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_TIME

WDT_ACADEMIC_TIME

ACADEMIC_PERIOD_LD

ACADEMIC_PERIOD_SD

STUDENT COURSE ATTRIBUTE 

STUDENT COURSE ATTRIBUTE 

NO

NO

ACADEMIC_YEAR NO

DIMENSION TABLE

WDT_ACADEMIC_TIME

ACADEMIC_YEAR

STUDENT COURSE ATTRIBUTE 

NO

ACADEMIC_YEAR_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_TIME

WDT_ACADEMIC_TIME

ACADEMIC_YEAR_SD

ACADEMIC_YEAR_LD

STUDENT COURSE ATTRIBUTE 

STUDENT COURSE ATTRIBUTE 

NO

NO

ADMINISTRATIVE_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

ADMINISTRATIVE_GROUP

STUDENT COURSE ATTRIBUTE 

NO

COURSE_ATTRIBUTE NO

DIMENSION TABLE

WDT_COURSE_ATTRIBUTE

COURSE_ATTRIBUTE

STUDENT COURSE ATTRIBUTE 

NO

COURSE_ATTRIBUTE_DESC NO

DIMENSION TABLE

WDT_COURSE_ATTRIBUTE

WDT_COURSE_ATTRIBUTE

COURSE_ATTRIBUTE_SD

COURSE_ATTRIBUTE_LD

STUDENT COURSE ATTRIBUTE 

STUDENT COURSE ATTRIBUTE 

NO

NO

MULTI_SOURCE NO

DIMENSION TABLE

WDT_MULTI_SOURCE

MULTI_SOURCE

STUDENT COURSE ATTRIBUTE 

NO

MULTI_SOURCE_DESC NO

DIMENSION TABLE

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

MULTI_SOURCE_SD

MULTI_SOURCE_LD

STUDENT COURSE ATTRIBUTE 

STUDENT COURSE ATTRIBUTE 

NO

NO

PROCESS_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

PROCESS_GROUP

STUDENT COURSE ATTRIBUTE 

NO



Ver: 9.0