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.
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