GPS_WFS_RPT_FIELDSETIDPrompt Table: SET_VLD_HR_05
SAL_ADMIN_PLANPrompt Table: SAL_PLAN_TBL
GRADEPrompt Table: SAL_GRADE_TBL
N=N
Y=Y
Default Value: N
GPS_WFS_MAP_GRD(SQL Table) |
Index Back |
|---|---|
GPS Grade Mapping tableGPS Grade Mapping table Define Grade Mapping for report field |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPS_WFS_RPT_FIELD |
Character(10) | VARCHAR2(10) NOT NULL | Report Field |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_VLD_HR_05 |
| 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 | GPS_WFS_MAP_RESULT | Character(100) | VARCHAR2(100) NOT NULL | GPS Workforce Statistic mapping result |
| 6 | 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 |