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.