Open topic with navigation

TIBCO iProcess® Engine 11.9.1

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

Column | Description
`reqid` | ID of the work item that this field belongs to, as defined in the staffo table.
`node_id` | ID of the node that this field is associated with, as defined in the nodes table.
`proc_id` | Number of the procedure that this field belongs to, as defined in the proc_index table.
`casenum` | Case number that this field belongs to, as defined in the case_information table.
`field_name` | Name of the field, as defined in the case_data table.
`field_value` | Value of the field. Note: A memo field has a value of 1. The associated memo data is stored in the pack_memo table.
`field_flags` | Status of the field. For internal use only.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_pack_data` | `reqid node_id field_name`

## Triggers

None.

## Indexes

None.

## Table Activity

The `pack_data` table contains one record for every assigned field that contains data has a value other than `SW_NA`) in every outstanding step on the system.

Rows are added, updated and deleted in the following situations.

A row is... | When...
added | Either:
| • | a step is sent out.
| • | a field is assigned a value on a keep or release.
updated | An assigned field has its value changed on a keep or release.
deleted | any of the following occur:
| • | a release instruction for a work item is processed by the background process.
| • | a work item is withdrawn.
| • | a case is purged.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine