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

SGHE Enterprise Data Warehouse EDW Source: EMPLOYEE_POSITION

Source Column Local Source Target Type Target Target Column Local Target
ADMINISTRATIVE_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

ADMINISTRATIVE_GROUP

NO

ANNUALIZED_FTE NO        
ANNUAL_SALARY NO        
EMPLOYEE_CAMPUS NO        
EMPLOYEE_CAMPUS_DESC NO        
EMPLOYEE_PROGRAM_CLASS_DESC NO        
EMPLOYER_CODE NO

DIMENSION TABLE

WDT_ADMINISTRATION

EMPLOYER_CODE

NO

EMPLOYER_DESC NO

DIMENSION TABLE

WDT_ADMINISTRATION

WDT_ADMINISTRATION

EMPLOYER_CODE_LD

EMPLOYER_CODE_SD

NO

NO

ENCUMBRANCE_AMOUNT NO        
JOB_SUFFIX NO

DIMENSION TABLE

WDT_JOB

JOB_SUFFIX

NO

MULTI_SOURCE NO

DIMENSION TABLE

WDT_MULTI_SOURCE

MULTI_SOURCE

NO

MULTI_SOURCE_DESC NO

DIMENSION TABLE

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

MULTI_SOURCE_LD

MULTI_SOURCE_SD

NO

NO

POSITION NO

DIMENSION TABLE

WDT_POSITION

POSITION

NO

POSITION_CLASS NO

DIMENSION TABLE

WDT_POSITION

POSITION_CLASS

NO

POSITION_CLASS_DESC NO

DIMENSION TABLE

WDT_POSITION

WDT_POSITION

POSITION_CLASS_SD

POSITION_CLASS_LD

NO

NO

POSITION_CONTRACT_TYPE NO

DIMENSION TABLE

WDT_POSITION

WDT_POSITION

WDT_POSITION

POSITION_CONTRACT_TYPE_SD

POSITION_CONTRACT_TYPE

POSITION_CONTRACT_TYPE_LD

NO

NO

NO

POSITION_LOCATION NO

DIMENSION TABLE

WDT_POSITION

WDT_POSITION

WDT_POSITION

POSITION_CAMPUS_SD

POSITION_CAMPUS_LD

POSITION_CAMPUS

NO

NO

NO

POSITION_STATUS NO

DIMENSION TABLE

WDT_POSITION

POSITION_STATUS

NO

POSITION_STATUS_DESC NO

DIMENSION TABLE

WDT_POSITION

WDT_POSITION

POSITION_STATUS_LD

POSITION_STATUS_SD

NO

NO

POSITION_TITLE NO

DIMENSION TABLE

WDT_POSITION

WDT_POSITION

POSITION_LD

POSITION_SD

NO

NO

PROCESS_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

PROCESS_GROUP

NO



Ver: 3.1