KNTA_USER_PROFILES
This table stores profile settings for each user. These profile settings modify the behavior of user interface elements (for example, the screen manager navigation interface).
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
CREATED_BY |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
KNTA_SCREENS_NLS |
SCREEN_ID |
SCREEN_ID |
KNTA_USERS |
USER_ID |
USER_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
USER_PROFILE_ID |
NOT NULL |
NUMBER |
System-generated identifier |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
ENTITY_LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date when a record in the entity was last updated |
USER_ID |
NOT NULL |
NUMBER |
Indicates the user associated with these profile settings |
SCREEN_ID |
NOT NULL |
NUMBER |
Determines which screen is shown first when the user logs on |
SHORTCUT_BAR_FLAG |
NOT NULL |
VARCHAR2(1) |
Determines whether the shortcut bar is shown in the screen manager |
SHORTCUT_BAR_LOC_CODE |
NOT NULL |
VARCHAR2(4) |
Determines the position within the screen manager where the shortcut bar is displayed |
SAVE_WINDOW_BOUNDS_FLAG |
NOT NULL |
VARCHAR2(1) |
Determines whether the size and location of the screen manager window are saved each time the user logs off; if saved, the settings are the default when the user next logs on |
WINDOW_HEIGHT |
NOT NULL |
NUMBER |
Determines the default height of the screen manager window |
WINDOW_WIDTH |
NOT NULL |
NUMBER |
Determines the default width of the screen manager window |
WINDOW_X_LOCATION |
NOT NULL |
NUMBER |
Determines the horizontal position of the screen manager window |
WINDOW_Y_LOCATION |
NOT NULL |
NUMBER |
Determines the vertical position of the screen manager window |
REUSE_INTERNAL_FRAME_FLAG |
NOT NULL |
VARCHAR2(1) |
Determines whether multiple internal frames can be opened within each screen |
SHOW_ALL_WORKFLOW_STEPS_FLAG |
NOT NULL |
VARCHAR2(1) |
Determines whether all workflow steps are shown within workflow status panes |
SHOW_TRAVERSED_STEPS_FLAG |
NOT NULL |
VARCHAR2(1) |
Determines whether steps that have been traversed and are no longer active are shown within workflow status panes |
HIDE_IMMEDIATE_STEPS_FLAG |
NOT NULL |
VARCHAR2(1) |
Determines whether workflow steps based upon immediate executions and conditions are shown within workflow status panes |
SHOW_CHANGE_WARNINGS_FLAG |
NOT NULL |
VARCHAR2(1) |
Determines whether warning messages are displayed when you update a business entity that is used by another entity (for example, when you update a workflow that is used by a change request line) |
HIDE_CANCELLED_CRL_FLAG |
NOT NULL |
VARCHAR2(1) |
Determines whether cancelled package lines are displayed in the Packages screen. |
DEFAULT_BROWSER |
NULLABLE |
VARCHAR2(300) |
Field to store file and path of default browser. May also contain special command line parameters for browser. |
SOURCE_TYPE_CODE |
NULLABLE |
VARCHAR2(30) |
For records that have been updated by an interface or migrator, indicates the type of external update (specific interface or migrator name, and so on) |
SOURCE |
NULLABLE |
VARCHAR2(100) |
For records that have been updated by an interface or migrator, provides additional information about the source of the external update. |
MAX_ROWS_PORTLETS |
NOT NULL |
NUMBER |
Maximum number of results to be displayed on the maximized portlet. |
CURRENCY_DISPLAY_CODE |
NOT NULL |
VARCHAR2(40) |
Controls whether currency display is in local or base in portlets |
PREVENT_USAGE_MONITORING | NULLABLE | VARCHAR2(1) | Whether PPM Usage Monitoring is prohibited for the user. |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KNTA_USER_PROFILES_U1 |
UNIQUE |
1 |
USER_PROFILE_ID |
KNTA_USER_PROFILES_U2 |
UNIQUE |
1 |
USER_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
KNTA_USER_PROFILES_S |
USER_PROFILE_ID |