GPS_WFS_RPT_FIELDSETIDPrompt Table: SET_VLD_HR_02
JOBCODEPrompt Table: JOBCODE_TBL
N=N
Y=Y
Default Value: N
GPS_WFS_MAP_JOB(SQL Table) |
Index Back |
|---|---|
GPS Job Code Mapping tableGPS Job Code Mapping table Define Job Code 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_02 |
| 3 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |
| 4 | GPS_WFS_MAP_RESULT | Character(100) | VARCHAR2(100) NOT NULL | GPS Workforce Statistic mapping result |
| 5 | 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 |