EntityType: TimesheetLineActualData (ProjectData service)

In this article
Definition
Parent element
Child elements

Contains the properties that define the reporting data for timesheet line actual data in the ProjectData service.

Example

The following REST query uses the TimesheetLineActualDataSet entity set and the TimesheetLineId and TimeByDay keys to get the LastChangedResourceName property for the specified timesheet line and time range. The query is all on one line.

https://<pwa_url>/_api/ProjectData/TimesheetLineActualDataSet
    ?$filter=TimesheetLineId eq guid'50c173b9-23bb-e111-aa86-00155d4a5608'
    and TimeByDay ge datetime'2012-01-01'
    &$select=LastChangedResourceName

Definition

<EntityType Name="TimesheetLineActualData">
  <Key>
    <PropertyRef Name="AdjustmentIndex" />
    <PropertyRef Name="TimeByDay" />
    <PropertyRef Name="TimesheetLineId" />
  </Key>
  <Property Name="TimesheetLineId" Type="Edm.Guid" Nullable="false" />
  . . .
  <NavigationProperty Name="LastChangedByResource" Relationship="ReportingData.TimesheetLineActualData_LastChangedByResource" ToRole="LastChangedByResource" FromRole="TimesheetLineActualData" />
  . . .
</EntityType>

Parent element

Element	Description
ReportingData	The schema for the reporting data in the ProjectData service.

Child elements

Child elements are properties of timesheet line actual data and navigation properties of that 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 time and timesheet line, that are associated with timesheet line actual data. A navigation property uses an Association element in a query for a related entity collection

The Key elements specify the properties that are the primary keys for a timesheet line actual data query. TimesheetLineId is the GUID of the timesheet line, AdjustmentIndex is adjustment number, and TimeByDay is a day in the timeline.

Property elements

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

Attribute values for the Property elements of TimesheetLineActualData

Name	Type	Nullable	Description
ActualOvertimeWorkBillable	Edm.Decimal	false	The actual billable overtime work that has already been performed.
ActualOvertimeWorkNonBillable	Edm.Decimal	false	The actual nonbillable overtime work that has already been performed.
ActualWorkBillable	Edm.Decimal	false	The actual billable amount of work that has already been performed.
ActualWorkNonBillable	Edm.Decimal	false	The actual nonbillable amount of work that has already been performed.
AdjustmentIndex	Edm.Int32	false	Key The timesheet actual adjustment index.
Comment	Edm.String	true	The text field for a timesheet line comment.
CreatedDate	Edm.DateTime	false	The date and time that the timesheet line was created.
LastChangedResourceName	Edm.String	true	The resource that last changed the timesheet line.
PlannedWork	Edm.Decimal	false	The estimated amount of work.
ResourceName	Edm.String	true	The name of the resource associated with the timesheet line.
TimeByDay	Edm.DateTime	false	Key A primary key that identifies the day along a timeline. The granularity is in days only.
TimeByDay_DayOfMonth	Edm.Byte	false	The value that represents the day of the month (1–31) for time by day calculation.
TimeByDay_DayOfWeek	Edm.Byte	false	The value that represents the day of the week (1–7) for time by day calculation.
TimesheetLineId	Edm.Guid	false	Key The GUID of the timesheet line.

NavigationProperty elements

The following table lists attribute values for the NavigationProperty elements of the TimesheetLineActualData 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 TimesheetLine_Actuals_TimesheetLineActualData_TimesheetLine navigation property, the primary type is TimesheetLine, and the secondary type is TimesheetLineActualData. For this type of navigation, the FromRole is TimesheetLine_Actuals, and the ToRole is TimesheetLineActualData_TimesheetLine.

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 LastChangedBy navigation property relationship, TimesheetLineActualData is the primary entity type and LastChangedByResource is the secondary entity type.

Attribute values for the NavigationProperty elements

Name	Relationship	Description
LastChangedByResource	TimesheetLineActualData_LastChangedByResource	Establishes navigation from a collection of timesheet line actual data to the resource that last changed the timesheet line.
Time	TimesheetLineActualData_Time	Establishes navigation from a collection of timesheet line actual data to time data.
TimesheetLine	TimesheetLine_Actuals_TimesheetLineActualData_TimesheetLine	Establishes navigation from a timesheet line to timesheet line actual data and from timesheet line actual data to a timesheet line.

See also

Reference

TimesheetLineActualDataSet

ReportingData

Concepts

Querying OData feeds for Project 2013 reporting data