RC_PSPNLFIELD

(SQL View)
 Index Back

Panel Field


SELECT PNLNAME , FIELDNUM , PNLFIELDNAME , FIELDTYPE , EDITSIZE , LABEL_ID , LBLTEXT , FIELDUSE , DEFERPROC , OCCURSLEVEL , RECNAME , FIELDNAME , ONVALUE , OFFVALUE , ASSOCFIELDNUM , SUBPNLNAME , SUBPNLVER , FIELDSTYLE , GRDCOLUMNCOUNT , GRDACTTYPE , PBDISPLAYTYPE , SCROLLACTION , TOOLACTION , CONTNAME FROM PSPNLFIELD

  • Related Language Record: RC_PNLFIELD_LVW

  • 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).

    Prompt Table: PSPNLDEFN_VW

    2 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    3 PNLFIELDNAME Character(18) VARCHAR2(18) NOT NULL Panel Field Name
    4 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    5 EDITSIZE Number(5,0) INTEGER NOT NULL Currently Not Used
    6 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    7 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
    8 FIELDUSE Number(10,0) DECIMAL(10) NOT NULL Panel Field Use
    9 DEFERPROC Number(1,0) SMALLINT NOT NULL Deferred Processing mode
    10 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level
    11 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

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

    Prompt Table: PSDBFIELD

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

    Prompt Table: XLATTABLE_VW

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

    Prompt Table: XLATTABLE_VW

    15 ASSOCFIELDNUM Number(4,0) SMALLINT NOT NULL Associated Field Number
    16 SUBPNLNAME Character(18) VARCHAR2(18) NOT NULL SubPanel Name

    Prompt Table: PSPNLDEFN_VW

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

    Prompt Table: PSSTYLEDEFN

    19 GRDCOLUMNCOUNT Number(3,0) SMALLINT NOT NULL Grid Column Count
    20 GRDACTTYPE Number(3,0) SMALLINT NOT NULL Grid Action Type
    21 PBDISPLAYTYPE Number(1,0) SMALLINT NOT NULL Pushbutton display type
    22 SCROLLACTION Number(2,0) SMALLINT NOT NULL Scroll Action
    23 TOOLACTION Number(2,0) SMALLINT NOT NULL Toolbar Action
    24 CONTNAME Character(30) VARCHAR2(30) NOT NULL Content Name