| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name
|
| 2 |
VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|
| 3 |
FIELDTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Type (from PSST0101 Ref.)
0=Character
1=Long Character
2=Number
3=Signed Number
4=Date
5=Time
6=DateTime
8=Image / Attachment
9=Image Reference
|
| 4 |
LENGTH |
Number(5,0) |
INTEGER NOT NULL |
Length
|
| 5 |
DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 6 |
FORMAT |
Number(2,0) |
SMALLINT NOT NULL |
Field Format
0=If Fieldtype=0 (Character) then Upper CaseIf Fieldtype=6 (DateTime) then HH:MM
1=Name
2=Phone Number North American (mandatory length 12 characters)
3=Zip/Postal Code North American (mandatory length 10 characters)
4=US Social Security Number (mandatory length 9 characters)
5=
6=Mixed Case
7=Raw/Binary
8=Numbers only
9=SIN (mandatory length 9 characters)
10=International Phone Number
11=Zip/Postal Code International
12=Time HH:MM:SS
13=Time HH:MM:SS.999999
14=Custom (FORMATFAMILY and DISPFMTNAME must be completed)
|
| 7 |
FORMATLENGTH |
Number(4,0) |
SMALLINT NOT NULL |
Format Length in characters. Except that Images and Attachments in Kb.
|
| 8 |
IMAGE_FMT |
Number(2,0) |
SMALLINT NOT NULL |
Image FormatOnly set for FIELDTYPE of Images and Attachments.
1=BMP - Bitmaps
2=CUT - HALO Image
3=DIB - Bitmaps
4=EPS - Postscript
5=GIF - Graphics Int Format
6=JPG - JPEG
7=PCT - Macintosh
8=PCX - Zsoft
9=RLE - Bitmaps
10=TGA - Targa
16=Attachment
|
| 9 |
FORMATFAMILY |
Character(15) |
VARCHAR2(15) NOT NULL |
Format Family Name (see PSFMTDEFN).
|
| 10 |
DISPFMTNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Display Format Name (see PSFMTITEM).
|
| 11 |
DEFCNTRYYR |
Number(2,0) |
SMALLINT NOT NULL |
Default Century Year
Default Value: 50
|
| 12 |
IMEMODE |
Number(3,0) |
SMALLINT NOT NULL |
Input Method Editor Mode
Default Value: 0
|
| 13 |
KBLAYOUT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Keyboard Layout
Default Value: 0
|
| 14 |
OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
|
| 15 |
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.
|
| 16 |
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.
|
| 17 |
FLDNOTUSED |
Number(1,0) |
SMALLINT NOT NULL |
This field indicates whether a field is being actively used in a table or whether it is just there to avoid rebuilding the table and removing it. The default is 0, which means the field is used.
1/0 Table Edit (1=True, 0=False)
Default Value: 0
|
| 18 |
AUXFLAGMASK |
Number(10,0) |
DECIMAL(10) NOT NULL |
Auxiliary Flag Mask bit values
|
| 19 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|