Task Planned Work
-
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. - Day—The date of a work entry for the task
- Week—The week of a work entry for the task.
- Month—The month of a work entry for the task
- Year— The year of a work entry for the task
- Quarter— The year and quarter of a work entry for the task
-
Assignee Full Name—The
full name of the task assignee(s). If no assignees, this is Unassigned.
Note: A task may have more than one assignee. -
Task Work Hours—The work hours assigned to a resource, in whole hour increments.
Task Work Hours are planned (assigned) work hours and display in the Resource Utilization application as Scheduled Hours.
-
Planned Labor Cost—The
planned labor cost of the task.
-
Planned Labor Revenue—The
planned labor revenue for the task.
- Task Internal Billing Rate—The
internal billing rate(s) for the task assignee(s).
-
Task Internal Billing Rate Inherited From—Where the
internal rate(s) 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.
- Task External Billing Rate—The
external billing rate(s) for the task assignee(s).
-
Task External Billing Rate Inherited From—Where the
external rate(s) 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.
-
Resource Allocation Units—The
percentage of work allocated to each assignee.
-
Assigned On—The
date on which the task was assigned.
-
Task Assignee Additional Information
-
First Name—The
first name of the assignee.
-
Last Name—The
last name of the assignee.
-
Title—The
title of the assignee.
-
Email—The
email address of the assignee.
-
Phone —The
phone number of the assignee.
-
Organization—The
organization of the assignee.
-
Resource Type Name—The
resource type of the assignee.
-
Resource Type Description—The
description of the assignee's resource type.
-
Department Name—The
department name of the assignee.
-
Parent Department Name—The
name of the parent department for the assignee.
-
Role Name—The
project role of the assignee.
-
Role Description—The
description of the assignee role.
- Address Detail
-
Email2—The
secondary email address of the assignee.
-
Phone2—The
secondary phone for the assignee.
-
Fax—The
address of the assignee.
-
Cell—The
cell phone number of the assignee.
-
Pager—The
pager number for the assignee.
-
Address1—The
address of the assignee.
-
Address2—The
address of the assignee.
-
City—The
city of the assignee.
-
State—The
state of the assignee.
-
Country—The
country of the assignee.
-
Postal/Zip Code—The
postal or zip code of the assignee.
- IDs
Note: IDs are included in the data model so you can join to other queries. Also, grouping on an ID can help separate different items with identical names. -
TaskAssignmentID -
PrincipalID
-
HomeEnterpriseID
-
OwnerID
-
DirectoryUserID
-
WorkweekCalendarID
-
InternalBillingRateID
-
ExternalBillingRateID
-
ResourceManagerID
-
SupervisorID
-
DepartmentID
-
EnterpriseID
-
PreviousRoleID
-
RoleID
-
UserID
-
EnterpriseMemberID
-
Inherited InternalBillingRateID
-
Inherited ExternalBillingRateID
-
UTC Dates
UTC dates are shows in Coordinated Universal Time format. UTC is also known as Greenwich Meridian Time (GMT). -
Assigned On (UTC)—The
date the requirement was created
-
Deprecated
These query items have been moved to the Task Actual Work query subject. - Actual Work Hours—
- Actual Labor Cost—
- Actual Hourly Rate—
- Actual External Hourly Rate—