SETIDPrompt Table: SET_VLD_HR_14
LABOR_AGREEMENTPrompt Table: HR_LABOR_AGRMNT
GPS_WFS_RPT_FLDDefault Value: EF43
Prompt Table: GPS_WFS_MAP_DTL
N=N
Y=Y
Default Value: N
GPS_WFS_MAP_AGR(SQL Table) |
Index Back |
|---|---|
Mapping Table for AGR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_VLD_HR_14 |
| 2 | LABOR_AGREEMENT |
Character(6) | VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table: HR_LABOR_AGRMNT |
| 3 | GPS_WFS_RPT_FLD |
Character(10) | VARCHAR2(10) NOT NULL |
GPS WFS Report Field
Default Value: EF43 Prompt Table: GPS_WFS_MAP_DTL |
| 4 | GPS_WFS_MAP_RS_AGR | Character(2) | VARCHAR2(2) NOT NULL | The mapping result field for reports field. |
| 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 |