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

SGHE Enterprise Data Warehouse EDW Source: POSITION_DEFINITION

Source Column Local Source Target Type Target Target Column Local Target
BUDGET_APPOINTMENT_PCT NO        
EEO_SKILL NO

DIMENSION TABLE

WDT_POSITION

POSITION_EEO_SKILL

NO

EEO_SKILL_DESC NO

DIMENSION TABLE

WDT_POSITION

WDT_POSITION

POSITION_EEO_SKILL_SD

POSITION_EEO_SKILL_LD

NO

NO

POSITION NO

DIMENSION TABLE

WDT_POSITION

POSITION

NO

POSITION_APPOINTMENT_PCT NO

DIMENSION TABLE

WDT_POSITION

APPOINTMENT_PERCENTAGE

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_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



Ver: 3.1