PSFLDFIELDDEFN

index back

File Layout - File Fields

The record contains contains stored at the File Field level for a File Layout.

PeopleSoft Field NameField TypeColumn TypeDescription
FLDDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLDefinition Name (see PSFLDDEFN).
FLDSEGNAMECharacter(15)VARCHAR2(15) NOT NULLSegment Name
FLDFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name
FLDSTARTNumber(5,0)INTEGER NOT NULLStarting Position
FLDLENGTHNumber(5,0)INTEGER NOT NULLField Length
FLDOFFSETNumber(5,0)INTEGER NOT NULLField Offset
FLDFIELDTYPENumber(2,0)SMALLINT NOT NULLField Type
DECIMAL_POSNumber(2,0)SMALLINT NOT NULLDecimal Position
FLDTAGCharacter(30)VARCHAR2(30) NOT NULLXML End Tag
FLDSEQNONumber(5,0)INTEGER NOT NULLField Sequence Number
FLDSUPPRESSNumber(3,0)SMALLINT NOT NULLSuppress Field Flag
FLDDATEFMTCharacter(30)VARCHAR2(30) NOT NULLField Date Format
FLDDATESEPARATORCharacter(1)VARCHAR2(1) NOT NULLField Date Separator
FLDQUALIFIERCharacter(1)VARCHAR2(1) NOT NULLField Qualifier
FLDTRIMSPACESNumber(3,0)SMALLINT NOT NULLTrim Trailing Spaces
FLDIPVSEGCharacter(15)VARCHAR2(15) NOT NULLInherit Parent Val SegmentName
FLDIPVFIELDCharacter(18)VARCHAR2(18) NOT NULLInherit Parent Val Field Name
FLDFIELDDFLTCharacter(100)VARCHAR2(100) NOT NULLField Default
DESCR100Character(100)VARCHAR2(100) NOT NULLLength 100 Description
FLDUPPERNumber(3,0)SMALLINT NOT NULLConvert to Upper Case
FLDSTRIPCHARCharacter(100)VARCHAR2(100) NOT NULLStrip Characters
PTFLDPADFIELDNumber(3,0)SMALLINT NOT NULLPad Field
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19