PSDBFIELD

Return to Index

  • Related language record: PSDBFIELDLANG
  • 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

    Author: David Kurtz, Uffe Graakjaer

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 19 May 2011