SGHE Enterprise Data Warehouse
Banner EDW Source: EMPLOYEE - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ADMINISTRATIVE_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
ADMINISTRATIVE_GROUP |
EMPLOYEE, EMPLOYEE DEGREE |
NO |
| CAMPUS |
NO |
DIMENSION TABLE |
WDT_ADMINISTRATION |
CAMPUS |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION |
NO |
| CAMPUS_DESC |
NO |
DIMENSION TABLE |
WDT_ADMINISTRATION WDT_ADMINISTRATION |
CAMPUS_SD CAMPUS_LD |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION EMPLOYEE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION |
NO NO |
| COLLEGE |
NO |
DIMENSION TABLE |
WDT_ADMINISTRATION |
COLLEGE |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION |
NO |
| COLLEGE_DESC |
NO |
DIMENSION TABLE |
WDT_ADMINISTRATION WDT_ADMINISTRATION WDT_ADMINISTRATION |
COLLEGE_SD COLLEGE_LD CAMPUS_LD |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION EMPLOYEE DEGREE |
NO NO NO |
| CURRENT_HIRE_DATE |
NO |
DIMENSION TABLE
FACT TABLE |
WDT_TIME WDT_TIME WFT_EMPLOYEE_POSITION |
CALENDAR_MONTH CALENDAR_YEAR YEARS_OF_SERVICE |
EMPLOYEE EMPLOYEE EMPLOYEE POSITION |
NO NO NO |
| DIVISION |
NO |
DIMENSION TABLE |
WDT_ADMINISTRATION |
DIVISION |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION |
NO |
| DIVISION_DESC |
NO |
DIMENSION TABLE |
WDT_ADMINISTRATION WDT_ADMINISTRATION |
DIVISION_SD DIVISION_LD |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION |
NO NO |
| EEO_SKILL |
NO |
DIMENSION TABLE |
WDT_EMPLOYEE |
EMPLOYEE_EEO_SKILL |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION |
NO |
| EEO_SKILL_DESC |
NO |
DIMENSION TABLE |
WDT_EMPLOYEE WDT_EMPLOYEE |
EMPLOYEE_EEO_SKILL_LD EMPLOYEE_EEO_SKILL_SD |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION |
NO NO |
| EMPLOYEE_CLASS |
NO |
DIMENSION TABLE |
WDT_EMPLOYEE |
EMPLOYEE_CLASS |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION |
NO |
| EMPLOYEE_CLASS_LONG_DESC |
NO |
DIMENSION TABLE |
WDT_EMPLOYEE |
EMPLOYEE_CLASS_LD |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION |
NO |
| EMPLOYEE_CLASS_SHORT_DESC |
NO |
DIMENSION TABLE |
WDT_EMPLOYEE |
EMPLOYEE_CLASS_SD |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION |
NO |
| EMPLOYEE_GROUPING |
NO |
DIMENSION TABLE |
WDT_EMPLOYEE |
EMPLOYEE_GROUPING |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION |
NO |
| EMPLOYEE_GROUPING_DESC |
NO |
DIMENSION TABLE |
WDT_EMPLOYEE WDT_EMPLOYEE |
EMPLOYEE_GROUPING_LD EMPLOYEE_GROUPING_SD |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION |
NO NO |
| EMPLOYEE_STATUS |
NO |
DIMENSION TABLE |
WDT_EMPLOYEE |
EMPLOYEE_STATUS |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION |
NO |
| EMPLOYEE_STATUS_DESC |
NO |
DIMENSION TABLE |
WDT_EMPLOYEE WDT_EMPLOYEE |
EMPLOYEE_STATUS_LD EMPLOYEE_STATUS_SD |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION |
NO NO |
| FULL_OR_PART_TIME_IND |
NO |
DIMENSION TABLE |
WDT_EMPLOYEE WDT_EMPLOYEE WDT_EMPLOYEE |
EMPLOYEE_TIME_STATUS_LD EMPLOYEE_TIME_STATUS EMPLOYEE_TIME_STATUS_SD |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION |
NO NO NO |
| FUNCTION |
NO |
DIMENSION TABLE
FACT TABLE |
WDT_HR_APPLICANT WDT_EMPLOYEE WFT_EMPLOYEE |
CURRENT_EMPLOYEE_IND FACULTY_STAFF_IND YEARS_OF_SERVICE |
EMPLOYMENT APPLICATION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYEE |
NO NO NO |
| HOME_ORGANIZATION |
NO |
DIMENSION TABLE |
WDT_ADMINISTRATION |
HOME_ORGANIZATION |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION |
NO |
| HOME_ORGANIZATION_CHART |
NO |
DIMENSION TABLE |
WDT_ADMINISTRATION |
HOME_ORGANIZATION_CHART |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION |
NO |
| HOME_ORGANIZATION_CHART_DESC |
NO |
DIMENSION TABLE |
WDT_ADMINISTRATION WDT_ADMINISTRATION |
HOME_ORGANIZATION_CHART_LD HOME_ORGANIZATION_CHART_SD |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION |
NO NO |
| HOME_ORGANIZATION_DESC |
NO |
DIMENSION TABLE |
WDT_ADMINISTRATION WDT_ADMINISTRATION |
HOME_ORGANIZATION_LD HOME_ORGANIZATION_SD |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION |
NO NO |
| MULTI_SOURCE |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
MULTI_SOURCE |
EMPLOYEE, EMPLOYEE DEGREE |
NO |
| MULTI_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE WDT_MULTI_SOURCE |
MULTI_SOURCE_LD MULTI_SOURCE_SD |
EMPLOYEE, EMPLOYEE DEGREE EMPLOYEE, EMPLOYEE DEGREE |
NO NO |
| PERSON_UID |
NO |
FACT TABLE |
WFT_EMPLOYEE_DEGREE WFT_EMPLOYEE_POSITION WFT_EMPLOYEE |
PERSON_UID PERSON_UID PERSON_UID |
EMPLOYEE DEGREE EMPLOYEE POSITION EMPLOYEE |
NO NO NO |
| PROCESS_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
PROCESS_GROUP |
EMPLOYEE, EMPLOYEE DEGREE |
NO |