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