PSPNLFIELD

index back

Panel Field


  • Related language record: PSPNLFIELDLANG
  • Parent record: PSPNLDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

    Prompt Table: PSPNLDEFN_VW

    PNLFLDID Number(4,0) SMALLINT NOT NULL Page Field ID
    FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    PNLFIELDNAME Character(18) VARCHAR2(18) NOT NULL Panel Field Name
    FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
    1=Frame
    2=Group Box
    3=Static Image
    4=Edit Box
    5=Drop Down List
    6=Long Edit Box
    7=Check Box
    8=Radio Button
    9=Image
    10=Scroll Bar
    11=Subpage
    12=Push Button/Link - PeopleCode
    13=Push Button/Link - Scroll Action
    14=Push Button/Link - Toolbar Action
    15=Push Button/Link - External Link
    16=Push Button/Link - Internal Link
    17=Push Button/Link - Process
    18=SecPage
    19=Grid
    20=Tree
    21=Push Button/Link - Secondary Page
    22=Horizontal Rule
    24=Tab Separator
    25=HTML Area
    26=Push Button/Link - Prompt Action
    27=Scroll Area
    29=Push Button/Link - Page Anchor
    30=Chart
    31=Push Button/Link - Instant Message Action
    32=Analytic Grid
    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
    USEDEFAULTLABEL Character(1) VARCHAR2(1) NOT NULL Use Default Label
    LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
    FIELDUSE Number(10,0) DECIMAL(10) NOT NULL Panel Field Use
    FIELDUSETMP Number(10,0) DECIMAL(10) NOT NULL Panel Field Use (Temporary)
    DEFERPROC Number(1,0) SMALLINT NOT NULL Deferred Processing mode
    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
    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
    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
    GRDODDROWSTYLE Character(30) VARCHAR2(30) NOT NULL Grid Odd Row Style
    GRDEVENROWSTYLE Character(30) VARCHAR2(30) NOT NULL Grid Even Row Style
    GRDACTIVETABSTYLE Character(30) VARCHAR2(30) NOT NULL Grud Active Tab Style
    GRDINACTIVETABSTYL Character(30) VARCHAR2(30) NOT NULL Grid Inactive Tab Style
    GRDNAVBARSTYLE Character(30) VARCHAR2(30) NOT NULL Grid Nav Bar Style
    GRDLABELSTYLE Character(30) VARCHAR2(30) NOT NULL Grid Label 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
    GRDALLOWCOLSORT Character(1) VARCHAR2(1) NOT NULL Allow Column Sorting
    TABENABLE Number(3,0) SMALLINT NOT NULL Enable Tab Key in ActiveX
    PBDISPLAYTYPE Number(1,0) SMALLINT NOT NULL Pushbutton display type
    OPENNEWWINDOW Number(1,0) SMALLINT NOT NULL Open in New Window
    URLDYNAMIC Number(1,0) SMALLINT NOT NULL Dynamic URL
    URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).
    GOTOPORTALNAME Character(30) VARCHAR2(30) NOT NULL Go to Portal Name
    GOTONODENAME Character(30) VARCHAR2(30) NOT NULL Go to Node Name
    GOTOMENUNAME Character(30) VARCHAR2(30) NOT NULL Go to Menu Name
    GOTOPNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Go to Panel Group Name
    GOTOMKTNAME Character(3) VARCHAR2(3) NOT NULL Go to Market Name
    GOTOPNLNAME Character(18) VARCHAR2(18) NOT NULL Go to Panel Name
    GOTOPNLACTION Number(1,0) SMALLINT NOT NULL Go to Panel Action (Mode)
    SRCHBYPNLDATA Number(1,0) SMALLINT NOT NULL Use Panel Data in Search
    SCROLLACTION Number(2,0) SMALLINT NOT NULL Scroll Action
    TOOLACTION Number(2,0) SMALLINT NOT NULL Toolbar Action
    CONTNAME Character(30) VARCHAR2(30) NOT NULL Content Name
    CONTNAMEOVER Character(30) VARCHAR2(30) NOT NULL Content Name (On Mouse Over)
    CONTNAMEDISABLE Character(30) VARCHAR2(30) NOT NULL Content Name Disabled
    PTLBLIMGCOLLAPSE Character(30) VARCHAR2(30) NOT NULL Label Image for Collapse
    PTLBLIMGEXPAND Character(30) VARCHAR2(30) NOT NULL Label Image for Expand
    PTADJHIDDENFIELDS Character(1) VARCHAR2(1) NOT NULL Adj Layout for Hidden Fields
    PTCOLLAPSEDATAAREA Character(1) VARCHAR2(1) NOT NULL Collapsible Data Area
    PTDFLTVIEWEXPANDED Character(1) VARCHAR2(1) NOT NULL Default View to Expanded
    PTHIDEFIELDS Character(1) VARCHAR2(1) NOT NULL Hide All Flds when Grp Box Hid
    SHOWCOLHIDEROWS Character(1) VARCHAR2(1) NOT NULL Show Column On Hide Rows
    PTLEBEXPANDFIELD Character(1) VARCHAR2(1) NOT NULL LEB Expand Fld when Dspl Only
    SHOWTABCNTLBTN Character(1) VARCHAR2(1) NOT NULL Show Tab Control Button
    SELINDICATORTYPE Number(1,0) SMALLINT NOT NULL Selection Indicator Type
    SECUREINVISIBLE Character(1) VARCHAR2(1) NOT NULL Secure Invisible Field
    ENABLEASANCHOR Character(1) VARCHAR2(1) NOT NULL Enable As Anchor
    URLENCODEDBYAPP Character(1) VARCHAR2(1) NOT NULL URL Encoded by Application
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19