NOTE:
Compare results from the orginal query.
CU_BAR_HR_0003_2_Compare_results.xls
Image of CU_BAR_HR_00003_2:
Query SQL:
Query SQL: | |
---|---|
SELECT B.FIRST_NAME, B.MIDDLE_NAME, B.LAST_NAME, A.EMPLID, A.HR_STATUS, A.FULL_PART_TIME, A.JOB_INDICATOR, A.EMPL_RCD, A.JOBCODE, H.DESCR, A.LABOR_AGREEMENT, A.DEPTID, C.DESCR, A.LOCATION, G.DESCR, TO_CHAR(A.EFFDT,'YYYY-MM-DD'), A.EFFSEQ, TO_CHAR(SYSDATE,'YYYY-MM-DD'), TO_CHAR(SYSDATE,'YYYY-MM-DD'), TO_CHAR(SYSDATE,'YYYY-MM-DD'),C.SETID,C.DEPTID,TO_CHAR(C.EFFDT,'YYYY-MM-DD'),H.SETID,H.JOBCODE,TO_CHAR(H.EFFDT,'YYYY-MM-DD'),G.SETID,G.LOCATION,TO_CHAR(G.EFFDT,'YYYY-MM-DD') FROM PS_JOB A, PS_EMPLMT_SRCH_QRY A1, PS_PERSON_NAME B, PS_DEPT_TBL C, PS_PERSONAL_DATA F, PS_PERALL_SEC_QRY F1, PS_JOBCODE_TBL H, PS_LOCATION_TBL G, PS_SET_CNTRL_REC G2 WHERE G.LOCATION = A.LOCATION AND G2.SETCNTRLVALUE = A.BUSINESS_UNIT AND G2.RECNAME = 'LOCATION_TBL' AND G2.SETID = G.SETID AND A.EMPLID = A1.EMPLID AND A.EMPL_RCD = A1.EMPL_RCD AND A1.OPRID = '23420211' AND F.EMPLID = F1.EMPLID AND F1.OPRID = '23420211' AND ( A.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_JOB A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.EMPL_RCD = A_ED.EMPL_RCD AND A_ED.EFFDT <= SYSDATE) AND A.EFFSEQ = (SELECT MAX(A_ES.EFFSEQ) FROM PS_JOB A_ES WHERE A.EMPLID = A_ES.EMPLID AND A.EMPL_RCD = A_ES.EMPL_RCD AND A.EFFDT = A_ES.EFFDT) AND A.EMPLID = B.EMPLID AND A.HR_STATUS = 'A' AND A.FULL_PART_TIME IN ('F','P') AND C.DEPTID = A.DEPTID AND C.EFFDT = (SELECT MAX(C_ED.EFFDT) FROM PS_DEPT_TBL C_ED WHERE C.SETID = C_ED.SETID AND C.DEPTID = C_ED.DEPTID AND C_ED.EFFDT <= SYSDATE) AND C.SETID = 'BAR01' AND A.JOB_INDICATOR IN ('P','S') AND B.EMPLID = F.EMPLID AND H.JOBCODE = A.JOBCODE AND H.EFFDT = (SELECT MAX(H_ED.EFFDT) FROM PS_JOBCODE_TBL H_ED WHERE H.SETID = H_ED.SETID AND H.JOBCODE = H_ED.JOBCODE AND H_ED.EFFDT <= SYSDATE) AND A.EMPL_STATUS IN ('A','L','P','S') AND G.EFFDT = (SELECT MAX(G_ED.EFFDT) FROM PS_LOCATION_TBL G_ED WHERE G.SETID = G_ED.SETID AND G.LOCATION = G_ED.LOCATION AND G_ED.EFFDT <= A.EFFDT) ) ORDER BY 4, 7, 8 |