Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Chapter 8 Work Items : pack_nmemo

pack_nmemo
The pack_nmemo table stores memo data associated with memo fields in the pack_data table after 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 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.
Structure
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)
-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_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.
Rows are added, updated and deleted in the following situations.

Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.