The case_data table holds the central copy of the field name and value of each assigned field in each case 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 case_data table has the following structure:
TABLE case_data (
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) ,
field_value_N VARCHAR(255) )
The case_data table contains
n rows for each open case on the system, where
n is the number of fields in the case that have assigned data values. Rows are added, updated and deleted in the following situations.