ASSIGNED_TO_EMAIL

Email address of the user to whom the package is assigned.

ASSIGNED_TO_GROUP_ID

ID of the security group to which the package is assigned.

ASSIGNED_TO_GROUP_NAME

Security group to which the package is assigned.

ASSIGNED_TO_USERNAME

Name of the user to whom the package is assigned.

ASSIGNED_TO_USER_ID

ID of the user to whom the package is assigned.

CREATED_BY

ID of the user who created the package.

CREATED_BY_EMAIL

Email address of the user who created the package.

CREATED_BY_USERNAME

PPM username of the user who created the package.

CREATION_DATE

Date the package was created.

DESCRIPTION

Package description.

ID

Package ID in the table KDLV_PACKAGES.

LAST_UPDATED_BY

ID of the user who last updated the package.

LAST_UPDATED_BY_EMAIL

Email address of the user who last updated the package.

LAST_UPDATED_BY_USERNAME

PPM username of the user who last updated the package.

LAST_UPDATE_DATE

Date the package was last updated.

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.

NOTES

All notes for the package.

NUMBER

Package name/number.

PACKAGE_GROUP_CODE

Package group code.

PACKAGE_GROUP_NAME

Package group name.

PACKAGE_ID

ID of the package in the table KDLV_PACKAGES.

PACKAGE_TYPE

Validation value meaning of the package type.

PACKAGE_TYPE_CODE

Validation value code for the package type.

PACKAGE_URL

URL of the package in the standard interface.

PARENT_REQUEST_ID

ID of the request that created this package (if applicable).

PERCENT_COMPLETE

Percent complete of the package.

PRIORITY

Package priority.

PRIORITY_CODE

Validation value code for the package priority.

PRIORITY_NAME

Validation value meaning of the package priority.

PRIORITY_SEQ

Package priority sequence.

PROJECT_CODE

Validation value code of the work plan to which the package belongs.

PROJECT_NAME

Validation value meaning of the work plan to which the package belongs.

REQUESTED_BY_EMAIL

Email address of the user who requested the package.

REQUESTED_BY_USERNAME

PPM username of the user who requested the package.

REQUESTED_BY_USER_ID

ID of the user who requested the package.

RUN_GROUP

Package run group.

STATUS

Validation value meaning for the package status.

STATUS_CODE

Validation value code for the package status.

SUBMIT_DATE

Date on which the package was submitted.

WORKBENCH_PACKAGE_NO_LINK

Package URL in the PPM Workbench.

WORKBENCH_PACKAGE_URL

Package screen URL in the PPM Workbench.

WORKFLOW_ID

ID of the workflow that the package uses.

WORKFLOW_NAME

Name of the workflow that the package uses.