EntityType: TimesheetLine (ProjectData service)
In this article
Definition
Parent element
Child elements
Contains the properties that define the reporting data for a timesheet line in the ProjectData service.
Example
The following REST query uses the TimesheetLines entity set and the TimesheetLineId key to get the LastSavedWork property of the specified timesheet line. The query is all on one line.
https://<pwa_url>/_api/ProjectData/TimesheetLines
?$filter=TimesheetLineId eq guid'129f6ca2-0d00-0000-0985-f4a2bf47ac08'
&$select=LastSavedWork
Definition
<EntityType Name="TimesheetLine">
<Key>
<PropertyRef Name="TimesheetLineId" />
</Key>
<Property Name="TimesheetLineId" Type="Edm.Guid" Nullable="false" />
. . .
<NavigationProperty Name="Actuals" Relationship="ReportingData.TimesheetLine_Actuals_TimesheetLineActualData_TimesheetLine" ToRole="TimesheetLineActualData_TimesheetLine" FromRole="TimesheetLine_Actuals" />
. . .
</EntityType>
Parent element
Element |
Description |
|---|---|
The schema for the reporting data in the ProjectData service. |
Child elements
Child elements are properties of a timesheet line and navigation properties of that timesheet line. 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 timesheet period status and timesheet status, that are associated with a timesheet line. A navigation property uses an Association element in a query for a related entity collection
The Key element specifies the property that is the primary key for a timesheet line query. TimesheetLineId is the timesheet line GUID.
Property elements
The following table lists the Property elements for the TimesheetLine entity. The Name, Type, and Nullable columns contain attribute values for each property.
Attribute values for the Property elements of TimesheetLine
Name |
Type |
Nullable |
Description |
|---|---|---|---|
ActualOvertimeWorkBillable |
Edm.Decimal |
true |
The actual billable overtime work that has already been performed by resources assigned to tasks. |
ActualOvertimeWorkNonBillable |
Edm.Decimal |
true |
The actual non-billable overtime work that has already been performed by resources assigned to tasks. |
ActualWorkBillable |
Edm.Decimal |
true |
The actual billable amount of regular, non-overtime work that has already been performed by resources assigned to tasks. |
ActualWorkNonBillable |
Edm.Decimal |
true |
The actual non-billable amount of regular, non-overtime work that has already been performed by resources assigned to tasks. |
AssignmentId |
Edm.Guid |
false |
The GUID that identifies the assignment that is associated with the timesheet line. |
CreatedDate |
Edm.DateTime |
true |
The date and time that the timesheet line was created. |
LastSavedWork |
Edm.Decimal |
true |
The amount of work last saved, in 1000ths of a minute. |
LCID |
Edm.Int32 |
false |
The locale identifier. |
ModifiedDate |
Edm.DateTime |
true |
The date and time that the timesheet line was modified. |
PeriodEndDate |
Edm.DateTime |
false |
The end date and time for the timesheet line period. |
PeriodStartDate |
Edm.DateTime |
false |
The start date and time for the timesheet line period. |
PlannedWork |
Edm.Decimal |
true |
The estimated amount of work. |
ProjectId |
Edm.Guid |
false |
The GUID that identifies the project that is associated with the timesheet line. |
ProjectName |
Edm.String |
true |
The name of the project that is associated with the timesheet line. |
TaskHierarchy |
Edm.String |
true |
The hierarchical list of tasks for a project. |
TaskId |
Edm.Guid |
false |
The GUID that identifies the task. |
TaskName |
Edm.String |
true |
The name of the task. |
TimesheetApproverResourceId |
Edm.Guid |
true |
The GUID of the resource that approves the timesheet. |
TimesheetApproverResourceName |
Edm.String |
true |
The name of the resource that approves the timesheet. |
TimesheetClassDescription |
Edm.String |
true |
The description of the timesheet class (for example, to describe its purpose as the recording of sick time or vacation time). |
TimesheetClassId |
Edm.Guid |
false |
The GUID that identifies the timesheet class. |
TimesheetClassName |
Edm.String |
true |
The name of the timesheet class. |
TimesheetClassType |
Edm.Byte |
false |
The type of the timesheet class (for example, sick time or vacation time). |
TimesheetId |
Edm.Guid |
false |
The GUID for the timesheet. |
TimesheetLineComment |
Edm.String |
true |
The text comment for the timesheet line. |
TimesheetLineId |
Edm.Guid |
false |
Key |
TimesheetLineStatus |
Edm.String |
true |
The status of the timesheet line. |
TimesheetLineStatusId |
Edm.Byte |
true |
The status GUID for the timesheet line. |
TimesheetName |
Edm.String |
true |
The name of the timesheet. |
TimesheetOwner |
Edm.String |
true |
The timesheet owner. |
TimesheetOwnerId |
Edm.Guid |
false |
The GUID of the timesheet owner. |
TimesheetPeriodId |
Edm.Guid |
false |
The GUID of the timesheet period. |
TimesheetPeriodName |
Edm.String |
true |
The name of the timesheet period. |
TimesheetPeriodStatus |
Edm.String |
true |
The status of the timesheet period. |
TimesheetPeriodStatusId |
Edm.Byte |
false |
The GUID of the timesheet period status. |
TimesheetStatus |
Edm.String |
true |
The status of the timesheet (for example, Acceptable or Approved). |
TimesheetStatusId |
Edm.Byte |
false |
The GUID of the timesheet status. |
NavigationProperty elements
The following table lists attribute values for the NavigationProperty elements of the TimesheetLine 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 Actuals 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 ApproverResource navigation property relationship, TimesheetLine is the primary entity type and ApproverResource is the secondary entity type.
Attribute values for the NavigationProperty elements
Name |
Relationship |
Description |
|---|---|---|
Actuals |
Establishes navigation from a collection of timesheet lines to actual data and from actual data to a collection of timesheet lines. |
|
ApproverResource |
Establishes navigation from a collection of timesheet lines to the resource that approves the timesheet line. |
|
Timesheet |
Establishes navigation from a collection of timesheet lines to a timesheet and from a timesheet to a collection of timesheet lines. |
|
TimesheetClass |
Establishes navigation from a collection of timesheet lines to a timesheet class. |