Request Tokens

The prefix for these tokens is REQ.

Table A-29. Request (REQ) tokens
Tokens	Description
APPLICATION_CODE	Validation value code for the application to which the request is assigned.
APPLICATION_NAME	Validation value meaning of the application to which the request is assigned.
ASSIGNED_TO_EMAIL	Email address of the user to whom the request is assigned.
ASSIGNED_TO_GROUP_ID	ID of the security group to which the request is assigned.
ASSIGNED_TO_GROUP_NAME	Name of the security group to which the request is assigned.
ASSIGNED_TO_USERNAME	PPM username of the user to whom the request is assigned.
ASSIGNED_TO_NAME	Full name of the assigned user.
ASSIGNED_TO_USER_ID	ID of the user to whom the request is assigned.
COMPANY	Company employing the user who created the request.
COMPANY_NAME	Name of the company employing the user who created the request.
CONTACT_EMAIL	Email address of the contact for the request.
CONTACT_NAME	Full name of the contact for the request.
CONTACT_PHONE_NUMBER	Phone number of the contact for the request.
CREATED_BY	ID of the user who created the request.
CREATED_BY_EMAIL	Email address of the user who created the request.
CREATED_BY_NAME	Full name of the created by user.
CREATED_BY_USERNAME	PPM username of the user who last updated the request.
CREATION_DATE	Date on which the request was created.
DEPARTMENT_CODE	Validation value code of the department for the request.
DEPARTMENT_NAME	Validation value meaning of the department for the request.
DESCRIPTION	Request description.
LAST_UPDATED_BY	ID of the user who last updated the request.
LAST_UPDATED_BY_EMAIL	Email address of the user who last updated the request.
LAST_UPDATED_BY_USERNAME	PPM username of the user who last updated the request.
LAST_UPDATE_DATE	Date on which the request was last updated.
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.
MOST_RECENT_NOTE_TYPE	Type of the most recent note (USER or FIELD CHANGE).
MOST_RECENT_NOTE_CONTEXT	In the case of requests, this is the request status; blank in all other cases.
MOST_RECENT_USER_NOTE_AUTHOR_FULL_NAME	First and last names 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.
MOST_RECENT_USER_NOTE_CONTEXT	Request status.
NOTES	All notes for the request.
PERCENT_COMPLETE	Percent of the request that is completed.
PRIORITY_CODE	Validation value code of the request priority.
PRIORITY_NAME	Validation value meaning of the request priority.
PROJECT_CODE	Validation value code of the work plan to which the request belongs.
PROJECT_NAME	Validation value meaning of the work plan to which the request belongs.
SUBMIT_DATE	Date on which the request was submitted.
REQUEST_GROUP_CODE	Request group code.
REQUEST_GROUP_NAME	Request group name.
REQUEST_ID	ID of the request in the table KCRT_REQUESTS.
REQUEST_ID_LINK	Standard hyperlink to display for the request in HTML-formatted notifications.
REQUEST_SUBTYPE_ID	ID of the sub-type for the request.
REQUEST_SUB_TYPE_NAME	Name of the sub-type for the request.
REQUEST_TYPE_ID	ID of the request type of the request.
REQUEST_TYPE_NAME	Name of the request type.
REQUEST_URL	URL of the request in the standard interface.
STATUS_ID	ID of the request status.
STATUS_NAME	Request status.
WORKBENCH_REQUEST_TYPE_URL	URL of the request type in the PPM Workbench.
WORKBENCH_REQUEST_URL	URL of the request in the PPM Workbench.
WORKFLOW_ID	ID of the workflow that the request uses.
WORKFLOW_NAME	Name of the workflow that the request uses.