Task Tokens

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.

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.