Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# proc_instance

The `proc_instance` table holds information that is specific to an instance of a version of a procedure (or sub-procedure or sub-procedure parameter template).

Note | Data that is specific to a procedure or to a version of a procedure is not held in this table. See the proc_index and proc_version tables instead.

## Structure

The `proc_instance` table has the following structure:

    TABLE proc_instance(
    	node_id		number(5)		NOT NULL,
    	proc_id		number(5)		NOT NULL,
    	major_vers	number(5)		NOT NULL,
    	minor_vers	number(5)		NOT NULL,
    	pd_version	number(7)		NOT NULL,
    	pi_first_step	varchar2(8),
    	pi_rpa_start	number(1),
    	pi_rpa_admin	number(1),
    	pi_has_eis_objs	number(1),
    	pi_has_subprocs	number(1))

Column | Description
`node_id` | ID of the node that this instance is stored on, as defined in the nodes table.
`proc_id` | Procedure number of the procedure associated with this instance, as defined in the proc_index table.
`major_vers` | Major version number of the version associated with this instance, as defined in the proc_version table.
`minor_vers` | Minor version number of the version associated with this instance, as defined in the proc_version table.
`pd_version` | Instance number of this procedure definition.
`pi_first_step` | Start step for this instance of the procedure.
`pi_rpa_start` | Flag that defines whether (`1`) or not (`0`) Remote Procedure Access (RPA) case start restrictions are set in the procedure definition.
`pi_rpa_admin` | Flag that defines whether (`1`) or not (`0`) Remote Procedure Access (RPA) administration restrictions are set in the procedure definition.
`pi_has_eis_objs` | Flag that defines whether (`1`) or not (`0`) the procedure definition contains EIS objects.
`pi_has_subprocs` | Flag that defines whether (`1`) or not (`0`) the procedure definition contains sub-procedure steps or graft steps.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s) | Index Tablespace
`pk_proc_instance` | `node_id proc_id pd_version` | BIGINDEXSPACE

## Foreign Keys

The following foreign key is defined for this table.

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

## Indexes

The following index is defined for this table.

Index Name | Column(s) Indexed | Tablespace
`idx_proc_instance_fk` | `node_id proc_id` | BIGINDEXSPACE

## Storage

The following STORAGE values are defined for this table.

Value | Definition
Initial | BIGTABLESIZE
Percentage Increase | BIGTABLEPCTINCREASE
Tablespace | BIGTABLESPACE

## Table Activity

The `proc_instance` table contains one row for each instance of each procedure (or sub-procedure or sub-procedure parameter template) defined on the system.

Rows are added, updated and deleted in the following situations.

A row is... | When...
added | a new procedure or version is created, or when an existing procedure definition is edited.
updated | never.
deleted | a procedure or version is deleted.

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