CO_FILE_NBRS_VW

index back

File Layout - File Fields

The record contains contains stored at the File Field level for a File Layout.
SELECT A.FLDDEFNNAME ,A.FLDSEGNAME ,A.FLDSEQNO ,A.FLDFIELDNAME ,A.FLDSTART ,A.FLDLENGTH ,B.DECIMALPOS ,C.FLDMAXSEGLEN FROM PSFLDFIELDDEFN A ,PSDBFIELD B ,PSFLDSEGDEFN C WHERE A.FLDFIELDTYPE IN (2,3) AND A.FLDFIELDNAME = B.FIELDNAME AND A.FLDDEFNNAME = C.FLDDEFNNAME AND A.FLDSEGNAME = C.FLDSEGNAME

PeopleSoft Field NameField TypeColumn TypeDescription
FLDDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLDefinition Name (see PSFLDDEFN).
FLDSEGNAMECharacter(15)VARCHAR2(15) NOT NULLSegment Name
FLDSEQNONumber(5,0)INTEGER NOT NULLField Sequence Number
FLDFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name
FLDSTARTNumber(5,0)INTEGER NOT NULLStarting Position
FLDLENGTHNumber(5,0)INTEGER NOT NULLField Length
DECIMALPOSNumber(2,0)SMALLINT NOT NULLDecimal Positions
FLDMAXSEGLENNumber(5,0)INTEGER NOT NULLMaximum Segment Length
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19