GVT_RTND_PAY_PLANGVT_RTND_SAL_PLANGVT_RTND_GRADEEFFDTDefault Value: %date
STEPDefault Value: SAL_STEP_TBL.STEP
Default Value: 80
GVT_RTND_SS_VW(SQL View) |
Index Back |
|---|---|
Retained Salary Step ViewSAL_STEP_TBL is used to store the salary for each step when multi-step grade is used. The control flag for multi-step grade is found on the Installation record. When it is set to 'Yes', employees salaries are automatically set to the one stored on this table for their Earnings Program (Pay Plan), Salary Administration Plan (Pay Table), Grade, and Step. 07/28/03 Lee - ICE508075000 - Add substring to viewtext for SQL validator. |
| SELECT %Substring(A.SETID, 1, 2) , A.SAL_ADMIN_PLAN , A.GRADE , A.EFFDT , A.STEP , A.HOURLY_RT , A.MONTHLY_RT , A.ANNUAL_RT , %subrec(SALSTP_FED_SBR,A) FROM PS_SAL_STEP_TBL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_RTND_PAY_PLAN |
Character(2) | VARCHAR2(2) NOT NULL | Retained Pay Plan |
| 2 | GVT_RTND_SAL_PLAN |
Character(4) | VARCHAR2(4) NOT NULL | Retained Pay Table |
| 3 | GVT_RTND_GRADE |
Character(3) | VARCHAR2(3) NOT NULL | Retained Grade |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | STEP |
Number(2,0) | SMALLINT NOT NULL | Step |
| 6 | HOURLY_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Hourly Rate |
| 7 | MONTHLY_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Monthly Rate |
| 8 | ANNUAL_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Annual Rate |
| 9 | GVT_BIWEEKLY_RT | Number(10,2) | DECIMAL(9,2) NOT NULL | Biweekly Rate |
| 10 | GVT_INCREM_DAYS | Number(3,0) | SMALLINT NOT NULL | Days to Next Step Increment |
| 11 | GVT_INCREM_WEEKS | Number(3,0) | SMALLINT NOT NULL | Weeks to Next Step Increment |
| 12 | GVT_STEP | Character(2) | VARCHAR2(2) NOT NULL |
US Federal Step
Default Value: SAL_STEP_TBL.STEP |
| 13 | GVT_WGI_ADJ | Number(3,0) | SMALLINT NOT NULL |
WGI Adjustment
Default Value: 80 |