Return to Index

  • Related language record: PSDBFIELDLANG
  • PeopleSoft Field NameDescription
    FIELDNAMEField Name
    VERSIONVersion Number (OBJECTTYPE = 'RDM',  also on PSLOCK)

    Internal PeopleTools version for controlling caching of object. 

    FIELDTYPEField Type
    1=Long Character
    3=Signed Number
    8=Image / Attachment
    9=Image Reference
    DECIMALPOSDecimal Positions
    FORMATField Format
      If Fieldtype=0 (Character) then Upper Case
      If Fieldtype=6 (DateTime) then HH:MM
    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)
    6=Mixed Case
    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)
    FORMATLENGTHHFormat Length in characters.
    Except that Images and Attachments in Kb.
    IMAGE_FMTImage 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
    FORMATFAMILYFormat Family Name (see PSFMTDEFN)
    DISPFMTNAMEDisplay Format Name (see PSMTITEM)
    DEFCNTRYYRDefault Century Year

    Default: 50

    IMEMODEInput Method Editor Mode

    Default: 0

    KBLAYOUTKeyboard Layout

    Default: 0

    OBJECTOWNERIDObject owner identifier translate values
    LASTUPDDTTMSpecifies 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.
    LASTUPDOPRIDSpecifies 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.
    FLDNOTUSEDThis 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

    AUXFLAGMASKAuxiliary Flag Mask
    DESCRLONGLong Description

    Author: David Kurtz, Uffe Graakjaer

    Return to Index

    © David Kurtz  Last updated 01 August 2015