GPS_CAR_RPT_FLDEFFDTDefault Value: %date
EMP=Empty
FIL=FILL
HCH=Hardcode
MAP=Mapping
ONE=One to one
FLD=Field with values
TAG=Tag only
GPS_CAR_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_CAR_RPT_FLD |
Character(25) | VARCHAR2(25) NOT NULL | GPS CAR 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_CAR_MAP_REC | Character(25) | VARCHAR2(25) NOT NULL | Mapping Record |
| 6 | GPS_CAR_MAP_FLD | Character(25) | VARCHAR2(25) NOT NULL | Mapping Field |
| 7 | GPS_CAR_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_CAR_MAP_FLD_TP | Character(3) | VARCHAR2(3) NOT NULL |
GPS Workforce Statistic Rule
FLD=Field with values TAG=Tag only |
| 9 | GPS_CAR_MAP_CLS | Character(254) | VARCHAR2(254) NOT NULL | Mapping Class |
| 10 | GPS_CAR_MAP_SC_LDR | Character(100) | VARCHAR2(100) NOT NULL | Mapping Source Loader Method |
| 11 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
| 12 | GPS_CAR_MAP_LV | Number(1,0) | SMALLINT NOT NULL | Field level in xml file. company:1 beneficiary 2.children3. |