CMP008_AE_VW

(SQL View)
 Index Back

Update by Sal Plan/Paygroup

Salary Mass Update by Salary Plan or Paygroup

SELECT DISTINCT G.SETID , G.SAL_ADMIN_PLAN , G.GRADE , G.EFFDT FROM PS_SAL_GRADE_TBL G WHERE G.EFF_STATUS = 'A' AND ( EXISTS ( SELECT G2.MIN_RT_HOURLY FROM PS_SAL_GRADE_TBL G2 WHERE G.SETID = G2.SETID AND G.SAL_ADMIN_PLAN = G2.SAL_ADMIN_PLAN AND G.GRADE = G2.GRADE AND G2.EFF_STATUS = 'A' AND G.MIN_RT_HOURLY <> G2.MIN_RT_HOURLY AND G2.EFFDT = ( SELECT MAX(G3.EFFDT) FROM PS_SAL_GRADE_TBL G3 WHERE G.SETID = G3.SETID AND G.SAL_ADMIN_PLAN = G3.SAL_ADMIN_PLAN AND G.GRADE = G3.GRADE AND G3.EFF_STATUS = 'A' AND G3.EFFDT < G.EFFDT)) OR EXISTS ( SELECT G2.MID_RT_HOURLY FROM PS_SAL_GRADE_TBL G2 WHERE G.SETID = G2.SETID AND G.SAL_ADMIN_PLAN = G2.SAL_ADMIN_PLAN AND G.GRADE = G2.GRADE AND G2.EFF_STATUS = 'A' AND G.MID_RT_HOURLY <> G2.MID_RT_HOURLY AND G2.EFFDT = ( SELECT MAX(G3.EFFDT) FROM PS_SAL_GRADE_TBL G3 WHERE G.SETID = G3.SETID AND G.SAL_ADMIN_PLAN = G3.SAL_ADMIN_PLAN AND G.GRADE = G3.GRADE AND G3.EFF_STATUS = 'A' AND G3.EFFDT < G.EFFDT)) OR EXISTS ( SELECT G2.MAX_RT_HOURLY FROM PS_SAL_GRADE_TBL G2 WHERE G.SETID = G2.SETID AND G.SAL_ADMIN_PLAN = G2.SAL_ADMIN_PLAN AND G.GRADE = G2.GRADE AND G2.EFF_STATUS = 'A' AND G.MAX_RT_HOURLY <> G2.MAX_RT_HOURLY AND G2.EFFDT = ( SELECT MAX(G3.EFFDT) FROM PS_SAL_GRADE_TBL G3 WHERE G.SETID = G3.SETID AND G.SAL_ADMIN_PLAN = G3.SAL_ADMIN_PLAN AND G.GRADE = G3.GRADE AND G3.EFF_STATUS = 'A' AND G3.EFFDT < G.EFFDT)) )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SET_VLD_HR_05

2 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
3 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
4 EFFDT Date(10) DATE Effective Date

Default Value: %date