index back

Database Field

  • Related language record: PSDBFIELDLANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
    1=Long Character
    3=Signed Number
    8=Image / Attachment
    9=Image Reference
    DECIMALPOSNumber(2,0)SMALLINT NOT NULLDecimal Positions
    FORMATNumber(2,0)SMALLINT NOT NULLField 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)
  • FORMATLENGTHNumber(4,0)SMALLINT NOT NULLFormat Length in characters. Except that Images and Attachments in Kb.
    IMAGE_FMTNumber(2,0)SMALLINT NOT NULLImage 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
    FORMATFAMILYCharacter(15)VARCHAR2(15) NOT NULLFormat Family Name (see PSFMTDEFN).
    DISPFMTNAMECharacter(15)VARCHAR2(15) NOT NULLDisplay Format Name (see PSFMTITEM).
    DEFCNTRYYRNumber(2,0)SMALLINT NOT NULLDefault Century Year

    Default: 50

    IMEMODENumber(3,0)SMALLINT NOT NULLInput Method Editor Mode

    Default: 0

    KBLAYOUTNumber(10,0)DECIMAL(10) NOT NULLKeyboard Layout

    Default: 0

    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
    FLDNOTUSEDNumber(1,0)SMALLINT NOT NULLThis 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

    AUXFLAGMASKNumber(10,0)DECIMAL(10) NOT NULLAuxiliary Flag Mask bit values
    DESCRLONGLong CharacterCLOBLong Description
    index back(c)David Kurtz 2019, 8.54
    PTRef generated on 09-JUN-19