![]() |
Copyright © TIBCO Software Inc. All rights reserved. |
The proc_index table holds information that is specific to a procedure (or sub-procedure or sub-procedure parameter template).
TABLE proc_index (
node_id INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
proc_used_count SMALLINT NOT NULL,
proc_name VARCHAR(8) NULL,
proc_desc VARCHAR(24) NULL,
proc_owner VARCHAR(49) NULL,
dir_name VARCHAR(12) NULL,
proc_used SMALLINT NOT NULL,
work_days SMALLINT NOT NULL,
auto_purge SMALLINT NOT NULL,
networked SMALLINT NOT NULL,
cdesc_type SMALLINT NOT NULL,
ignore_blanks SMALLINT NOT NULL,
is_predict SMALLINT NOT NULL,
normalise_data SMALLINT NOT NULL,
delay_purge SMALLINT NOT NULL,
delay_value VARCHAR(512) NULL)
Note: Internal procedures are prefixed with a dollar sign ($) character. Flag that defines whether the procedure uses a 7-day week (0) or a configurable working week (1) in date calculations. Flag that defines whether (1) or not (0) cases of this procedure are automatically purged when they are closed. Flag that defines whether a case description is Required (0), Optional (1) or Hidden (2) when a case of this procedure is started.
• 0 means that the field is treated as an error and the step is delivered to the undelivered queue.
• 1 means that the field is not treated as an error.
• 0 means that the auto-purge operation is not delayed.
• 1 means that the auto-purge operation is delayed. The value of the delay_value column is:
•
• If the value of the delay_purge column is 1, then the value of the delay_value column is specified in one of the following ways:
The following DELETE CASCADE trigger is defined for this table.
![]() |
Copyright © TIBCO Software Inc. All rights reserved. |