Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# 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)

Column | Description
`node_id` | ID of the node that this attribute is defined on, as defined in the nodes table.
`attribute_id` | Unique ID for this attribute.
`attribute_name` | Name of this attribute.
`attribute_type` | Attribute type: Either ASCII (`A`), Numeric (`R`), Date (`D`) or Time (`T`).

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_user_attrib` | `attribute_id node_id`

## Triggers

The following `DELETE CASCADE` trigger is defined for this table.

Trigger Name | Triggered by | Affects Table(s)
`tr_user_attrib` | `DELETE` | user_values

## Indexes

The following indexes are defined for this table.

Index Name | Column(s) Indexed
`idx_user_attrib_fk` | `node_id`
`idx_user_attrib` | `attribute_name`

## Table Activity

The `user_attrib` table contains one or more rows for each iProcess attribute defined on the system. The following action takes place if an attribute’s maximum length is defined as follows:

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

| • | 25 characters or more, one row is created for each 24 characters of the attribute’s maximum length, and a number is appended to the `attribute_name` entry for each row.

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 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