SETIDDefault Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SET_VLD_HR_05
SAL_ADMIN_PLANPrompt Table: SAL_PLAN_TBL
GRADEPrompt Table: SAL_GRADE_TBL
EFFDTDefault Value: %date
STEPPrompt Table: CURRENCY_CD_TBL
HRS_SAL_STEP_I(SQL View) |
Index Back |
|---|---|
Salary Step TableSAL_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 Salary Administration Plan, Grade, and Step. |
| SELECT SETID ,SAL_ADMIN_PLAN ,GRADE ,EFFDT ,STEP ,CURRENCY_CD ,HOURLY_RT ,MONTHLY_RT ,ANNUAL_RT ,STEP_DESCR FROM PS_SAL_STEP_TBL |
| # | 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
Prompt Table: SAL_GRADE_TBL |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | STEP |
Number(2,0) | SMALLINT NOT NULL | Step |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 7 | HOURLY_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Hourly Rate |
| 8 | MONTHLY_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Monthly Rate |
| 9 | ANNUAL_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Annual Rate |
| 10 | STEP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description field for salary step |