Expand Minimize

EntityType: TimesheetLine (ProjectData service)

Office 2013

Last modified: August 06, 2014

In this article
Definition
Parent element
Child elements

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

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

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

Element

Description

ReportingData

The schema for the reporting data in the ProjectData service.

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
The GUID of the timesheet line.

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

TimesheetLine_Actuals_TimesheetLineActualData_TimesheetLine

Establishes navigation from a collection of timesheet lines to actual data and from actual data to a collection of timesheet lines.

ApproverResource

TimesheetLine_ApproverResource

Establishes navigation from a collection of timesheet lines to the resource that approves the timesheet line.

Timesheet

TimesheetLine_Timesheet_Timesheet_Lines

Establishes navigation from a collection of timesheet lines to a timesheet and from a timesheet to a collection of timesheet lines.

TimesheetClass

TimesheetLine_TimesheetClass

Establishes navigation from a collection of timesheet lines to a timesheet class.

Show:
© 2014 Microsoft