SGHE Enterprise Data Warehouse
Banner EDW Source: FACULTY - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| FACULTY_MEMBER_CATEGORY |
NO |
DIMENSION TABLE |
WDT_EMPLOYEE |
FACULTY_MEMBER_CATEGORY |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION |
NO |
| FACULTY_MEMBER_CATEGORY_DESC |
NO |
DIMENSION TABLE |
WDT_EMPLOYEE WDT_EMPLOYEE |
FACULTY_MEMBER_CATEGORY_LD FACULTY_MEMBER_CATEGORY_SD |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION |
NO NO |
| HOME_COLLEGE |
NO |
DIMENSION TABLE |
WDT_INSTRUCTOR |
HOME_COLLEGE |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| HOME_COLLEGE_DESC |
NO |
DIMENSION TABLE |
WDT_INSTRUCTOR WDT_INSTRUCTOR |
HOME_COLLEGE_SD HOME_COLLEGE_LD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO |
| HOME_DEPARTMENT |
NO |
DIMENSION TABLE |
WDT_INSTRUCTOR |
HOME_DEPARTMENT |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| HOME_DEPARTMENT_DESC |
NO |
DIMENSION TABLE |
WDT_INSTRUCTOR WDT_INSTRUCTOR |
HOME_DEPARTMENT_SD HOME_DEPARTMENT_LD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO |
| PERSON_UID |
NO |
DIMENSION TABLE |
WDT_INSTRUCTOR |
INSTRUCTOR_UID |
ACADEMIC PROGRAM COURSE, COURSE INSTRUCTOR, COURSE REGISTRATION, FEEDBACK, STUDENT COURSE |
NO |
| TENURE |
NO |
DIMENSION TABLE |
WDT_EMPLOYEE |
TENURE |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION |
NO |
| TENURE_DESC |
NO |
DIMENSION TABLE |
WDT_EMPLOYEE WDT_EMPLOYEE |
TENURE_SD TENURE_LD |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION |
NO NO |