EOTL_TB_BTN_VW

(SQL View)
 Index Back

Toolbar Buttons

Button definition for Toolbar..................

SELECT A.EOTL_TOOLBAR_ID , B.EOTL_TB_BTN_ID , A.EOTL_ACCESS_KEY , A.EOTL_ALT_CONTNAME , A.EOTL_ALT_CONTNAMED , B.EOTL_CLASS_METHOD , B.CONTNAME , B.CONTNAMEDISABLE , 'N' , 'N' , B.EOTL_TB_LABEL , A.EOTL_TB_LABEL , A.EOTL_BTN_TXT_LNK , A.EOTL_TB_BTN_SEQ , A.EOTL_TB_BTN_SEQ , B.EOTL_PT_ACTION , A.SEQUENCE_NBR , C.EOTL_BTN_DISPLAY , A.EOTL_TB_BTN_TYPE , 'N' , A.EOTL_USR_HIDE_FLG FROM %Table(EOTL_TB_BTNS) A , %Table(EOTL_BTN_DEFN) B , %Table(EOTL_TB_DEFN) C WHERE A.EOTL_TB_BTN_ID = B.EOTL_TB_BTN_ID AND A.EOTL_TOOLBAR_ID=C.EOTL_TOOLBAR_ID

  • Related Language Record: EOTL_TB_BTN_LVW

    • # 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_ID Character(30) VARCHAR2(30) NOT NULL EOTL_TB_BTN_

    Prompt Table: EOTL_BTN_DEFN

    3 EOTL_ACCESS_KEY Character(1) VARCHAR2(1) NOT NULL Access Key........................
    4 EOTL_ALT_CONTNAME Character(30) VARCHAR2(30) NOT NULL Alternate Conent Name

    Prompt Table: EOTL_TB_IMG_VW

    5 EOTL_ALT_CONTNAMED Character(30) VARCHAR2(30) NOT NULL Alternate Content / Diabled

    Prompt Table: EOTL_TB_IMG_VW

    6 EOTL_CLASS_METHOD Character(30) VARCHAR2(30) NOT NULL Field to store the method to be called when a toolbar icon is pressed.
    7 CONTNAME Character(30) VARCHAR2(30) NOT NULL Content Name

    Prompt Table: EOTL_TB_IMG_VW

    8 CONTNAMEDISABLE Character(30) VARCHAR2(30) NOT NULL Content Name Disabled

    Prompt Table: EOTL_TB_IMG_VW

    9 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.
    N=No
    Y=Yes

    Y/N Table Edit

    10 EOTL_HIDE_FLG Character(1) VARCHAR2(1) NOT NULL Hide Flag
    N=No
    Y=Yes

    Y/N Table Edit

    11 EOTL_TB_LABEL_1 Character(60) VARCHAR2(60) NOT NULL EOTL_TB_LAB
    12 EOTL_TB_LABEL_2 Character(60) VARCHAR2(60) NOT NULL EOTL_TB_LAB
    13 EOTL_BTN_TXT_LNK Character(20) VARCHAR2(20) NOT NULL Toolbar Button Text label
    14 EOTL_TB_BTN_SEQ Number(3,0) SMALLINT NOT NULL EOTL_TB_BTN_SEQ
    15 EOTL_ORG_SEQ_NBR Number(3,0) SMALLINT NOT NULL Organization Sequence
    16 EOTL_PT_ACTION Character(4) VARCHAR2(4) NOT NULL Pre-Defined Toolbar Action
    ADD=Add
    CORR=Correction
    CTI=CTI Phone Launch
    NCMP=Next Page In Component
    NLIS=Next in List
    PCMP=Previous Page In Component
    PLIS=Previous in List
    POP=Related Links
    RFSH=Refresh
    RTN=Return to List
    SAVE=Save
    SPLL=Spell Check
    UPAL=Update/Display All
    UPDT=Update/Display
    17 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
    18 EOTL_BTN_DISPLAY Character(1) VARCHAR2(1) NOT NULL Toolbar Button Display Option
    B=Icon and Text Label
    I=Icon Only
    T=Text Only
    19 EOTL_TB_BTN_TYPE Character(1) VARCHAR2(1) NOT NULL Toolbar Button Type
    P=Primary
    S=Secondary
    20 EOTL_USR_HIDDN_FLG Character(1) VARCHAR2(1) NOT NULL Field used in RB_BUTTON_SBR for hidden user
    21 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

    Y/N Table Edit