SETIDDefault Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SET_VLD_HR_05
SAL_ADMIN_PLANPrompt Table: SAL_PLAN_TBL
GRADEEFFDTDefault Value: %date
A=Active
I=Inactive
HRS_SAL_GRADE_I(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. |
| SELECT A.SETID ,A.SAL_ADMIN_PLAN ,A.GRADE ,A.EFFDT ,A.EFF_STATUS ,A.DESCR ,A.DESCRSHORT FROM PS_SAL_GRADE_TBL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_05 |
| 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 |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |