| PeopleSoft Field Name | Description |
|---|
 FIELDNAME | Field Name |
| VERSION | Version Number (OBJECTTYPE = 'RDM', also on PSLOCK) Internal PeopleTools version for controlling caching of object. |
| FIELDTYPE | Field Type
0=Character
1=Long Character
2=Number
3=Signed Number
4=Date
5=Time
6=DateTime
8=Image / Attachment
9=Image Reference |
| LENGTH | Length |
| DECIMALPOS | Decimal Positions |
| FORMAT | Field Format
0=
If Fieldtype=0 (Character) then Upper Case
If 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 DISPLAFMTNAME must be completed) |
| FORMATLENGTHH | Format Length in characters.
Except that Images and Attachments in Kb. |
| IMAGE_FMT | Image Format. Only 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 |
| FORMATFAMILY | Format Family Name (see PSFMTDEFN) |
| DISPFMTNAME | Display Format Name (see PSMTITEM) |
| DEFCNTRYYR | Default Century Year Default: 50 |
| IMEMODE | Input Method Editor Mode Default: 0 |
| KBLAYOUT | Keyboard Layout Default: 0 |
| OBJECTOWNERID | Object owner identifier translate values |
| LASTUPDDTTM | 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. |
| LASTUPDOPRID | 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. |
| FLDNOTUSED | 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: 0 |
| AUXFLAGMASK | Auxiliary Flag Mask |
| DESCRLONG | Long Description |