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 NameField TypeColumn TypeDescription
FLDDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLDefinition Name (see PSFLDDEFN).
FLDSEGNAMECharacter(15)VARCHAR2(15) NOT NULLSegment Name
FLDSEGIDCharacter(30)VARCHAR2(30) NOT NULLSegment ID
FLDSEGPARENTCharacter(15)VARCHAR2(15) NOT NULLSegment Parent
FLDSEGIDSTARTNumber(5,0)INTEGER NOT NULLSegment ID Start
FLDSEGIDLENGTHNumber(5,0)INTEGER NOT NULLSegment ID Length
FLDOFFSETNumber(5,0)INTEGER NOT NULLField Offset
FLDTAGCharacter(30)VARCHAR2(30) NOT NULLXML End Tag
FLDSEQNONumber(5,0)INTEGER NOT NULLField Sequence Number
FLDQUALIFIERCharacter(1)VARCHAR2(1) NOT NULLField Qualifier
FLDDELIMITERTYPENumber(2,0)SMALLINT NOT NULLField Delimiter Type
FLDDELIMITERCharacter(1)VARCHAR2(1) NOT NULLField Delimiter
FLDSEGCOUNTNumber(5,0)INTEGER NOT NULLSegment Count
FLDFIELDCOUNTNumber(5,0)INTEGER NOT NULLField Count
FLDIDSEQNONumber(5,0)INTEGER NOT NULLFile ID Sequence Number
FLDMAXSEGLENNumber(5,0)INTEGER NOT NULLMaximum Segment Length
DESCR100Character(100)VARCHAR2(100) NOT NULLLength 100 Description
RECNAME_FILECharacter(15)VARCHAR2(15) NOT NULLModel File Layout
SQLIDCharacter(30)VARCHAR2(30) NOT NULLSQL 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)
  • SQLTYPECharacter(1)VARCHAR2(1) NOT NULLSQL 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
  • PTFLDSEGTERMCharacter(5)VARCHAR2(5) NOT NULLSegment Terminator
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19