FS_FLAT_FILE(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(20) | VARCHAR2(20) NOT NULL | Layout ID | |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
3 | FS_FF_FLD_DLMT | Character(5) | VARCHAR2(5) NOT NULL | Field Delimiter |
4 | FS_FF_SUBF_DLMT | Character(5) | VARCHAR2(5) NOT NULL | Sub-Field Delimiter |
5 | FS_FF_REC_DLMT | Character(5) | VARCHAR2(5) NOT NULL | Record Delimiter |
6 | FS_FF_RET_FOLLOW | Character(1) | VARCHAR2(1) NOT NULL |
Add Line Feed
Y/N Table Edit Default Value: Y |
7 | FS_FF_COMMENT | Character(5) | VARCHAR2(5) NOT NULL | Comment |
8 | IB_PACKAGEID | Character(100) | VARCHAR2(100) NOT NULL |
Referenced Package
Prompt Table: PSLSDEFNPACK_VW |
9 | IB_SCHEMANAME | Character(100) | VARCHAR2(100) NOT NULL |
Document Name
Prompt Table: PSLSDEFNSRCH_VW |
10 | IB_VARIANTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Version Name
Prompt Table: FS_DEFNVARS_VW |
11 | FS_MAP_UPLD_PB | Character(1) | VARCHAR2(1) NOT NULL | PS Document Builder |
12 | FS_MAP_DOC_LD_PB | Character(1) | VARCHAR2(1) NOT NULL | Display Document |
13 | FS_MAP_TITLE_PRINT | Character(1) | VARCHAR2(1) NOT NULL |
Insert Column Header
Y/N Table Edit Default Value: N |
14 | TREECTLEVENT | Character(46) | VARCHAR2(46) NOT NULL | Tree Control Event |