Business Performance Data Warehouse tracking group views

Tracking Group tables are used by the Business Performance Data Warehouse to create views to make the tracked data externally available for both IBM® Business Process Manager and third-party reports. When you query the Business Performance Data Warehouse database, use the tracking group views.

Tracking group views contain the same data as the Tracking Group tables. This data includes a column for each tracked variable and several columns to capture timing and other important task information. The Business Performance Data Warehouse creates a view for each tracking group defined in the Process Designer and gives each view the same name as the corresponding tracking group in the Process Designer. When you use one tracking group in multiple process applications, all data is stored in a single view, with an ID to distinguish each implementation.

The Tracking Group tables in the Business Performance Data Warehouse database differ from the views in that they contain all tracked data, including data for those variables that you might have stopped tracking during the lifetime of your process. Only the views are updated when you make such changes to your tracking requirements.

The following general rules apply to how Business Performance Data Warehouse manages changes to an existing tracking group:

When a tracking group is renamed (in Process Designer), the Tracking Group view is renamed, but the name of the Tracking Group table does not change.
When a tracking group is deleted, the view is deleted and the tracking group in the table is marked as deleted, but the table does not change.
When a new field is added to an existing tracking group, a field of the same name is added to the view whose name matches the name of the tracking group. Additionally, a new column with a unique name that is similar (but not necessarily identical) to the name of the field is added to the table.
When a field is deleted from a tracking group (in Process Designer), the field remains in both the table and the view. If a snapshot that contains particular fields in a tracking group is archived using the Business Performance Data Warehouse command-line tool (perfsvrtool), those fields are removed from the view and marked as deleted. If the snapshot is restored, those fields are added back to the view.
When a field is renamed, both the old name and the new name are present in the view and the table.
When the type of a field (string, number, or date/time) is changed, a new column with a unique name that is similar (but not necessarily identical) to the name of the field in the tracking group is added to the table, and the view is updated to use the new column. The formerly used column does not change. You must manually migrate the data for the modified field to the new column. This is also true for type changes from one version (snapshot) to another.

Note: When you send tracking definitions from IBM Process Designer or as part of snapshot installation on a runtime server, Business Performance Data Warehouse performs a comparison between the updated definitions and the definitions in its tables, and performs the appropriate update action for each change. Unchanged data is not sent again.

Tracking group views include the following columns:

Column	Description
`business data columns`	One column for each variable in the corresponding tracking group. Each column has the same name as the corresponding tracked field.
TRACKING_GROUP_ID	The primary key of the tracking group to which this entry corresponds. This column links to the TRACKINGGROUPS view.
TRACKING_POINT_ID	The primary key of the tracking point to which this entry corresponds. This column links to the TRACKINGPOINTS view.
TASK_ID	The primary key in the Business Performance Data Warehouse of the task to which this entry corresponds. This column links to the TASKS view.
FUNCTIONAL_TASK_ID	The primary key in the Business Performance Data Warehouse of the BPD instance to which this entry corresponds. This column links to the TASKS view.
SNAPSHOT	The snapshot (version) of the process application or toolkit to which this entry corresponds. If no snapshots exist, a Null value is stored in this column.
ACRONYM	The acronym of the process application or toolkit to which this entry corresponds.
TIME_STAMP	The date and time at which the corresponding tracking point was traversed.
TIME_STAMP_DAYS	TIME_STAMP truncated to days.
TIME_STAMP_WEEKS	TIME_STAMP truncated to weeks.
TIME_STAMP_MONTHS	TIME_STAMP truncated to months.
TIME_STAMP_QUARTERS	TIME_STAMP truncated to quarters.
TIME_STAMP_YEARS	TIME_STAMP truncated to years.