PSFLDFIELDDEFN

index back

File Layout - File Fields

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

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
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
FLDOFFSET Number(5,0) INTEGER NOT NULL Field Offset
FLDFIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type
DECIMAL_POS Number(2,0) SMALLINT NOT NULL Decimal Position
FLDTAG Character(30) VARCHAR2(30) NOT NULL XML End Tag
FLDSEQNO Number(5,0) INTEGER NOT NULL Field Sequence Number
FLDSUPPRESS Number(3,0) SMALLINT NOT NULL Suppress Field Flag
FLDDATEFMT Character(30) VARCHAR2(30) NOT NULL Field Date Format
FLDDATESEPARATOR Character(1) VARCHAR2(1) NOT NULL Field Date Separator
FLDQUALIFIER Character(1) VARCHAR2(1) NOT NULL Field Qualifier
FLDTRIMSPACES Number(3,0) SMALLINT NOT NULL Trim Trailing Spaces
FLDIPVSEG Character(15) VARCHAR2(15) NOT NULL Inherit Parent Val SegmentName
FLDIPVFIELD Character(18) VARCHAR2(18) NOT NULL Inherit Parent Val Field Name
FLDFIELDDFLT Character(100) VARCHAR2(100) NOT NULL Field Default
DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
FLDUPPER Number(3,0) SMALLINT NOT NULL Convert to Upper Case
FLDSTRIPCHAR Character(100) VARCHAR2(100) NOT NULL Strip Characters
PTFLDPADFIELD Number(3,0) SMALLINT NOT NULL Pad Field
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19