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

SGHE Enterprise Data Warehouse Banner EDW Source: EMPLOYEE_EARNING_CY - NULL

Source Column Local Source Target Type Target Target Column Star Name Local Target
FUNCTION NO

FACT TABLE

WFT_EMPLOYEE_POSITION

WFT_EMPLOYEE_POSITION

WFT_EMPLOYEE

WFT_EMPLOYEE

WFT_EMPLOYEE

WFT_EMPLOYEE

WFT_EMPLOYEE_POSITION

WFT_EMPLOYEE_POSITION

OTHER_EARNINGS

REGULAR_EARNINGS

REGULAR_EARNINGS

OVERTIME_EARNINGS

OTHER_EARNINGS

TOTAL_EARNINGS

OVERTIME_EARNINGS

TOTAL_EARNINGS

EMPLOYEE POSITION 

EMPLOYEE POSITION 

EMPLOYEE 

EMPLOYEE 

EMPLOYEE 

EMPLOYEE 

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_POSITION

WFT_EMPLOYEE_POSITION

WFT_EMPLOYEE

WFT_EMPLOYEE_POSITION

WFT_EMPLOYEE

YTD_OVERTIME_EARNINGS

YTD_TOTAL_EARNINGS

YTD_OVERTIME_EARNINGS

YTD_REGULAR_EARNINGS

YTD_REGULAR_EARNINGS

YTD_OTHER_EARNINGS

YTD_OTHER_EARNINGS

EMPLOYEE 

EMPLOYEE 

EMPLOYEE POSITION 

EMPLOYEE POSITION 

EMPLOYEE 

EMPLOYEE POSITION 

EMPLOYEE 

NO

NO

NO

NO

NO

NO

NO



Ver: 9.0