The pack_memo table stores memo data associated with memo fields in the
pack_data table before upgrading to iProcess Engine 11.6.
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.
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)
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.