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
EMPLOYEE_CONTRIBUTION_YTD NO        
FUNCTION NO

FACT TABLE

WFT_EMPLOYEE

WFT_EMPLOYEE_POSITION

WFT_EMPLOYEE_POSITION

WFT_EMPLOYEE_POSITION

WFT_EMPLOYEE

WFT_EMPLOYEE

WFT_EMPLOYEE

WFT_EMPLOYEE_POSITION

OVERTIME_EARNINGS

OTHER_EARNINGS

OVERTIME_EARNINGS

TOTAL_EARNINGS

REGULAR_EARNINGS

OTHER_EARNINGS

TOTAL_EARNINGS

REGULAR_EARNINGS

EMPLOYEE 

EMPLOYEE POSITION 

EMPLOYEE POSITION 

EMPLOYEE POSITION 

EMPLOYEE 

EMPLOYEE 

EMPLOYEE 

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_POSITION

WFT_EMPLOYEE_POSITION

WFT_EMPLOYEE_POSITION

WFT_EMPLOYEE

YTD_TOTAL_EARNINGS

YTD_REGULAR_EARNINGS

YTD_OTHER_EARNINGS

YTD_REGULAR_EARNINGS

YTD_OVERTIME_EARNINGS

YTD_OTHER_EARNINGS

YTD_OVERTIME_EARNINGS

EMPLOYEE 

EMPLOYEE 

EMPLOYEE 

EMPLOYEE POSITION 

EMPLOYEE POSITION 

EMPLOYEE POSITION 

EMPLOYEE 

NO

NO

NO

NO

NO

NO

NO

TOTAL_EARNINGS_YTD(SUM) NO        


Ver: 8.4.2