Copyright © Cloud Software Group, Inc. All rights reserved.
Copyright © Cloud Software Group, Inc. All rights reserved.


Chapter 12 Users and Work Queues : user_names

user_names
The user_names table holds the names of all iProcess user and group queues registered on the system.
Structure
The user_names table has the following structure:
TABLE user_names (
node_id
INTEGER NOT NULL,
user_id INTEGER NOT NULL,
user_name VARCHAR(64) NOT NULL,
user_type VARCHAR(1) NOT NULL)
Note: Users and groups have separate ID sequences, as defined in the user_type column, so both a user and a group can have the same user_id value.
Queue type: user (U) or group (G).
Primary Key
The following primary key is defined for this table.
Foreign Keys
The following foreign key is defined for this table.

1
This key enforces the DELETE CASCADE referential action.

Indexes
The following indexes are defined for this table.
Table Activity
The user_names table contains one row for each user or group queue defined on the system.
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.