PSFLDSEGDEFN

(SQL Table)
 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 PeopleSoft Field Type Database Column Type Description
1 FLDDEFNNAME Character(30) VARCHAR2(30) NOT NULL Definition Name (see PSFLDDEFN).
2 FLDSEGNAME Character(15) VARCHAR2(15) NOT NULL Segment Name
3 FLDSEGID Character(30) VARCHAR2(30) NOT NULL Segment ID
4 FLDSEGPARENT Character(15) VARCHAR2(15) NOT NULL Segment Parent
5 FLDSEGIDSTART Number(5,0) INTEGER NOT NULL Segment ID Start
6 FLDSEGIDLENGTH Number(5,0) INTEGER NOT NULL Segment ID Length
7 FLDOFFSET Number(5,0) INTEGER NOT NULL Field Offset
8 FLDTAG Character(30) VARCHAR2(30) NOT NULL XML End Tag
9 FLDSEQNO Number(5,0) INTEGER NOT NULL Field Sequence Number
10 FLDQUALIFIER Character(1) VARCHAR2(1) NOT NULL Field Qualifier
11 FLDDELIMITERTYPE Number(2,0) SMALLINT NOT NULL Field Delimiter Type
12 FLDDELIMITER Character(1) VARCHAR2(1) NOT NULL Field Delimiter
13 FLDSEGCOUNT Number(5,0) INTEGER NOT NULL Segment Count
14 FLDFIELDCOUNT Number(5,0) INTEGER NOT NULL Field Count
15 FLDIDSEQNO Number(5,0) INTEGER NOT NULL File ID Sequence Number
16 FLDMAXSEGLEN Number(5,0) INTEGER NOT NULL Maximum Segment Length
17 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
18 RECNAME_FILE Character(15) VARCHAR2(15) NOT NULL Model File Layout
19 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)
    • 20 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
    • 21 PTFLDSEGTERM Character(5) VARCHAR2(5) NOT NULL Segment Terminator