GVT_PAY_PLANPrompt Table: GVT_PAY_PLAN
SAL_ADMIN_PLANPrompt Table: SAL_PLAN_TBL
GRADEPrompt Table: SAL_GRADE_TBL
EFFDTDefault Value: %date
STEPDefault Value: SAL_STEP_TBL.STEP
Default Value: 80
GVT_SAL_STP_VW(SQL View) |
Index Back |
|---|---|
Salary Step TableGVT_SAL_STEP_VW is used as the Prompt for Step on the Federal Panels. It swaps SETID with GVT_PAY_PLAN to get the appropriate prompt values |
| SELECT %substring(A.SETID,1,2), A.SAL_ADMIN_PLAN, A.GRADE, A.EFFDT, A.STEP, A.HOURLY_RT, A.MONTHLY_RT, A.ANNUAL_RT, %subrec(SALSTP_FED_SBR,A) FROM PS_SAL_STEP_TBL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_PAY_PLAN |
Character(2) | VARCHAR2(2) NOT NULL |
Pay Plan
Prompt Table: GVT_PAY_PLAN |
| 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 | HOURLY_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Hourly Rate |
| 7 | MONTHLY_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Monthly Rate |
| 8 | ANNUAL_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Annual Rate |
| 9 | GVT_BIWEEKLY_RT | Number(10,2) | DECIMAL(9,2) NOT NULL | Biweekly Rate |
| 10 | GVT_INCREM_DAYS | Number(3,0) | SMALLINT NOT NULL | Days to Next Step Increment |
| 11 | GVT_INCREM_WEEKS | Number(3,0) | SMALLINT NOT NULL | Weeks to Next Step Increment |
| 12 | GVT_STEP | Character(2) | VARCHAR2(2) NOT NULL |
US Federal Step
Default Value: SAL_STEP_TBL.STEP |
| 13 | GVT_WGI_ADJ | Number(3,0) | SMALLINT NOT NULL |
WGI Adjustment
Default Value: 80 |