RB_TB_BUTTON_VW(SQL View) |
Index Back |
---|---|
Toolbar ButtonsButton definition for Toolbar.................. |
SELECT A.TOOLBAR_ID , B.TB_BUTTON_ID , A.ACCESSKEY , A.ALT_CONTNAME , A.ALT_CONTNAME_D , B.CLASS_METHOD , B.CONTNAME , B.CONTNAMEDISABLE , 'N' , 'N' , B.RC_TB_LABEL , A.RC_TB_LABEL , A.TB_BTN_TEXT_LINK , A.RC_TB_BUTTON_SEQ , A.RC_TB_BUTTON_SEQ , B.RC_TB_PT_ACTION , A.SEQUENCE_NBR , C.TB_DISPLAY_OPTION , A.TB_BUTTON_TYPE , 'N' , A.USER_PERSONALIZE FROM %Table(RB_TOOLBAR_BTNS) A , %Table(RB_BUTTON_DEFN) B , %Table(RB_TOOLBAR_DEFN) C WHERE A.TB_BUTTON_ID = B.TB_BUTTON_ID AND A.TOOLBAR_ID=C.TOOLBAR_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TOOLBAR_ID | Character(30) | VARCHAR2(30) NOT NULL | TOOLBAR_ID |
2 | TB_BUTTON_ID | Character(30) | VARCHAR2(30) NOT NULL |
TB_BUTTON_ID
Prompt Table: RB_BUTTON_DEFN |
3 | ACCESSKEY | Character(1) | VARCHAR2(1) NOT NULL | Access Key........................ |
4 | ALT_CONTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Alternate Conent Name
Prompt Table: RC_TB_IMAGE_VW |
5 | ALT_CONTNAME_D | Character(30) | VARCHAR2(30) NOT NULL |
Alternate Content / Diabled
Prompt Table: RC_TB_IMG_D_VW |
6 | 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: RC_TB_IMAGE_VW |
8 | CONTNAMEDISABLE | Character(30) | VARCHAR2(30) NOT NULL |
Content Name Disabled
Prompt Table: RC_TB_IMG_D_VW |
9 | DISABLED | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
Y/N Table Edit |
10 | HIDE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Hide Flag
N=No Y=Yes Y/N Table Edit |
11 | RC_TB_LABEL_1 | Character(60) | VARCHAR2(60) NOT NULL | RC_TB_LABEL |
12 | RC_TB_LABEL_2 | Character(60) | VARCHAR2(60) NOT NULL | RC_TB_LABEL |
13 | TB_BTN_TEXT_LINK | Character(20) | VARCHAR2(20) NOT NULL | Toolbar Button Text label |
14 | RC_TB_BUTTON_SEQ | Number(3,0) | SMALLINT NOT NULL | RC_TB_BUTTON_SEQ |
15 | ORG_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Organization Sequence |
16 | RC_TB_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 | TB_DISPLAY_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Toolbar Button Display Option
B=Icon and Text Label I=Icon Only T=Text Only |
19 | TB_BUTTON_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Toolbar Button Type
P=Primary S=Secondary |
20 | USER_HIDDEN | Character(1) | VARCHAR2(1) NOT NULL | Field used in RB_BUTTON_SBR for hidden user |
21 | USER_PERSONALIZE | 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 |