GVT_SAL_GRD_VW(SQL View) |
Index Back |
|---|---|
Salary Grade TableSAL_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. GVT: Added ERN_PROGRAM + some GVT fields for Federal |
| SELECT %Substring(A.SETID,1,2) , A.SAL_ADMIN_PLAN , A.GRADE , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.SALARY_MATRIX_CD , A.CURRENCY_CD , A.MIN_RT_HOURLY , A.MID_RT_HOURLY , A.MAX_RT_HOURLY , A.MIN_RT_MONTHLY , A.MID_RT_MONTHLY , A.MAX_RT_MONTHLY , A.MIN_RT_ANNUAL , A.MID_RT_ANNUAL , A.MAX_RT_ANNUAL , A.STEP_INCREM_TYPE , A.STEP_INCREM_ACCUM , %subrec(SALGRD_FED_SBR,A) FROM PS_SAL_GRADE_TBL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GVT_PAY_PLAN |
Character(2) | VARCHAR2(2) NOT NULL |
Pay Plan
Prompt Table: GVT_PAY_PLAN |
| 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 |
| 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 | SALARY_MATRIX_CD | Character(5) | VARCHAR2(5) NOT NULL |
Salary Matrix Code
Prompt Table: SAL_MATRIX_TBL |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 10 | MIN_RT_HOURLY | Number(19,6) | DECIMAL(18,6) NOT NULL | Minimum Pay Rate-Hourly |
| 11 | MID_RT_HOURLY | Number(19,6) | DECIMAL(18,6) NOT NULL | Midpoint Pay Rate-Hourly |
| 12 | MAX_RT_HOURLY | Number(19,6) | DECIMAL(18,6) NOT NULL | Maximum Pay Rate-Hourly |
| 13 | MIN_RT_MONTHLY | Number(19,3) | DECIMAL(18,3) NOT NULL | Minimum Pay Rate-Monthly |
| 14 | MID_RT_MONTHLY | Number(19,3) | DECIMAL(18,3) NOT NULL | Midpoint Pay Rate-Monthly |
| 15 | MAX_RT_MONTHLY | Number(19,3) | DECIMAL(18,3) NOT NULL | Maximum Pay Rate-Monthly |
| 16 | MIN_RT_ANNUAL | Number(19,3) | DECIMAL(18,3) NOT NULL | Minimum Pay Rate-Annual |
| 17 | MID_RT_ANNUAL | Number(19,3) | DECIMAL(18,3) NOT NULL | Midpoint Pay Rate-Annual |
| 18 | MAX_RT_ANNUAL | Number(19,3) | DECIMAL(18,3) NOT NULL | Maximum Pay Rate-Annual |
| 19 | STEP_INCREM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Step Increment Type
D=Date Based Increment Type E=Either Hours or Date Based H=Hours Based Increment Type M=Manual Based Increment Type W=Weeks Based Increment Type |
| 20 | STEP_INCREM_ACCUM | Character(3) | VARCHAR2(3) NOT NULL | Spec Accum for Step Increments |
| 21 | GVT_MAX_RT_BIWK | Number(10,2) | DECIMAL(9,2) NOT NULL | Maximum Pay Rate - BiWeekly |
| 22 | GVT_MID_RT_BIWK | Number(10,2) | DECIMAL(9,2) NOT NULL | Midpoint Pay Rate - BiWeekly |
| 23 | GVT_MIN_RT_BIWK | Number(10,2) | DECIMAL(9,2) NOT NULL | Minimum Pay Rate - BiWeekly |