PSFLDDEFN

 index back

File Layout - File Defns

A 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 Field Type Column Type Description
FLDDEFNNAME Character(30) VARCHAR2(30) NOT NULL Definition Name
FLDFORMAT Number(5,0) INTEGER NOT NULL Field Format
FLDSEGCOUNT Number(5,0) INTEGER NOT NULL Segment Count
FLDTAG Character(30) VARCHAR2(30) NOT NULL XML End Tag
FLDQUALIFIER Character(1) VARCHAR2(1) NOT NULL Field Qualifier
FLDQUALIFIEROPT Number(3,0) SMALLINT NOT NULL Qualifier Optional
FLDDELIMITERTYPE Number(2,0) SMALLINT NOT NULL Field Delimiter Type
FLDDELIMITER Character(1) VARCHAR2(1) NOT NULL Field Delimiter
FLDIMPLYDECIMAL Number(3,0) SMALLINT NOT NULL Imply Decimal Place
FLDEXCELFORMAT Number(3,0) SMALLINT NOT NULL Parse using Excel Format
FLDCONVERTTABS Number(3,0) SMALLINT NOT NULL Convert Tabs To Spaces
FLDSTRIPSPACE Number(3,0) SMALLINT NOT NULL Strip Leading & Trailing Space
FLDINTRPBACKSLASH Number(3,0) SMALLINT NOT NULL Interpret Backslash
FLDEMBQUOTEFMT Number(5,0) INTEGER NOT NULL Embedded Quote Format
FLDFILENAME Character(250) VARCHAR2(250) NOT NULL Field Default File Name
DESCR Character(30) VARCHAR2(30) NOT NULL Description
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
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.
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.
FLDSEGID Character(30) VARCHAR2(30) NOT NULL Segment ID
FLDSEGIDSTART Number(5,0) INTEGER NOT NULL Segment ID Start
FLDSEGIDLENGTH Number(5,0) INTEGER NOT NULL Segment ID Length
FLDXMLBUFFSIZE Number(10,0) DECIMAL(10) NOT NULL XML Buffer Size
DESCRLONG Long Character CLOB Long Description
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20