Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Chapter 5 Procedures : proc_index

proc_index
The proc_index table holds information that is specific to a procedure (or sub-procedure or sub-procedure parameter template).
Structure
The proc_index table has the following structure:
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.
Flag that defines whether (1) or not (0) case prediction is enabled for this procedure.
Flag that defines whether (1) or not (0) case data normalization is enabled for this procedure.
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 0, then the value of the delay_value column is NULL.
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:
date expression^time expression
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.
Storage
The following STORAGE values are defined for this table.
Table Activity
The proc_index table contains one row for each procedure defined on the system.
Rows are added, updated and deleted in the following situations.

Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved