SETIDSTEPPrompt Table: SAL_PLAN_TBL
Prompt Table: SAL_GRADE_TBL
EFFDTDefault Value: %date
SAL_STEP_MC_VW(SQL View) |
Index Back |
|---|---|
Salary Step View - Step KeySAL_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.step , a.sal_admin_plan , a.grade , a.effdt 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 |
| 2 | STEP |
Number(2,0) | SMALLINT NOT NULL | Step |
| 3 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table: SAL_PLAN_TBL |
| 4 | GRADE | Character(3) | VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table: SAL_GRADE_TBL |
| 5 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |