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

SGHE Enterprise Data Warehouse EDW Source: HR_APPLICATION

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

DIMENSION TABLE

WDT_MULTI_SOURCE

ADMINISTRATIVE_GROUP

NO

APPLICATION_DATE NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

CALENDAR_MONTH

CALENDAR_YEAR

NO

NO

DESIRED_HOURLY NO        
DESIRED_SALARY NO        
FUNCTION NO

DIMENSION TABLE

WDT_HR_APPLICANT_STATUS

WDT_HR_APPLICANT_STATUS

WDT_HR_APPLICANT_STATUS

WDT_HR_APPLICANT_STATUS

WDT_HR_APPLICANT_STATUS

WDT_HR_APPLICANT_STATUS

INTERVIEWED_IND

EMPLOYMENT_OFFERED_IND

ACCEPTED_IND

APPLIED_IND

INTERVIEW_OFFERED_IND

EMPLOYED_IND

NO

NO

NO

NO

NO

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

PERSON_UID NO        
PROCESS_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

PROCESS_GROUP

NO

REQUISITION_NUMBER NO        
SOURCE NO

DIMENSION TABLE

WDT_HR_APPLICANT

SOURCE

NO

SOURCE_DESC NO

DIMENSION TABLE

WDT_HR_APPLICANT

WDT_HR_APPLICANT

SOURCE_SD

SOURCE_LD

NO

NO



Ver: 3.1