GPS_WFS_RPT_FIELDY/N Table Edit
Y/N Table Edit
Y/N Table Edit
GPS_WFS_MET_MAP(SQL Table) |
Index Back |
|---|---|
GPS Meta Mapping tableGPS Meta Mapping table Define Mapping columns 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 | GPS_WFS_MAP_JOBCD | Character(1) | VARCHAR2(1) NOT NULL |
GPS Workforce Statistic job code mapping flag
Y/N Table Edit |
| 3 | GPS_WFS_MAP_GRADE | Character(1) | VARCHAR2(1) NOT NULL |
GPS Workforce Statistic grade mapping flag
Y/N Table Edit |
| 4 | GPS_WFS_MAP_EMPL | Character(1) | VARCHAR2(1) NOT NULL |
GPS Workforce Statistic Employee Category mapping flag
Y/N Table Edit |