SETIDPrompt Table: SET_VLD_HR_05
SAL_ADMIN_PLANPrompt Table: SAL_PLAN_TBL
GRADEPrompt Table: SAL_GRADE_TBL
STEPPrompt Table: SAL_STEP_TBL
GPS_WFS_RPT_FLDDefault Value: EF17
Prompt Table: GPS_WFS_MAP_DTL
N=N
Y=Y
Default Value: N
GPS_WFS_MAP_STP(SQL Table) |
Index Back |
|---|---|
Mapping Table for STP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
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 | STEP |
Number(2,0) | SMALLINT NOT NULL |
Step
Prompt Table: SAL_STEP_TBL |
| 5 | GPS_WFS_RPT_FLD |
Character(10) | VARCHAR2(10) NOT NULL |
GPS WFS Report Field
Default Value: EF17 Prompt Table: GPS_WFS_MAP_DTL |
| 6 | GPS_WFS_MAP_RS_STP | Character(2) | VARCHAR2(2) NOT NULL | The mapping result field for reports field. |
| 7 | GPS_WFS_MAP_EXC | Character(1) | VARCHAR2(1) NOT NULL |
The Exclude flag indicates whether the emplids with matching exclude on any of the mappings will be excluded from the report / file.
N=N Y=Y Default Value: N |