Task Tokens
The prefix for these tokens is TSK.
Tokens |
Description |
---|---|
ACTUAL_DURATION |
Actual task duration. |
ACTUAL_EFFORT |
Actual effort associated with the task. |
ACTUAL_FINISH_DATE |
Actual date the task finished. |
ACTUAL_START_DATE |
Actual date the task started. |
CONFIDENCE_CODE |
Confidence code that the user specified. |
CONFIDENCE_NAME |
Confidence name that the user specified. |
CONSTRAINT_DATE |
Task constraint date. |
CREATED_BY |
User who created the task. |
CREATED_BY_EMAIL |
Email address of the user who created the task. |
CREATED_BY_USERNAME |
Username of the user who created the task. |
CREATION_DATE |
Date the task was created. |
DEPARTMENT_CODE |
Department code value the user specified. |
DEPARTMENT_NAME |
Department name the user specified. |
DESCRIPTION |
TASK description. |
ESTIMATED_REMAINING_DURATION |
Estimated time remaining to complete the task. |
ESTIMATED_REMAINING_EFFORT |
Estimated remaining effort involved in the task. |
ESTIMATED_FINISH_DATE |
Estimated finish date of the task. |
HAS_EXCEPTIONS |
Flag to show whether or not the task has exceptions. |
LAST_UPDATE_DATE |
Date on which the task was last updated. |
LAST_UPDATED_BY |
Last user to update the task. |
LAST_UPDATED_BY_EMAIL |
Email address of the last user to update the task. |
LAST_UPDATED_BY_USERNAME |
Username of the last person to update the task. |
MASTER_PROJECT_NAME |
Name of the master project. |
MOST_RECENT_NOTE_AUTHOR_FULL_NAME |
First and last name of the author of the most recent note. |
MOST_RECENT_NOTE_AUTHOR_USERNAME |
Username of the author of the most recent note. |
MOST_RECENT_NOTE_AUTHORED_DATE |
Date of the most recent note. |
MOST_RECENT_NOTE_TEXT |
Text of the most recent note. |
PARENT_PROJECT_ID |
ID of the parent work plan. |
PARENT_PROJECT_NAME |
Name of the parent work plan. |
PARENT_TASK_ID |
ID of the parent task. |
PERCENT_COMPLETE |
Percentage of the task completed. |
PRIORITY |
Task priority. |
PROJECT_PATH |
Work plan path. Hierarchy of parent work plans that contain this task. |
PROJECT_TEMPLATE |
Name of the project template used to create the work plan that contains the task. |
PROJECT_TYPE_CODE |
Returns TASK for tasks and PROJECT for work plans. |
RESOURCE_ID |
ID of the resource assigned to the task. |
RESOURCE_EMAIL |
Email address of the resource. |
RESOURCE_GROUP_ID |
ID of the resource group assigned to the task. |
RESOURCE_GROUP_NAME |
Name of the resource group assigned to the task. |
RESOURCE_USERNAME |
Username of the resource. |
SCHEDULED_EFFORT |
Scheduled effort involved in the task. |
SCHEDULED_DURATION |
Duration scheduled for the task. |
SCHEDULED_FINISH_DATE |
Finish date scheduled for the task. |
SCHEDULED_START_DATE |
Start date scheduled for the task. |
SCHEDULING_CONSTRAINT |
Scheduling constraint for the task. |
TASK_ID |
The number that uniquely identifies the task (same as TASK_NUMBER). This corresponds to the PROJECT_ID column in table KDRV_PROJECTS. |
TASK_NAME |
Task name. |
TASK_NAME_LINK |
Standard hyperlink to the task in HTML-formatted notifications. |
TASK_NUMBER |
Number that uniquely identifies the task (same as TASK_ID). |
TASK_STATE |
The task state. |
TASK_URL |
URL for the task Detail page. |
WORKBENCH_TASK_URL |
URL to access this task in the PPM Workbench. |
Tasks > Pending Tokens
The prefix for these tokens is TSK.PEND.
Tokens |
Description |
---|---|
ID |
ID of the entity that is blocked by the task. |
NAME |
Name of the entity that is blocked by the task. |
DETAIL |
Detail information for the entity that is blocked by the task as shown in the References field. |
DESCRIPTION |
Description of the entity that is blocked by the task. |
STATUS_ID |
ID of the state or the code of the status of the entity that is being blocked by the task. |
STATUS_NAME |
Name of the status (or state) of the entity that is blocked by the task. |
STATE |
Name of the state of the entity blocked by the task. |
ASSIGNED_TO_USERNAME |
Name of the assigned user (or resource) of the entity blocked by the task. |
ASSIGNED_TO_USER_ID |
Username of the assigned user (or resource) of the entity blocked by the task. |
ASSIGNED_TO_GROUP_NAME |
Name of the assigned group (or resource group) of the entity blocked by the task. |
ASSIGNED_TO_GROUP_ID |
ID of the assigned group (or resource group) of the entity that is being blocked by the task. |
RESOURCE_USERNAME |
Name of the resource associated with the entity that is blocked by the task. |
RESOURCE_ID |
Username of the resource (or assigned user) associated with the entity blocked by the task. |
RESOURCE_GROUP_NAME |
Name of the resource group (or assigned user) associated with the entity blocked by the task. |
RESOURCE_GROUP_ID |
ID of the resource group (or assigned group) associated with the entity blocked by the task. |
PERCENT_COMPLETE |
Current percent complete value associated with the entity blocked by the task. |
ENTITY_TYPE_ID |
ID of the type of entity blocked by the task. |
ENTITY_TYPE_NAME |
Name of the type of entity that is being blocked by the task. |