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
number(20) NOT NULL,
node_id number(5) NOT NULL,
proc_id number(5) NOT NULL,
casenum number(20) NOT NULL,
field_name varchar2(31) NOT NULL,
field_value varchar2(255) NULL,
field_flags number(5) 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.
Foreign Keys
None.
Indexes
None.
Storage
The following STORAGE values are defined for this table.
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.