GPS_WFS_MAP_SC(SQL Table) |
Index Back |
|---|---|
Mapping Table for SGService class group and grade rating mapping table |
| # | 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 | GPS_GRADE |
Character(8) | VARCHAR2(8) NOT NULL |
Salary Grade.
Prompt Table: GPS_GRADE_TBL |
| 3 | GPS_SC_GROUP |
Character(4) | VARCHAR2(4) NOT NULL |
This field is used to define Service Class Group values.
1=Without University Degree 2=With University Degree ED=Simple Service GD=Upper Service HD=Supreme Service MD=Midrange Service |
| 4 | GPS_WFS_RPT_FLD |
Character(10) | VARCHAR2(10) NOT NULL |
GPS WFS Report Field
Default Value: EF13 Prompt Table: GPS_WFS_MAP_DTL |
| 5 | GPS_WFS_MAP_RESULT |
Character(100) | VARCHAR2(100) NOT NULL |
GPS Workforce Statistic mapping result
Prompt Table: GPS_WFS_RAT_VW |
| 6 | GPS_WFS_MAP_RS_SG | Character(3) | VARCHAR2(3) 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 |