EOTL_TB_DEFN

(SQL Table)
 Index Back

Toolbar Definition

Primary CRM Toolbar Definition record

  • Related Language Record: EOTL_TB_DEFNLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOTL_TOOLBAR_ID Character(30) VARCHAR2(30) NOT NULL TOOLBAR_ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 EOTL_MARQUEE_FLG Character(1) VARCHAR2(1) NOT NULL Show Marquee
    N=N
    Y=Y

    Y/N Table Edit

    Default Value: N

    4 EOTL_DATE_TIME_FLG Character(1) VARCHAR2(1) NOT NULL This field is used as flag to indicate show or hide data and time.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    5 EOTL_TIME_ZONE_FLG Character(1) VARCHAR2(1) NOT NULL This field is a flag field to show or hide Time Zone selection.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    6 EOTL_MARQ_SCRL_FLG Character(1) VARCHAR2(1) NOT NULL Display Continuous Marquee Message
    N=N
    Y=Y

    Y/N Table Edit

    7 EOTL_PG_TITLE_FLG Character(1) VARCHAR2(1) NOT NULL Visibility Control Field for displaying Page/Toolbar title
    N=N
    Y=Y

    Default Value: Y

    8 EOTL_TB_PG_TITLE Character(100) VARCHAR2(100) NOT NULL Toolbar/Page Title text
    9 EOTL_PRSNLZ_FLG Character(1) VARCHAR2(1) NOT NULL Allow Toolbar User Personalization
    N=N
    Y=Y

    Default Value: Y

    10 EOTL_SMRY_LYT_TYP Character(1) VARCHAR2(1) NOT NULL Summary Information Area Layout Type
    C=Column
    R=Row

    Default Value: C

    11 EOTL_SMRY_COLUMNS Character(1) VARCHAR2(1) NOT NULL Number of Columns in the Summary Information Area
    1=1
    2=2

    Default Value: 2

    12 EOTL_SMRY_WDTH_TYP Character(1) VARCHAR2(1) NOT NULL Summary Area Display column width unit
    P=Percentage
    X=Pixel

    Default Value: P

    13 EOTL_COL1_WIDTH Number(3,0) SMALLINT NOT NULL Width of Column 1 in the Summary Information Area

    Default Value: 50

    14 EOTL_COL2_WIDTH Number(3,0) SMALLINT NOT NULL Width of Column 2 in the Summary Information Area

    Default Value: 50

    15 EOTL_BTN_DISPLAY Character(1) VARCHAR2(1) NOT NULL Toolbar Button Display Option
    B=Icon and Text Label
    I=Icon Only
    T=Text Only

    Default Value: B

    16 EOTL_TB_FTR_FLG Character(1) VARCHAR2(1) NOT NULL Visibility Control field to display Toolbar Footer
    N=NO
    Y=YES

    Default Value: Y

    17 EOTL_PT_BTN_FLG Character(1) VARCHAR2(1) NOT NULL Visibility Control for PeopleTools Buttons
    N=NO
    Y=YES

    Default Value: N

    18 EOTL_PT_LINK_FLG Character(1) VARCHAR2(1) NOT NULL Visibility Control for PeopleTools bottom hyperlinks
    N=NO
    Y=YES

    Default Value: N

    19 EOTL_TRAIL_SPACE Character(1) VARCHAR2(1) NOT NULL Check flag field to determine whether to Leave a 8 pixel gap after the toolbar is rendered
    N=NO
    Y=YES

    Default Value: Y

    20 EOTL_TB_WIDTH Number(4,0) SMALLINT NOT NULL Toolbar runtime width

    Default Value: 745

    21 EOTL_TB_WIDTH_CP Number(4,0) SMALLINT NOT NULL Toolbar runtime width for Classic Plus
    22 EOTL_UID20 Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.
    23 DESCRLONG Long Character CLOB Long Description
    24 EOTL_SYSD_FLG Character(1) VARCHAR2(1) NOT NULL System data flag
    N=No
    S=Sample
    Y=Yes

    Default Value: N

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