PST_PNLFIELDS

index back

Upgrader Panel Work


  • Parent record: PSPNLDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    SRC_TGT Character(1) VARCHAR2(1) NOT NULL Source/Target Indicator
    FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
    EDITSIZE Number(5,0) INTEGER NOT NULL Currently Not Used
    DSPLFORMAT Number(10,0) DECIMAL(10) NOT NULL Display Format
    FIELDLEFT Number(4,0) SMALLINT NOT NULL Field Left
    FIELDTOP Number(4,0) SMALLINT NOT NULL Field Top
    FIELDRIGHT Number(4,0) SMALLINT NOT NULL Field Right
    FIELDBOTTOM Number(4,0) SMALLINT NOT NULL Field Bottom
    EDITLBLLEFT Number(4,0) SMALLINT NOT NULL Edit Label Left
    EDITLBLTOP Number(4,0) SMALLINT NOT NULL Edit Label Top
    EDITLBLRIGHT Number(4,0) SMALLINT NOT NULL Edit Label Right
    EDITLBLBOTTOM Number(4,0) SMALLINT NOT NULL Edit Label Bottom
    DSPLFILL Character(1) VARCHAR2(1) NOT NULL Display Fill Character
    LBLTYPE Number(1,0) SMALLINT NOT NULL Label Type
    0=None
    1=Text
    2=RFT Short
    3=RFT Long
    LBLLOC Number(1,0) SMALLINT NOT NULL Label Location
    LBLPADSIZE Number(5,0) INTEGER NOT NULL Currently Not Used
    LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
    FIELDUSE Number(10,0) DECIMAL(10) NOT NULL Panel Field Use
    OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD

    ONVALUE Character(4) VARCHAR2(4) NOT NULL On Value

    Prompt Table: XLATTABLE_VW

    OFFVALUE Character(4) VARCHAR2(4) NOT NULL Off Value

    Prompt Table: XLATTABLE_VW

    ASSOCFIELDNUM Number(4,0) SMALLINT NOT NULL Associated Field Number
    OCCURSCOUNT1 Number(2,0) SMALLINT NOT NULL Occurs Count First Level
    OCCURSOFFSET1 Number(4,0) SMALLINT NOT NULL Occurs Offset First Level
    OCCURSCOUNT2 Number(2,0) SMALLINT NOT NULL Occurs Count Second Level
    OCCURSOFFSET2 Number(4,0) SMALLINT NOT NULL Occurs Offset Second Level
    OCCURSCOUNT3 Number(2,0) SMALLINT NOT NULL Occurs Count Third Level
    OCCURSOFFSET3 Number(4,0) SMALLINT NOT NULL Occurs Offset Third Level
    HELPCONTEXTNUM Number(10,0) DECIMAL(10) NOT NULL Help Context Number
    SUBPNLNAME Character(18) VARCHAR2(18) NOT NULL SubPanel Name

    Prompt Table: PSPNLDEFN_VW

    SUBPNLVER Number(10,0) DECIMAL(10) NOT NULL SubPanel Version Number
    FIELDSTYLE Character(30) VARCHAR2(30) NOT NULL Field Style Name

    Prompt Table: PSSTYLEDEFN

    LABELSTYLE Character(30) VARCHAR2(30) NOT NULL Label Style Name

    Prompt Table: PSSTYLEDEFN

    FIELDSIZETYPE Number(1,0) SMALLINT NOT NULL Field Size Type
    LABELSIZETYPE Number(1,0) SMALLINT NOT NULL Label Position
    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
    PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

    Prompt Table: PRCSTYPE_VW

    PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

    Prompt Table: PRCSDEFN

    PROMPTFIELD Character(18) VARCHAR2(18) NOT NULL Dropdown Prompt Field
    FORMATFAMILY Character(15) VARCHAR2(15) NOT NULL Format Family Name (see PSFMTDEFN).
    DISPFMTNAME Character(15) VARCHAR2(15) NOT NULL Display Format Name (see PSFMTITEM).
    POPUPMENU Character(30) VARCHAR2(30) NOT NULL Popup Menu
    TREECTRLID Number(3,0) SMALLINT NOT NULL Tree Control ID
    TREECTRLTYPE Number(3,0) SMALLINT NOT NULL Tree Control Type
    MULTIRECTREE Number(3,0) SMALLINT NOT NULL Multi Record Tree
    NODECOUNT Number(3,0) SMALLINT NOT NULL Node Count
    GRDCOLUMNCOUNT Number(3,0) SMALLINT NOT NULL Grid Column Count
    GRDSHOWCOLHDG Number(3,0) SMALLINT NOT NULL Grid Show Column Heading
    GRDSHOWROWHDG Number(3,0) SMALLINT NOT NULL Grid Show Row Heading
    GRDCOLHDGSTYLE Character(30) VARCHAR2(30) NOT NULL Grid Column Heading Style
    GRDODDROWSTYLE Character(30) VARCHAR2(30) NOT NULL Grid Odd Row Style
    GRDEVENROWSTYLE Character(30) VARCHAR2(30) NOT NULL Grid Even Row Style
    GRDLBLMSGSET Number(3,0) SMALLINT NOT NULL Grid Label Message Set
    GRDLBLMSGNUM Number(3,0) SMALLINT NOT NULL Grid Label Message Number
    GRDLBLALIGN Number(3,0) SMALLINT NOT NULL Grid Label Alignment
    GRDACTTYPE Number(3,0) SMALLINT NOT NULL Grid Action Type
    GRDACTRECNAME Character(15) VARCHAR2(15) NOT NULL Grid Action Record Name
    GRDACTFIELDNAME Character(18) VARCHAR2(18) NOT NULL Grid Action Field Name
    GRDACTPNLNAME Character(18) VARCHAR2(18) NOT NULL Grid Action Panel Name
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19