Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Chapter 12 Users and Work Queues : user_attrib

user_attrib
The user_attrib table holds the definitions of all iProcess attributes defined on the system.
Structure
The user_attrib table has the following structure:
TABLE user_attrib (
node_id
INTEGER NOT NULL,
attribute_id INTEGER NOT NULL,
attribute_name VARCHAR(15) NOT NULL,
attribute_type VARCHAR(1) NOT NULL)
Attribute type: Either ASCII (A), Numeric (R), Date (D) or Time (T).
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_attrib table contains one or more rows for each iProcess attribute defined on the system. If an attribute’s maximum length is defined as:
The following example illustrates this:
DESCRIPTION is a system-defined attribute of type ASCII with a maximum length of 24 characters; one row is therefore added to the table.
QSUPERVISORS is a system-defined attribute of type ASCII with a maximum length of 48 characters; two rows are therefore added to the table - QSUPERVISORS_01 and QSUPERVISORS_02, each with a unique attribute_id.
JOBDESC is a user-defined attribute of type ASCII with a maximum length of 60 characters; two rows are therefore added to the table - JOBDESC_01 and JOBDESC_02, each with a unique attribute_id.

 
    node_id     attribute_id     attribute_name     attribute_type
    -------     ------------     --------------     --------------
    1           1                DESCRIPTION        A
    1           2                LANGUAGE           A
    1           3                MENUNAME           A
    1           4                SORTMAIL           A
    1           5                USERFLAGS          A
    1           6                QSUPERVISORS_01    A
    1           7                QSUPERVISORS_02    A
    1           9                JOBDESC_01         A
    1           10               JOBDESC_02         A

 
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 © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.