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) ,
pi_rpa_start SMALLINT ,
pi_rpa_admin SMALLINT ,
pi_has_eis_objs SMALLINT ,
pi_has_subprocs SMALLINT )
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.
Foreign Keys
The following foreign key is defined for this table.

1
This key enforces the DELETE CASCADE referential action.

Indexes
The following index is defined for this table.
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