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