The pack_memo table stores memo data associated with memo fields in the
pack_data table before upgrading to iProcess Engine 11.6.
You can migrate case memo data in the pack_memo table to the
pack_nmemo table when upgrading to iProcess Engine 11.6 or migrate them by using the
swutil MIGRATEMEMOS command after the upgrades.
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 number(20) NOT NULL,
node_id number(5) NOT NULL,
proc_id number(5) NOT NULL,
casenum number(20) NOT NULL,
memo_id number(4) NOT NULL,
memo_index number(10) NOT NULL,
memo_size number(10) NOT NULL,
memo_data blobNOT NULL,
array_idx number(6) 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.