Enterprise User
Users
-
Full Name—User's
full name in First +
Last format. -
First Name—User's
first name.
-
Last Name—User's
last name.
-
Email—User's
primary email address.
-
Supervisor—User's
supervisor.
-
Resource Manager—User's
resource manager.
-
Title—User's
title.
-
Organization—User's
organization.
-
Resource Type Name—The
user's resource type (if any).
-
Resource Type Description—The
description of the user's resource type (if any).
-
Phone—User's
phone number.
-
Fax—User's
fax number.
-
Cell—User's
cell phone number.
-
Pager—User's
pager number.
-
NTAccount—NT
account information for the user.
-
Timesheets Required—Whether
or not the user is required to use timesheets. Options are Yes
and No.
-
Report Author License—Whether
or not the user is licensed as a PPM report author. Options are Queriy Studio Author, Report Studio Author and None.
-
User Count—The total
count of users in the report. This also provides subtotals for any groupings
of users you include in the report. This value can change as you add or
remove items that impact the number of users in the report.
Note: User Count counts the unique GUID values for users. This means that if you have 2 users with identical names, User Count will be 2 even though your report shows a single user. -
User Internal Billing Rate—User's
internal billing rate.
-
User Internal Billing Rate Inherited From—Where the
user internal billing rate is inherited from (if applicable).
-
Is Manual Internal Billing Rate—Whether or
not the internal rate is a manual rate. Options are Yes
and No.
-
User External Billing Rate—User's
external billing rate.
-
User External Billing Rate Inherited From—Where the
user external billing rate is inherited from (if applicable).
-
Is Manual External Billing Rate—Whether or
not the external rate is a manual rate. Options are Yes
and No.
-
Status—User's PPM status. Options are Active
and Inactive.
- < any custom user fields >
- Work Schedule
-
Calendar Name—The
name of the calendar to which the user is assigned.
-
Work Schedule Monday—The
number of hours user is scheduled to work on Monday.
-
Work Schedule Tuesday—The
number of hours user is scheduled to work on Tuesday.
-
Work Schedule Wednesday—The
number of hours user is scheduled to work on Wednesday.
-
Work Schedule Thursday—The
number of hours user is scheduled to work on Thursday.
-
Work Schedule Friday—The
number of hours user is scheduled to work on Friday.
-
Work Schedule Saturday—The
number of hours user is scheduled to work on Saturday.
-
Work Schedule Sunday—The
number of hours user is scheduled to work on Sunday.
-
- Nonworking Time Schedule
-
Nonworking Time Name—The
name of the nonworking time (for example, Fourth
of July).
-
Nonworking Time Start Day—The
date the nonworking time begins.
-
Nonworking Time End Day—The
date the nonworking time ends.
-
Nonworking Time Duration—The
length of the nonworking time. This value may be in hours per day, or
All Day.
-
Nonworking Time Type—The
type of nonworking time. Options are Global
or Personal.
-
Nonworking Time Created By—The
creator of the nonworking time.
-
Nonworking Time Created On—The
date the nonworking time was created.
- Nonworking Time Date Groups
Date group query items are useful for reporting trends over time. If you include a date group item and pivot your report on that item, you can see how something is trending over time.
- User Calendar Day—
- User Calendar Week—
- User Calendar Month—
- User Calendar Quarter—
- User Calendar Year—
- Nonworking Time Hours—
-
- Login Information
-
Last Successful Login—The
date and time of the last successful login for the user.
-
Number of Successful Logins—The
number of times the user has successfully logged into PPM.
-
- Additional Address Information
-
Address1—The
first address line for the user.
-
Address2—The
second address line for the user.
-
City—The
address city for the user.
-
State—The
address state for the user.
-
Postal/Zip Code—The
postal/zip code for the user.
-
Country—The
country for the user.
-
Email2—The
secondary email for the user.
-
Phone2—The
secondary phone for the user.
-
- IDs
Note: IDs are included in the data model so you can group on an ID if you have multiple items with the same name. Grouping on the ID can help separate different items with identical names.
-
DirectoryUserID— -
OwnerID—
-
HomeEnterpriseID—
-
PrincipalID—
-
UserLogonInfoID—
-
UserLogonInfo DirectoryUserID—
-
EnterpriseMemberID—
-
RoleID—
-
PreviousRoleID—
-
EnterpriseID—
-
DepartmentID—
-
SupervisorID—
-
ResourceManagerID—
-
InternalBillingRateID—
-
ExternalBillingRateID—
-
WorkweekCalendarID—
-
WorkspaceMemberID—
-
Inherited InternalBillingRateID—
-
Inherited ExternalBillingRateID—
-
- UTC Dates
Note: UTC dates are shown in Coordinated Universal Time format. UTC is also known as Greenwich Meridian Time (GMT).
-
Created On (UTC)—The
date the user was created (added to PPM).
-
Last Successful Login (UTC)—The
date the user last logged into PPM successfully.
-
User Roles
- Name—The
name of the role. For example, Executive
and Project Manager.
For external users, a user role Name of External User displays.
Note: If you include a User Name, this is limited to Enterprise roles. - Description—The
description of the role.
- Project Type—The
project type in which the role is included (valid only for Project Roles).
- IDs
Note: IDs do not display in reports. They are included in the data model so you can group on an ID if you have multiple items with the same name. Grouping on the ID can help separate different items with identical names.
- RoleID—
- EnterpriseID—
- ProfileID—
- WorkspaceTypeID—
Departments
- Department Name—The
name of the department.
- Parent Department Name—The
name of the parent for the department (where applicable).
- IDs
Note: IDs do not display in reports. They are included in the data model so you can group on an ID if you have multiple items with the same name. Grouping on the ID can help separate different items with identical names.
- DepartmentID—
- ParentDepartmentID—
- EnterpriseID—
Workgroups
- Workgroup Name—The
name of the workgroup.
- Workgroup Type—The
workgroup type. Options are Enterprise
Workgroup and Project Workgroup.
- Workgroup Project Name—The
name of the project in which the workgroup exists (only applicable for
Project Workgroups).
- IDs
Note: IDs do not display in reports. They are included in the data model so you can group on an ID if you have multiple items with the same name. Grouping on the ID can help separate different items with identical names.
- EnterpriseID—
- WorkspaceID—
- OwnerID—
- WorkgroupID—
Skills
- Skill Name—The
name of the skill.
- Skill Category—The
category of the skill.
- Skill Description—The
description of the skill.
- IDs
Note: IDs do not display in reports. They are included in the data model so you can group on an ID if you have multiple items with the same name. Grouping on the ID can help separate different items with identical names.
- ParentCategoryID
- OwnerID
- EnterpriseID
- SkillID