GPS_WFS_RPT_FLDEFFDTDefault Value: %date
EMP=Empty
FIL=FILL
HCH=Hardcode
MAP=Mapping
ONE=One to one
GPS_WFS_MAP_DTL(SQL Table) |
Index Back |
|---|---|
Mapping Detail for WFSMapping detail table for Workforce Statistic |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | ORDERNO | Number(5,0) | INTEGER NOT NULL | Sort Order |
| 5 | GPS_WFS_MAP_REC | Character(25) | VARCHAR2(25) NOT NULL | Mapping Record |
| 6 | GPS_WFS_MAP_FLD | Character(25) | VARCHAR2(25) NOT NULL | Mapping Field |
| 7 | 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 |
| 8 | GPS_WFS_MAP_CLS | Character(254) | VARCHAR2(254) NOT NULL | Mapping Class |
| 9 | GPS_WFS_MAP_REQ | Character(1) | VARCHAR2(1) NOT NULL | Whether the field is reqired |
| 10 | GPS_WFS_MAP_SC_LDR | Character(100) | VARCHAR2(100) NOT NULL | Mapping Source Loader Method |
| 11 | GPS_RPT_FLD_TYPE | Character(15) | VARCHAR2(15) NOT NULL | GPS Report Field Type |
| 12 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |