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 |
|---|---|
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 |
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 |
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 |
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 |
Establishes navigation from a collection of timesheet line actual data to the resource that last changed the timesheet line. |
|
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. |