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 |
| 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 |
| 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_SD EMPLOYEE_GROUPING_LD |
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_SD EMPLOYEE_TIME_STATUS_LD EMPLOYEE_TIME_STATUS |
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_EMPLOYEE WDT_HR_APPLICANT WFT_EMPLOYMENT_APPLICATION WFT_EMPLOYEE |
FACULTY_STAFF_IND CURRENT_EMPLOYEE_IND PREVIOUS_MONTHS_OF_SERVICE YEARS_OF_SERVICE |
EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION EMPLOYMENT APPLICATION EMPLOYMENT APPLICATION EMPLOYEE |
NO 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_SD HOME_ORGANIZATION_CHART_LD |
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_SD MULTI_SOURCE_LD |
EMPLOYEE, EMPLOYEE DEGREE EMPLOYEE, EMPLOYEE DEGREE |
NO NO |
| PERSON_UID |
NO |
FACT TABLE |
WFT_EMPLOYEE WFT_EMPLOYEE_DEGREE WFT_EMPLOYEE_POSITION |
PERSON_UID PERSON_UID PERSON_UID |
EMPLOYEE EMPLOYEE DEGREE EMPLOYEE POSITION |
NO NO NO |
| PROCESS_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
PROCESS_GROUP |
EMPLOYEE, EMPLOYEE DEGREE |
NO |