PSFLDDEFN

Return to Index

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 NameField TypeDescription
FLDDEFNNAMEVARCHAR2(30) NOT NULLDefinition Name
FLDFORMATINTEGER NOT NULLField Format
FLDSEGCOUNTINTEGER NOT NULLSegment Count
FLDTAGVARCHAR2(30) NOT NULLXML End Tag
FLDQUALIFIERVARCHAR2(1) NOT NULLField Qualifier
FLDQUALIFIEROPTSMALLINT NOT NULLQualifier Optional
FLDDELIMITERTYPESMALLINT NOT NULLField Delimiter Type
FLDDELIMITERVARCHAR2(1) NOT NULLField Delimiter
FLDIMPLYDECIMALSMALLINT NOT NULLImply Decimal Place
FLDEXCELFORMATSMALLINT NOT NULLParse using Excel Format
FLDCONVERTTABSSMALLINT NOT NULLConvert Tabs To Spaces
FLDSTRIPSPACESMALLINT NOT NULLStrip Leading & Trailing Space
FLDINTRPBACKSLASHSMALLINT NOT NULLInterpret Backslash
FLDEMBQUOTEFMTINTEGER NOT NULLEmbedded Quote Format
FLDFILENAMEVARCHAR2(250) NOT NULLField Default File Name
DESCRVARCHAR2(30) NOT NULLDescription
VERSIONDECIMAL(10) NOT NULLVersion
LASTUPDOPRIDVARCHAR2(30) NOT NULLSpecifies 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.
LASTUPDDTTMDATESpecifies 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.
FLDSEGIDVARCHAR2(30) NOT NULLSegment ID
FLDSEGIDSTARTINTEGER NOT NULLSegment ID Start
FLDSEGIDLENGTHINTEGER NOT NULLSegment ID Length
FLDXMLBUFFSIZEDECIMAL(10) NOT NULLXML Buffer Size
DESCRLONGLONG VARCHARLong Description

Author: PeopleTools 8.52

Return to Index

© David Kurtz  Last updated 01 August 2015