![]() |
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 number(5) NOT NULL,
proc_id number(5) NOT NULL,
proc_used_count number(5) NOT NULL,
proc_name varchar2(8) ,
proc_desc varchar2(24) ,
proc_owner varchar2(24) ,
dir_name varchar2(12) ,
proc_used number(1) NOT NULL,
work_days number(1) NOT NULL,
auto_purge number(1) NOT NULL,
networked number(1) NOT NULL,
cdesc_type number(1) NOT NULL,
ignore_blanks number(1) NOT NULL,
is_predict number(1) NOT NULL,
normalise_data number(1) NOT NULL,
delay_purge number(1) 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:
This key enforces the DELETE CASCADE referential action.
![]() |
Copyright © TIBCO Software Inc. All rights reserved. |