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

SGHE Enterprise Data Warehouse Banner EDW Source: SECONDARY_SCHOOL_SUBJECT - NULL

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

DIMENSION TABLE


FACT TABLE

WDT_SECONDARY_SCHOOL_SUBJECT

WFT_SECONDARY_SCHOOL_SUBJECT

SECONDARY_SUBJECT_GPA_RANGE

SECONDARY_SCHOOL_SUBJECT_GPA

SECONDARY SCHOOL SUBJECT 

SECONDARY SCHOOL SUBJECT 

NO

NO

GRADE NO

DIMENSION TABLE

WDT_SECONDARY_SCHOOL_SUBJECT

SECONDARY_SUBJECT_GRADE

SECONDARY SCHOOL SUBJECT 

NO

PERSON_UID NO

DIMENSION TABLE


FACT TABLE

WDT_PERSON

WFT_SECONDARY_SCHOOL_SUBJECT

PERSON_UID

PERSON_UID

SECONDARY SCHOOL SUBJECT 

SECONDARY SCHOOL SUBJECT 

NO

NO

SUBJECT NO

DIMENSION TABLE

WDT_SECONDARY_SCHOOL_SUBJECT

SECONDARY_SCHOOL_SUBJECT

SECONDARY SCHOOL SUBJECT 

NO

SUBJECT_DESC NO

DIMENSION TABLE

WDT_SECONDARY_SCHOOL_SUBJECT

WDT_SECONDARY_SCHOOL_SUBJECT

SECONDARY_SCHOOL_SUBJECT_SD

SECONDARY_SCHOOL_SUBJECT_LD

SECONDARY SCHOOL SUBJECT 

SECONDARY SCHOOL SUBJECT 

NO

NO

YEARS_TAKEN NO

FACT TABLE

WFT_SECONDARY_SCHOOL_SUBJECT

YEARS_TAKEN

SECONDARY SCHOOL SUBJECT 

NO



Ver: 9.0