Copyright © Cloud Software Group, Inc. All Rights Reserved |
The predict table stores the prediction data for all expected work items currently defined on the system.
•
• 0, if this is a predicted work item in a future sub-case, rather than in a currently outstanding sub-case. ID of the parent procedure associated with this predicted work item, as defined in the proc_index table, if proc_num is a sub-procedure.
• ID of the parent case associated with this predicted work item, as defined in the case_information table, if case_num is a sub-case.
• 0, if this is a predicted work item in a future sub-case, rather than a currently outstanding sub-case, that was itself started from a predicted future sub-case. Expected duration (in seconds) between this predicted work item being delivered to and released from the step_addr queue.Note: The step_durn_usecs column can be combined with this column to provide resolution to a microsecond. Number of microseconds to be added to the value specified in the step_durn_secs column. Date and time that this predicted work item is expected to arrive in the step_addr queue, to the resolution of a second.Note: The step_start_usecs column can be combined with this column to provide resolution to a microsecond. Date and time that this predicted work item is expected to be released from the step_addr queue, to the resolution of a second.Note: The step_end_usecs column can be combined with this column to provide resolution to a microsecond. Value of the CDQP assigned to the field_name field for this predicted work item.
This key enforces the DELETE CASCADE referential action.
By default, the predict and predict_lock tables use the SMALL macro values. If you intend to enable case prediction on your system, TIBCO recommends that you change these tables to use a larger value in line with the level of prediction activity you expect.The predict table contains one or more rows for each predicted work item generated by each step of each case of each procedure that currently has prediction data defined for it.If a predicted work item contains one or more fields that have CDQPs assigned to them, duplicate rows are added for each CDQP. In the first row, the field_name and field_value columns are blank. Each subsequent row contains the field_name and field_value entries for one assigned CDQP. For example, if a predicted work item contains 5 fields that have CDQPs assigned to them, it will have 6 rows in this table.
Note: One row is added for each step in the procedure that can occur on the currently predicted path(s). Note: All rows for a given main case number are deleted for each step in the procedure that can no longer occur on the currently predicted path(s).
Case prediction can be enabled and disabled using the ENABLE_CASE_PREDICTION process attribute. See TIBCO iProcess Engine Administrator's Guide for more information.
Copyright © Cloud Software Group, Inc. All Rights Reserved |