cdm_cases View

A default view is created in the TIBCO BPM Enterprise database that you can use to view TIBCO BPM Enterprise case data in TIBCO Spotfire.

The default view is called cdm_cases. The following table describes the columns available in cdm_cases.

Column Description
case_identifier A unique alphanumeric value identifying this case.
casereference The reference to the case object. The case reference also contains the version. This is updated with every new version of the case object.
unversioned_casereference A unique version number that stays the same throughout the lifecycle of the case object.
type The case type is the fully qualified name of the case class.
version The version of the case model.
state The state of the case.
casedata The data associated with the case.
is_active If the case is still active.
creation_timestamp The date time the case was created.
modification_timestamp The date and time the case was modified.
completed_case_duration The duration of the case.
application_name Name of the application that generated the case.
application_id A unique alphanumeric value identifing the application.
application_version The version of the application.