SETIDSAL_ADMIN_PLANPrompt Table: SAL_PLAN_TBL
GRADEPrompt Table: SAL_GRADE_TBL
JOB_POINTS_TOTALSETID_JOBCODEJOBCODELANGUAGE_CDGVT_JOBG_LNG_VW(SQL View) |
Index Back |
|---|---|
Job Evaluations by Grade LvlJOBCODE_GRADE is a view which selects all Job Codes in each Salary Grade and ranks them in descending order by total job evaluation points. It is used in the Salary Administration application. Related Language view for GVT_JOBCODE_GRD. |
| SELECT A.GVT_PAY_PLAN ,A.SAL_ADMIN_PLAN ,A.GRADE ,A.JOB_POINTS_TOTAL ,A.SETID ,A.JOBCODE ,AL.LANGUAGE_CD ,AL.DESCR ,AL.DESCRSHORT FROM PS_JOBCODE_TBL A, PS_JOBCODE_LANG AL WHERE A.EFF_STATUS = 'A' AND A.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_JOBCODE_TBL B WHERE B.JOBCODE = A.JOBCODE AND B.EFFDT <= %CURRENTDATEIN) AND A.SETID = AL.SETID AND A.JOBCODE = AL.JOBCODE AND A.EFFDT = AL.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SAL_ADMIN_PLAN |
Character(4) | VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table: SAL_PLAN_TBL |
| 3 | GRADE |
Character(3) | VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table: SAL_GRADE_TBL |
| 4 | JOB_POINTS_TOTAL |
Number(5,0) | INTEGER NOT NULL | Total Points |
| 5 | SETID_JOBCODE |
Character(5) | VARCHAR2(5) NOT NULL | Job Code SetID |
| 6 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 7 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |