EOTL_TB_USR_PRS

(SQL Table)
Index Back

User Personalizations for TB

User 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.