GVT_RTND_PAY_PLANGVT_RTND_SAL_PLANGVT_RTND_GRADEEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
GVT_RTND_SG_VW(SQL View) |
Index Back |
|---|---|
Retained Salary Grade ViewSAL_GRADE_TBL is the reference table for salary ranges. The mimimum, midpoint, and maximum salary are used to calculate compa ratio and percent of range. Several edits are done in the system to warn that an employee is over the maximum or under the mimimum for their salary grade. 07/28/03 Lee - ICE508075000 - Add substring to viewtext for SQL validator. |
| SELECT %Substring(setid, 1, 2) ,sal_admin_plan ,grade ,effdt ,eff_status ,descr ,descrshort ,min_rt_hourly ,gvt_min_rt_biwk ,min_rt_monthly ,min_rt_annual ,max_rt_hourly ,gvt_max_rt_biwk ,max_rt_monthly ,max_rt_annual FROM PS_SAL_GRADE_TBL |
| # | 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 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 8 | MIN_RT_HOURLY | Number(19,6) | DECIMAL(18,6) NOT NULL | Minimum Pay Rate-Hourly |
| 9 | GVT_MIN_RT_BIWK | Number(10,2) | DECIMAL(9,2) NOT NULL | Minimum Pay Rate - BiWeekly |
| 10 | MIN_RT_MONTHLY | Number(19,3) | DECIMAL(18,3) NOT NULL | Minimum Pay Rate-Monthly |
| 11 | MIN_RT_ANNUAL | Number(19,3) | DECIMAL(18,3) NOT NULL | Minimum Pay Rate-Annual |
| 12 | MAX_RT_HOURLY | Number(19,6) | DECIMAL(18,6) NOT NULL | Maximum Pay Rate-Hourly |
| 13 | GVT_MAX_RT_BIWK | Number(10,2) | DECIMAL(9,2) NOT NULL | Maximum Pay Rate - BiWeekly |
| 14 | MAX_RT_MONTHLY | Number(19,3) | DECIMAL(18,3) NOT NULL | Maximum Pay Rate-Monthly |
| 15 | MAX_RT_ANNUAL | Number(19,3) | DECIMAL(18,3) NOT NULL | Maximum Pay Rate-Annual |