Share this page

# Task Tokens

The prefix for these tokens is TSK.

Table A-38. Tasks (TSK) tokens
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.

Table A-39. Tasks > Pending (TSK.PEND) tokens
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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: