EOTL_TBBTNSS_VW(SQL View) |
Index Back |
---|---|
Toolbar Secondary ButtonsToolbar Secondary 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_BTN_TXT_LNK ,EOTL_TB_LABEL ,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 = 'S' |
# | 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_BTN_TXT_LNK | Character(20) | VARCHAR2(20) NOT NULL | Toolbar Button Text label |
8 | EOTL_TB_LABEL | Character(60) | VARCHAR2(60) NOT NULL | EOTL_TB_LAB |
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. |