ACTUAL_DURATION

Actual duration of the work plan.

ACTUAL_EFFORT

Actual effort associated with the work plan.

ACTUAL_FINISH_DATE

Actual finish date of the work plan.

ACTUAL_START_DATE

Actual start date of the work plan.

BUDGET_ID

ID of the budget linked to the work plan.

BUDGET_NAME

Name of the budget linked to the work plan.

CONFIDENCE_CODE

Code of the confidence value specified by the user.

CONFIDENCE_NAME

Name of the confidence value specified by the user.

CREATED_BY

User who created the work plan.

CREATED_BY_EMAIL

Email address of the user who created the work plan.

CREATED_BY_USERNAME

Username of the person who created the work plan.

CREATION_DATE

Creation date of the work plan.

DEPARTMENT_CODE

Code of the department value specified by the user.

DEPARTMENT_NAME

Name of the department value specified by the user.

DESCRIPTION

Description of the work plan.

ESTIMATED_REMAINING_DURATION

Estimated time remaining for the work plan.

ESTIMATED_REMAINING_EFFORT

Estimated remaining effort involved in the work plan.

ESTIMATED_FINISH_DATE

Estimated finish date of the work plan.

LAST_UPDATE_DATE

Date on which the work plan was last updated.

LAST_UPDATED_BY

Last person to update the work plan.

LAST_UPDATED_BY_EMAIL

Email address of the last person to update the project plan.

LAST_UPDATED_BY_USERNAME

Username of the last person to update the work plan.

MASTER_PROJECT_ID

ID of the master project.

MASTER_PROJECT_NAME

Name of the master project.

MOST_RECENT_NOTE_AUTHOR_FULL_NAME

First and last names 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.

MOST_RECENT_NOTE_TYPE

Type of the most recent note (USER or FIELD CHANGE).

MOST_RECENT_USER_NOTE_AUTHOR_FULL_NAME

First and last name of the author of the most recent user note.

MOST_RECENT_USER_NOTE_AUTHOR_USERNAME

Username of the author of the most recent user note.

MOST_RECENT_USER_NOTE_AUTHORED_DATE

Date of the most recent user note.

MOST_RECENT_USER_NOTE_TEXT

Text of the most recent user note.

PARENT_PROJECT_ID

ID of the parent work plan.

PARENT_PROJECT_NAME

Name of the parent work plan.

PERCENT_COMPLETE

Percent of the work plan completed.

PRIORITY

Priority of the work plan.

PROGRAM_ID

Delimited list of program ids of all programs associated with the project.

PROGRAM_MANAGER

Delimited list of manager ids of all programs associated with the project.

PROGRAM_MANAGER_USERNAME

Delimited list of manager usernames of all programs associated with the project.

PROGRAM_NAME

Delimited list of program names of all programs associated with the project.

PROJECT_ID

Number that uniquely identifies the work plan (same as PROJECT_NUMBER) in the table KDRV_PROJECTS.

PROJECT_MANAGER

Manager of the work plan. Use this token to get the project manager information from the project container.

PROJECT_MANAGER_EMAIL

Email address of the project manager.

PROJECT_MANAGER_USERNAME

Username of the project manager.

PROJECT_NAME

Work plan name.

PROJECT_NAME_LINK

Standard hyperlink to the work plan in HTML-formatted notifications.

PROJECT_NUMBER

Number that uniquely identifies the work plan (same as PROJECT_ID).

PROJECT_PATH

Work plan path. This is a hierarchy of parent work plans that contain this work plan.

PROJECT_REQUEST_ID

Request ID for this project. Returns the request_id associated with the project. You can feed this into a request token to get at all the request details.

PROJECT_RESOURCES

Resources for this project.

PROJECT_STAKEHOLDER

Delimited list of user ids of the project stakeholders.

PROJECT_STAKEHOLDER_EMAIL

Delimited list of emails of the project stakeholders.

PROJECT_STAKEHOLDER_USERNAME

DelimIted list of usernames of the project stakeholders.

PROJECT_STATE

Work plan state.

PROJECT_SUMMARY_TASK_OWNERS

Summary task owners for the work plan.

PROJECT_TEMPLATE

Name of the project template used to create the project plan.

PROJECT_TYPE_CODE

Returns TASK for tasks and PROJECT for work plans.

PROJECT_URL

URL for the Project Overview page of the work plan.

REGIONAL_CALENDAR

Name of the regional calendar for the work plan

SCHEDULED_EFFORT

Scheduled effort defined in the work plan.

SCHEDULED_DURATION

Scheduled duration for the work plan.

SCHEDULED_FINISH_DATE

Finish date scheduled for the work plan.

SCHEDULED_START_DATE

Start date scheduled for the work plan.

SUMMARY_CONDITION

Summary condition of the work plan.

WORKBENCH_PROJECT_URL

URL used to access this work plan in the PPM Workbench.