index back

Database Field

  • Related language record: PSDBFIELDLANG
  • PeopleSoft Field Name Field Type Column Type Description
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
    1=Long Character
    3=Signed Number
    8=Image / Attachment
    9=Image Reference
    LENGTH Number(5,0) INTEGER NOT NULL Length
    DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    FORMAT Number(2,0) SMALLINT NOT NULL Field 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 DISPFMTNAME must be completed)
  • FORMATLENGTH Number(4,0) SMALLINT NOT NULL Format Length in characters. Except that Images and Attachments in Kb.
    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
    FORMATFAMILY Character(15) VARCHAR2(15) NOT NULL Format Family Name (see PSFMTDEFN).
    DISPFMTNAME Character(15) VARCHAR2(15) NOT NULL Display Format Name (see PSFMTITEM).
    DEFCNTRYYR Number(2,0) SMALLINT NOT NULL Default Century Year

    Default: 50

    IMEMODE Number(3,0) SMALLINT NOT NULL Input Method Editor Mode

    Default: 0

    KBLAYOUT Number(10,0) DECIMAL(10) NOT NULL Keyboard Layout

    Default: 0

    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    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.
    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.
    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: 0

    AUXFLAGMASK Number(10,0) DECIMAL(10) NOT NULL Auxiliary Flag Mask bit values
    DESCRLONG Long Character CLOB Long Description
    index back (c)David Kurtz 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20