Banner EDW Source: EMPLOYEE_EARNING

	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
EMPLOYEE_CONTRIBUTION_YTD	NO	FACT TABLE	WFT_EMPLOYEE WFT_EMPLOYEE	YTD_EMPLOYEE_DEDUCTION_AMOUNT YTD_EMPLOYER_DEDUCTION_AMOUNT	EMPLOYEE EMPLOYEE	NO NO
FUNCTION	NO	FACT TABLE	WFT_EMPLOYEE WFT_EMPLOYEE WFT_EMPLOYEE WFT_EMPLOYEE WFT_EMPLOYEE_POSITION WFT_EMPLOYEE_POSITION WFT_EMPLOYEE_POSITION WFT_EMPLOYEE_POSITION	OTHER_EARNINGS OVERTIME_EARNINGS REGULAR_EARNINGS TOTAL_EARNINGS OTHER_EARNINGS OVERTIME_EARNINGS REGULAR_EARNINGS TOTAL_EARNINGS	EMPLOYEE EMPLOYEE EMPLOYEE EMPLOYEE EMPLOYEE POSITION EMPLOYEE POSITION EMPLOYEE POSITION EMPLOYEE POSITION	NO NO NO NO NO NO NO NO
MONTH	NO	DIMENSION TABLE	WDT_TIME WDT_TIME	CALENDAR_MONTH CALENDAR_YEAR	EMPLOYEE POSITION EMPLOYEE POSITION	NO NO
TOTAL_EARNINGS_YTD	NO	FACT TABLE	WFT_EMPLOYEE WFT_EMPLOYEE WFT_EMPLOYEE WFT_EMPLOYEE WFT_EMPLOYEE_POSITION WFT_EMPLOYEE_POSITION WFT_EMPLOYEE_POSITION	YTD_OTHER_EARNINGS YTD_OVERTIME_EARNINGS YTD_REGULAR_EARNINGS YTD_TOTAL_EARNINGS YTD_OTHER_EARNINGS YTD_OVERTIME_EARNINGS YTD_REGULAR_EARNINGS	EMPLOYEE EMPLOYEE EMPLOYEE EMPLOYEE EMPLOYEE POSITION EMPLOYEE POSITION EMPLOYEE POSITION	NO NO NO NO NO NO NO
TOTAL_EARNINGS_YTD(SUM)	NO	FACT TABLE	WFT_EMPLOYEE_POSITION	YTD_TOTAL_EARNINGS	EMPLOYEE POSITION	NO

Ver: 8.1