The pack_nmemo table stores memo data associated with memo fields in the
pack_data table after upgrading to iProcess Engine 11.6.
11.6 When a work item is sent out to a queue, memo data is copied from the nmemo table to the
pack_nmemo table. The client uses the memo data in the
pack_nmemo table to fill out the form correctly. When the form is kept any changed memo data is updated in the
pack_nmemo table. When a work item is released memo data is moved from the
pack_nmemo table to the
nmemo table.
The pack_nmemo table is structured as follows:
TABLE pack_nmemo (
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(2G)NOT NULL NOT LOGGED,
array_idx INTEGER NOT NULL)
The pack_nmemo table contains one row for every assigned memo field that contains data (for example, that has a value other than
SW_NA) in every outstanding step on the system.