GRADEGVT_ZPP_GRD_VW(SQL View) |
Index Back |
|---|---|
Valid Pay Plan/Grade CombosGVT_SAL_GRD_VW is a view of the distinct entries from the Salary Grade tables to form valid combinations of Pay Plans and Grades. It is used in the Priority Placement application. |
| SELECT DISTINCT A.GVT_PAY_PLAN, A.GRADE FROM PS_GVT_SAL_GRD_VW A WHERE A.EFFDT = (SELECT MAX (B.EFFDT) FROM PS_GVT_SAL_GRD_VW B WHERE B.GVT_PAY_PLAN = A.GVT_PAY_PLAN 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 |