EOTL_TBBTNSP_VW

(SQL View)
 Index Back

Toolbar Primary Buttons

Toolbar Primary button definition View

SELECT EOTL_TOOLBAR_ID ,EOTL_TB_BTN_TYPE , SEQUENCE_NBR , EOTL_TB_BTN_SEQ ,EOTL_TB_BTN_ID ,EOTL_USR_HIDE_FLG ,EOTL_TB_LABEL ,EOTL_BTN_TXT_LNK ,EOTL_ALT_CONTNAME ,EOTL_ALT_CONTNAMED ,EOTL_ACCESS_KEY ,EOTL_SYSD_FLG ,EOCF_CREATEDTTM , EOCF_CREATEOPRID , EOCF_LASTUPDDTTM , EOCF_LASTUPDOPRID FROM PS_EOTL_TB_BTNS WHERE EOTL_TB_BTN_TYPE = 'P'

  • Related Language Record: EOTL_TBBTNSPLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOTL_TOOLBAR_ID Character(30) VARCHAR2(30) NOT NULL TOOLBAR_ID
    2 EOTL_TB_BTN_TYPE Character(1) VARCHAR2(1) NOT NULL Toolbar Button Type
    P=Primary
    S=Secondary
    3 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
    4 EOTL_TB_BTN_SEQ Number(3,0) SMALLINT NOT NULL EOTL_TB_BTN_SEQ
    5 EOTL_TB_BTN_ID Character(30) VARCHAR2(30) NOT NULL EOTL_TB_BTN_

    Prompt Table: EOTL_BTN_DEFN

    6 EOTL_USR_HIDE_FLG Character(1) VARCHAR2(1) NOT NULL Field to determinate if a user can hide a toolbar icon.
    N=N
    Y=Y
    7 EOTL_TB_LABEL Character(60) VARCHAR2(60) NOT NULL EOTL_TB_LAB
    8 EOTL_BTN_TXT_LNK Character(20) VARCHAR2(20) NOT NULL Toolbar Button Text label
    9 EOTL_ALT_CONTNAME Character(30) VARCHAR2(30) NOT NULL Content Name

    Prompt Table: EOTL_TB_IMG_VW

    10 EOTL_ALT_CONTNAMED Character(30) VARCHAR2(30) NOT NULL Content Name Disabled

    Prompt Table: EOTL_TB_IMG_VW

    11 EOTL_ACCESS_KEY Character(1) VARCHAR2(1) NOT NULL Access Key........................
    12 EOTL_SYSD_FLG Character(1) VARCHAR2(1) NOT NULL System data flag
    N=No
    S=Sample
    Y=Yes

    Default Value: N

    13 EOCF_CREATEDTTM DateTime(26) TIMESTAMP CLAF - Created DateTime
    14 EOCF_CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    15 EOCF_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    16 EOCF_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.