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 NameField TypeColumn TypeDescription
FLDDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLDefinition Name
FLDFORMATNumber(5,0)INTEGER NOT NULLField Format
FLDSEGCOUNTNumber(5,0)INTEGER NOT NULLSegment Count
FLDTAGCharacter(30)VARCHAR2(30) NOT NULLXML End Tag
FLDQUALIFIERCharacter(1)VARCHAR2(1) NOT NULLField Qualifier
FLDQUALIFIEROPTNumber(3,0)SMALLINT NOT NULLQualifier Optional
FLDDELIMITERTYPENumber(2,0)SMALLINT NOT NULLField Delimiter Type
FLDDELIMITERCharacter(1)VARCHAR2(1) NOT NULLField Delimiter
FLDIMPLYDECIMALNumber(3,0)SMALLINT NOT NULLImply Decimal Place
FLDEXCELFORMATNumber(3,0)SMALLINT NOT NULLParse using Excel Format
FLDCONVERTTABSNumber(3,0)SMALLINT NOT NULLConvert Tabs To Spaces
FLDSTRIPSPACENumber(3,0)SMALLINT NOT NULLStrip Leading & Trailing Space
FLDINTRPBACKSLASHNumber(3,0)SMALLINT NOT NULLInterpret Backslash
FLDEMBQUOTEFMTNumber(5,0)INTEGER NOT NULLEmbedded Quote Format
FLDFILENAMECharacter(250)VARCHAR2(250) NOT NULLField Default File Name
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
LASTUPDOPRIDCharacter(30)VARCHAR2(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.
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
FLDSEGIDCharacter(30)VARCHAR2(30) NOT NULLSegment ID
FLDSEGIDSTARTNumber(5,0)INTEGER NOT NULLSegment ID Start
FLDSEGIDLENGTHNumber(5,0)INTEGER NOT NULLSegment ID Length
FLDXMLBUFFSIZENumber(10,0)DECIMAL(10) NOT NULLXML Buffer Size
DESCRLONGLong CharacterCLOBLong Description
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19