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 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 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 version of the deployed application