GPS_WFS_RPT_FLDEMP=Empty
FIL=FILL
HCH=Hardcode
MAP=Mapping
ONE=One to one
GPS_WFS_FLD_VW(SQL View) |
Index Back |
|---|---|
Report field viewNew effective report field view |
| SELECT GPS_WFS_RPT_FLD ,ORDERNO ,DESCR254 ,GPS_WFS_MAP_REC , GPS_WFS_MAP_FLD ,GPS_WFS_MAP_RUL ,GPS_WFS_MAP_CLS ,GPS_WFS_MAP_REQ ,GPS_WFS_MAP_SC_LDR ,LENGTH FROM PS_GPS_WFS_MAP_DTL DTL WHERE DTL.EFFDT = ( SELECT MAX(DTL2.EFFDT) FROM PS_GPS_WFS_MAP_DTL DTL2 WHERE DTL.GPS_WFS_RPT_FLD =DTL2.GPS_WFS_RPT_FLD ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPS_WFS_RPT_FLD |
Character(10) | VARCHAR2(10) NOT NULL | GPS WFS Report Field |
| 2 | ORDERNO | Number(5,0) | INTEGER NOT NULL | Sort Order |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | GPS_WFS_MAP_REC | Character(25) | VARCHAR2(25) NOT NULL | Mapping Record |
| 5 | GPS_WFS_MAP_FLD | Character(25) | VARCHAR2(25) NOT NULL | Mapping Field |
| 6 | GPS_WFS_MAP_RUL | Character(3) | VARCHAR2(3) NOT NULL |
GPS Workforce Statistic Rule
EMP=Empty FIL=FILL HCH=Hardcode MAP=Mapping ONE=One to one |
| 7 | GPS_WFS_MAP_CLS | Character(254) | VARCHAR2(254) NOT NULL | Mapping Class |
| 8 | GPS_WFS_MAP_REQ | Character(1) | VARCHAR2(1) NOT NULL | Whether the field is reqired |
| 9 | GPS_WFS_MAP_SC_LDR | Character(100) | VARCHAR2(100) NOT NULL | Mapping Source Loader Method |
| 10 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |