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

SGHE Enterprise Data Warehouse Banner EDW Source: ADMISSIONS_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

APPLICATION ATTRIBUTE 

NO

ACADEMIC_PERIOD_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_TIME

WDT_ACADEMIC_TIME

ACADEMIC_PERIOD_SD

ACADEMIC_PERIOD_LD

APPLICATION ATTRIBUTE 

APPLICATION ATTRIBUTE 

NO

NO

ACADEMIC_YEAR NO

DIMENSION TABLE

WDT_ACADEMIC_TIME

ACADEMIC_YEAR

APPLICATION ATTRIBUTE 

NO

ACADEMIC_YEAR_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_TIME

WDT_ACADEMIC_TIME

ACADEMIC_YEAR_SD

ACADEMIC_YEAR_LD

APPLICATION ATTRIBUTE 

APPLICATION ATTRIBUTE 

NO

NO

ADMISSIONS_ATTRIBUTE NO

DIMENSION TABLE

WDT_ATTRIBUTE

ATTRIBUTE

APPLICATION ATTRIBUTE 

NO

ADMISSIONS_ATTRIBUTE_DESC NO

DIMENSION TABLE

WDT_ATTRIBUTE

WDT_ATTRIBUTE

ATTRIBUTE_SD

ATTRIBUTE_LD

APPLICATION ATTRIBUTE 

APPLICATION ATTRIBUTE 

NO

NO

PERSON_UID NO

DIMENSION TABLE


FACT TABLE

WDT_PERSON

WFT_APPLICATION_ATTRIBUTE

PERSON_UID

PERSON_UID

APPLICATION ATTRIBUTE 

APPLICATION ATTRIBUTE 

NO

NO



Ver: 9.0