Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# user_values

The `user_values` table holds the values for all attributes defined for all users and groups on the system.

## Structure

The `user_values` table has the following structure:

    TABLE user_values (
    	node_id		number(5)		NOT NULL,
    	user_id		number(6)		NOT NULL,
    	attribute_id	number(5)		NOT NULL,
    	attribute_value	varchar2(24)NULL,
    	user_type	varchar2(1)	NOT NULL)

Column | Description
`node_id` | ID of the node that this attribute is defined on, as defined in the nodes table.
`user_id` | ID of the (user or group) queue that this attribute value is associated with, as defined in the user_names table.
`attribute_id` | ID of the attribute that this attribute value is associated with, as defined in the user_attrib table.
`attribute_value` | Value of this attribute. Note: If an attribute value is longer than 24 characters multiple rows are used to store the value. Each segment of the value is uniquely identified by its `attribute_id` value, as defined in the user_attrib table.
`user_type` | Type of the (user or group) queue that this attribute value is associated with, as defined in the user_names table.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s) | Index Tablespace
`pk_user_values` | `user_id attribute_id user_type node_id` | BIGINDEXSPACE

## Foreign Keys

The following foreign keys are defined for this table.

Key Name1 These keys enforce the DELETE CASCADE referential action. | Column(s) | Referenced in Table...
`fk_user_values1` | `node_id user_id user_type` | user_names
`fk_user_values2` | `attribute_id node_id` | user_attrib

## Indexes

The following indexes are defined for this table.

Index Name | Column(s) Indexed | Tablespace
`idx_user_values_fk1` | `node_id user_id user_type` | BIGINDEXSPACE
`idx_user_values_fk2` | `attribute_id node_id` | BIGINDEXSPACE
`idx_user_values` | `attribute_id` | BIGINDEXSPACE

## Storage

The following STORAGE values are defined for this table.

Value | Definition
Initial | BIGTABLESIZE
Percentage Increase | BIGTABLEPCTINCREASE
Tablespace | BIGTABLESPACE

## Table Activity

The `user_values` table contains one or more rows per assigned attribute per (user or group) queue on the system. If an attribute value’s length is:

| • | 24 characters or less, one row is created for the attribute value.

| • | more than 24 characters, one row is created for each 24 characters of the attribute value.

Rows are added, updated and deleted in the following situations.

A row is... | When...
added | a Move System Information is performed, if the flag_table indicates that the Users data area has been modified. Note: The table is purged and rewritten using the values from the tsys_user_names table.
updated | never.
deleted | a Move System Information is performed, if the flag_table indicates that the Users data area has been modified. Note: The table is purged and rewritten using the values from the tsys_user_names table.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine