Salary Planning Query -Managing Exceptions

Delivered Salary Planning defaults the Salary Admin Plan from the Location and the Grade from the JobCode, but the Job record allows you to override these defaults by allow you to change either the Salary Admin Plan or the Grade.  So how can you track who has been overridden?  You can create a query based on the SQL below to manager your Salary Planning Exceptions.


SELECT A.EMPLID, A.EMPL_RCD, A.POSITION_NBR, A.SAL_ADMIN_PLAN, A.GRADE, CASE  B.SAL_ADMIN_PLAN WHEN ' ' THEN   C.SAL_ADMIN_PLAN ELSE  B.SAL_ADMIN_PLAN END, C.GRADE
  FROM PS_CURRENT_JOB A,   PS_LOCATION_TBL B, PS_JOBCODE_TBL C
  WHERE  B.LOCATION = A.LOCATION
     AND B.EFFDT =
        (SELECT MAX(B_ED.EFFDT) FROM PS_LOCATION_TBL B_ED
        WHERE B.SETID = B_ED.SETID
          AND B.LOCATION = B_ED.LOCATION
          AND B_ED.EFFDT <= SYSDATE)
     AND A.SETID_LOCATION = B.SETID
     AND C.JOBCODE = A.JOBCODE
     AND C.EFFDT =
        (SELECT MAX(C_ED.EFFDT) FROM PS_JOBCODE_TBL C_ED
        WHERE C.SETID = C_ED.SETID
          AND C.JOBCODE = C_ED.JOBCODE
          AND C_ED.EFFDT <= SYSDATE)
     AND A.SETID_JOBCODE = C.SETID
     AND ( A.SAL_ADMIN_PLAN <> CASE  B.SAL_ADMIN_PLAN WHEN ' ' THEN   C.SAL_ADMIN_PLAN ELSE  B.SAL_ADMIN_PLAN END
     OR A.GRADE <> C.GRADE)
     AND A.HR_STATUS = 'A'

Enjoy!