PSFLDSEGDEFN

 index back

File Layout - File Segments.

A File Layout is simply a collection of File Records/Segments, which in turn are a collection of Fields. A segment is the exact same as a record, only it contains no information. You have to add all the information yourself. After you add the information to a segment, you can treat it just like any other file record. This record is used to store the Record / Segment information.

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
FLDSEGID Character(30) VARCHAR2(30) NOT NULL Segment ID
FLDSEGPARENT Character(15) VARCHAR2(15) NOT NULL Segment Parent
FLDSEGIDSTART Number(5,0) INTEGER NOT NULL Segment ID Start
FLDSEGIDLENGTH Number(5,0) INTEGER NOT NULL Segment ID Length
FLDOFFSET Number(5,0) INTEGER NOT NULL Field Offset
FLDTAG Character(30) VARCHAR2(30) NOT NULL XML End Tag
FLDSEQNO Number(5,0) INTEGER NOT NULL Field Sequence Number
FLDQUALIFIER Character(1) VARCHAR2(1) NOT NULL Field Qualifier
FLDDELIMITERTYPE Number(2,0) SMALLINT NOT NULL Field Delimiter Type
FLDDELIMITER Character(1) VARCHAR2(1) NOT NULL Field Delimiter
FLDSEGCOUNT Number(5,0) INTEGER NOT NULL Segment Count
FLDFIELDCOUNT Number(5,0) INTEGER NOT NULL Field Count
FLDIDSEQNO Number(5,0) INTEGER NOT NULL File ID Sequence Number
FLDMAXSEGLEN Number(5,0) INTEGER NOT NULL Maximum Segment Length
DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
RECNAME_FILE Character(15) VARCHAR2(15) NOT NULL Model File Layout
SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
    • SQLTYPE Character(1) VARCHAR2(1) NOT NULL SQL Object type
  • 0=SQL Object referenced from elsewhere
  • 1=Application Engine Step
  • 2=SQL View
  • 5=Queries for DDDAUDIT and SYSAUDIT
  • 6= Application Engine Step XSLT
    • PTFLDSEGTERM Character(5) VARCHAR2(5) NOT NULL Segment Terminator
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20