PROCESS_INSTANCE view

Process choreographer provides the following predefined view for queries on process instances. Only the columns that are relevant to V5.0-style processes are documented here.

Column name Type Comments
PTID ID Process template ID.
PIID ID Process instance ID.
NAME String Name of the process instance.
STATE Integer State of the process instance. Possible values:
STATE_READY
STATE_RUNNING
STATE_FINISHED
STATE_COMPENSATING
STATE_FAILED
STATE_TERMINATED
STATE_COMPENSATED
STATE_TERMINATING
STATE_FAILING
CREATED Timestamp The time the process instance is created.
STARTED Timestamp The time the process instance is started.
COMPLETED Timestamp The time the process instance is completed.
PARENT_NAME String The name of the parent process instance.
TOP_LEVEL_NAME String The name of the top-level process instance. This name is the current process instance if there is no top level.
STARTER String Principal ID of the starter.
DESCRIPTION String If the description of the process template contains placeholders, this column contains the description of the process instance with the placeholders resolved.
TEMPLATE_NAME String The name of the associated process template.
TEMPLATE_DESCR String Description of the associated process template.
TEMPLATE_CATEGORY String The category to which the associated process template belongs.





Searchable topic ID:   c6viewfi
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/wfapi/concepts/c6viewfi.html

Library | Support | Terms of Use | Feedback