|
SELECT L.DOCUMENT AS EMPLID , B.BUSINESS_UNIT , B.PROJECT_ID , W.BEGIN_DT AS DATE_WEEK_BEGIN , SUM(B.PC_ACTUAL_HRS) FROM PS_RS_ED_ETL_LOG L , (%Sql(RS_ED_PC_TRANS_SEL)) B , PS_CAL_DETP_TBL W , PS_INSTALLATION_PC I , PS_EID_ETL_LASTRUN R WHERE B.EMPLID = L.DOCUMENT AND B.TRANS_DATE BETWEEN W.BEGIN_DT AND %DateAdd(W.BEGIN_DT,6) AND W.SETID = I.ANALYSIS_SETID AND W.CALENDAR_ID = I.CAL_TYPE_WEEK AND W.BEGIN_DT BETWEEN %DateAdd(%CurrentDateIn,-182) AND %DateAdd(%CurrentDateIn,-1) AND R.EID_DS_ID = 'Resources' AND L.DTTM_MODIFIED >= R.LAST_RUN_DTM GROUP BY L.DOCUMENT, B.BUSINESS_UNIT, B.PROJECT_ID, W.BEGIN_DT
|