PSPNLCNTRLDATA

(SQL Table)
Index Back

  • Related Language Record: PSPNLCTLDATALNG
  • Parent record: PSPNLDEFN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Panel Name (see PSPNLDEFN).
    2 PNLFLDID Number(4,0) SMALLINT NOT NULL Page Field ID
    3 PTFINDSTRING Character(1) VARCHAR2(1) NOT NULL Indicator: Use Find String. Values of of enum type: EPDMCHECKSTATE
    4 PTHDGSHOW Character(1) VARCHAR2(1) NOT NULL Show Heading
    5 PTHDGROWACTBTNS Character(1) VARCHAR2(1) NOT NULL Indicator for display use Show Heading Row Action Buttons. Values of of enum type: EPDMCHECKSTATE
    6 PTHDGROWACTALGN Number(3,0) SMALLINT NOT NULL Scroll Area Row Action Buttons alignment setting. Valid values are of enum type: EPDMALIGN
    7 PTHDGNAVBARBTNS Character(1) VARCHAR2(1) NOT NULL Indicator for display use Show Heading Navigation Bar. Values of of enum type: EPDMCHECKSTATE
    8 PTHDGNAVBARALGN Number(3,0) SMALLINT NOT NULL Scroll Area Heading Navigation Bar alignment setting. Valid values are of enum type: EPDMALIGN
    9 PTBAREASTYLENAME Character(30) VARCHAR2(30) NOT NULL Style Sheet Name for Body Area Style. Valid value: Style Sheet.
    10 PTBAREAROWACTALGN Number(3,0) SMALLINT NOT NULL Bdy Area Row Act Align
    11 PTBAREAHIDEROWSEP Character(1) VARCHAR2(1) NOT NULL Indicator for Hide Body Area Row Seperator. Values of of enum type: EPDMCHECKSTATE
    12 PTBAREASHWGRDLINES Character(1) VARCHAR2(1) NOT NULL Bdy Area Show Grid Lines
    13 PTFTGSHOW Character(1) VARCHAR2(1) NOT NULL Indicator for Scroll Area Show Footing. Values of of enum type: EPDMCHECKSTATE
    14 PTFTGSTYLENAME Character(30) VARCHAR2(30) NOT NULL Style Sheet Name for Footing Area Style. Valid value: Style Sheet.
    15 PTFTGSHOWROWACT Character(1) VARCHAR2(1) NOT NULL Indicator for Scroll Area Show Row Action Buttons. Values of of enum type: EPDMCHECKSTATE
    16 PTFTGROWACTALGN Number(3,0) SMALLINT NOT NULL Scroll Area Row Action Buttonsr alignment setting. Valid values are of enum type: EPDMALIGN
    17 PTFTGSHOWNAVBAR Character(1) VARCHAR2(1) NOT NULL Indicator for Scroll Area Show Navigation Bar. Values of of enum type: EPDMCHECKSTATE
    18 PTFTGNAVBARALGN Number(3,0) SMALLINT NOT NULL Scroll Area Footing Navigation Bar alignment setting. Valid values are of enum type: EPDMALIGN
    19 PTSEPSTARTOFFSET Number(5,0) INTEGER NOT NULL Separator Start Offset
    20 PTSEPOCCURSOFFSET Number(5,0) INTEGER NOT NULL Separator Occurs Offset
    21 PTBTNSTARTOFFSET Number(5,0) INTEGER NOT NULL Button Start Offset
    22 PTBTNOCCURSOFFSET Number(5,0) INTEGER NOT NULL Button Occurs Offset
    23 ALLOWMULTIROWINS Number(1,0) SMALLINT NOT NULL Allow Multi-Row Inserts
    24 PTGRDLAYOUT Number(3,0) SMALLINT NOT NULL Indicator for Grid Layout
    25 PTGRDSCROLLBAR Number(3,0) SMALLINT NOT NULL Indicator for Grid Scrollbar

    Default Value: 3

    26 GRIDROWS Number(3,0) SMALLINT NOT NULL Rows shown in Scrollable Grid
    27 PTSMRYDFLTTOTITLE Number(3,0) SMALLINT NOT NULL Indicator for Summary Default to Title
    28 PTSMRYLBLTYPE Number(1,0) SMALLINT NOT NULL Indicator for Summary Label Type
    29 PTSMRYMSGSET Number(3,0) SMALLINT NOT NULL Indicator for Summary Message Set
    30 PTSMRYMSGNUM Number(3,0) SMALLINT NOT NULL Indicator for Summary Message Number
    31 PTSMRYDSPLFORMAT Number(3,0) SMALLINT NOT NULL Indicator for Summary Display Format
    32 PTSUMMARYATTRIBUTE Character(254) VARCHAR2(254) NOT NULL Indicator for Summary Attribute