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).
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)
The following DELETE CASCADE trigger is defined for this table.
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.