EntityType: AssignmentTimephasedData (ProjectData service)

Office 2013 and later

Last modified: March 09, 2015

In this article
Definition
Parent element
Child elements

Contains the properties that define the reporting data for assignment timephased data in the ProjectData service.

The following REST query uses the AssignmentTimephasedDataSet entity set and the ProjectId and TimeByDay keys to get the specified collection of assignment timephased data in ProjectData. The query is all on one line.

http://<pwa_url>/_api/ProjectData/AssignmentTimephasedDataSet
    ?$filter=ProjectId eq guid'3a9acc04-3ce6-e111-9724-00155d344f1a'
    and TimeByDay gt datetime'2012-01-01'

<EntityType Name="AssignmentTimephasedData">
  <Key>
    <PropertyRef Name="ProjectId" />
    <PropertyRef Name="AssignmentId" />
    <PropertyRef Name="TimeByDay" />
  </Key>
  <Property Name="ProjectId" Type="Edm.Guid" Nullable="false" />
  . . .
  <NavigationProperty Name="Assignment" Relationship="ReportingData.AssignmentTimephasedData_Assignment_Assignment_TimephasedData" ToRole="Assignment_TimephasedData" FromRole="AssignmentTimephasedData_Assignment" />
  . . .
</EntityType>

Element

Description

ReportingData

The schema for the reporting data in the ProjectData service.

Child elements are properties of assignment timephased data and navigation properties of that assignment timephased data. Attributes of the Property elements specify the property name and type, and whether the property can be a null value. The NavigationProperty elements specify collections of entities, such as tasks and assignments, that are associated with assignment timephased data. A navigation property uses an Association element in a query for a related entity or collection.

The Key elements specify the properties that are the primary keys for a query for assignment timephased data. ProjectId is the project GUID, AssignmentId is the GUID for the assignment, and TimeByDay is a day in the timeline.

Property elements

The following table lists the values of the Property elements for the AssignmentTimephasedData entity. The Name, Type, and Nullable columns contain attribute values for each property.

Attribute values for the Property elements of AssignmentTimephasedData

Name

Type

Nullable

Description

AssignmentActualCost

Edm.Decimal

true

The costs incurred for work that has already been performed on an assignment, along with any other associated costs.

AssignmentActualOvertimeCost

Edm.Decimal

true

The costs incurred for overtime work that has already been performed on an assignment.

AssignmentActualOvertimeWork

Edm.Decimal

true

The actual amount of overtime work that has already been performed on an assignment.

AssignmentActualRegularCost

Edm.Decimal

false

The cost of the nonovertime work that has already been performed on an assignment.

AssignmentActualRegularWork

Edm.Decimal

false

The actual amount of regular, nonovertime work that has already been performed on an assignment.

AssignmentActualWork

Edm.Decimal

true

The amount of work that has already been performed on an assignment.

AssignmentBudgetCost

Edm.Decimal

false

The total projected cost of an assignment.

AssignmentBudgetMaterialWork

Edm.Decimal

false

The total projected amount of use on the assignment of material resources.

AssignmentBudgetWork

Edm.Decimal

false

The total projected amount of work that is planned for an assignment.

AssignmentCombinedWork

Edm.Decimal

false

The work for the assignment, from both the project plan and the resource plan.

AssignmentCost

Edm.Int32

true

The total cost for an assignment, based on costs already incurred, in addition to costs that are planned for the remaining work.

AssignmentCumulativeActualWork

Edm.Decimal

false

The summation of the work that has already been performed on an assignment.

AssignmentCumulativeCost

Edm.Decimal

false

The summation of the cost of an assignment.

AssignmentCumulativeWork

Edm.Decimal

false

The summation of the amount of time, such as person-hours or days, that has accumulated on an assignment.

AssignmentId

Edm.Guid

false

Key
The GUID that identifies the assignment.

AssignmentMaterialActualWork

Edm.DateTime

true

The actual amount of work that has already been performed with the use of a material resource, usually expressed as a percentage of the scheduled amount of material resource work.

AssignmentMaterialWork

Edm.Decimal

true

The total work time scheduled for a material resource.

AssignmentOvertimeCost

Edm.Decimal

true

The total overtime cost for an assignment, including costs for overtime work that has already been performed, in addition to remaining overtime costs.

AssignmentOvertimeWork

Edm.Decimal

true

The total overtime work for an assignment, including overtime work that has already been performed, in addition to remaining overtime work.

AssignmentRegularCost

Edm.Decimal

false

The total cost for regular, nonovertime assignment work that has already been performed, in addition to remaining nonovertime work.

AssignmentRegularWork

Edm.Decimal

false

The total nonovertime work for an assignment (including regular, nonovertime work that has already been performed), in addition to remaining regular, nonovertime work.

AssignmentRemainingCost

Edm.Decimal

false

The scheduled expense that will be incurred in completing the remaining work on the assignment.

AssignmentRemainingCumulativeActualWork

Edm.Decimal

false

The cumulative total amount of remaining scheduled work.

AssignmentRemainingCumulativeWork

Edm.Decimal

false

The cumulative total amount of remaining work.

AssignmentRemainingOvertimeCost

Edm.Decimal

false

The remaining overtime expense for an assignment.

AssignmentRemainingOvertimeWork

Edm.Decimal

false

The remaining overtime work for an assignment.

AssignmentRemainingRegularCost

Edm.Decimal

false

The expense that will be incurred by completing the remaining regular, nonovertime work for an assignment.

AssignmentRemainingRegularWork

Edm.Decimal

false

The amount of time, such as person-hours or days, that is still required to complete the regular, nonovertime work for an assignment.

AssignmentRemainingWork

Edm.Decimal

false

The amount of time, such as person-hours or days, that is still required to complete both regular and overtime work for an assignment.

AssignmentResourcePlanWork

Edm.Decimal

false

The total time that is scheduled for an assignment in the resource plan.

AssignmentWork

Edm.Decimal

true

The total amount of time, such as person-hours or days, that is scheduled for an assignment.

ProjectId

Edm.Guid

false

Key
The GUID that identifies the project for the assignment timephased data.

ProjectName

Edm.String

true

The name of a project.

ResourceId

Edm.Guid

false

The GUID that identifies the resource for the assignment timephased data.

TaskId

Edm.Guid

false

The GUID that identifies the task for the assignment timephased data.

TaskIsActive

Edm.Boolean

false

True if the task for the assignment timephased data is active.

TaskName

Edm.String

true

The name of a task.

TimeByDay

Edm.DateTime

false

Key
A primary key that identifies a day along a timeline. The granularity is in days only.

NavigationProperty elements

The following table lists attribute values for the NavigationProperty elements of the AssignmentTimephasedData entity. The Name and Relationship columns contain attribute values for each navigation property.There are two types of Relationship attributes. One type contains two pairs of names; each pair of names indicates a navigation direction. The first pair starts with the entity type that has the primary, or starting, role in the navigation. The second pair starts with the entity type that has the secondary, or dependent, role in the navigation. For example, for the Assignment navigation property, the primary type is AssignmentTimephasedData, and the secondary type is Assignment. For this type of navigation, the FromRole is AssignmentTimephasedData_Assignment, and the ToRole is Assignment_TimephasedData.

The other type of Relationship attribute contains a single pair of names. The first name in the pair is the primary entity type in the navigation. The second name in the pair is the secondary entity type in the navigation. For example, in the Project navigation property relationship, AssignmentBaselineTimephasedData is the primary entity type and Project is the secondary entity type.

Attribute values for the NavigationProperty elements

Name

Relationship

Description

Assignment

AssignmentTimephasedData_Assignment_Assignment_TimephasedData

Establishes navigation from a collection of assignment timephased data to an assignment and from an assignment to a timephased data entity.

Project

AssignmentTimephasedData_Project

Establishes navigation from a collection of assignment timephased data to a project.

Task

AssignmentTimephasedData_Task

Establishes navigation from a collection of assignment timephased data to a task.

Show: