User Tokens

The prefix for these tokens is USR.

Table A-41. User (USR) tokens

Tokens

Description

AUTHENTICATION_MODE_CODE

Authentication mode for the user (such as LDAP).

AUTHENTICATION_MODE_NAME

Authentication mode for the user (such as LDAP).

COMPANY

Company that employs the user.

COMPANY_NAME

Name of the company that employs the user.

CREATED_BY

ID of the user who created the user.

CREATED_BY_FULL_NAME

Full name of the "created by" user.

CREATED_BY_USERNAME

PPM username of the user who created the user.

CREATION_DATE

Date on which the user was created.

DEPARTMENT_CODE

Lookup code of the department the user belongs to (lookup type = DEPT).

DEPARTMENT_NAME

Name of the department to which the user belongs.

EMAIL_ADDRESS

Email address of the user.

END_DATE

Date on which the user is made inactive in the application.

FIRST_NAME

First name of the user.

FULL_NAME

Full name of the user.

LAST_NAME

Last name of the user.

LAST_UPDATED_BY

ID of the user who last updated the user.

LAST_UPDATE_BY_FULL_NAME

Full name of the last updated by user.

LAST_UPDATED_BY_USERNAME

PPM username of the user who last updated the user.

LAST_UPDATE_DATE

Date the user was last updated.

LOCATION_CODE

Lookup code of the user's location (lookup type = RSC - Location).

LOCATION_NAME

Name of the user's location.

MANAGER_USERNAME

Username of the user's manager.

MANAGER_USER_ID

ID of the user's manager.

PASSWORD

Password for the user to use to log on to PPM. This value is encrypted.

PASSWORD_EXPIRATION_DATE

Date the password needs to be reset for the user.

PASSWORD_EXPIRATION_DAYS

Number of days until the password must be reset for the user.

PHONE_NUMBER

Phone number of the user.

PRIMARY_ROLE_ID

ID of the primary role associated with the user.

PRIMARY_ROLE_NAME

Name of the primary role associated with the user.

REGION

Region associated with the user.

REGIONAL_CALENDAR

Name of the regional calendar for the user.

RESOURCE_CATEGORY_CODE

Lookup code of resource category (lookup type = RSC - Category) to which the user belongs.

RESOURCE_CATEGORY_NAME

Name of the category to which the user belongs.

RESOURCE_TITLE_CODE

Lookup code of the user's resource title (lookup type = RSC - Resource Title).

RESOURCE_TITLE_NAME

Name of the user's resource title.

START_DATE

Date the user is made active in the application.

USERNAME

Username for the user to use to log on to PPM.

USER_ID

ID of the user in the table KNTA_USERS.

WORKLOAD_CAPACITY

Workload capacity of the user (% of FTE)