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


Chapter 5 Procedures : proc_instance

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).
Structure
The proc_instance table has the following structure:
TABLE proc_instance(
node_id
INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
major_vers SMALLINT NOT NULL,
minor_vers SMALLINT NOT NULL,
pd_version INTEGER NOT NULL,
pi_first_step VARCHAR(8) NULL,
pi_rpa_start SMALLINT NULL,
pi_rpa_admin SMALLINT NULL,
pi_has_eis_objs SMALLINT NULL,
pi_has_subprocs SMALLINT NULL)
Flag that defines whether (1) or not (0) Remote Procedure Access (RPA) case start restrictions are set in the procedure definition.
Flag that defines whether (1) or not (0) Remote Procedure Access (RPA) administration restrictions are set in the procedure definition.
Flag that defines whether (1) or not (0) the procedure definition contains EIS objects.
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.
Triggers
The following DELETE CASCADE trigger is defined for this table.
Indexes
None.
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.

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