PSPNLDEFN

(SQL Table)
Index Back

Panel Definition

Please remove HELPCONTEXTNUM the next time this record is modified. This will require coding changes that remove it from caching, data structures and SQL statments.

  • Related Language Record: PSPNLDEFNLANG
  • Parent Record Of PSPNLCNTRLDATA PSPNLCTLDATALNG PSPNLFIELD PSPNLFIELDLANG PSPNLHTMLAREA PSPNLHTMLLANG PSPNLTREECTRL PST_PNLFIELDS RC_PNLFIELD_LVW RC_PSPNLFIELD
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Panel Name
    2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    3 PNLTYPE Number(1,0) SMALLINT NOT NULL Panel Type
    4 FIELDCOUNT Number(4,0) SMALLINT NOT NULL Field Count
    5 MAXPNLFLDID Number(4,0) SMALLINT NOT NULL Maximum Page Field ID
    6 GRIDHORZ Number(4,0) SMALLINT NOT NULL Grid - Horizontal
    7 GRIDVERT Number(4,0) SMALLINT NOT NULL Grid - Vertical
    8 HELPCONTEXTNUM Number(10,0) DECIMAL(10) NOT NULL Help Context Number
    9 PANELTOP Number(4,0) SMALLINT NOT NULL Panel Top
    10 PANELLEFT Number(4,0) SMALLINT NOT NULL Panel Left
    11 PANELRIGHT Number(4,0) SMALLINT NOT NULL Panel Right
    12 PANELBOTTOM Number(4,0) SMALLINT NOT NULL Panel Bottom
    13 PNLSTYLE Character(30) VARCHAR2(30) NOT NULL Panel Style Name

    Prompt Table: PSSTYLEDEFN

    14 STYLESHEETNAME Character(30) VARCHAR2(30) NOT NULL Style Sheet Name (see PSSTYLSHEETDEFN).
    15 FFSTYLESHEETNAME Character(30) VARCHAR2(30) NOT NULL Style Sheet Name
    16 PNLUSE Number(5,0) INTEGER NOT NULL Panel Use
    17 DEFERPROC Number(1,0) SMALLINT NOT NULL Deferred Processing mode
    18 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    19 POPUPMENU Character(30) VARCHAR2(30) NOT NULL Popup Menu
    20 LICENSE_CODE Character(64) VARCHAR2(64) NOT NULL License Code
    21 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.
    22 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.
    23 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    24 FFSTYLEDESKTOP Character(100) VARCHAR2(100) NOT NULL Desktop Free Form Style
    25 FFSTYLEPHONE Character(100) VARCHAR2(100) NOT NULL Phone Free Form Style
    26 FFSTYLETABLET Character(100) VARCHAR2(100) NOT NULL Tablet Free Form Style
    27 PNLUSETEMP Number(5,0) INTEGER NOT NULL Panel Use
    28 FFSTYLEMEDIUM Character(100) VARCHAR2(100) NOT NULL Free Form Style for Medium FF
    29 FFSTYLEEXLARGE Character(100) VARCHAR2(100) NOT NULL Free Form Style Extra Large
    30 DESCRLONG Long Character CLOB Long Description