FS_MAP_FL_NAME0=FIXED
1=CSV
2=XML
FS_MAP_FLD_DEFN(SQL View) |
Index Back |
|---|
| SELECT FLDDEFNNAME ,FLDFORMAT , DESCR FROM PSFLDDEFN WHERE FLDFORMAT = 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FS_MAP_FL_NAME |
Character(30) | VARCHAR2(30) NOT NULL | File Layout |
| 2 | FS_MAP_FLDFORMAT | Character(1) | VARCHAR2(1) NOT NULL |
File Layout Format
0=FIXED 1=CSV 2=XML |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |