EMPLIDEMPL_RCDSALARY_RANGE_VW(SQL View) |
Index Back |
|---|---|
Current Salary Ranges by GradeSALARY_RANGE_VW returns annual min, mid and max salaray rates for a given emplid/empl_rcd. It is used in the Direct Line Reports pagelet. |
| SELECT A.EMPLID , A.EMPL_RCD , A.ANNUAL_RT , B.CURRENCY_CD , B.MIN_RT_ANNUAL , B.MID_RT_ANNUAL , B.MAX_RT_ANNUAL , B.MID_RT_HOURLY FROM PS_JOB A , PS_SAL_GRADE_TBL B WHERE A.SETID_SALARY = B.SETID AND A.SAL_ADMIN_PLAN = B.SAL_ADMIN_PLAN AND A.GRADE = B.GRADE AND A.EFFDT <= %CurrentDateIn AND A. EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_JOB D WHERE D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.EFFDT <= %CurrentDateIn) AND A.EFFSEQ =( SELECT MAX(E.EFFSEQ) FROM PS_JOB E WHERE E.EMPLID = A.EMPLID AND E.EMPL_RCD = A.EMPL_RCD AND E.EFFDT = A.EFFDT) AND B.EFF_STATUS = 'A' AND B.EFFDT <= %CurrentDateIn AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_SAL_GRADE_TBL C WHERE C.SETID = B.SETID AND C.SAL_ADMIN_PLAN = B.SAL_ADMIN_PLAN AND C.GRADE = B.GRADE AND C.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | ANNUAL_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Annual Rate |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 5 | MIN_RT_ANNUAL | Number(19,3) | DECIMAL(18,3) NOT NULL | Minimum Pay Rate-Annual |
| 6 | MID_RT_ANNUAL | Number(19,3) | DECIMAL(18,3) NOT NULL | Midpoint Pay Rate-Annual |
| 7 | MAX_RT_ANNUAL | Number(19,3) | DECIMAL(18,3) NOT NULL | Maximum Pay Rate-Annual |
| 8 | MID_RT_HOURLY | Number(19,6) | DECIMAL(18,6) NOT NULL | Midpoint Pay Rate-Hourly |