Copyright © Cloud Software Group, Inc. All Rights Reserved

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 INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
field_name VARCHAR(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)
pk_iap_global	proc_id node_id field_name

Foreign Keys

The following foreign key is defined for this table.

Key Name	Column(s)	Referenced in Table...
fk_iap_global1	proc_id node_id	proc_index nodes

---

1

This key enforces the DELETE CASCADE referential action.

Indexes

The following index is defined for this table.

Index Name	Column(s) Indexed
idx_iap_global_fk	proc_id node_id

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.

Copyright © Cloud Software Group, Inc. All Rights Reserved