FS_MAP_TRG_HDR(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FS_MAP_ID |
Character(30) | VARCHAR2(30) NOT NULL | Map ID |
| 2 | FS_MAP_NODE_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Source Type
D=PS Document F=Delimited File L=File Layout (FIXED) R=Report T=Table X=XMLDoc |
| 3 | FS_MAP_RELT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Type
T=DB Table X=XML File |
| 4 | FS_FF_LAYOUT_ID | Character(20) | VARCHAR2(20) NOT NULL |
Layout ID
Prompt Table: FS_FLAT_FILE |
| 5 | FS_MAP_UPLD_PB | Character(1) | VARCHAR2(1) NOT NULL | PS Document Builder |
| 6 | FS_MAP_LAYOUT_PB | Character(1) | VARCHAR2(1) NOT NULL | Upload XSD |
| 7 | FS_MAP_CHAR_SET | Character(1) | VARCHAR2(1) NOT NULL |
Character Set
G=GBK18030-2005 U=UTF-8 W=UTF-8 Without BOM |
| 8 | FS_MAP_REFRESH_PB | Character(1) | VARCHAR2(1) NOT NULL | Refresh |
| 9 | IB_PACKAGEID | Character(100) | VARCHAR2(100) NOT NULL |
Referenced Package
Prompt Table: PSLSDEFNPACK_VW |
| 10 | IB_SCHEMANAME | Character(100) | VARCHAR2(100) NOT NULL |
Document Name
Prompt Table: PSLSDEFNSRCH_VW |
| 11 | IB_VARIANTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Version Name
Prompt Table: FS_DEFNVARS_VW |
| 12 | FS_MAP_UPD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Update Only Flag
Y/N Table Edit Default Value: N |
| 13 | FS_MAP_SAMPLEFILE | Character(64) | VARCHAR2(64) NOT NULL | XML Sample File |