FLDDEFNNAMEPSFLDDEFN(SQL Table) |
Index Back |
|---|---|
File Layout - File DefnsA File Layout is a definition (or mapping) of a file to be processed. It identifies where in a file data fields are located. Once a File Layout has been created, you can write PeopleCode programs that use the File Layout to either read data from or write data to a file. This record contains all information stored at the File Layout (root) level. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FLDDEFNNAME |
Character(30) | VARCHAR2(30) NOT NULL | Definition Name |
| 2 | FLDFORMAT | Number(5,0) | INTEGER NOT NULL | Field Format |
| 3 | FLDSEGCOUNT | Number(5,0) | INTEGER NOT NULL | Segment Count |
| 4 | FLDTAG | Character(30) | VARCHAR2(30) NOT NULL | XML End Tag |
| 5 | FLDQUALIFIER | Character(1) | VARCHAR2(1) NOT NULL | Field Qualifier |
| 6 | FLDQUALIFIEROPT | Number(3,0) | SMALLINT NOT NULL | Qualifier Optional |
| 7 | FLDDELIMITERTYPE | Number(2,0) | SMALLINT NOT NULL | Field Delimiter Type |
| 8 | FLDDELIMITER | Character(1) | VARCHAR2(1) NOT NULL | Field Delimiter |
| 9 | FLDIMPLYDECIMAL | Number(3,0) | SMALLINT NOT NULL | Imply Decimal Place |
| 10 | FLDEXCELFORMAT | Number(3,0) | SMALLINT NOT NULL | Parse using Excel Format |
| 11 | FLDCONVERTTABS | Number(3,0) | SMALLINT NOT NULL | Convert Tabs To Spaces |
| 12 | FLDSTRIPSPACE | Number(3,0) | SMALLINT NOT NULL | Strip Leading & Trailing Space |
| 13 | FLDINTRPBACKSLASH | Number(3,0) | SMALLINT NOT NULL | Interpret Backslash |
| 14 | FLDEMBQUOTEFMT | Number(5,0) | INTEGER NOT NULL | Embedded Quote Format |
| 15 | FLDFILENAME | Character(250) | VARCHAR2(250) NOT NULL | Field Default File Name |
| 16 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 17 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| 18 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 19 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 20 | FLDSEGID | Character(30) | VARCHAR2(30) NOT NULL | Segment ID |
| 21 | FLDSEGIDSTART | Number(5,0) | INTEGER NOT NULL | Segment ID Start |
| 22 | FLDSEGIDLENGTH | Number(5,0) | INTEGER NOT NULL | Segment ID Length |
| 23 | FLDXMLBUFFSIZE | Number(10,0) | DECIMAL(10) NOT NULL | XML Buffer Size |
| 24 | DESCRLONG | Long Character | CLOB | Long Description |