EOTL_TB_USR_PRS(SQL Table) |
Index Back |
---|---|
User Personalizations for TBUser Personalizations for Toolbars. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | EOTL_TOOLBAR_ID | Character(30) | VARCHAR2(30) NOT NULL | TOOLBAR_ID |
3 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
4 | EOTL_HIDE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Hide Flag
N=No Y=Yes |
5 | EOTL_TB_BTN_SEQ | Number(3,0) | SMALLINT NOT NULL | EOTL_TB_BTN_SEQ |
6 | 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: I |
7 | EOCF_CREATEDTTM | DateTime(26) | TIMESTAMP | CLAF - Created DateTime |
8 | EOCF_CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
9 | EOCF_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
10 | EOCF_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |