RB_TOOLBAR_DEFN

(SQL Table)
 Index Back

Toolbar Definition

Primary CRM Toolbar Definition record

  • Related Language Record: RB_TOOLDEFN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TOOLBAR_ID Character(30) VARCHAR2(30) NOT NULL TOOLBAR_ID
    2 RB_TB_WIDTH_CP Number(4,0) SMALLINT NOT NULL Toolbar runtime width for Classic Plus
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 RC_TB_SHOW_MARQUEE Character(1) VARCHAR2(1) NOT NULL Show Marquee
    N=N
    Y=Y

    Y/N Table Edit

    Default Value: N

    5 SHOW_DATE_AND_TIME 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

    6 SHOW_TIMEZONE_SEL 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

    7 RC_TB_MARQUEE_CONT Character(1) VARCHAR2(1) NOT NULL Display Continuous Marquee Message
    N=N
    Y=Y

    Y/N Table Edit

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

    Default Value: Y

    9 RB_TB_TITLE_TEXT Character(100) VARCHAR2(100) NOT NULL Toolbar/Page Title text
    10 RB_PERSONALIZE Character(1) VARCHAR2(1) NOT NULL Allow Toolbar User Personalization
    N=N
    Y=Y

    Default Value: Y

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

    Default Value: C

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

    Default Value: 2

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

    Default Value: P

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

    Default Value: 50

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

    Default Value: 50

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

    Default Value: B

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

    Default Value: Y

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

    Default Value: N

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

    Default Value: N

    20 TRAILING_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

    21 RTLB_WIDTH Number(4,0) SMALLINT NOT NULL Toolbar runtime width

    Default Value: 745

    22 UID20 Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.
    23 DESCRLONG Long Character CLOB Long Description
    24 RC_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Call center Maintenance Owner
    0=PeopleSoft
    1=PeopleSoft / Customer Modified
    2=Customer

    Default Value: 2

    25 SYSD_APPLICATION01 Character(1) VARCHAR2(1) NOT NULL PS CRM Core
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    26 SYSD_APPLICATION02 Character(1) VARCHAR2(1) NOT NULL Financial Services
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    27 SYSD_APPLICATION03 Character(1) VARCHAR2(1) NOT NULL Telecommunications
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    28 SYSD_APPLICATION04 Character(1) VARCHAR2(1) NOT NULL Government
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    29 SYSD_APPLICATION05 Character(1) VARCHAR2(1) NOT NULL Energy
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    30 SYSD_APPLICATION06 Character(1) VARCHAR2(1) NOT NULL Insurance
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    31 SYSD_APPLICATION07 Character(1) VARCHAR2(1) NOT NULL High Technology
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    32 SYSD_APPLICATION08 Character(1) VARCHAR2(1) NOT NULL HR HelpDesk
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    33 SYSD_APPLICATION09 Character(1) VARCHAR2(1) NOT NULL System Data Field for Application 9. Application 9 is used for Wealth Management.
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    34 SYSD_APPLICATION10 Character(1) VARCHAR2(1) NOT NULL Used in Application 10
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    35 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    36 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    37 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    38 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    39 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    40 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time