SAL_STEP_PUB(SQL Table) |
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. |
| # | 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: SETID_TBL |
| 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 | INCREM_MONTHS | Number(3,0) | SMALLINT NOT NULL | Months to Next Step Increment |
| 11 | INCREM_HOURS | Number(8,2) | DECIMAL(7,2) NOT NULL | Hours to Next Step Increment |
| 12 | DAILY_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Daily Rate |
| 13 | GVT_BIWEEKLY_RT | Number(10,2) | DECIMAL(9,2) NOT NULL | Biweekly Rate |
| 14 | GVT_INCREM_DAYS | Number(3,0) | SMALLINT NOT NULL | Days to Next Step Increment |
| 15 | GVT_INCREM_WEEKS | Number(3,0) | SMALLINT NOT NULL | Weeks to Next Step Increment |
| 16 | GVT_STEP | Character(2) | VARCHAR2(2) NOT NULL |
US Federal Step
Default Value: SAL_STEP_TBL.STEP |
| 17 | GVT_WGI_ADJ | Number(3,0) | SMALLINT NOT NULL |
WGI Adjustment
Default Value: 80 |
| 18 | AUDIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values |
| 19 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |