Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# iap_global

The `iap_global` table holds the fields that have been allocated globally to the specified procedure.

## Structure

The `iap_global` table has the following structure:

    TABLE iap_global(
    	node_id		number(5)			NOT NULL,
    	proc_id		number(5)			NOT NULL,
    	field_name	varchar2(31)			NOT NULL)

Column | Description
`node_id` | ID of the node that this procedure is stored on, as defined in the nodes table.
`proc_id` | Unique ID of this procedure, generated from the sequences table.
`field_name` | The name of the iProcess Engine field for which data is to be sent out with the activity event.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s) | Index Tablespace
`pk_iap_global` | `proc_id node_id field_name` | SMALLINDEXSPACE

## Foreign Keys

The following foreign key is defined for this table.

Key Name | Column(s) | Referenced in Table...
`fk_iap_global` 1 This key enforces the DELETE CASCADE referential action. | `proc_id node_id` | proc_index nodes

## Indexes

The following index is defined for this table.

Index Name | Column(s) Indexed | Tablespace
`idx_iap_global_fk` | `proc_id node_id` | SMALLINDEXSPACE

## Storage

The following STORAGE values are defined for this table.

Value | Definition
Initial | SMALLTABLESIZE
Percentage Increase | MEDIUMTABLEPCTINCREASE
Tablespace | SMALLTABLESPACE

## Table Activity

The `iap_global` table contains one row for each field that has been allocated globally to the specified procedure. Rows are added, updated and deleted in the following situations.

A row is... | When...
added | A new global field has been allocated to the specified procedure.
updated | A global field’s details have been updated.
deleted | Never.

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