Banner EDW Source: EMPLOYMENT_HISTORY

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

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
CURRENT_SALARY	NO	FACT TABLE FACT TABLE	WFT_EMPLOYMENT_APPLICATION WFT_EMPLOYMENT_APPLICATION	PREVIOUS_YEARLY_SALARY PREVIOUS_YEARLY_SALARY	EMPLOYMENT APPLICATION EMPLOYMENT APPLICATION	NO NO
EMPLOYER_INDUSTRIAL_DESC	NO	DIMENSION TABLE DIMENSION TABLE	WDT_EMPLOYMENT_HISTORY WDT_EMPLOYMENT_HISTORY WDT_EMPLOYMENT_HISTORY WDT_EMPLOYMENT_HISTORY	EMPLOYER_INDUSTRIAL_TYPE_LD EMPLOYER_INDUSTRIAL_TYPE_SD EMPLOYER_INDUSTRIAL_TYPE_LD EMPLOYER_INDUSTRIAL_TYPE_SD	EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION	NO NO NO NO
EMPLOYER_INDUSTRIAL_TYPE	NO	DIMENSION TABLE DIMENSION TABLE	WDT_EMPLOYMENT_HISTORY WDT_EMPLOYMENT_HISTORY	EMPLOYER_INDUSTRIAL_TYPE EMPLOYER_INDUSTRIAL_TYPE	EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION	NO NO
EMPLOYER_NAME	NO	DIMENSION TABLE DIMENSION TABLE	WDT_EMPLOYMENT_HISTORY WDT_EMPLOYMENT_HISTORY	EMPLOYER_NAME EMPLOYER_NAME	EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION	NO NO
MONTHS_IN_POSITION	NO	FACT TABLE FACT TABLE	WFT_EMPLOYMENT_APPLICATION WFT_EMPLOYMENT_APPLICATION	PREVIOUS_MONTHS_OF_SERVICE PREVIOUS_MONTHS_OF_SERVICE	EMPLOYMENT APPLICATION EMPLOYMENT APPLICATION	NO NO

Ver: 8.4.3