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


Chapter 8 Work Items : pack_memo

pack_memo
The pack_memo table stores memo data associated with memo fields in the pack_data table before upgrading to iProcess Engine 11.6.
Since iProcess Engine 11.6, all the new memo data associated with the memo fields is stored in the BLOB(2G) data type in the pack_nmemo table.
11.6 When a work item is sent out to a queue, memo data is copied from the memo table to the pack_memo table. The client uses the memo data in the pack_memo table to fill out the form correctly. When the form is kept any changed memo data is updated in the pack_memo table. When a work item is released memo data is moved from the pack_memo table to the memo table.
Structure
The pack_memo table is structured as follows:
TABLE pack_memo (
reqid
NUMERIC(20) NOT NULL,
node_id INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
casenum NUMERIC(20) NOT NULL,
memo_id INTEGER NOT NULL,
memo_index INTEGER NOT NULL,
memo_size INTEGER NOT NULL,
memo_data BLOB(30K)NOT NULL NOT LOGGED,
array_idx INTEGER NOT NULL)
-1, if the memo is not an array memo field.
Primary Key
The following primary key is defined for this table.
Foreign Keys
None.
Indexes
None.
Table Activity
The pack_memo table contains one or more rows for every assigned memo field that contains data (i.e. that has a value other than SW_NA) in every outstanding step 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.