Conventional Database View of a Case Type

In TIBCO BPM Enterprise, it is not always necessary to create a database view of a case type. A database view named "cdm_cases" already exists for the case manager. This lists the cases for different case types created in the TIBCO BPM Enterprise.

The cdm_cases view has the following columns:

Columns Description
case_identifier an identifier for a given case
casereference reference for the case with version
unversioned_casereference reference for the case without version
type case type for a given case
version version for a given case
state current state for a given case
casedata data associated with the case
is_active whether the case type is active
creation_timestamp time of creation of the case
modification_timestamp time of modification of the case
completed_case_duration total time elapsed from the start of the case to its completion
application_name name or label for the deployed application
application_id unique id for the deployed application
application_version the version of the deployed application