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


Chapter 8 Work Items : pack_data

pack_data
The pack_data table holds the field name and value of every assigned field in every outstanding step on the system.
When a work item is sent out to a queue, field data is copied from the case_data table to the pack_data table. The client uses the field values in the pack_data table to fill out the form correctly. When the form is kept any changed fields are updated in the pack_data table. When a work item is released field data is moved from the pack_data table to the case_data table.
Structure
The pack_data table has the following structure:
TABLE pack_data (
reqid
NUMERIC(20) NOT NULL,
node_id INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
casenum NUMERIC(20) NOT NULL,
field_name VARCHAR(31) NOT NULL,
field_value VARCHAR(255) NULL,
field_flags INTEGER NOT NULL)
Note: A memo field has a value of 1. The associated memo data is stored in the pack_memo table.
Primary Key
The following primary key is defined for this table.
Triggers
None.
Indexes
None.
Table Activity
The pack_data table contains one record for every assigned 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 © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.