GPS_WFS_RPT_FIELDSETIDPrompt Table: SET_VLD_HR_14
EMPL_CTGPrompt Table: EMPL_CTG_L1_VW
N=N
Y=Y
Default Value: N
GPS_WFS_MAP_EMP(SQL Table) |
Index Back |
|---|---|
GPS Employee Category MappingGPS Employee Category Mapping table Define Employee Category 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_14 |
| 3 | EMPL_CTG |
Character(6) | VARCHAR2(6) NOT NULL |
Employee Category
Prompt Table: EMPL_CTG_L1_VW |
| 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 |