SGHE Enterprise Data Warehouse
Banner EDW Source: FACULTY_DEPARTMENT_COLLEGE - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| COLLEGE |
NO |
DIMENSION TABLE |
WDT_INSTRUCTOR |
HOME_COLLEGE |
COURSE INSTRUCTOR, FEEDBACK, STUDENT COURSE |
NO |
| COLLEGE_DESC |
NO |
DIMENSION TABLE |
WDT_INSTRUCTOR WDT_INSTRUCTOR |
HOME_COLLEGE_SD HOME_COLLEGE_LD |
COURSE INSTRUCTOR, FEEDBACK, STUDENT COURSE COURSE INSTRUCTOR, FEEDBACK, STUDENT COURSE |
NO NO |
| DEPARTMENT |
NO |
DIMENSION TABLE |
WDT_INSTRUCTOR |
HOME_DEPARTMENT |
COURSE INSTRUCTOR, FEEDBACK, STUDENT COURSE |
NO |
| DEPARTMENT_DESC |
NO |
DIMENSION TABLE |
WDT_INSTRUCTOR WDT_INSTRUCTOR |
HOME_DEPARTMENT_LD HOME_DEPARTMENT_SD |
COURSE INSTRUCTOR, FEEDBACK, STUDENT COURSE COURSE INSTRUCTOR, FEEDBACK, STUDENT COURSE |
NO NO |