PSDBFIELD_VW

(SQL View)
 Index Back

Database Field View

Global Payroll Database Field View Record

SELECT fieldname ,fieldtype ,length ,version ,decimalpos ,format ,formatlength ,image_fmt FROM PSDBFIELD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
2 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
3 LENGTH Number(5,0) INTEGER NOT NULL Length
4 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
5 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
6 FORMAT Number(2,0) SMALLINT NOT NULL 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 DISPFMTNAME must be completed)
    • 7 FORMATLENGTH Number(4,0) SMALLINT NOT NULL Format Length in characters. Except that Images and Attachments in Kb.
    8 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
    16=Attachment