Copyright © Cloud Software Group, Inc. All rights reserved.

proc_deadline

The proc_deadline table stores definitions of procedure deadlines.

Structure

The proc_deadline table has the following structure:

TABLE proc_deadline(
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,
dead_name VARCHAR(32) NOT NULL,
event_name VARCHAR(32) NOT NULL,
dead_value VARCHAR(512) NOT NULL)

Column	Description
node_id	ID of the node that this procedure is defined on, as defined in the nodes table.
proc_id	Unique ID of this procedure, generated from the sequences table.
major_vers	The major version number of the procedure that this case belongs to, as defined in the proc_version table.
minor_vers	The minor version number of the procedure that this case belongs to, as defined in the proc_version table.
pd_version	Instance number of the procedure definition, as defined in the proc_instance table.
dead_name	The name of the case deadline.
event_name	The name of the event step that is triggered when the case deadline expires.
dead_value	The value of the case deadline. The value is specified in one of the following formats: • If the case deadline is specified as a period, then the value is in the format: minutes^hours^days^weeks^months^years • If the case deadline is specified as an expression, then the value is in the format: date expression^time expression

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)
pk_proc_deadline	node_id proc_id pd_version dead_name

Foreign Keys

The following foreign key is defined for this table.

Key Name	Column(s)	Referenced in Table...
fk_proc_deadline1	node_id proc_id pd_version	proc_instance

---

1

This key enforces the DELETE CASCADE referential action.

Indexes

The following index is defined for this table.

Key Name	Column(s) Indexed
idx_proc_dl_fk	node_id pro_id pd_version

Table Activity

The proc_deadline table contains one or more rows for each instance of each procedure definition on the system. Rows are added, updated, and deleted in the following situations.

A row is...	When...
added	The deadlines are created.
updated	The deadlines are updated.
deleted	The deadlines are deleted.

Copyright © Cloud Software Group, Inc. All rights reserved.