TASK_TEMPL view: Business Process Choreographer database view

IBM BPM, V8.0.1, All platforms > Reference > Database views for Business Process Choreographer
TASK_TEMPL view

This predefined Business Process Choreographer database view holds data that you can use to instantiate tasks.

Columns in the TASK_TEMPL view.
This table defines the parameters in the TASK_TEMPL view.

Column name Type Comments
TKTID ID The task template ID.
VALID_FROM Timestamp The time when the task template becomes available for instantiation.
APPLIC_DEFAULTS_ID String The ID of the application component that specifies the defaults for the task template.
APPLIC_NAME String The name of the enterprise application to which the task template belongs.
ASSIGNMENT_TYPE Integer Specifies how the work for the task is assigned. Possible values are:

ASSIGNMENT_TYPE_SINGLE

The task is assigned to one person only.

ASSIGNMENT_TYPE_PARALLEL

The task is assigned to several people who work on it simultaneously.

AUTONOMY Integer Specifies the relationship of a task instance to the parent process. Possible values are:

AUTONOMY_PEER (1)

The task instance runs independently of its parent process.

AUTONOMY_CHILD (2)

The execution of the task instance depends on the parent process.

AUTONOMY_NOT_APPLICABLE (3)

The task instance is an inline task and therefore the autonomy attribute is not applicable.

BUSINESS_RELEVANCE Boolean Specifies whether the task template is business relevant. The attribute affects logging to the audit trail. Possible values are:

TRUE

The task is business relevant and it is audited.

FALSE

The task is not business relevant and it is not audited.

CONTAINMENT_CTX_ID ID The containment context for this task template. This attribute determines the lifecycle of the task template. When a containment context is deleted, the task template is also deleted.
CTX_AUTHORIZATION Integer Allows the task owner to access the task context. Possible values are:

AUTH_NONE

No authorization rights for the associated context object.

AUTH_READER

Operations on the associated context object require reader authority, for example, reading the properties of a process instance.

CUSTOM_TEXT1
through
CUSTOM_TEXT8
String Inline custom properties that can be set for a task. The values of these fields can be set in Integration Designer.
DEFINITION_NAME String The name of the task template definition in the Task Execution Language (TEL) file.
DEFINITION_NS String The namespace of the task template definition in the TEL file.
INHERITED_AUTH Integer The kind of authorization that is inherited by a subtask from the parent task. Possible values are:

INHERITED_AUTH_NONE (0)

The authorization roles for the parent tasks are not inherited by the subtask.

INHERITED_AUTH_ADMINISTRATOR (1)

The subtask inherits the administrators of the parent tasks.

INHERITED_AUTH_ALL (3)

The subtask inherits all of the authorization roles that are defined for the parent tasks.

IS_AD_HOC Boolean Indicates whether this task template was created dynamically at run time or when the task was deployed as part of an EAR file.
IS_INLINE Boolean Indicates whether this task template is modeled as a task within a BPEL process.
IS_TIP Boolean Indicates whether the task template was deployed from a Process Center Tip.
KIND Integer The kind of tasks that are derived from this task template. Possible values are:

KIND_HUMAN (101)

States that the task is a collaboration task that is created and processed by a human.

KIND_ORIGINATING (103)

States that the task is an invocation task that supports person-to-computer interactions, which enables people to create, initiate, and start services.

KIND_PARTICIPATING (105)

States that the task is a to-do task that supports computer-to-person interactions, which enable a person to implement a service.

KIND_ADMINISTRATIVE (106)

States that the task is an administration task.

NAME String The name of the task template.
NAMESPACE String The namespace used to categorize the task template.
PRIORITY Integer The priority of the task template.
STATE Integer The state of the task template. Possible values are:

STATE_STARTED (1)

Specifies that the task template is available for creating task instances.

STATE_STOPPED (2)

Specifies that the task template is stopped. Task instances cannot be created from the task template in this state.

SUPPORT_AUTOCLAIM Boolean Indicates whether tasks derived from this task template can be claimed automatically if they are assigned to a single user.
SUPPORT_CLAIM_SUSP Boolean Indicates whether tasks derived from this task template can be claimed if they are suspended.
SUPPORT_DELEGATION Boolean Indicates whether tasks derived from this task template support work delegation using creation, deletion, or transfer of work items.
SUPPORT_FOLLOW_ON Boolean Indicates whether the task template supports the creation of follow-on tasks.
SUPPORT_SUB_TASK Boolean Indicates whether the task template supports the creation of subtasks.
TYPE String The type used to categorize the task template.
WORK_BASKET String The name of the work basket that will contain instances of this template.

Additional columns in the TASK_TEMPL view. This table shows the additional columns that are set for task templates that were deployed using the Process Center.
Column name Type Comments
PROCESS_APP_ACRONYM String The acronym of the process application if the root container is a process application.
PROCESS_APP_NAME String The name of the process application if the root container is a process application.
SNAPSHOT_ID String The snapshot ID of the root container, which can be either a process application or a toolkit.
SNAPSHOT_NAME String The snapshot name of the root container.
TOOLKIT_ACRONYM String The acronym of the toolkit that contains the process if the process is contained in a toolkit.
TOOLKIT_NAME String The name of the toolkit that contains the process if the process is contained in a toolkit.
TOOLKIT_SNAPSHOT_ID String The snapshot ID of the toolkit that contains the task template, if the task template is contained in a toolkit.
TOOLKIT_SNAPSHOT_NAME String The snapshot name of the toolkit that contains the task template, if the task template is contained in a toolkit.
TOP_LEVEL_TOOLKIT_ACRONYM String The acronym of the toolkit if the root container is a toolkit.
TOP_LEVEL_TOOLKIT_NAME String The name of the toolkit if the root container is a toolkit.
TRACK_NAME String The name of the track of the root container.

Database views for Business Process Choreographer

Related information:
Task instances

Column name	Type	Comments
TKTID	ID	The task template ID.
VALID_FROM	Timestamp	The time when the task template becomes available for instantiation.
APPLIC_DEFAULTS_ID	String	The ID of the application component that specifies the defaults for the task template.
APPLIC_NAME	String	The name of the enterprise application to which the task template belongs.
ASSIGNMENT_TYPE	Integer	Specifies how the work for the task is assigned. Possible values are: ASSIGNMENT_TYPE_SINGLE The task is assigned to one person only. ASSIGNMENT_TYPE_PARALLEL The task is assigned to several people who work on it simultaneously.
AUTONOMY	Integer	Specifies the relationship of a task instance to the parent process. Possible values are: AUTONOMY_PEER (1) The task instance runs independently of its parent process. AUTONOMY_CHILD (2) The execution of the task instance depends on the parent process. AUTONOMY_NOT_APPLICABLE (3) The task instance is an inline task and therefore the autonomy attribute is not applicable.
BUSINESS_RELEVANCE	Boolean	Specifies whether the task template is business relevant. The attribute affects logging to the audit trail. Possible values are: TRUE The task is business relevant and it is audited. FALSE The task is not business relevant and it is not audited.
CONTAINMENT_CTX_ID	ID	The containment context for this task template. This attribute determines the lifecycle of the task template. When a containment context is deleted, the task template is also deleted.
CTX_AUTHORIZATION	Integer	Allows the task owner to access the task context. Possible values are: AUTH_NONE No authorization rights for the associated context object. AUTH_READER Operations on the associated context object require reader authority, for example, reading the properties of a process instance.
CUSTOM_TEXT1 through CUSTOM_TEXT8	String	Inline custom properties that can be set for a task. The values of these fields can be set in Integration Designer.
DEFINITION_NAME	String	The name of the task template definition in the Task Execution Language (TEL) file.
DEFINITION_NS	String	The namespace of the task template definition in the TEL file.
INHERITED_AUTH	Integer	The kind of authorization that is inherited by a subtask from the parent task. Possible values are: INHERITED_AUTH_NONE (0) The authorization roles for the parent tasks are not inherited by the subtask. INHERITED_AUTH_ADMINISTRATOR (1) The subtask inherits the administrators of the parent tasks. INHERITED_AUTH_ALL (3) The subtask inherits all of the authorization roles that are defined for the parent tasks.
IS_AD_HOC	Boolean	Indicates whether this task template was created dynamically at run time or when the task was deployed as part of an EAR file.
IS_INLINE	Boolean	Indicates whether this task template is modeled as a task within a BPEL process.
IS_TIP	Boolean	Indicates whether the task template was deployed from a Process Center Tip.
KIND	Integer	The kind of tasks that are derived from this task template. Possible values are: KIND_HUMAN (101) States that the task is a collaboration task that is created and processed by a human. KIND_ORIGINATING (103) States that the task is an invocation task that supports person-to-computer interactions, which enables people to create, initiate, and start services. KIND_PARTICIPATING (105) States that the task is a to-do task that supports computer-to-person interactions, which enable a person to implement a service. KIND_ADMINISTRATIVE (106) States that the task is an administration task.
NAME	String	The name of the task template.
NAMESPACE	String	The namespace used to categorize the task template.
PRIORITY	Integer	The priority of the task template.
STATE	Integer	The state of the task template. Possible values are: STATE_STARTED (1) Specifies that the task template is available for creating task instances. STATE_STOPPED (2) Specifies that the task template is stopped. Task instances cannot be created from the task template in this state.
SUPPORT_AUTOCLAIM	Boolean	Indicates whether tasks derived from this task template can be claimed automatically if they are assigned to a single user.
SUPPORT_CLAIM_SUSP	Boolean	Indicates whether tasks derived from this task template can be claimed if they are suspended.
SUPPORT_DELEGATION	Boolean	Indicates whether tasks derived from this task template support work delegation using creation, deletion, or transfer of work items.
SUPPORT_FOLLOW_ON	Boolean	Indicates whether the task template supports the creation of follow-on tasks.
SUPPORT_SUB_TASK	Boolean	Indicates whether the task template supports the creation of subtasks.
TYPE	String	The type used to categorize the task template.
WORK_BASKET	String	The name of the work basket that will contain instances of this template.

Column name	Type	Comments
PROCESS_APP_ACRONYM	String	The acronym of the process application if the root container is a process application.
PROCESS_APP_NAME	String	The name of the process application if the root container is a process application.
SNAPSHOT_ID	String	The snapshot ID of the root container, which can be either a process application or a toolkit.
SNAPSHOT_NAME	String	The snapshot name of the root container.
TOOLKIT_ACRONYM	String	The acronym of the toolkit that contains the process if the process is contained in a toolkit.
TOOLKIT_NAME	String	The name of the toolkit that contains the process if the process is contained in a toolkit.
TOOLKIT_SNAPSHOT_ID	String	The snapshot ID of the toolkit that contains the task template, if the task template is contained in a toolkit.
TOOLKIT_SNAPSHOT_NAME	String	The snapshot name of the toolkit that contains the task template, if the task template is contained in a toolkit.
TOP_LEVEL_TOOLKIT_ACRONYM	String	The acronym of the toolkit if the root container is a toolkit.
TOP_LEVEL_TOOLKIT_NAME	String	The name of the toolkit if the root container is a toolkit.
TRACK_NAME	String	The name of the track of the root container.