Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Chapter 12 Users and Work Queues : user_values

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)
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.
Primary Key
The following primary key is defined for this table.
Foreign Keys
The following foreign keys are defined for this table.

1
These keys enforce the DELETE CASCADE referential action.

Indexes
The following indexes are defined for this table.
Storage
The following STORAGE values are defined for this table.
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:
Rows are added, updated and deleted in the following situations.
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.
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.

Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved