IBM BPM, V8.0.1, All platforms > Reference

Database views for Business Process Choreographer

This reference information describes the columns in the predefined database views.

• ACTIVITY view
  Use this predefined Business Process Choreographer database view for queries on activities.
• ACTIVITY_ATTRIBUTE view
  Use this predefined Business Process Choreographer database view for queries on custom properties for activities.
• ACTIVITY_SERVICE view
  Use this predefined Business Process Choreographer database view for queries on activity services.
• APPLICATION_COMP view
  Use this predefined Business Process Choreographer database view to query the application component ID and default settings for tasks.
• AUDIT_LOG_B view
  Use this predefined Business Process Choreographer database view for queries on audit log information for BPEL processes.
• ESCALATION view
  Use this predefined Business Process Choreographer database view to query data for escalations.
• ESCALATION_CPROP view
  Use this predefined Business Process Choreographer database view to query custom properties for escalations.
• ESCALATION_DESC view
  Use this predefined Business Process Choreographer database view to query multilingual descriptive data for escalations.
• ESC_TEMPL view
  Use this predefined database view to query data for escalation templates.
• ESC_TEMPL_CPROP view
  Use this predefined database view to query custom properties for escalation templates.
• ESC_TEMPL_DESC view
  Use this predefined database view to query multilingual descriptive data for escalation templates.
• MIGRATION_FRONT view
  Use this predefined Business Process Choreographer database view to query where the process instance was in its navigation when it was migrated to the new version of the process template. The migration front represents the activities that were either active or just completed when the migration occurred.
• PROCESS_ATTRIBUTE view
  Use this predefined Business Process Choreographer database view for queries on custom properties for processes.
• PROCESS_INSTANCE view
  Use this predefined Business Process Choreographer database view for queries on process instances.
• PROCESS_TEMPLATE view
  Use this predefined Business Process Choreographer database view for queries on process templates.
• PROCESS_TEMPL_ATTR view
  Use this predefined Business Process Choreographer database view for queries on custom properties for process templates.
• QUERY_PROPERTY view
  Use this predefined Business Process Choreographer database view for queries on process-level variables.
• SHARED_WORK_ITEM view
  Use this predefined Business Process Choreographer database view for queries on shared work items. Only system administrators can query this view.
• TASK_AUDIT_LOG view
  Use this predefined Business Process Choreographer database view for queries on audit log information for human tasks.
• TASK view
  Use this predefined Business Process Choreographer database view for queries on task objects.
• TASK_CPROP view
  Use this predefined Business Process Choreographer database view to query custom properties for task objects.
• TASK_DESC view
  Use this predefined Business Process Choreographer database view to query multilingual descriptive data for task objects.
• TASK_HISTORY view
  Use this predefined Business Process Choreographer database view for queries on the event log for a task.
• TASK_TEMPL view
  This predefined Business Process Choreographer database view holds data that you can use to instantiate tasks.
• TASK_TEMPL_CPROP view
  Use this predefined Business Process Choreographer database view to query custom properties for task templates.
• TASK_TEMPL_DESC view
  Use this predefined Business Process Choreographer database view to query multilingual descriptive data for task template objects.
• WORK_ITEM view
  Use this predefined Business Process Choreographer database view for queries on work items and authorization data for process, tasks, and escalations.