GPS_WFS_MAP_RESULTGPS_WFS_RAT_VW(SQL View) |
Index Back |
|---|---|
View for Report Mapping Values |
| SELECT DISTINCT GPS_WFS_MAP_RESULT FROM PS_GPS_WFS_MAP_JOB WHERE GPS_WFS_RPT_FIELD = 'EF10' UNION SELECT DISTINCT GPS_WFS_MAP_RESULT FROM PS_GPS_WFS_MAP_EMP WHERE GPS_WFS_RPT_FIELD = 'EF10' UNION SELECT DISTINCT GPS_WFS_MAP_RESULT FROM PS_GPS_WFS_MAP_GRD WHERE GPS_WFS_RPT_FIELD = 'EF10' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPS_WFS_MAP_RESULT |
Character(100) | VARCHAR2(100) NOT NULL | GPS Workforce Statistic mapping result |