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 Name Field Type Column Type Description
FLDDEFNNAME Character(30) VARCHAR2(30) NOT NULL Definition Name (see PSFLDDEFN).
FLDSEGNAME Character(15) VARCHAR2(15) NOT NULL Segment Name
FLDSEQNO Number(5,0) INTEGER NOT NULL Field Sequence Number
FLDFIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name
FLDSTART Number(5,0) INTEGER NOT NULL Starting Position
FLDLENGTH Number(5,0) INTEGER NOT NULL Field Length
DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
FLDMAXSEGLEN Number(5,0) INTEGER NOT NULL Maximum Segment Length
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19