EntityType: TimesheetLineActualData (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 timesheet line actual data in the ProjectData service.

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

<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>

Element

Description

ReportingData

The schema for the reporting data in the ProjectData service.

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.

Show: