GVT_GRD_PRMPT

(SQL View)
 Index Back

SELECT DISTINCT %substring(A.SETID,1,2), A.GRADE FROM PS_SAL_GRADE_TBL A WHERE A.EFFDT = (SELECT MAX (B.EFFDT) FROM PS_SAL_GRADE_TBL B WHERE B.SETID = A.SETID AND B.SAL_ADMIN_PLAN = A.SAL_ADMIN_PLAN AND B.EFFDT <= %CURRENTDATEIN)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
2 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade