SETIDDefault Value: OPR_DEF_TBL_HR.SETID
SAL_ADMIN_PLANGRADE_TOEFFDTDefault Value: %date
STEP_TOSAL_STEP_TO_VW(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 A.SETID, A.SAL_ADMIN_PLAN, A.GRADE, A.EFFDT, A.STEP FROM PS_SAL_STEP_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 |
| 2 | SAL_ADMIN_PLAN |
Character(4) | VARCHAR2(4) NOT NULL | Salary Administration Plan |
| 3 | GRADE_TO |
Character(3) | VARCHAR2(3) NOT NULL | To Grade |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | STEP_TO |
Number(2,0) | SMALLINT NOT NULL | Step |