PeopleSoft Field Name |
Field Type |
Column Type |
Description |
FLDDEFNNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Definition Name
|
FLDFORMAT |
Number(5,0) |
INTEGER NOT NULL |
Field Format
|
FLDSEGCOUNT |
Number(5,0) |
INTEGER NOT NULL |
Segment Count
|
FLDTAG |
Character(30) |
VARCHAR2(30) NOT NULL |
XML End Tag
|
FLDQUALIFIER |
Character(1) |
VARCHAR2(1) NOT NULL |
Field Qualifier
|
FLDQUALIFIEROPT |
Number(3,0) |
SMALLINT NOT NULL |
Qualifier Optional
|
FLDDELIMITERTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Delimiter Type
|
FLDDELIMITER |
Character(1) |
VARCHAR2(1) NOT NULL |
Field Delimiter
|
FLDIMPLYDECIMAL |
Number(3,0) |
SMALLINT NOT NULL |
Imply Decimal Place
|
FLDEXCELFORMAT |
Number(3,0) |
SMALLINT NOT NULL |
Parse using Excel Format
|
FLDCONVERTTABS |
Number(3,0) |
SMALLINT NOT NULL |
Convert Tabs To Spaces
|
FLDSTRIPSPACE |
Number(3,0) |
SMALLINT NOT NULL |
Strip Leading & Trailing Space
|
FLDINTRPBACKSLASH |
Number(3,0) |
SMALLINT NOT NULL |
Interpret Backslash
|
FLDEMBQUOTEFMT |
Number(5,0) |
INTEGER NOT NULL |
Embedded Quote Format
|
FLDFILENAME |
Character(250) |
VARCHAR2(250) NOT NULL |
Field Default File Name
|
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
FLDSEGID |
Character(30) |
VARCHAR2(30) NOT NULL |
Segment ID
|
FLDSEGIDSTART |
Number(5,0) |
INTEGER NOT NULL |
Segment ID Start
|
FLDSEGIDLENGTH |
Number(5,0) |
INTEGER NOT NULL |
Segment ID Length
|
FLDXMLBUFFSIZE |
Number(10,0) |
DECIMAL(10) NOT NULL |
XML Buffer Size
|
DESCRLONG |
Long Character |
CLOB |
Long Description
|