EMPLIDEMPL_RCDEFFDTDefault Value: %date
HR_WF_COMP_VW(SQL View) |
Index Back |
|---|---|
Current Annual SalaryCurrent Annual Salary for use in My Team analytics. |
| SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.SETID_SALARY , A.SAL_ADMIN_PLAN , A.GRADE , %Round(A.ANNUAL_RT,2) , A.CURRENCY_CD , CASE WHEN (CASE WHEN A.CURRENCY_CD <> GRD.CURRENCY_CD THEN %Round(%DecDiv((SELECT %DecMULT(%DecDiv(A.HOURLY_RT, RT1.RATE_DIV),RT1.RATE_MULT) FROM PS_HR_TM_COMP_RT_V RT1 WHERE RT1.FROM_CUR=A.CURRENCY_CD),(SELECT %DecMULT(%DecDiv(GRD.MID_RT_HOURLY, RT2.RATE_DIV),RT2.RATE_MULT) FROM PS_HR_TM_COMP_RT_V RT2 WHERE RT2.FROM_CUR=GRD.CURRENCY_CD)),2) ELSE CASE WHEN GRD.MID_RT_HOURLY = 0 THEN 0 ELSE %Round((%DecDiv(A.HOURLY_RT, GRD.MID_RT_HOURLY)),2) END END ) > 9.99 THEN 9.99 ELSE (CASE WHEN A.CURRENCY_CD <> GRD.CURRENCY_CD THEN %Round(%DecDiv((SELECT %DecMULT(%DecDiv(A.HOURLY_RT, RT1.RATE_DIV),RT1.RATE_MULT) FROM PS_HR_TM_COMP_RT_V RT1 WHERE RT1.FROM_CUR=A.CURRENCY_CD),(SELECT %DecMULT(%DecDiv(GRD.MID_RT_HOURLY, RT2.RATE_DIV),RT2.RATE_MULT) FROM PS_HR_TM_COMP_RT_V RT2 WHERE RT2.FROM_CUR=GRD.CURRENCY_CD)),2) ELSE CASE WHEN GRD.MID_RT_HOURLY = 0 THEN 0 ELSE %Round((%DecDiv(A.HOURLY_RT, GRD.MID_RT_HOURLY)),2) END END) END FROM PS_JOB A , PS_HR_TM_GRD_VW GRD WHERE A.SETID_SALARY = GRD.SETID AND A.SAL_ADMIN_PLAN = GRD.SAL_ADMIN_PLAN AND A.GRADE = GRD.GRADE AND GRD.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB JB1 WHERE JB1.EMPLID = A.EMPLID AND JB1.EMPL_RCD = A.EMPL_RCD AND JB1.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(JB2.EFFSEQ) FROM PS_JOB JB2 WHERE JB2.EMPLID = A.EMPLID AND JB2.EFFDT = A.EFFDT AND JB2.EMPL_RCD = A.EMPL_RCD) |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | SETID_SALARY | Character(5) | VARCHAR2(5) NOT NULL | Salary Set ID |
| 5 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL | Salary Administration Plan |
| 6 | GRADE | Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
| 7 | ANNUAL_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Annual Rate |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | COMPA_RATIO | Number(4,2) | DECIMAL(3,2) NOT NULL | Compa-Ratio |