EOTL_TB_BTNS(SQL Table) | 
Index Back | 
|---|---|
Buttons within a CRM ToolbarRecord to store the buttons used with a specific CRM Toolbar definition | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | TOOLBAR_ID | |
| 2 | Character(1) | VARCHAR2(1) NOT NULL | 
Toolbar Button Type
 P=Primary S=Secondary Default Value: S  | 
|
| 3 | Number(2,0) | SMALLINT NOT NULL | 
Sequence Number
 Default Value: 1  | 
|
| 4 | EOTL_TB_BTN_SEQ | Number(3,0) | SMALLINT NOT NULL | 
EOTL_TB_BTN_SEQ
 Default Value: 10  | 
| 5 | EOTL_TB_BTN_ID | Character(30) | VARCHAR2(30) NOT NULL | 
EOTL_TB_BTN_
 Prompt Table: EOTL_BTN_DEFN  | 
| 6 | EOTL_BTN_TXT_LNK | Character(20) | VARCHAR2(20) NOT NULL | Toolbar Button Text label | 
| 7 | EOTL_TB_LABEL | Character(60) | VARCHAR2(60) NOT NULL | EOTL_TB_LAB | 
| 8 | EOTL_ALT_CONTNAME | Character(30) | VARCHAR2(30) NOT NULL | 
Alternate Conent Name
 Prompt Table: EOTL_TB_IMG_VW  | 
| 9 | EOTL_ALT_CONTNAMED | Character(30) | VARCHAR2(30) NOT NULL | 
Alternate Content / Diabled
 Prompt Table: EOTL_TB_IMG_VW  | 
| 10 | EOTL_ACCESS_KEY | Character(1) | VARCHAR2(1) NOT NULL | Access Key........................ | 
| 11 | 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 Default Value: Y  | 
| 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. |