|
SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.CAL_RUN_ID , B.CAL_RUN_ID , A.GP_PAYGROUP , A.CAL_ID , B.CAL_ID ,A.PRC_ORD_TS ,B.PRC_ORD_TS , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , (A.EMPLID %Concat %Cast(A.EMPL_RCD,NUMBER,CHARACTER)) , A.GP_RPT_RETRO , A.SEG_BGN_DT , A.SEG_END_DT , A.SLICE_BGN_DT , A.SLICE_END_DT , A.PRD_BGN_DT , A.PRD_END_DT , A.GP_RPT_BGN_DT , A.GP_RPT_END_DT , A.RUN_TYPE , A.BUSINESS_UNIT , A.BUSINESS_DESCR , A.PAY_ENTITY , A.COUNTRY , A.COMPANY , A.GP_PA_COMP_DESCR , A.LOCATION , A.LOCATION_DESCR , A.CONTRACT_TYPE , A.ESTABID , A.ESTAB_DESCR , A.DEPTID , A.DEPT_DESCR , A.FTE , A.JOBCODE , A.JOBCODE_DESCR , A.SETID_JOBCODE , A.SETID_DEPT , A.SETID_LOCATION , A.GP_INCLUDE_RETRO , A.FIRST_NAME , A.LAST_NAME , A.PYE_CALC_STAT , A.FREQUENCY_ID , A.GP_SEG_COUNT , A.GROUP_LIST_ID , A.STRM_NUM , A.PIN_GROSS_NUM ,A.PIN_GROSS_VAL , A.GP_CALC_VAL1 , (B.GP_CALC_VAL1) ,(CASE WHEN (B.GP_CALC_VAL1) <> 0 THEN %Round(((A.GP_CALC_VAL1) - (B.GP_CALC_VAL1)) ,6) ELSE (A.GP_CALC_VAL1) END) , A.PIN_NET_NUM ,A.PIN_NET_VAL , A.GP_CALC_VAL2 , B.GP_CALC_VAL2 , (CASE WHEN (B.GP_CALC_VAL2) <> 0 THEN %Round(((A.GP_CALC_VAL2) - (B.GP_CALC_VAL2)) ,6) ELSE (A.GP_CALC_VAL2) END) ,(CASE WHEN (B.GP_CALC_VAL1) <> 0 THEN %Round((((A.GP_CALC_VAL1) - (B.GP_CALC_VAL1))/(%Abs(B.GP_CALC_VAL1)))*100 ,2) ELSE %Round((A.GP_CALC_VAL1),2) END) ,(CASE WHEN (B.GP_CALC_VAL2) <> 0 THEN %Round((((A.GP_CALC_VAL2) - (B.GP_CALC_VAL2))/(%Abs(B.GP_CALC_VAL2)))*100 ,2) ELSE %Round((A.GP_CALC_VAL2) ,2) END) , A.FULL_PART_TIME , A.SUPERVISOR_ID , A.EMPL_STATUS , A.GP_PA_HIRE_DT , A.TERMINATION_DT , A.CONTRACT_NUM , A.GP_SEG_EXISTS ,(CASE WHEN B.CAL_RUN_ID IS NULL THEN 'Y' ELSE 'N' END) FROM PS_GP_PA_RSLT_ANL A LEFT OUTER JOIN PS_GP_PA_RSLT_ANL B ON A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID <> B.CAL_ID
|
EMPLID