Office
Sign in

Project Online and Project Server export data definitions

This technical reference article describes the data objects and properties contained in the output files you receive when using the user data export method described in Export user data from Project Online and in Export user data from Project Server . This article will include short descriptions of the objects and properties you will find in the output data.

We can group the user data output your receive from both Project Online and Project Server into the following:

Project lists

You will receive three lists of projects contained in the Project Draft, Published, and Reporting schemas. All the projects in the lists were projects the user was a part of. This means the user was involved in the project as at least one of the following:

  • Was the project owner.

  • Has a task assigned to him or her in the project.

  • Is an assignment owner of a task in the project.

  • Is the status manager of a task in the project.

This data includes:

Description

List of projects from the Draft schema that corresponds to the conditions above.

List of projects from the Published schema that corresponds to the conditions above.

List of projects from the Reporting schema that corresponds to the conditions above.

The list of projects may differ slightly for each of the three files. For example, a user can save the project and not publish, meaning that it will appear in the Draft projects list, but not the Published or Reporting projects lists.

A project admin can use the Project list files to give them information about which project-specific export files they may be interested in analyzing to decide how much of the exported content should be shared with the user.

All three of the ProjectList files will have the following properties for each project listed:

Property

Description

SiteId

The unique identifier for the PWA site in which the project exists.

Proj_UID

The unique identifier for the project.

Proj_Name

Name of the project.

Feature-specific data

The export method defined in Export user data from Project Online creates the following feature-related .json files that checks for a specific user's data in features used in Project Online. If no data is found for the user in that feature, the corresponding .json file will be empty.

The export method defined in Export user data from Project Server queries for feature-related data through SQL scripts run against the Project Server databases.

The feature areas for both Project Online and Project Server include the following. Click on the feature name in the table to see brief definitions of the objects and properties you may see in the data you export data you receive about the user.

Name

Description

AdminAudit

Project Web App server settings change data.

BusinessDrivers

Portfolio analysis business drivers data.

PortfolioAnalysis

Portfolio analyses data.

Calendars

Enterprise calendar data.

CustomFields

Custom field data.

Delegations

Delegation data.

DriverPrioritizations

Business driver prioritizations data.

Engagements

Resource engagement data.

LookupTables

Lookup table data.

PortfolioAnalysis

Portfolio analyses data.

QueueJobs

Data about user jobs process through the Queue Service.

ReminderEmails

Reminder email data.

ReportingResource

Resource reporting data.

ReportingResourcePlan

Resource plan reporting data.

Resource

Resource data.

ResourcePlans

Resource plan data.

Rules

Rules data.

Security

Data about security groups, categories, and permissions.

StatusReports

Status report data.

SubscribedReminders

Subscribed reminders data.

TaskStatusing_AssignmentsHistory

Statusing assignments history data.

TaskStatusing_AssignmentsSaved

Statusing assignments save data.

TaskStatusing_AssignmentsSubmitted

Statusing assignments submit data.

Timesheets

Data about timesheets.

Timesheets_Reporting

Reporting data about timesheets.

UnsubscribedAlerts

Unsubscribed alerts data.

UserViewSettings

User view settings data.

Workflow

Project workflow data.

WorkspaceItems

Data about SharePoint items from project sites.

AdminAudit

AdminAudit contains data about Project Web App server settings that the user changed. Each AdminAuditData object will have the following properties:

Property

Description

SiteId

Unique identifier for the PWA site.

ServerSettingName

Name of the PWA server setting.

SettingOldValue

Previous value for the setting.

SettingNewValue

New value for the setting.

ChangedDate

Time and date the setting was changed.

ResourceUid

Unique identifier for the resource that made the setting change.

ResourceName

Name for the resource that made the setting change.

BusinessDrivers

BusinessDrivers contains data about Portfolio Analysis business drivers that the user created or modified. Each Drivers object will have the following properties:

Property

Description

DriverID

Unique identifier of the business driver.

DriverDescription

Description of the business driver.

BusinessDriverIsActive

Is the business driver active (true/false).

CreatedByResourceID

Unique identifier of the resource that created the driver.

CreatedByResourceName

Display name of the resource that created the driver.

ModifiedByResourceID

Unique identifier of the resource that modified the driver.

ModifiedByResourceName

Display name of the resource that modified the driver.

ImpactDescriptionNone

Description of what is considered to be no impact for the driver.

ImpactDescriptionLow

Description of what is considered to be low impact for the driver.

ImpactDescriptionModerate

Description of what is considered to be moderate impact for the driver.

ImpactDescriptionStrong

Description of what is considered to be strong impact for the driver.

ImpactDescriptionExtreme

Description of what is considered to be extreme impact for the driver.

CreatedDate

Date and timestamp of when the driver was created.

ModifiedDate

Date and timestamp of when the driver was last modified.

Each Drivers object can have Department objects, which have the following properties.

Property

Description

DriverId

Unique identifier for the business driver.

DepartmentId

Unique identifier for the department.

DepartmentName

Name of the department.

Calendars

Calendars contains data about enterprise calendars that are currently checked out by the user. Each CalendarData object will have the following properties:

Property

Description

Id

Unique identifier for the calendar.

Name

Name of the calendar.

CheckedOutDate

Date and time the calendar was checked out.

CustomFields

CustomFields contains data about custom fields that are currently checked out by the user. Each CustomFieldData object will have the following properties:

Property

Description

ID

Unique identifier for the custom field.

Name

Name of the custom field.

CheckOutDate

Time and date the custom field was last checked out.

Delegations

Delegations contains data about delegations that the user is involved in. The user can either be the delegate or the person who requests for the delegation. Each DelegationData object will have the following properties:

Property

Description

Id

Unique identifier for the delegation.

ResourceId

Unique identifier for the resource that requested the delegation.

ResourceName

Name of the resource that requested the delegation.

DelegateResourceId

Unique identifier for the delegate.

DelegateName

Name of the delegate.

StartDate

Start date for the delegation period.

FinishDate

End date for the delegation period.

DriverPrioritizations

DriverPrioritizations contains data about business driver prioritizations that the user created or modified. Each Prioritizations object may have the following properties:

Property

Description

PrioritizationId

Unique identifier of the portfolio analysis prioritization.

PrioritizationName

Name of the portfolio analysis prioritization.

PrioritizationDescription

Description of the portfolio analysis prioritization.

ConsistencyRatio

The prioritization consistency ratio.

PrioritizationIsManual

True if a portfolio analysis prioritization is manual. If False, it is calculated.

DepartmentId

Unique identifier for the department.

DepartmentName

Name of the department.

CreatedByResourceId

Unique identifier of the resource that created the prioritization.

CreatedByResourceName

Name of the resource that created the prioritization.

ModifiedByResourceID

Unique identifier of the resource that last updated the prioritization.

ModifiedByResourceName

Display name of the resource that last updated the prioritization.

CreatedDate

Date and time when the prioritization was created.

ModifiedDate

Date and time when the prioritization was last updated.

For BusinessDrivers, you will see the following properties:

Property

Description

PrioritizationId

Unique identifier for the prioritization.

BusinessDriverId

Unique identifier for the business driver.

BusinessDriverName

Name of the business driver.

BusinessDriverPriorityPercentage

Priority percentage assigned to the business driver.

For the DriverRankings, you will see the following properties:

Property

Description

PrioritizationId

Unique identifier for the prioritization.

BusinessDriver1Id

Unique identifier for the first business driver in the prioritization.

BusinessDriver1Name

Name of the first business driver in the prioritization.

RelationValue

Relationship value assigned to this business driver in comparison to another business driver.

BusinessDriver2Id

Unique identifier for the second business driver in the prioritization.

BusinessDriver2Name

Name of the second business driver in the prioritization.

Engagements

Engagements contains data about resource engagements that the user created or modified, or was requested as a resource. Each Engagement object will have the following properties:

Property

Description

EngagementUID

Unique identifier for the engagement.

ProjectID

Unique identifier for the project for which the engagement was requested.

ResourceUID

Unique identifier for the resource requested.

ResourceName

Display name of the resource.

EngagementName

Name of the engagement.

CreatedDate

Date the engagement was created.

SubmittedDate

Date the engagement was submitted for approval.

ReviewedDate

Date the engagement was reviewed.

LastModifiedDate

Date the engagement was last modified.

SubmitterResourceUID

Unique identifier for the resource that submitted the engagement.

SumitterResourceName

Resource name of the submitter.

ReviewerResourceUID

Unique identifier for the resource that reviewed the engagement.

ReviewerResourceName

Display name of the resource that reviewed the engagement request.

LastModifiedByResourceUID

Unique identifier of the resource that last modified the engagement request.

LastModifiedByResourceName

Display name of the resource that last modified the engagement request.

EngagementStatus

Status of the engagement request:

  • 0- Committed

  • 1- Proposed

  • 2- Draft

  • 3- Rejected

ProposedCustomContour

CommittedCustomContour

Each Engagements object can contain multiple EngagementSegments, which may have the following properties:

Property

Description

EngagementUID

Unique identifier for the engagement that contains the EngagementSegment.

SegmentType

  • 0- Committed

  • 1- Proposed

  • 2- Draft

  • 3- Rejected

SegmentStartDate

The proposed start date. Depending on the SegmentType, this is proposed/draft/committed start date for the segment.

SegmentFinishDate

The proposed end date. Depending on the SegmentType, this is proposed/draft/committed end date for the segment.

SegmentMaxUnits

Maximum number of units representing capacity.

SegmentWork

Number of work units for a work day.

Each Engagements object can contain EngagementComments, which may have the following properties:

Property

Description

CommentUID

Unique identifier for the comment.

EngagementUID

Unique identifier for the engagement that contains the EngagementSegment.

CommentCreatedDate

Date the comment was created.

CommentMessage

Comment details.

CommentAuthorResourceUID

Resource UID of the author of the comment.

CommentAuthorResourceName

Resource name of the author of the comment.

LookupTables

LookupTables contains data about lookup tables that are currently checked out by the user. Each LookupTableData object may have the following properties:

Property

Description

ID

Unique identifier for the lookup table.

Name

Name of the lookup table.

CheckOutDate

Time and date the lookup table was last checked out.

PortfolioAnalysis

PortfolioAnalysis contains data about Portfolio Analyses that the user created or modified. Each Analyses object will have the following properties:

Property

Description

AnalysisID

Unique identifier for the analysis.

AnalysisName

Name of the analysis.

AnalysisDescription

Description of the analysis.

AnalysisType

Type of analysis.

PrioritizationType

Prioritization type for the analysis (Business driver or Custom fields).

PrioritizationID

Unique identifier for the prioritization.

PrioritizationName

Name of the prioritization.

HardConstraintCustomFieldID

Unique identifier for the custom field selected as the primary cost constraint.

HardConstraintCustomFieldName

Name of the custom field selected as the primary cost constraint.

TimeScale

The time scale selected for the analysis:

  • 0- Days

  • 1- Weeks

  • 2- Months

  • 3- Quarters

  • 4- Years

BookingType

Specifies whether a resource is considered committed or proposed.

ModifiedByResourceID

Unique identifier for the resource that last modified the analysis.

ModifiedByResourceName

Name of the resource that last modified the analysis.

CreatedByResourceId

Unique identifier for the resource that created the analysis.

CreatedByResourceName

Name of the resource that created the analysis.

DepartmentId

Unique identifier for the department.

DepartmentName

Name of the department.

FilterResourcesByDepartment

True if resources are filtered by department.

FilterResourcesByRBS

True if are resources filtered by resource breakdown structure.

FilterResourcesByRBSValueId

The identifier of the RBS value being used for filtering.

FilterResourcesByRBSValueText

The actual text of the RBS value being used for filtering.

UseAlternateProjectDatesForResourcePlans

True if alternate project dates are used for resource plans.

AlternateProjectStartDateCustomFieldId

The GUID for a custom field that contains an alternate start date for a portfolio analysis.

AlternateProjectStartDateCustomFieldName

The name of a custom field that contains an alternate start date for a portfolio analysis.

AlternateProjectEndDateCustomFieldId

The GUID for a custom field that contains an alternate end date and time for a portfolio analysis.

AlternateProjectEndDateCustomFieldName

The name of a custom field that contains an alternate end date and time for a portfolio analysis.

ForcedInAliasLookupTableId

Identifier of the internal lookup table used for forcing in projects.

ForcedInAliasLookupTableName

Name of the internal lookup table used for forcing in projects

ForcedOutAliasLookupTableId

Identifier of the internal lookup table used for forcing out projects.

ForcedOutAliasLookupTableName

Name of the internal lookup table used for forcing out projects

CreatedDate

Date the analysis was created.

ModifiedDate

Date the analysis was last modified.

ProjectData

Dataset link for more information about the project on which the analysis was done.

Each Analyses object can have ProjectData properties, which include:

Property

Description

AnalysisID

Unique identifier for the analysis.

ProjectId

Unique identifier for the project.

ProjectName

Name of the project.

AnalysisPriority

Project priority.

AbsolutePriority

Normalized project priority.

OriginalStartDate

Original start date of the project.

OriginalEndDate

Original end date of the project.

StartDate

Start date of the project.

Duration

Duration of the project.

StartNoEarlierThan

Project starts no earlier than specified date.

FinishNoLaterThan

Project starts no later than specified date.

Locked

True if project is locked.

For Optimizer Solutions, CostConstraintProject objects can have the following properties:

Property

Description

ScenarioId

Identifier of the cost constraint scenario.

ScenarioName

Name of the cost constraint scenario.

AnalysisID

Unique identifier for the analysis.

AnalysisName

Name of the analysis.

ProjectId

Identifier of the project included in the cost constraint scenario.

ProjectName

Name of the project included in the cost constraint scenario.

ProjectStatus

Status of the project.

ForceStatus

Force status of the project (whether it is forced in or forced out).

ForceAliasLookupTableId

Identifier of the internal lookup table used for forcing in projects.

ForceAliasLookupTableName

Name of the internal lookup table used for forcing in projects.

ProjectPriority

Priority of the project.

AbsolutePriority

Normalized project priority.

HardConstraintValue

Value of the project for the custom field select as a hard constraint.

For Optimizer Solutions, CostConstraintScenario objects can have the following properties:

Property

Description

AnalysisID

Unique identifier for the analysis.

AnalysisName

Name of the analysis.

ScenarioId

Identifier of the cost constraint scenario.

ScenarioName

Name of the cost constraint scenario.

ScenarioDescription

Description of the cost constraint scenario.

UseDependencies

Specify whether or not the cost constraint scenario uses dependencies.

CreatedByResourceId

Identifier for the resource that created the cost constraint scenario.

CreatedByResourceName

Name for the resource that created the cost constraint scenario.

ModifiedByResourceId

Identifier for the resource that modified the cost constraint scenario.

ModifiedByResourceName

Name of the resource that modified the cost constraint scenario.

CreatedDate

Date when cost constraint scenario was created.

ModifiedDate

Date when cost constraint scenario was last modified.

SelectedProjectsCost

Cost of the selected project.

SelectedProjectsPriority

Priority of the selected project.

UnselectedProjectsCost

Cost of the unselected project.

UnselectedProjectsPriority

Priority of the unselected project.

For Planner Solutions, ResourceConstraintProject objects can have the following properties:

Property

Description

ScenarioId

Identifier of the cost constraint scenario.

ScenarioName

Name of the cost constraint scenario.

AnalysisID

Unique identifier for the analysis.

AnalysisName

Name of the analysis.

CostConstraintScenarioId

Unique identifier for the portfolio analysis cost constraint scenario.

CostConstraintScenarioName

The name of a portfolio analysis cost constraint scenario.

ProjectId

Identifier of the project included in the cost constraint scenario.

ProjectName

Name of the project included in the cost constraint scenario.

NewStartDate

The new start date of the project.

ForceStatus

Force status of the project (whether it is forced in or forced out).

ProjectStatus

The status of the project.

ResourceWork

The amount of work that is performed by a resource on a project.

ResourceCost

The cost of a resource on a project.

ForceAliasLookupTableId

Identifier of the internal lookup table used for forcing in projects.

ForceAliasLookupTableName

Name of the internal lookup table used for forcing in projects.

ProjectPriority

Priority of the project.

AbsolutePriority

Normalized project priority.

HardConstraintValue

Value of the project for the custom field select as a hard constraint.

For Planner Solutions, ResourceConstraintScenario objects can have the following properties:

Property

Description

ScenarioId

Identifier of the cost constraint scenario.

ScenarioName

Name of the cost constraint scenario.

ScenarioDescription

Description of the cost constraint scenario.

AnalysisID

Unique identifier for the analysis.

AnalysisName

Name of the analysis.

CostConstraintScenarioId

Unique identifier for the portfolio analysis cost constraint scenario.

CostConstraintScenarioName

The name of a portfolio analysis cost constraint scenario.

ConstraintType

The type of restriction or constraint.

ConstraintValue

A value that indicates the limit of a constraint.

AllocationThreshold

The percentage number between 0 and 100 that specifies the minimum threshold that is required for a resource to be allocated to a project.

RateTable

The cost rate table used for the resource.

EnforceProjectDependencies

A flag that indicates whether project dependencies are enforced.

EnforceSchedulingConstraints

A flag that indicates whether scheduling constraints are enforced.

HiringType

The internal or external hiring type.

CreatedByResourceId

Identifier for the resource that created the cost constraint scenario.

CreatedByResourceName

Name for the resource that created the cost constraint scenario.

ModifiedByResourceId

Identifier for the resource that modified the cost constraint scenario.

ModifiedByResourceName

Name of the resource that modified the cost constraint scenario.

CreatedDate

Date when cost constraint scenario was created.

ModifiedDate

Date when cost constraint scenario was last modified.

QueueJobs

QueueJobs contains data about jobs that were created by the user through the Queuing service. Each QueueData object may have the following properties:

Property

Description

CorrelationId

Unique identifier for jobs that are part of a correlation with other jobs.

QueueState

Queue state the job is currently in:

  • 0- Unknown

  • 1- ReadyForProcessing

  • 2- SendIncomplete

  • 3- Processing

  • 4- Success

  • 5- Failed

  • 6- FailedNotBlocking

  • 7-ProcessingDeferred

  • 8- CorrelationBlocked

  • 9- Cancelled

  • 10- OnHold

  • 11- Sleeping

  • 12- ReadyForLaunch

MessageType

Queue job type (see the corresponding QueueStateLabel value).

ErrorInfo

Error details about the queue job.

JobId

Unique identifier for the queue job.

PercentComplete

Current percentage completed of processing the job through the Queue service.

CreatedDate

Date and time the queue job was created.

ProcessingDate

Date and time the queue job began processing through the Queue service.

CompletedDate

Date and time the queue job was processed through the Queue service.

ReadyForProcessingDate

Date and time the queue job was ready to be picked up for processed through the Queue service.

MessageTypeLabel

Job type (associated with the MessageType value).

QueueStateLabel

Current queue state of the job (see the corresponding QueueStateValue).

ReminderEmails

ReminderEmails contains data about email reminder notifications for the user. Each ReminderEmailData object will have the following properties:

Property

Description

SessionId

The unique identifier for the reminder emails.

EmailType

The type of emails: Task, StatusReport, Timesheet, or Engagement.

RowIsReady

If the email is ready to be sent out.

ReportingResource

ReportingResource contains data about reporting resources. Each ReportingResourceData object may have the following properties:

Property

Description

ResourceUID

Unique identifier for the resource.

ResourceName

Display name of the resource.

ResourceNTAccount

The Windows account name for a resource.

UserClaimsAccount

Login name for the user.

ResourceEmailAddress

The email address of a resource.

ResourceCanLevel

True if resource leveling can be done.

ResourceEarliestAvailableFrom

The earliest date that a resource is available for work on a particular task.

ResourceLatestAvailableTo

The last date that a resource is available.

ResourceStandardRate

The standard rate of pay for a resource.

ResourceOvertimeRate

The rate of overtime pay for a resource.

ResourceMaxUnits

The maximum capacity (percentage or units) that a resource is available to accomplish tasks during the current time period.

ResourceBaseCalendar

The base calendar for a resource.

ResourceHyperlinkFriendlyName

Shows the title or explanatory text for a hyperlink associated with a resource.

ResourceHyperlinkHref

The text that is displayed for a resource hyperlink, as specified in the Edit User page of Project Web Access.

ResourceInitials

The initials of a resource.

ResourceType

The type of a resource (for example, Enterprise, Local, Project Server, Material, or Generic). See ResourceType Enumerations for values.

ResourceBookingType

The resource booking type: proposed or committed.

ResourceCostPerUse

The cost that accrues each time a work resource is used.

ResourceGroup

The group to which resource belongs.

ResourceCode

Contains any code, abbreviation, or number you want to enter as part of a resource's information.

ResourceTimesheetManagerUID

The unique identifier of a timesheet manager.

ResourceName(OR ResourceName1)

Display name of the resource.

ResourceWorkgroup

A number value that represents a team collaboration method for a resource.

ResourceCostCenter

A user-defined code for resource cost accounting.

ResourceIsTeam

True if a resource is a team resource.

ResourceRequiresEngagements

True if the resource can only be requested through an engagement request.

ResourceCreatedDate

The date and time that a resource was created in the project.

ResourceModifiedDate

The date that information about a resource was last modified.

Each Customfields object may have the following properties:

Property

Description

CustomFieldValueUID

Unique identifier for the custom field value.

CustomFieldTypeUID

Unique identifier for the custom field type.

CustomFieldName

Name of the custom field.

EntityUID(OR ResourceUID)

Unique identifier for the resource.

CFValue

Custom field value.

Each ResourceCapacityData object may have the following properties:

Property

Description

ResourceUID

Unique identifier for the resource.

TimeByDay

A primary key that identifies the day along a timeline. The granularity is in days only.

BaseCapacity

The maximum work capacity that is determined by the resource calendar. Also known as baseline capacity.

Capacity

The amount of work that can be done by a resource.

ReportingResourcePlan

ReportingResourcePlan contains data about reporting resource plans. It may have the following properties:

Property

Description

AssignmentId

Unique identifier for the assignment.

ProjectId

Unique identifier for the project.

ResourceUID

Unique identifier for the resource.

ResourceName

Display name of the resource.

TaskId

Unique identifier for the task.

ResourceOwnerId

Resource ID of the resource owner.

AssignmentCost

The total scheduled (or projected) cost for an assignment.

AssignmentOvertimeCost

The sum of the actual and remaining overtime cost of the assignment.

AssignmentActualCost

The costs incurred for work that has already been performed on an assignment, along with any other associated costs.

AssignmentActualOvertimeCost

The costs incurred for overtime work that has already been performed on an assignment.

AssignmentWork

The total amount of time, such as person-hours or days, that is scheduled for an assignment.

AssignmentOvertimeWork

The total overtime work for an assignment, including overtime work that has already been performed, in addition to remaining overtime work.

AssignmentActualWork

The amount of work that has already been performed on an assignment.

AssignmentActualOvertimeWork

The actual amount of overtime work that has already been performed on an assignment.

AssignmentMaterialWork

The total work time scheduled for a material resource.

AssignmentMaterialActualWork

The actual amount of work that has already been performed with the use of a material resource, usually expressed as a percentage of the scheduled amount of material resource work.

AssignmentPercentWorkCompleted

Percentage of work that has been completed.

AssignmentStartDate

Date a resource is scheduled to begin an assignment.

AssignmentFinishDate

Assignment finish date.

AssignmentDelay

Amount of time a resource is to wait before starting to work on an assignment.

AssignmentStartVariance

Variance at the start of the assignment.

AssignmentFinishVariance

Variance at the assignment finish.

AssignmentACWP

Actual cost of work performed for the assignment.

AssignmentBCWP

Budgeted cost of work performed for the assignment (earned value).

AssignmentBCWS

Budgeted cost of work scheduled for the assignment (planned value).

AssignmentBookingID

Assignment booking GUID.

AssignmentType

Type of assignment. NormalAssignment=0, WorkOnlyAssignment=1, FixedCostAssignment=2, FixedCostWorkOnlyAssignment=3, EmptyAssignment=4, FixedCostGeneratedAssignment=100 (generated during RDS transfer), ResourcePlanAssignment=101.

AssignmentResourceType

The type of resource that is associated with an assignment. See Type enumeration.

IsPublic

True if the item was published, so a team member can see it.

AssignmentIsPublished

True if assignment is published.

AssignmentWorkVariance

The variance of assignment work from the baseline work as minutes x 1000.

AssignmentCostVariance

The difference between the cost and baseline cost for a resource.

AssignmentCV

Earned value cost variance.

AssignmentSV

Earned value schedule variance.

AssignmentVAC

Variance at completion.

AssignmentIsOverallocated

True if any assigned resources are overallocated.

AssignmentPeakUnits

Maximum number of units that a resource is assignmed for a task.

AssignmentCreatedDate

Date and time the assignment was created.

AssignmentModifiedDate

Date and time the assignment was last updated.

AssignmentBudgetCost

The total projected cost of an assignment.

AssignmentBudgetWork

The total projected amount of work that is planned for an assignment.

AssignmentBudgetMaterialsWork

The total projected amount of use on the assignment of material resources.

AssignmentResourcePlanWork

The total time that is scheduled for an assignment in the resource plan.

TaskIsActive

True if the task for the assignment timephased data is active.

TimesheetClassUid

GUID of the timesheet class.

Resource

Resource contains data about the resource. Each ResourceData object may have the following properties:

Property

Description

ResourceID

ID of the resource within the list of resources.

ResourceUID

Unique identifier for the resource.

ResourceName

Display name of the resource.

ResourceAccount

User's account.

UserClaimsAccount

User's claims account (same as the Office 365 account when using Project Online).

ResourceEmailAddress

The email address of a resource.

ResourceEmailLanguage

Language code used for the resources email.

ResourceIsOffline

True if the resource is offline. This feature is deprecated.

ResourceLastConnectDate

The last time the resource connected. This feature is deprecated.

ResourcePhonetics

The phonetic spelling of the resource name. For use with Japanese only.

ResourceHasNotes

Whether the resource has notes (value of 2)

ResourceCanBeLeveled

True if resource leveling can be done.

ResourceAccrueAt

How cost is accrued against the resource. (1=Start, 2=End, 3=Prorated, 4=Invalid).

ResourceAvailableFrom

The starting date that a resource is available for work at the units specified for the current time period.

ResourceAvailableTo

The end date that a resource is available for work at the units specified for the current time period.

ResourceStandardRate

The standard rate of pay for a resource.

ResourceOvertimeRate

The rate of overtime pay for a resource.

ResourceMaxUnits

The maximum capacity (percentage or units) that a resource is available to accomplish tasks during the current time period.

ResourceBaseCalendar

The base calendar for a resource.

ResourceHyperlinkFriendlyName

Shows the title or explanatory text for a hyperlink associated with a resource.

ResourceHyperlinkHref

Contains the combination, or concatenation, of the Hyperlink Address and Hyperlink SubAddress fields associated with a resource..

ResourceInitials

The initials of a resource.

ResourceType

The type of a resource. See ResourceType Enumerations for values.

ResourceBookingType

The resource booking type: proposed or committed.

ResourceGroup

The name of the group that a resource belongs to.

ResourceCode

Contains any code, abbreviation, or number you want to enter as part of a resource's information.

ResourceCostPerUse

The cost that accrues each time a work resource is used.

DefaultAssignmentOwner

Default assignment owner for the resource.

DefaultAssignmentOwnerDisplayName

Display name of the default assignment owner.

ResourceTimesheetManagerUID

Timesheet manager for the given resource.

ResourceTimesheetManagerDisplayName

Display name of the timesheet manager.

ResourceCostCenter

The cost center for the resource.

ResourceIsTeam

True if a resource is a team resource.

ResourceRequiresEngagements

True if the resource can only be requested through an engagement request.

ResourceCreatedDate

The date and time that a resource was created.

ResourceModifiedDate

The date that information about a resource was last modified.

CheckedOutDate

Time and date the resource was last checked out.

CheckedOutBy

The user that checked out the resource.

DefaultAssignmentOwnerResources

Resources for which the resource is the default assignment owner.

Each ResourceData object may have a collection of DefaultAssignmentOwnerResources. Each DefaultAssignmentOwnerResources object may have the following properties:

Property

Description

ResourceID

The ID of the resource within the list of resources.

ResourceUID

Unique identifier for the resource for which the user is the default assignment owner.

ResourceName

Name of the resource.

ResourceType

The type of a resource (for example, Enterprise, Local, Project Server, Material, or Generic). See ResourceType Enumerations for values.

DefaultAssignmentOwner

Default assignment owner for the resource.

Each ResourceData object may also have a collection of CustomFields. Each CustomFields object may contain the following properties:

Property

Description

ResourceUID

Unique identifier for the resource.

CustomFieldUid

Unique identifier for the custom field.

CustomFieldName

Name of the custom field.

CustomFieldValue

Value properties for the custom field.

ResourcePlans

ResourcePlans contains data about resource plans the user created, modified, or was a part. For each ResourcePlans object, you will see the following properties:

Property

Description

ProjectId

Unique identifier for the project.

ProjectName

Name of the project.

ResourcePlanUtilizationType

Value that represents the utilization type of a resource plan.

ResourcePlanUtilizationDate

The start date and time for use of the resource plan.

ResourceId

Unique identifier of the resource.

ResourceName

Name of the resource.

ResourcePlanCheckedOutById

Resource ID of the user that checked out the resource plan.

ResourcePlanCheckedOutByName

Name of the user that checked out the resource plan.

ResourcePlanCheckedOutDate

Date the resource plan was checked out.

ResourcePlanPublishStatus

Internal property describing publish status.

ProjectCurrentRevCounter

Internal property describing number of revisions.

ProjectCurrentRevRank

Internal property describing number of revisions.

ResourcePlanCreationDate

Date and time the resource plan was created.

ResourcePlanModDate

Date and time the resource plan was last updated.

ResourcePlanCreatedRevCounter

Internal property describing number of revisions.

ResourcePlanModRevCounter

Internal property describing number of revisions.

ResourcePlanStartDate

Date and time the resource plan began.

ResourcePlanFinishDate

Date and time the resource plan ended.

ResourcePlanModRevCounter

Internal property describing number of revisions.

ResourcePlanCreatedRevCounter

Internal property describing number of revisions.

ResourcePlanAssignments

Assignments associated with the resource plan.

A ResourcePlan object can have a collection of ResourcePlanAssignments. Each ResourcePlanAssignments object may have the following properties:

Property

Description

ProjectId

Unique identifier for the project.

ProjectName

Name of the project.

AssignmentId

Unique identifier for the assignment.

ReservedData

Used to temporarily store calculated values.

AssignmentActualFinish

The actual finish date of the assignment.

AssignmentActualStart

The actual start date of the assignment.

AssignmentResourceType

The type of resource that is associated with an assignment. See Type enumeration.

AssignmentIsOverAllocated

Indicates whether a resource is assigned to more work on a specific task than can be done within the resource's normal working capacity.

AssignmentWorkContour

The work contour of the assignment. Values are: 0=Flat, 1=Back Loaded, 2=Front Loaded, 3=Double Peak, 4=Early Peak, 5=Late Peak, 6=Bell, 7=Turtle, 8=Contoured.

AssignmentStartVariance

The variance of the assignment start date from the baseline start date.

AssignmentFinishVariance

The variance of the assignment finish date from the baseline finish date.

AssignmentUpdateNeeded

Indicates whether a TeamUpdate message should be sent to the resource assigned to a task because of changes to the start date, finish date, or resource reassignments.

AssignmentHasLinkedFields

Indicates that the assignment has linked fields.

AssignmentIsConfirmed

Indicates whether a resource assigned to a task has accepted or rejected the task assignment.

AssignmentResponsePending

Indicates whether an answer has been received from a message sent to a resource assigned to a task notifying the resource of the assignment.

AssignmentHasNotes

There are notes about the assignment.

AssignmentTeamStatusPending

Indicates whether a status message has been received in response to a TeamStatus message sent to a resource assigned to a task.

ResourceId

Unique identifier of the resource.

ResourceName

Name of the resource.

AssignmentStartDate

The date and time that an assigned resource is scheduled to begin working on a task.

AssignmentFinishDate

The date and time that an assigned resource is scheduled to stop working on a task.

AssignmentDelay

The amount of time a resource is to wait after the task start date before starting work on an assignment.

AssignmentDelayFMT

The format for expressing the duration of the delay. Values are: 3=m, 4=em, 5=h, 6=eh, 7=d, 8=ed, 9=w, 10=ew, 11=mo, 12=emo, 19=%, 20=e%, 21=null, 35=m, 36=em, 37=h, 38=eh, 39=d, 40=ed, 41=w, 42=ew, 43=mo, 44=emo, 51=%, 52=e% and 53=null.

AssignmentLevelingDelay

The amount of time that an assignment is to be delayed from the scheduled start date as a result of resource leveling.

AssignmentCostRateTable

Indicates which cost rate table to use for a resource on an assignment.

AssignmentMaterialRateFMT

Indicates the units in which the bid is expressed in the project.

AssignmentUnits

The number of units for which a resource is assigned to a task, expressed as a percentage.

AssignmentWork

The total amount of work scheduled to be performed by a resource on a task.

AssignmentActualWork

The amount of work that has already been done by a resource on a task.

AssignmentRegularWork

The total amount of non-overtime work scheduled to be performed by a resource assigned to a task.

AssignmentRemainingWork

The amount of time required by a resource assigned to a task to complete an assignment.

AssignmentCost

The total scheduled (or projected) cost for an assignment.

AssignmentActualCost

The cost incurred for work already performed by a resource on a task.

AssignmentRemainingCost

The costs associated with completing all remaining scheduled work by any resources on a specific task.

AssignmentOvertimeWork

The amount of overtime to be performed by a resource on a task; charged at the resource's overtime rate.

AssignmentActualOvertimeWork

The actual amount of overtime work already performed by a resource on an assigned task.

AssignmentRemainingOvertimeWork

The amount of overtime work that remains on an assignment.

AssignmentActualOvertimeCost

The cost incurred for overtime work already performed by a resource on a task.

AssignmentRTFNotes

Notes that are associated with the specified assignment, and that are stored in Rich Text Format.

AssignmentRemainingOvertimeCost

The remaining scheduled overtime expense for an assignment.

AssignmentBookingType

Specifies the booking type of the assignment (committed or proposed).

AssignmentTDModeDate

Internal property describing last modified date on timephased data.

AssignmentTDModCounter

Internal property describing number of revisions.

AssignmentOvertimeCost

The total overtime cost for a resource assignment.

AssignmentStopDate

The date the assignment was stopped.

AssignmentResumeDate

The date the assignment was resumed.

CreatedDate

The date that the assignment was created.

ModDate

The date that the assignment was last updated.

CreatedRevCounter

Internal property describing number of revisions.

ModRevCounter

Internal property describing number of revisions.

A ResourcePlanAssignments object can have a collection of Assignments. Each Assignments object may contain the following properties:

Property

Description

ResourceUID

Unique identifier for the resource for the assignment.

ProjectId

Unique identifier for the project for the assignment.

AssignmentId

Unique identifier for the assignment.

MDProjectUID

Internal user only.

CustomFieldName

Name of the resource.

CustomFieldValue

Values for the custom field.

CreationDate

Date the custom field was created.

ModDate

Date the custom field was last updated.

ResourceName

Name of the resource for the assignment.

Start

Date and time the assignment work began.

End

Date and time the assignment work ended.

Work

The total amount of work scheduled to be performed by a resource on a task.

Rules

Rules contains data about approval rules defined by status manager to approve certain task updates. Each RulesData object can have the following properties:

Property

Description

RuleUid

Unique identifier for the rule.

RuleManagerUid

Unique identifier for the Status Manager Owner of the rule.

RuleManagerName

The name of the Status Manager Owner.

RuleName

Name of the rule.

IsAutomatic

True if status updates are automatically approved if they meet criteria defined in this rule, false otherwise.

AutoPublish

True if projects are published after the updates are automatically applied.

RuleTypeNewTaskAndAssignments

True if this rule is applying to updates of type new task or new assignments, false otherwise.

RuleTypeDelegations

True if this this rule is applying to updates of type Delegation(Reassign), false otherwise.

RuleTypeUpdateTasks

True if this rule is applying to updates made to the task assignments, false otherwise.

RuleTypeDeletes

True if this rule is applying to updates of type delete assignment, false otherwise.

RuleConditionType

If extra filtering is done in this rule this filed will have one of the values: None, Compare with fix string, or Compare with Database Column.

Field1

The left side of the filter

Field2

The right side of the filter

Operator

Operator (can be Equal, Not Equal, Less Than, Greater Than, Less Than or Equal, Greater Than, or Equal).

ValueType

Type of right side of the filter (can be string, int, double, date, bool).

IntValue

Value to compare with if ValueType is Int.

DateValue

Value to compare with if ValueType is Date.

DecimalValue

Value to compare with if ValueType is Decimal.

StringValue

Value to compare with if ValueType is String.

IncludesAllProjects

True if this rule applies to updates made in all projects, false otherwise.

IncludesAllResources

True if this rule applies to updates made by all resources, false otherwise.

IncludesAllDelegatee

True if this rule applies to updates of type delegation regardless of delegatee, false otherwise.

RuleDescription

Description for the rule.

CreatedDate

Date the rule was created.

ModifiedDate

Date the rule was last updated.

RuleDetailsData

Object with details about projects/resources this rule will applied for. This object will be populated with data only if IncludesAllProjects or IncludesAllResources or IncludesAllDelegatee is false.

Each RulesDetailsData object will have the following properties:

Property

Description

RuleUid

Unique identifier for the rule.

RuleListItemUid

Unique identifier for project/resource/delagatee.

RuleListItemType

Type of the item, can be project, resource or delegate.

RuleListItemName

RuleListItemName Name of the item (can be name of the project/ resource/delegatee depending on the ruleListItemType).

CreatedDate

Date the rule was created.

ModDate

Date the rule was last updated.

Security

Security provides security data about your user. It will only include data about your user if the PWA site is using Project Server permissions mode.

It includes:

  • SecurityData: Account information about the user.

  • GroupData: Project security groups in that the user was associated with.

  • CategoryData: Security categories that the user was associated with.

  • PermissionData: Global permission settings for your user.

A ResourceData object may have the following properties:

Properties

Description

EncodedClaim

Claims account of the resource.

ResourceUID

Unique identifier of resource.

ResourceName

Display name of the resource.

GroupData

Security group objects data.

CategoryData

Security category objects data.

Under ResourceData, a GroupData object may have the following properties:

Property

Description

ResourceUID

Unique identifier of resource.

GroupUID

Unique identifier of the security group.

GroupName

Name of the security group.

GroupDecription

Description of the security group.

Under ResourceData, a CategoryData object may have the following properties:

Property

Description

ResourceUID

Unique identifier of resource.

CategoryUID

Unique identifier of the category.

CategoryName

Name of the category.

CategoryDescription

Description of the category.

Under ResourceData, aParentPermissionData object may have the following properties:

Property

Description

ResourceUID

Unique identifier of resource.

PermissionUID

Unique identifier of the parent permission.

PermissionName

Name of the parent permission.

PermissionData

Permission objects under the parent permission.

Under ParentPermissionData, aPermissionData object may have the following properties:

Property

Description

ResourceUID

Unique identifier of resource.

PermissionUID

Unique identifier of the permission.

PermissionParentUID

Internal unique identifier of the parent permission name.

AllowOption

If True, Allow was selected for permission for the user.

DenyOption

If True, Deny was selected for permission for the user.

PermissionName

Name of the permission.

StatusReports

StatusReports contains data about status reports that the user created or received as a status report manager. For each StatusReports object, you will see the following properties:

Properties

Description

StatusReportId

Unique identifier of the status report.

StatusReportName

Name of the status report.

ManagerId

Unique identifier of the status report manager.

ManagerName

Name of the status report manager.

IsEnabled

Indicates whether it’s a active or archived status report.

IsRequested

Indicates whether it’s a Requested or Misc status report.

Sections

Sections of the status report.

CreatedDate

Date the status report was created.

ModifiedDate

Date the status report was last updated.

Each StatusReportRequests object may have the following properties:

Properties

Description

StatusReportId

Unique identifier of the status report.

RequesterId

Unique identifier of the requestor.

RequesterName

Name of the requestor.

DueDate

Date when the status report is due

IsNewRequest

Indicates whether it’s a active or archived status report.

IsEnabled

Indicates whether it’s a Requested or Misc status report.

CreatedDate

Date and time when the request was created.

ModifiedDate

Date and time when the request was last updated.

Each StatusReportResponses object may have the following properties:

Properties

Description

ResponseId

Unique identifier of the response.

StatusReportId

Unique identifier of the status report.

ResponderId

Unique identifier of the responder.

ResponderName

Name of the responder.

ResponsePeriodStartDate

Start date of the response period.

ResponsePeriodFinishDate

End date of the response period.

ResponseSubmittedStatus

The status of the submitted response.

ResponseSubmittedDate

Date the response was submitted.

ResponseSectionsCount

The number of sections included in the status response.

IsMatchingResponse

True if the response matches the status report period.

IsNewResponse

True if the response is new versus updated.

ResponseSendId

Identifier of the status report response.

CreatedDate

Date and time when the response was created.

ModifiedDate

Date and time when the response was last updated.

Each StatusReportSections object may have the following properties:

Properties

Description

SectionId

Unique identifier of the section.

ResponseId

Unique identifier of the response.

SectionText

Actual text of a status report section.

SectionIndex

Identifier of the status report section.

SectionName

Name of the section.

SectionDescription

Description of the section.

StatusReportId

Unique identifier of the status report.

CreatedDate

Date the section was created.

ModifiedDate

Date the section was last updated.

Each StatusReportFrequencies object may have the following properties:

Properties

Description

StatusReportId

Unique identifier of the status report.

StatusReportName

Name of the status report.

ResponseId

Unique identifier of the response.

FrequencyType

Indicates the status report is due by week,month, or year.

FrequencyPart1

Due weeks for the status report.

FrequencyPart2

Due days or day of the month, or day of the week, or week of the month for the status report.

FrequencyPart3

Due month or day of the week for the status report.

FrequencyPart4

Due week of the month for the status report.

FrequencyPart5

Due day of the week for the status report.

FrequencyPart6

Due month of the status report.

FrequencyYearlyDate

Date of yearly frequency for the status report.

CreatedDate

Date the frequency was created.

ModifiedDate

Date the frequency was last updated.

Each StatusReportDistribution object may have the following properties:

Properties

Description

ResponderId

Unique identifier of the responder.

ResponderName

Name of the responder.

ResponseId

Unique identifier of the response.

CreatedDate

Date the distribution was created.

ModifiedDate

Date the distribution was last updated.

Each WorkDetails object may have the following properties:

Properties

Description

StatusReportId

Unique identifier of the status report.

StatusReportName

Name of the status report.

StartDate

Start date of the status report.

CreatedDate

Date and time when the request was created.

ModifiedDate

Date and time when the request was last updated.

DueWeek

Indicates the Due week number of the status report.

DueDays

Due date of the status report.

SubscribedReminders

SubscribedReminders contains data about reminders subscribed to by the user. For each SubscribedReminderData object, you will see the following properties:

Property

Description

Id

The unique identifier of the reminder.

ReminderName

The name of the reminder.

RecipientType

Can be either: OnlyToManager, OnlyToTeamMember, or ToBothManagerAndTeamMember.

FrequencyPeriod

Can be: Daily, Weekly, or Monthly.

FrequencyValue

The value of the frequency to send the reminder, combined with the frequency period. For example, the value is "2" and the FrequencyPeriod is "Monthly", so the reminder will be sent every 2 months.

NextRun

The time the next reminder will be sent.

TaskStatus_AssignmentsHistory

TaskStatus_AssignmentsHistory contains data about status updates where user is the submitter, assignment owner, status manager or delagatee. Each Transactions object, you may see the following properties:

Properties

Description

TransactionUid

Unique identifier of the transaction.

State

State of the transaction.

UpdateType

Type of update: new assignment, status update, delete assignment, reassignment, or new task.

ApprovalType

The action taken by the status manager regarding the status update: Approve or Reject.

ErrorStatus

In case the status update couldn’t be applied to the plan this will tell you the error encountered.

DelegateeUid

Unique identifier of the delegatee.

DelegateeName

Name of the delegatee.

SubmitterUid

Unique identifier of the submitter.

SubmitterName

Name of the submitter.

ApproverUid

Unique identifier of the approver.

ApproverName

Name of the approver.

UpdateDate

Date the status update last modified by the submitter or approver.

SubmittedDate

When this status update was submitted.

CreatedDate

Creation date for the status update.

ModifiedDate

Last modified date for the status update.

AssignmentUid

Unique identifier of the assignment.

StatusAssignmentTaskUid

Unique identifier of the status assignment task.

ProjectUid

Unique identifier of the project.

ProjectName

Name of the project.

TaskUid

Unique identifier of the task.

TaskName

Name of the task.

Changes

The object containing the changes made by the submitter in the status update.

Each Changes object may have the following properties:

Properties

Description

TransactionUid

Unique identifier of the transaction.

EntityUid

Task UID or Assignment UID depending if the change was made for the task or for the assignment.

PropertyName

Name of the property that was changed.

PeriodStart

The start of the period.

PeriodEnd

The end of the period.

Value

Value the property was changed to.

Each TransactionsComments object may have the following properties:

Properties

Description

CommentUid

Unique identifier of the comment.

TransactionUid

Unique identifier of the transaction.

CommentType

Type of comment (Submitted or Approved).

AuthorUid

Unique identifier of the comment author.

AuthorName

Name of the comment author.

Comment

Comment details.

DateEntered

Date and time the comment was created.

CommentCreatedDate

Date and time the comment was created.

CommentModifiedDate

Date and time the comment was last updated.

TaskStatus_AssignmentsSaved

TaskStatus_AssignmentsSaved contains data about status reports that the user created or received as a status report manager. This file will contain a collection of Tasks objects, which may have the following properties:

Properties

Description

TaskUid

Unique identifier of the task.

TaskPublishedUid

Name of the status report.

ProjectUid

Unique identifier of the project in which the task exists.

ProjectName

Name of the project in which the task exists.

TaskParentUid

Unique identifier of the parent task.

TaskACWP

The actual cost of work performed on the task to date.

TaskBCWP

The budgeted cost of work performed on the task to date.

TaskBCWS

The budgeted cost of work scheduled for the task.

TaskDurationVariance

The difference between the baseline duration of a task and the total duration.

TaskFinishVariance

The variance of the task finish date from the baseline finish date as minutes x 1000.

TaskOutlineNumber

The outline number of the task.

TaskStartVariance

The difference between the baseline start and the actual start.

TaskIsOverallocated

True if the task is overallocated.

TaskOvertimeWork

The amount of overtime work scheduled for the task

TaskVAC

The task variance at completion of the task.

TaskRegularWork

The amount of time scheduled for a task that is charged at the resource's standard rate.

TaskTotalSlack

The amount of total slack.

TaskId

Unique identifier for the task.

TaskHasLinkedFields

True if the task has linked fields.

TaskIsMilestone

True if the task is a milestone.

TaskIsCritical

True if the task is in the critical chain.

TaskIsSummary

True if the task is a summary task.

TaskIsSubproject

True if the task is an inserted project.

TaskIsMarked

Indicates whether a task is marked for further action or identification of some kind.

TaskIgnoresResourceCalendar

True if the task ignores the resource calendar.

TaskIsRolledUp

True if the task is rolled up

TaskIsSubprojectScheduledFromFinish

Gets a value that indicates whether a subproject for this task is set to schedule from finish.

TaskBarIsHidden

True if the GANTT bar of the task is hidden when displayed in Microsoft Office Project.

TaskIsRecurring

True if the task is recurring.

TaskIsRecurringSummary

True if the task is a recurring summary task.

TaskIsExternal

True if the task is external.

TaskIsEffortDriven

True if the task is effort driven.

TaskIsCollapsed

True if task is displayed collapsed in Project client.

TaskHasNotes

True if text notes are associated with the task.

TaskIsSubprojectReadOnly

Gets a value that indicates whether a subproject for this task is read-only.

TaskLevelingCanSplit

True if leveling can split the task.

TaskCanSplit

Indicates whether the resource leveling function can cause splits on remaining work on this task. If this field is set to Yes, then leveling can interrupt this task. If this field is set to No, leveling cannot split the task.

TaskDurationIsEstimated

Indicates whether the task's duration is flagged as an estimate.

TaskEarlyFinish

The early finish date of the task.

TaskLateStart

The late start date of the task.

TaskStopDate

The date that the task was stopped.

TaskFreeSlack

The amount of free slack.

TaskResumeDate

The date that the task was resumed.

TaskCompletedDate

The date argument for the task constraint type.

TaskOutlineLevel

The outline level of the task.

TaskScheduledDuration

The scheduled duration of the task.

TaskScheduledDurationFormat

Gets the total span of active working time for the task as entered or as calculated based on the start date, the finish date, calendars, and other scheduling factors.

TaskActualDuration

The actual duration of the task.

TaskRemainingDuration

The amount of time required to complete the unfinished portion of the task.

TaskConstraintType

The constraint on the start or finish date of the task. Values are: 0=As Soon As Possible, 1=As Late As Possible, 2=Must Start On, 3=Must Finish On, 4=Start No Earlier Than, 5=Start No Later Than, 6=Finish No Earlier Than and 7=Finish No Later Than.

TaskLevelingDelay

The delay caused by leveling the task.

TaskLevelingDelayFormat

The format for expressing the duration of the delay. Values are: 3=m, 4=em, 5=h, 6=eh, 7=d, 8=ed, 9=w, 10=ew, 11=mo, 12=emo, 19=%, 20=e%, 21=null, 35=m, 36=em, 37=h, 38=eh, 39=d, 40=ed, 41=w, 42=ew, 43=mo, 44=emo, 51=%, 52=e% and 53=null.

TaskScheduledStart

The scheduled start date of the task.

TaskScheduledFinish

The scheduled finish date of the task.

TaskActualStart

The actual start date of the task.

TaskActualFinish

The actual finish date of the task.

TaskConstraintDate

The date associated with the constraint type.

TaskPriority

The priority of the task from 0 to 1000.

TaskPercentComplete

The percentage of the task duration completed.

TaskWorkPercentComplete

The percentage of the task work completed.

TaskType

The type of task. Values are: 0=Fixed Units, 1=Fixed Duration, 2=Fixed Work.

TaskFixedCostAccrual

How the fixed cost is accrued against the task. Values are: 1=Start, 2=Prorated and 3=End.

TaskPreleveledStart

Contains the start date of a task as it was before resource leveling was done.

TaskPreleveledFinish

Contains the end date of a task as it was before resource leveling was done.

TaskEarlyStart

The early start date of the task.

TaskLateFinish

The late finish date of the task.

TaskCalendarUid

The unique identifier of the calendar associated with a task.

TaskDeadline

 The final desired point in a task’s time length that the task must be completed by.

TaskWork

The amount of scheduled work for the task.

TaskActualWork

The actual work for the task.

TaskRemainingWork

The remaining work scheduled to complete the task

TaskCost

The projected or scheduled cost of the task.

TaskFixedCost

The fixed cost of the task.

TaskActualCost

The actual cost of the task.

TaskRemainingCost

The remaining projected cost of completing the task.

TaskActualOvertimeWork

The actual overtime work for the task.

TaskRemainingOvertimeWork

The remaining overtime work scheduled to finish the task.

TaskOvertimeCost

The sum of the actual and remaining overtime cost of the task.

TaskActualOvertimeCost

The actual overtime cost of the task.

TaskRemainingOvertimeCost

The remaining overtime cost projected to finish the task.

TaskWBS

The work breakdown structure (WBS) code of the task.

TaskName

The name of the task.

TaskHierarchy

The hierarchy of the task.

TaskRightMostLevel

Used in leveling.

TaskRTFNotes

Notes that are associated with the specified task, and that are stored in Rich Text Format.

TaskPhysicalPercentCompleted

The percentage complete value entered by the Project Manager.

TaskEAC

The EAC (estimate at completion) field shows theexpected total cost of a task based on performance up to the status date. EAC is also called forecast at completion (FAC).

TaskEarnedValueMethod

The method for calculating earned value. Values are: 0=Percent Complete, 1=Physical Percent Complete.

TaskTDModifyDate

Last datetime when task's timephased data was modified.

TaskOptIndex

Gets the Item ID of the task in the task list.

TaskIsNull

Specifies whether the task has no values set.

TaskIsDeletedInProject

Indicates if the task was deleted from the project.

TaskCostIsValid

Gets or sets a Boolean value that indicates whether the current field is the associated cost for the task.

TaskDeletedFlag

Indicates if the task was deleted.

TaskUpdatesConflict

True if the Project Manager updated this task and the updates might conflict with updates made by a team member.

TASK_IS_ROLLUP_ASSN

Indicates whether the task has rollup data for the assignment.

TASK_LOCKDOWN_BY_MANAGER

True if this task will not accept updates from team members.

TASK_EXT_TASK_UID

Specifies cross project tasks links.

TASK_EXT_PROJ_UID

Specifies cross project links.

TaskContact

Contact information for the task. 

TaskCPI

The CPI (cost performance index) fields show the ratio of budgeted (or baseline) costs of work performed to actual costs of work performed.

TaskCV

Task cost variance.

TaskHyperLinkFriendlyName

Shows the title or explanatory text for a hyperlink associated with a task.

TaskHyperLinkAddress

The URL or UNC path of a document.

TaskHyperLinkSubAddress

Contains the specific location in a document within a hyperlink associated with a task.

TaskNotes

Notes for the task.

TaskSPI

Often used to estimate the project completion date.

TaskSV

The cost difference between the current progress and the baseline plan of a task.

TaskTCPI

The TCPI (to complete performance index) field shows the ratio of the work remaining to be done to funds remaining to be spent, as of the status date.

TaskWorkVariance

The variance of task work from the baseline task work as minutes x 1000.

TaskCostVariance

Gets the difference in cost terms between the current progress and the baseline planned progress for a resource on the task.

TaskFinishSlack

Amount of finish slack.

TaskBudgetWork

The scheduled work for a task.

TaskBudgetCost

Gets the budget costs for budget cost resources.

TaskWinprojUniqueId

Indicates the unique identifier for the task used in Project client.

TaskStartSlack

Amount of start slack.

TaskCommitmentType

Specifies whether the task has an associated deliverable or a dependency on an associated deliverable. Values are: 0=The task has no deliverable or dependency on a deliverable, 1=The task has an associated deliverable, 2=The task has a dependency on an associated deliverable.

TaskCommitmentUid

Unique identifier for the commitment.

TaskCommitmentStart

Start date for the commitment.

TaskCommitmentFinish

End date for the commitment.

TaskIsActive

True if the task is active.

TaskDispSumary

The value of the property should be false. Reserved for future use.

TaskIsManual

True if the task is manual.

TaskDuration

The planned duration of the task

TaskDurationFormat

The format for expressing the duration of the task. Values are: 3=m, 4=em, 5=h, 6=eh, 7=d, 8=ed, 9=w, 10=ew, 11=mo, 12=emo, 19=%, 20=e%, 21=null, 35=m, 36=em, 37=h, 38=eh, 39=d, 40=ed, 41=w, 42=ew, 43=mo, 44=emo, 51=%, 52=e% and 53=null.

TaskStartDate

The scheduled start date of the task.

TaskFinishDate

The scheduled finish date of the task.

TaskDurationString

String used for task duration.

TaskStartString

String used for task finish.

TaskFinishString

String used for task start.

TaskCreatedDate

Date the task was created.

TaskModifiedDate

The date the task was last updated.

Assignments

The collection of assignments that make up the project.

Each Tasks object may have a collection of Assignments objects, which may have the following properties:

Object

Description

AssignmentUID

Unique identifier of the assignment.

TaskUID

Unique identifier of the task for the assignment.

TaskName

Name of the task for the assignment.

ProjectUid

Unique identifier of the project for the the task.

ResourceUid

Unique identifier of the resource assigned to the assignment.

ResourceName

Name of the resource assigned to the assignment.

AssignmentActualFinish

The actual finish date of the assignment.

AssignmentActualStart

The actual start date of the assignment.

AssignmentActualCostOfWorkPerformed

Gets the actual cost of work performed (ACWP) for the assignment to date.

AssignmentEarnedValue

Specifies the assignment's budgeted cost of work performed (BCWP).

AssignmentBCWS

The budgeted cost of work on the assignment.

AssignmentResourceType

The type of resource that is associated with an assignment. See Type enumeration.

AssignmentIsOverallocated

Whether the assignment is overallocated.

AssignmentWorkContour

The work contour of the assignment. Values are: 0=Flat, 1=Back Loaded, 2=Front Loaded, 3=Double Peak, 4=Early Peak, 5=Late Peak, 6=Bell, 7=Turtle, 8=Contoured.

AssignmentStartVariance

The variance of the assignment start date from the baseline start date.

AssignmentFinishVariance

The variance of the assignment finish date from the baseline finish date.

AssignmentUpdateNeeded

True if the resource assigned to a task needs to be updated as to the status of the task.

AssignmentHasLinkedFields

Whether the project is linked to another OLE object.

AssignmentIsPendingResponse

True if a response has not been received for a TeamAssign message.

AssignmentHasNotes

Has text notes associated with the assignment.

AssignmentTeamStatusPending

Indicates whether a status message has been received in response to a TeamStatus message sent to a resource assigned to a task.

AssignmentsStartDate

The scheduled start date of the assignment.

AssignmentFinishDate

The scheduled finish date of the assignment.

AssignmentDelay

The amount that the assignment is delayed

AssignmentDelayFormat

The format for expressing the duration of the delay. Values are: 3=m, 4=em, 5=h, 6=eh, 7=d, 8=ed, 9=w, 10=ew, 11=mo, 12=emo, 19=%, 20=e%, 21=null, 35=m, 36=em, 37=h, 38=eh, 39=d, 40=ed, 41=w, 42=ew, 43=mo, 44=emo, 51=%, 52=e% and 53=null.

AssignmentLevelingDelay

The delay caused by leveling.

AssignmentCostRateTable

The cost rate table used for the assignment.

AssignmentMaterialRateFormat

Indicates the units in which the bid is expressed in the project.

AssignmentUnits

The number of units for the assignment.

AssignmentWork

The amount of scheduled work for the assignment.

AssignmentActualWork

The actual amount of work incurred on the assignment.

AssignmentRegularWork

The amount of non-overtime work scheduled for the assignment.

AssignmentRemainingWork

The remaining work scheduled to complete the assignment.

AssignmentCost

The projected or scheduled cost of the assignment.

AssignmentActualCost

The actual cost incurred on the assignment.

AssignmentRemainingCost

The remaining projected cost of completing the assignment.

AssignmentOvertimeWork

The scheduled overtime work for the assignment.

AssignmentActualOvertimeWork

The actual amount of overtime work incurred on the assignment.

AssignmentRemainingOvertimeWork

The remaining overtime work scheduled to complete the assignment.

AssignmentOvertimeCost

The sum of the actual and remaining overtime cost of the assignment.

AssignmentRemainingOvertimeCost

The remaining projected overtime cost of completing the assignment.

AssignmentRTFNotes

Represents notes that are associated with the specified assignment, and that are stored in Rich Text Format.

AssignmentBookingType

Specifies the booking type of the assignment. 1=Commited, 2=Proposed.

AssignmentParentId

Unique identifier of the primary assignment.

AssignmentRemovedByResource

True if team member removed this resource.

StatusManagerUid

Unique identifier for the status manager.

StatusManagerName

Name of the status manager.

DefaultAssignmentOwnerUid

Unique identifier for the default assignment owner.

DefaultAssignmentOwnerName

Name of the default assignment owner.

AssignmentLastWork

The scheduled work from the last update from Project.

AssignmentsComments

The user's comments about the assignment.

AssignmentNoteStatus

Indicates whether a note has been entered for the assignment.

TaskIsSummary

Specifies whether the task is a summary task.

AssignmentIsConfirmed

Whether the Resource has accepted all of his or her assignments.

AssignmentUpdatedByManager

True if the assignment was updated by Project Manager.

AssignmentLockeByManager

True if this assignment doesn't accept update from team member anymore.

AssignmentCreatedByResourceId

Resource ID of the assignment creator.

CreatorName

Name of the assignment creator.

AssignmentCurrentTrackingMode

Indicates the current method used to track projects.

  • 0 - None (default)

  • 1 - Timephased actuals

  • 2 - Percent complete tracking

  • 3 - Total actual work and remaining work tracking

AssignmentUpdatedTrackingMode

Indicates the updated method used to track projects:

  • 0 - None (default)

  • 1 - Timephased actuals

  • 2 - Percent complete tracking

  • 3 - Total actual work and remaining work tracking

AssignmentNeedUpdatesSubmitted

True if there are saved update from team members for assignment.

AssignmentDeletedInProject

True if assignment was deleted from project.

AssignmentUpdatesByResource

True if the assignment was updated by team member.

AssignmentRequestsUpdates

Indicates whether a team resource has submitted actuals.

AssignmentUpdatesAccepted

True is status updates made for assignment where accepted.

AssignmentActualsPending

True if accepted updates are pending to be applied to the plan.

AssignmentDeletePending

True if delete for assignment is pending to be applied.

AssignmentIsDelegated

True if assignment was created by a reassign operation.

AssignmentIsNew

True if assignment is newly created for team member.

AssignmentUpdateStatus

Indicates the status of an assignment.

  • 0 - Not edited by resource.

  • 1 - Edited by resource but not updated to the project manager yet.

AssignmentPercentWorkCompleted

The amount of work completed on the assignment.

AssignmentAssignedToExisting

Indicates whether a new assignment has been created by a resource using the assign self to task feature.

AssignmentTDModifyDate

Last modified date for assignment timephased data

AssignmentResumeDate

The date that the assignment resumed.

AssignmentStopDate

The date that the assignment was stopped.

AssignmentIsPublished

True if assignment was published.

AssignmentDemandRequire

Indicates how to assign resources when using the resource substitution wizard.

AssignmentIsCostValid

Indicates whether or not the cost associated with the assignment has been approved.

AssignmentCostIsEdited

Indicates if the cost associated with this assignment was edited.

AssignmentOtherType

Indicates the type of assignment:

  • 0 - Regular

  • 1 - TaskOnlyWork

  • 2 - FixedCosts

  • 3 - FixedCostsAndTaskOnly

  • 4 - RegularUnassigned

AssignmentUpdatesConflict

True if there are conflicting updates for assignment

DeletedFlag

Indicates if the assignment was deleted.

AssignmentVAC

The difference between baseline cost and total cost.

AssignmentSV

Earned value schedule variance, through the project status date.

AssignmentWorkVariance

The variance of assignment work from the baseline work as minutes x 1000.

AssignmentCostVariance

The difference between the cost and baseline cost for a resource.

AssignmentBudgetWork

The budgeted work amount for work or material resources on this assignment.

AssignmentBudgetCost

The budgeted amount for cost resources on this assignment.

AssignmentTaskManagementFlags

Internal use only.

AssignmentIgnoreResourceCalendar

Indicates whether the resource calendar intersects with the task calendar.

AssignmentWinProjUniqueId

Indicates a unique identifier for the assignment used in Project client.

AssignmentRemovedFromTS

Indicates if the assignment was removed from the timesheet.

AssignmentCreatedDate

The date that the assignment was created.

AssignmentModifiedDate

The date that the assignment was last updated.

AssignmentSendUpdatesDate

The date and time that an assignment update was sent by the resource to a manager.

AssignmentSummaryProgress

Shows progress on a summary task based on progress on its subtasks and where these subtasks have been scheduled.

TeamLeadUid

Unique identifier for the team lead.

 TeamLeadName

Name of the team lead.

ReservedData1

Used to temporarily store calculated values.

ReservedData2

Used to temporarily store calculated values.

ReservedData3

Used to temporarily store calculated values.

AssignmentHyperlinkFriendlyName

The title or explanatory text for a hyperlink associated with an assignment.

AssignmentHyperlinkAddress

The URL or UNC path of a document.

AssignmentHyperlinkSubAddress

The specific location in a document within a hyperlink associated with a assignment.

AssignmentNotes

The notes that are entered in the assignment details dialog box.

AssignmentVAC

The difference between baseline cost and total cost.

Each Assignments object may have a collection of Timephased objects, which may have the following properties:

Properties

Description

AssignmentUID

Unique identifier for the assignement.

Date

Date the work started.

Work

Units of work scheduled for the assignment.

OvertimeWork

Units of overtime work scheduled for the assignment.

ActualWork

Actual units of work completed for the assignment.

ActualOvertimeWork

Actual units of overtime work completed for the assignment.

Each Assignments object may have a collection of CustomFields objects, which may have the following properties:

Property

Description

CustomFieldUid

Unique identifier for the custom field.

CustomFieldName

Name of the custom field.

AssignmentUid

Unique identifier for the assignment.

Type

Type of the custom field (can be number, text, cost, duration, date, fals, finish date, start date, etc.).

CustomFieldValue

Value properties for the custom field.

DurationFormat

Specifies the display format for the value if type is "duration".

LookupTableUid

Unique identifier for the lookup table.

IndicatorValue

Specifies the value of the custom field if the type of custom field is "indicator".

TaskStatus_AssignmentsSubmitted

TaskStatus_AssignmentsSubmitted contains data about status reports that the user .. This file will contain a collection of Tasks objects, which may have the following properties:

Properties

Description

TaskUid

Unique identifier of the task.

TaskPublishedUid

Name of the status report.

ProjectUid

Unique identifier of the project in which the task exists.

ProjectName

Name of the project in which the task exists.

TaskParentUid

Unique identifier of the parent task.

TaskACWP

The actual cost of work performed on the task to date.

TaskBCWP

The budgeted cost of work performed on the task to date.

TaskBCWS

The budgeted cost of work scheduled for the task.

TaskDurationVariance

Difference between the baseline duration and the total duration (current estimate) of a task.

TaskFinishVariance

The variance of the task finish date from the baseline finish date as minutes x 1000.

TaskOutlineNumber

The outline number of the task.

TaskStartVariance

Task start variance is the difference between a baseline start date and the currently scheduled start date.

TaskIsOverallocated

True if the task is overallocated.

TaskOvertimeWork

The amount of overtime work scheduled for the task

TaskVAC

Variance at completion.

TaskRegularWork

Total amount of non-overtime work scheduled for a task.

TaskTotalSlack

The amount of total slack.

TaskId

Unique identifier for the task.

TaskHasLinkedFields

True if the task has linked fields.

TaskIsMilestone

True if the task is a milestone.

TaskIsCritical

True if the task is in the critical chain.

TaskIsSummary

True if the task is a summary task.

TaskIsSubproject

True if the task is an inserted project.

TaskIsMarked

Indicates whether a task is marked for further action or identification of some kind.

TaskIgnoresResourceCalendar

True if the task ignores the resource calendar.

TaskIsRolledUp

True if the task is rolled up

TaskIsSubprojectScheduledFromFinish

Gets a value that indicates whether a subproject for this task is set to schedule from finish.

TaskBarIsHidden

True if the GANTT bar of the task is hidden when displayed in Microsoft Office Project.

TaskIsRecurring

True if the task is recurring.

TaskIsRecurringSummary

True if the task is a recurring summary task.

TaskIsExternal

True if the task is external.

TaskIsEffortDriven

True if the task is effort driven.

TaskIsCollapsed

True if task is displayed collapsed in Project client.

TaskHasNotes

True if text notes are associated with the task.

TaskIsSubprojectReadOnly

Gets a value that indicates whether a subproject for this task is read-only.

TaskLevelingCanSplit

True if leveling can split the task.

TaskCanSplit

Indicates whether the resource leveling function can cause splits on remaining work on this task. If this field is set to Yes, then leveling can interrupt this task. If this field is set to No, leveling cannot split the task .

TaskDurationIsEstimated

Indicates whether the task's duration is flagged as an estimate.

TaskEarlyFinish

The early finish date of the task.

TaskLateStart

The late start date of the task.

TaskStopDate

The date that the task was stopped.

TaskResumeDate

The date that the task was resumed.

TaskCompletedDate

The date argument for the task constraint type.

TaskFreeSlack

The amount of free slack.

TaskOutlineLevel

The outline level of the task.

TaskScheduledDuration

The scheduled duration of the task.

TaskScheduledDurationFormat

Gets the total span of active working time for the task as entered or as calculated based on the start date, the finish date, calendars, and other scheduling factors.

TaskActualDuration

The actual duration of the task.

TaskRemainingDuration

The amount of time required to complete the unfinished portion of the task.

TaskConstraintType

The constraint on the start or finish date of the task. Values are: 0=As Soon As Possible, 1=As Late As Possible, 2=Must Start On, 3=Must Finish On, 4=Start No Earlier Than, 5=Start No Later Than, 6=Finish No Earlier Than and 7=Finish No Later Than.

TaskLevelingDelay

The delay caused by leveling the task.

TaskLevelingDelayFormat

The format for expressing the duration of the delay. Values are: 3=m, 4=em, 5=h, 6=eh, 7=d, 8=ed, 9=w, 10=ew, 11=mo, 12=emo, 19=%, 20=e%, 21=null, 35=m, 36=em, 37=h, 38=eh, 39=d, 40=ed, 41=w, 42=ew, 43=mo, 44=emo, 51=%, 52=e% and 53=null.

TaskScheduledStart

The scheduled start date of the task.

TaskScheduledFinish

The scheduled finish date of the task.

TaskActualStart

The actual start date of the task.

TaskActualFinish

The actual finish date of the task.

TaskConstraintDate

The date associated with the constraint type.

TaskPriority

The priority of the task from 0 to 1000.

TaskPercentComplete

The percentage of the task duration completed.

TaskWorkPercentComplete

The percentage of the task work completed.

TaskType

The type of task. Values are: 0=Fixed Units, 1=Fixed Duration, 2=Fixed Work.

TaskFixedCostAccrual

How the fixed cost is accrued against the task. Values are: 1=Start, 2=Prorated and 3=End.

TaskPreleveledStart

Contains the start date of a task as it was before resource leveling was done.

TaskPreleveledFinish

Contains the end date of a task as it was before resource leveling was done.

TaskEarlyStart

The early start date of the task.

TaskLateFinish

The late finish date of the task.

TaskCalendarUid

The unique identifier of the calendar associated with a task.

TaskDeadline

 The final desired point in a task’s time length that the task must be completed by.

TaskWork

The amount of scheduled work for the task.

TaskActualWork

The actual work for the task.

TaskRemainingWork

The remaining work scheduled to complete the task

TaskCost

The projected or scheduled cost of the task.

TaskFixedCost

The fixed cost of the task.

TaskActualCost

The actual cost of the task.

TaskRemainingCost

The remaining projected cost of completing the task.

TaskActualOvertimeWork

The actual overtime work for the task.

TaskRemainingOvertimeWork

The remaining overtime work scheduled to finish the task.

TaskOvertimeCost

The sum of the actual and remaining overtime cost of the task.

TaskActualOvertimeCost

The actual overtime cost of the task.

TaskRemainifOvertimeCost

The remaining overtime cost projected to finish the task.

TaskWBS

The work breakdown structure (WBS) code of the task.

TaskName

The name of the task.

TaskHierarchy

The hierarchy of the task.

TaskRightMostLevel

Used in leveling.

TaskRTFNotes

Notes that are associated with the specified task, and that are stored in Rich Text Format.

TaskPhysicalPercentCompleted

The percentage complete value entered by the Project Manager.

TaskEAC

Shows the expected total cost of a task based on performance up to the status date. EAC is also called forecast at completion (FAC).

TaskEarnedValueMethod

The method for calculating earned value. Values are: 0=Percent Complete, 1=Physical Percent Complete.

TaskTDModifyDate

Last datetime when task's timephased data was modified.

TaskTDModifyCounter

Counter for modifying timephased data.

TaskStartOffset

Offset for the task start.

TaskReservedData

Used to temporarily store calculated values.

TaskOptIndex

Gets the Item ID of the task in the task list.

TaskSummaryProgressDate

Internal user only.

TaskIsNull

Specifies whether the task has no values set.

TaskIsDeletedInProject

Indicates if the task was deleted from the project.

TaskCostIsValid

Gets or sets a Boolean value that indicates whether the current field is the associated cost for the task.

TaskDeletedFlag

Indicates if the task was deleted.

TaskUpdatesConflict

True if the ProjectManager updated this task and the updates might conflict with updates made by a team member.

TASK_IS_ROLLUP_ASSN

Indicates whether the task has rollup data for the assignment.

TASK_LOCKDOWN_BY_MANAGER

True if this task will not accept updates from team members.

TASK_EXT_TASK_UID

Specifies cross project tasks links.

TASK_EXT_PROJ_UID

Specifies cross project links.

TaskContact

Contact for the task.

TaskCPI

The CPI (cost performance index) fields show the ratio of budgeted (or baseline) costs of work performed to actual costs of work performed.

TaskCV

Task cost variance.

TaskHyperLinkFriendlyName

Shows the title or explanatory text for a hyperlink associated with a task.

TaskHyperLinkAddress

The URL or UNC path of a document.

TaskHyperLinkSubAddress

Contains the specific location in a document within a hyperlink associated with a task.

TaskNotes

Notes for the task.

TaskSPI

SPI is often used to estimate the project completion date.

TaskSV

The cost difference between the current progress and the baseline plan of a task.

TaskTCPI

The TCPI (to complete performance index) field shows the ratio of the work remaining to be done to funds remaining to be spent, as of the status date.

TaskWorkVariance

The variance of task work from the baseline task work as minutes x 1000.

TaskCostVariance

Gets the difference in cost terms between the current progress and the baseline planned progress for a resource on the task.

TaskFinishSlack

Amount of finish slack.

TaskBudgetWork

The scheduled work.

TaskBudgetCost

Gets the budget costs for budget cost resources.

TaskWinprojUniqueId

Indicates the unique identifier for the task used in Project client.

TaskStartSlack

Amount of start slack.

TaskCommitmentType

Specifies whether the task has an associated deliverable or a dependency on an associated deliverable. Values are: 0=The task has no deliverable or dependency on a deliverable, 1=The task has an associated deliverable, 2=The task has a dependency on an associated deliverable.

TaskCommitmentUid

Unique identifier for the commitment.

TaskCommitmentStart

Start date for the commitment.

TaskCommitmentFinish

End date for the commitment.

TaskIsActive

True if the task is active.

TaskDispSumary

The value of the property should be false. Reserved for future use.

TaskIsManual

True if the task is manual.

TaskDuration

The planned duration of the task

TaskDurationFormat

The format for expressing the duration of the task. Values are: 3=m, 4=em, 5=h, 6=eh, 7=d, 8=ed, 9=w, 10=ew, 11=mo, 12=emo, 19=%, 20=e%, 21=null, 35=m, 36=em, 37=h, 38=eh, 39=d, 40=ed, 41=w, 42=ew, 43=mo, 44=emo, 51=%, 52=e% and 53=null.

TaskStartDate

The scheduled start date of the task.

TaskFinishDate

The scheduled finish date of the task.

TaskDurationString

String used for task duration.

TaskStartString

String used for task finish.

TaskFinishString

String used for task start.

TaskCreatedDate

The date the task was created.

TaskModifiedDate

The date the task was last updated.

Assignments

The collection of assignments that make up the project.

Each Tasks object may have a collection of Assignments objects, which may have the following properties:

Object

Description

AssignmentUID

Unique identifier of the assignment.

TaskUID

Unique identifier of the task for the assignment.

TaskName

Name of the task for the assignment.

ProjectUid

Unique identifier of the project for the task.

ResourceUid

Unique identifier of the resource assigned to the assignment.

ResourceName

Name of the resource assigned to the assignment.

ReservedData

Used to temporarily store calculated values.

ProjectSummaryAssignmentID

Unique identifier of the project summary assignment.

AssignmentActualFinish

The actual finish date of the assignment.

AssignmentActualStart

The actual start date of the assignment.

AssignmentActualCostOfWorkPerformed

Gets the actual cost of work performed (ACWP) for the assignment to date.

AssignmentEarnedValue

Specifies the assignment's budgeted cost of work performed (BCWP).

AssignmentBCWS

The budgeted cost of work on the assignment.

AssignmentResourceType

The type of resource that is associated with an assignment. See Type enumeration.

AssignmentIsOverallocated

Whether the assignment is overallocated.

AssignmentWorkContour

The work contour of the assignment. Values are: 0=Flat, 1=Back Loaded, 2=Front Loaded, 3=Double Peak, 4=Early Peak, 5=Late Peak, 6=Bell, 7=Turtle, 8=Contoured.

AssignmentStartVariance

The variance of the assignment start date from the baseline start date.

AssignmentFinishVariance

The variance of the assignment finish date from the baseline finish date.

AssignmentUpdateNeeded

True if the resource assigned to a task needs to be updated as to the status of the task.

AssignmentHasLinkedFields

Whether the project is linked to another OLE object.

AssignmentIsConfirmed

Yes if the value is con

AssignmentIsPendingResponse

True if a response has not been received for a TeamAssign message.

AssignmentHasNotes

Has text notes associated with the assignment.

AssignmentTeamStatusPending

Indicates whether a status message has been received in response to a TeamStatus message sent to a resource assigned to a task.

AssignmentsStartDate

The scheduled start date of the assignment.

AssignmentFinishDate

The scheduled finish date of the assignment.

AssignmentDelay

The amount that the assignment is delayed

AssignmentDelayFormat

The format for expressing the duration of the delay. Values are: 3=m, 4=em, 5=h, 6=eh, 7=d, 8=ed, 9=w, 10=ew, 11=mo, 12=emo, 19=%, 20=e%, 21=null, 35=m, 36=em, 37=h, 38=eh, 39=d, 40=ed, 41=w, 42=ew, 43=mo, 44=emo, 51=%, 52=e% and 53=null.

AssignmentLevelingDelay

The delay caused by leveling.

AssignmentCostRateTable

The cost rate table used for the assignment.

AssignmentMaterialRateFormat

Indicates the units in which the bid was expressed in the project.

AssignmentUnits

The number of units for the assignment.

AssignmentWork

The amount of scheduled work for the assignment.

AssignmentActualWork

The actual amount of work incurred on the assignment.

AssignmentRegularWork

The amount of non-overtime work scheduled for the assignment.

AssignmentRemainingWork

The remaining work scheduled to complete the assignment.

AssignmentCost

The projected or scheduled cost of the assignment.

AssignmentActualCost

The actual cost incurred on the assignment.

AssignmentRemainingCost

The remaining projected cost of completing the assignment.

AssignmentOvertimeWork

The scheduled overtime work for the assignment.

AssignmentActualOvertimeWork

The actual amount of overtime work incurred on the assignment.

AssignmentRemainingOvertimeWork

The remaining overtime work scheduled to complete the assignment.

AssignmentOvertimeCost

The sum of the actual and remaining overtime cost of the assignment.

AssignmentRemainingOvertimeCost

The remaining projected overtime cost of completing the assignment.

AssignmentRTFNotes

Represents notes that are associated with the specified assignment, and that are stored in Rich Text Format.

AssignmentBookingType

Specifies the booking type of the assignment. 1=Commited, 2=Proposed.

AssignmentParentId

Unique identifier of the primary assignment.

AssignmentRemovedByResource

True if team member removed this resource.

StatusManagerUid

Unique identifier for the status manager.

StatusManagerName

Name of the status manager.

DefaultAssignmentOwnerUid

Unique identifier for the default assignment owner.

DefaultAssignmentOwnerName

Name of the default assignment owner.

AssignmentLastWork

The scheduled work from the last update from Project.

AssignmentsComments

The user's comments about the assignment.

HistoryNotes

AssignmentNoteStatus

Indicates whether a note has been entered for the assignment.

TaskIsSummary

Specifies whether the task is a summary task.

AssignmentIsConfirmed

Whether the Resource has accepted all of his or her assignments.

AssignmentUpdatedByManager

True if the assignment was updated by Project Manager.

AssignmentLockeByManager

True if this assignment doesn't accept update from team member anymore.

AssignmentCreatedByResourceId

Resource ID of the assignment creator.

CreatorName

Name of the assignment creator.

AssignmentCurrentTrackingMode

Indicates the current method used to track projects:

  • 0 - None (default)

  • 1 - Timephased actuals

  • 2 - Percent complete tracking

  • 3 - Total actual work and remaining work tracking

AssignmentUpdatedTrackingMode

Indicates the updated method used to track projects:

  • 0 - None (default)

  • 1 - Timephased actuals

  • 2 - Percent complete tracking

  • 3 - Total actual work and remaining work tracking

AssignmentNeedUpdatesSubmitted

True if there are saved update from team members for this assignment.

AssignmentDeletedInProject

True if assignment was deleted from project.

AssignmentUpdatesByResource

True if the assignment was updated by team member.

AssignmentRequestsUpdates

Indicates whether a team resource has submitted actuals.

AssignmentUpdatesAccepted

True is status updates made for assignment where accepted.

AssignmentActualsPending

True if accepted updates are pending to be applied to the plan.

AssignmentDeletePending

True if delete for assignment is pending to be applied.

AssignmentIsDelegated

True if assignment was created by a reassign operation.

AssignmentIsNew

True if assignment is newly created for team member.

AssignmentUpdateStatus

Indicates the status of an assignment: 0 - Not edited by resource. 1 - Edited by resource but not updated to the project manager yet.

AssignmentLastDelegationId

The last delegation performed on this assignment.

AssignmentPercentWorkCompleted

The amount of work completed on the assignment.

AssignmentSendUpdatesDate

The date and time that an assignment update was sent by the resource to a manager.

AssignmentSummaryProgress

Shows progress on a summary task based on progress on its subtasks and where these subtasks have been scheduled.

TeamLeadUid

Unique identifier of the team lead.

TeamLeadName

Name of the team lead.

WNWRK_UID

Internal use only.

WNWORK_ENTRY_UID

Internal use only.

AssignmentAssignedToExisting

Indicates whether a new assignment has been created by a resource using the assign self to task feature.

ReservedData1

Used to temporarily store calculated values.

ReservedData2

Used to temporarily store calculated values.

ReservedData3

Used to temporarily store calculated values.

AssignmentTDModifyDate

Last modified date for assignment timephased data.

AssignmentTDModifiedCounter

Counter for modified timephased data for an assignment.

AssignmentResumeDate

The date that the assignment resumed.

AssignmentStopDate

The date that the assignment was stopped.

AssignmentIsPublished

True if assignment is published.

AssignmentDemandRequire

Indicates how to assign resources when using the resource substitution wizard.

AssignmentIsCostValid

Indicates whether or not the cost associated with the assignment has been approved.

AssignmentCostIsEdited

Indicates if the cost associated with this assignment was edited.

AssignmentOtherType

Indicates the type of assignment:

  • 0 - Regular

  • 1 - TaskOnlyWork

  • 2 - FixedCosts

  • 3 - FixedCostsAndTaskOnly

  • 4 - RegularUnassigned

AssignmentUpdatesConflict

True if there are conflicting updates for assignment

DeletedFlag

Indicates if the assignment was deleted.

AssignmentCV

Earned value cost variance.

AssignmentHyperlinkFriendlyName

The title or explanatory text for a hyperlink associated with an assignment.

AssignmentHyperlinkAddress

The URL or UNC path of a document.

AssignmentHyperlinkSubAddress

The specific location in a document within a hyperlink associated with a assignment.

AssignmentNotes

The notes that are entered in the assignment details dialog box.

AssignmentVAC

The difference between baseline cost and total cost.

AssignmentSV

Earned value schedule variance, through the project status date.

AssignmentWorkVariance

The variance of assignment work from the baseline work as minutes x 1000.

AssignmentCostVariance

The difference between the cost and baseline cost for a resource.

AssignmentBudgetWork

The budgeted work amount for work or material resources on this assignment.

AssignmentBudgetCost

The budgeted amount for cost resources on this assignment.

AssignmentTaskManagementFlags

Internal use only.

AssignmentIgnoreResourceCalendar

Indicates whether the resource calendar intersects with the task calendar.

AssignmentWinProjUniqueId

Indicates a unique identifier for the assignment used in Project client.

AssignmentRemovedFromTS

Indicates if the assignment was removed from the timesheet.

AssignmentCreatedDate

The date that the assignment was created.

AssignmentModifiedDate

The date that the assignment was last updated.

Each Assignments object may have a collection of CustomFields objects, which may have the following properties:

Property

Description

CustomFieldUid

Unique identifier for the custom field.

CustomFieldName

Name of the custom field.

AssignmentUid

Unique identifier for the assignment.

Type

Type of the custom field (can be number, text, cost, duration, date, fals, finish date, start date, etc.).

CustomFieldValue

Value properties for the custom field.

DurationFormat

Specifies the display format for the value if type is "duration".

LookupTableUid

Unique identifier for the lookup table.

IndicatorValue

Specifies the value of the custom field if the type of custom field is "indicator".

Timesheets

Timesheets contains data about timesheets the user owns or is a part of. For each timesheet, you will see the following objects:

Object

Description

TimesheetUID

Unique identifier for the timesheet.

TimesheetName

Name of the timesheet.

TimesheetOwnerID

The unique identifier for the owner of the timesheet.

TimesheetOwner

The owner of the timesheet.

StatusID

The value associated with the timesheet status (see Status).

Status

The status of the timesheet.

PeriodName

The name of the timesheet period.

StartDate

The start date and time of the timesheet.

EndDate

The end date and time for the timesheet.

PeriodUID

The unique identifier for the timesheet period.

PeriodStatusID

The status identifier of the timesheet period (open, closed, or all periods).

PeriodStatus

The status of the timesheet period.

Comment

Comment details.

ModifiedDate

The date and time that the timesheet was last modified.

CreatedDate

The date and time that the timesheet was created.

A Timesheets object can have a collection of Lines objects, which may have the following properties:

Property

Description

TimesheetUID

Unique identifier for the timesheet.

TimesheetLineId

Unique identifier for the timesheet line item.

AssignmentUID

Unique identifier for the assignment.

LastSavedWork

Amount of Actual Work for the timesheet line item.

CreatedDate

Time and date of when the line item was created.

ModifiedDate

Time and date of when the line item was last modified.

ProjectId

Unique identifier of the project.

ProjectName

Name of the project.

TaskId

Unique identifier for the task.

TaskName

Name of the task.

TimesheetApproverResourceID

Name of the Timesheet Approver.

TimesheetApproverResourceName

Resource ID of the Timesheet Approver.

TimesheetClassDescription

The description of the timesheet class (for example, to describe its purpose as the recording of sick time or vacation time).

TimesheetClassId

Unique identifier of the timesheet line class.

TimesheetClassName

The name of the timesheet line class.

TimesheetClassType

The type of the timesheet class (for example, sick time or vacation time).

TimesheetLineComment

The text comment for the timesheet line.

TimesheetLineStatus

The status of the timesheet line.

TimesheetLineStatusId

Unique identifier for the timesheet line status (see the corresponding TimesheetLineStatus value).

Each Lines object can have a collection of Actuals objects. Each Actuals object may have the following properties:

Property

Description

TimesheetUID

Unique identifier for the timesheet.

TimesheetLineId

Unique identifier for the timesheet line.

ActualOvertimeWorkBillable

The actual billable overtime work that has already been performed by resources assigned to tasks.

ActualOvertimeWorkNonBillable

The actual non-billable overtime work that has already been performed by resources assigned to tasks.

ActualWorkBillable

The actual billable amount of regular, non-overtime work that has already been performed by resources assigned to tasks.

ActualWorkNonBillable

The actual non-billable amount of regular, non-overtime work that has already been performed by resources assigned to tasks.

Comment

Comment details.

CreatedDate

The date and time that the timesheet actual was created.

PlannedWork

The estimated amount of work.

StartDate

Start date of the period.

EndDate

End date of the period.

TimesheetLineModifiedDate

Time and date the line was last updated.

A Lines object can have a collection of CustomFields objects, which may have the following properties:

Property

Description

TimeSheetLineID

Unique identifier for the timesheet line.

CustomFieldUID

Unique identifier for the custom field value.

CustomFieldName

Name of the custom field.

Timesheets_Reporting

Timesheets_Reporting contains timesheet data for the user from the reporting schema. For each Timesheets object, you will see the following properties:

Property

Description

TimesheetUID

Unique identifier for the timesheet.

TimesheetName

Name of the timesheet.

TimesheetOwnerId

Unique identifier for the timesheet owner.

TimesheetOwner

Name of the timesheet owner.

StatusDescription

Status of the timesheet.

PeriodName

Name of the period.

StartDate

Start date of the period.

EndDate

End date of the period.

PeriodUID

Unique identifier for the period.

PeriodStatusID

Unique identifier for the period status.

PeriodStatus

The status of the timesheet period.

Comment

Comment details.

ModifiedDate

Time and date the timesheet was last modified.

Each Timesheets object can have a collection of Line objects. Each Line object may have the following properties:

Property

Description

TimesheetUID

Unique identifier for the timesheet.

TimesheetLineId

Unique identifier for the timesheet line item.

ActualOvertimeWorkBillable

The actual billable overtime work that has already been performed by resources assigned to tasks.

ActualOvertimeWorkNonBillable

The actual non-billable overtime work that has already been performed by resources assigned to tasks.

ActualWorkBillable

The actual billable amount of regular, non-overtime work that has already been performed by resources assigned to tasks.

ActualWorkNonBillable

The actual non-billable amount of regular, non-overtime work that has already been performed by resources assigned to tasks.

PlannedWork

The estimated amount of work.

AssignmentUID

Unique identifier for the assignment.

LastSavedWork

Unique identifier for the workflow stage.

CreatedDate

Time and date of when the line item was created.

ModifiedDate

Time and date of when the line item was last modified.

ProjectId

Unique identifier of the project.

ProjectName

Name of the project.

TaskId

Unique identifier for the task.

TaskName

Name of the task.

TaskHierarchy

The hierarchical list of tasks for a project.

TimesheetApproverResourceId

Resource ID of the timesheet approver.

TimesheetApproverResourceName

Name of the timesheet approver.

TimesheetClassDescription

The description of the timesheet class (for example, to describe its purpose as the recording of sick time or vacation time).

TimesheetClassId

Unique identifier of the timesheet class.

TimesheetClassName

The name of the timesheet class.

TimesheetClassType

The type of the timesheet class (for example, sick time or vacation time).

TimesheetLineComment

The text comment for the timesheet line.

TimesheetLineStatus

The status of the timesheet line.

TimesheetLineStatusId

Unique identifier for the timesheet line status (see the corresponding TimesheetLineStatus value).

Each Timesheets object can have a collection of Actuals objects. Each Actuals object may have the following properties:

Property

Description

TimesheetLineId

Unique identifier for the timesheet line.

ActualOvertimeWorkBillable

The actual billable overtime work that has already been performed by resources assigned to tasks.

ActualOvertimeWorkNonBillable

The actual non-billable overtime work that has already been performed by resources assigned to tasks.

ActualWorkBillable

The actual billable amount of regular, non-overtime work that has already been performed by resources assigned to tasks.

ActualWorkNonBillable

The actual non-billable amount of regular, non-overtime work that has already been performed by resources assigned to tasks.

AdjustmentIndex

The timesheet actual adjustment index.

Comment

Comment details.

CreatedDate

The date and time that the timesheet line was created.

LastChangedResourceName

Name of the resource that last modified the line.

PlannedWork

The estimated amount of work.

TimeByDay

Date and time for the data, for example, 2013-03-29 00:00:00.000.

TimeByDay_DayOfMonth

Day of the month (1 - 31) for time by day calculation.

TimeByDay_DayOfWeek

Day of the week (1 - 7) for time by day calculation.

TimesheetLineModifiedDate

Time and date the line was last updated.

Each Actuals object can have a collection of CustomFields objects. Each CustomFields object may have the following properties:

Property

Description

CustomFieldId

Unique identifier for the custom field.

CustomFieldName

Name of the resource.

TimesheetUID

Unique identifier for the timesheet.

TimesheetLineId

Unique identifier for the timesheet line item.

CustomFieldValue

Values for the custom field.

UnsubscribedAlerts

UnsubscribedAlerts contains data about alert notifications unsubscribed by the user. For each UnsubscribedAlertData object, you will see the following properties:

Property

Description

Id

Unique identifier for the alert.

AlertName

Name of the alert.

UserViewSettings

Note: The information in this section applies to Project Server 2016, Project Server 2013, and Project Online. For Project Server 2010, see the UserViewSettings for Project Server 2010.

UserViewSettings contains data about custom view settings that the user created. You can see properties for the following objects:

  • WebControlSettings: User settings for web controls in different pages.

  • WebControlResourcePlanEngagementSettings: : User settings for web controls in the resource plan engagement pages.

  • ViewSettings: User settings in different views across the product.

  • LastPDPViewed: Information about the last Project Detail Page that was viewed for a particular project.

  • UserSettings: Settings customized by the user.

  • OptimizerPlannerPlannerReqPages: Settings customized on the Optimizer, Planner and Planner Request pages.

  • PlannerDefPlannerResPlannerAvailPages: Settings customized on the Planner Deficit, Planner Resource, Planner Availability pages.

  • PortfolioAnalysisGridSettings: Settings customized on the Portfolio Analysis Grid.

  • OtherWebSettings: Other settings customized on web pages.

WebControlSettings objects can have the following following properties:

Property

Description

WebControl

Web control type (for example, resourcecenter).

PropertyName

Name of the property.

PropertyValue

Value of the property.

WebControlResourcePlanEngagementSettings objects can have the following properties:

Property

Description

WebControl

Web control type (for example, resourcecenter).

PropertyName

Name of the property.

ProjectId

Unique identifier for the project.

ProjectName

Name of the project.

PropertyValue

Value of the property.

ViewSettings objects can have following properties:

Property

Description

ViewId

The unique identifier for the view.

ViewName

Name of the view.

PropertyName

Name of the property.

PropertyValue

Value of the property.

LastPDPViewed objects can have the following properties:

Property

Description

ProjectId

The unique identifier for the project.

PropertyName

Name of the property.

PropertyString

String representing value of the property

PropertyData

The binary representation of the property string

PropertyValue

Value of the property.

UserSettings objects can have the following properties:

Property

Description

ProjectId

The unique identifier for the project.

SettingKey

Key of the user setting stored in the database.

PropertyString

String representing value of the property

PropertyName

Name of the property.

PropertyValue

Value of the property.

PropertyData

The binary representation of the property string

OptimizerPlannerPlannerReqPages objects can have the following properties:

Property

Description

PageName

Name of the page.

AnalysisUid

Unique identifier of the analysis.

AnalysisName

Name of the analysis.

ViewUid

Unique identifier of the view

ViewName

Name of the view.

PropertyName

Name of the property.

PropertyValue

Value of the property.

For each PlannerDefPlannerResPlannerAvailPages object, you will see the following properties:

Property

Description

PageName

Name of the page.

AnalysisUid

Unique identifier of the analysis.

AnalysisName

The name of the analysis.

PropertyName

Name of the property.

PropertyValue

Value of the property.

PortfolioAnalysisGridSettings objects can have the following properties:

Property

Description

PageUrl

URL of the page.

AnalysisId

The unique identifier of the analysis.

AnalysisName

The name of the analysis.

PropertyName

Name of the property.

PropertyValue

Value of the property.

OtherWebSettings objects can have the following properties:

Property

Description

SettingKey

Unique key that describes the user setting data being stored.

PropertyName

Name of the property.

PropertyValue

Value of the property.

PropertyData

The binary representation of the property string

PropertyName and PropertyValue properties

You may see the following properties for the above objects for the PropertyName and corresponding PropertyValue properties:

Property

Description

ViewUid

Unique identifier of the view

JSGridWidth

Width of the displayed grid (value in pixels).

SelectedResourceIds

Unique identifiers of resources selected last on the grid.

SelectedResources

Unique identifiers of resources selected last on the grid.

TimeStampUID

A sequential guid that updates every time the view is initialized.

Duration

Selected value of duration for display on the grid. Values are:

-1 -Invalid, -2 -The duration is an estimate, 1 -Seconds, 2 -Elapsed seconds, 3 -Minutes, 4 -Elapsed minutes, 5 -Hours, 6 -Elapsed Hours, 7 -Days, 8 -Elapsed days, 9 -Weeks, 10 -Elapsed Weeks, 11 -Months, 12 -Elapsed Months, 13 -Quarters, 14 -Elapsed Quarters, 15 -Years, 16 -Elapsed Years, 17 -Decades, 18 -Elapsed Decades, 19 -Percent, 20 -Elapsed Percent, 21 -No Units, 22 -Material Usage

Date

The date format used. Values are:

1 – ShortDate, 2 – ShortTime, 3 – ShortDateTime, 4 – LongDate, 5 – LongDateTime, 6 – WeekDayMonth, 7 – MonthDay, 8 – YearMonth, 9 – Sortable, 10 – SmartShortDateTime, 10 – GeneralLongDateTime

ProjectTeamJsGridFields

Contains key value pairs of the fields on the grid.

ExpandSubProjects

If true, subprojects are expanded in the UI.

GanttZoomLevel

Level to which Gantt is zoomed in for display. Goes from most zoomed in to most zoomed out: 0 - Minute, 1 – Hour longdate, 2 - Hour shortdate, 3 – Day with the shortest day name, 4 – Day with the day Year Month listed, 5 – Day with the day year month listed, 6 – Month, 7 - Month, 8 - Quarter, 9 – Half year

PredefinedFilter

Value of current filtering. Values are: 0 – All, 1 – Overdue, 2 – Newly Assigned, 3- Completed, 4 – Incomplete, 5 - Custom

DefaultLayout

Default layout of the page. Values are: 0- None, 1- Gantt, 2- Timephased

ZoomLevel

Zoom level from most zoomed in to most zoomed out : 0- Minute, 1 – Hour longdate, 2- Hour shortdate, 3 – Day with the shortest day name, 4 – Day with the day Year Month listed, 5 – Day with the day year month listed, 6 – Month, 7 - Month, 8 - Quarter, 9 – Half year

DividerPosition

Position of JsGrid splitter in pixels.

GroupBy0

Field to group by.

GroupBy1

Field to group by.

GroupBy2

Field to group by.

SortBy

Field to sort by.

SortByOrder

0 – Ascending, 1 - Descending

ViewOutlineLevel

If value is -1, expand all, except for subprojects. If value is any other number, set that outline level expanded.

FilterBy

Column to filter by.

SelectedFilterId

Field selected to filter.

JSGridFields

Contains key-value pairs describing the settings used to display the Grid in the user interface.

ShowTimeWithDates

If true, time is displayed with dates. If false, they are not.

PrincipalColumnWidth

Width of principal column in pixels.

CategoryColumnWidth

Width of category column in pixels.

IsSidebarHidden

Set to true if sidebar is hidden, false if not.

IsViewBubbleChart

If true, cost constraint analysis chart is displayed. If false, the grid is displayed.

IsViewSBAChart

If true, Strategic Business Alignment Chart is displayed. If false, Efficient Frontier chart is displayed.

IsHighlightDeficit

If true, the Highlight Deficit option is checked. If false, it is not.

ProjUid

Unique identifier of project.

IncludeProposedBookings

True to include proposed bookings in the data displayed on grid, false otherwise.

WorkUnits

Determine work units for the grid. Values are: 0- Hours, 1 – Days, 2- Full Time Equivalent

TimeScale

Determines time scale for the grid. Values are: 3 – Days, 4- Weeks, 5- Months, 6- Quarters, 7 - Years

SelectedViewType

Determines the view type. Values are: 0 – AssignmentsByResource, 1 – AssignmentsByProject, 2- Availability, 3 – Work, 4 - HeatMapCapacityEngagement

DateEarliestSerialized

Represents start date of the view on Capacity Planning page.

DateLatestSerialized

Represents the end date of the view on Capacity Planning page.

UpperThreshold

Value of upper threshold on Capacity Planning page.

LowerThreshold

Value of lower threshold on Capacity Planning page.

FromDate

Start date of the view in the grid.

ToDate

End date of the view in grid.

IncludeProposed

If true, Include Proposed booking is checked. If false, it is not.

TabExpanded

If true, the filter tab is expanded on the Timesheet History page.

DateFilterChecked

If true, the date filter is checked on the Timesheet page.

ResourceFilterChecked

If true, the Resource Filter option is checked on the Timesheet page.

StartDate

Date when view starts.

FinishDate

Date when view ends.

FilterMode

Determines which timesheets are displayed. Values are: 1 – Show unsubmitted timesheets, 2- Show approved timesheets, 3- Show all timesheets

CustomFilterSelected

If true, a custom filter is selected.

SelectedResource

Numeric identifier of the resource selected last on the grid.

SelectedFiscalPeriod

Index of the fiscal period selected from the Fiscal Period dropdown menu.

ShowTimeWithDate

If true, time is displayed with dates.

ShowInsertedProjects

If true, inserted projects will display.

ShowRollups

If true, rollups will display.

ShowGanttChart

If true, Gantt chart will display.

ShowProjectSummaryTask

If true, project summary task will display on grid.

ViewSelection

Whether the view displays InProgressAndFailedJobsInThePastWeek/AllInProgressAndFailedJobs/SuccessfulJobsInThePastWeek/AllSuccessfulJobs/AllJobsInThePastWeek/AllJobs TimePhasedPane..

TimePhasedPane

If true, the Timephased pane will display.

IncludeSummaryTasks

If true, summary tasks will display.

ShowOvertimeWork

If true, overtime work will display.

ShowScheduledWork

If true, scheduled work will display.

ShowSelectedList

If true, selected resources list will display.

Timephased

If true, the Timephased grid will be visible.

Proposed

If true, the proposed values will display.

Planned

If true, planned work will display.

Overtime

If true, overtime work will display.

NonBillable

If true, non-billable work will display.

CommentOnSubmit

If true, comment dialog will display on submit of timesheet.

ShowTotals

If true, total work will display.

TimephasedStart

ECMA Date representation of the start date of timephased data.

TimephasedEnd

ECMA Date representation of the end date of timephased data.

showPlanned

If true, planned work will display.

showOvt

If true, overtime work will display.

showNonBill

If true, non-billable work will display.

dateFormat

The format of date values: 1 - ShortDate, 2 - ShortTime, 3 - ShortDateTime, 4 -LongDate, 5 - LongDateTime, 6 - WeekdayDayMonth, 7 - MonthDay, 8 - YearMonth, 9 - Sortable, 10 - SmartShortDateTime, 11 - General LongDateTime

durationFormat

-1 - Invalid, -2 - SwitchToEstimatedDuration , 1 - Seconds, 2 - ElapsedSeconds, 3 - Minutes, 4 - ElapsedMinutes, 5 - Hours, 6 - ElapsedHours, 7 - Days, 8 - ElapsedDays, 9 - Weeks, 10 - ElapsedWeeks, 11 - Months, 12 - ElapsedMonths, 13 - Quarters, 14 - ElapsedQuarters, 15 - Years, 16 - ElapsedYears, 17 - Decades, 18 - ElapsedDecades, 19 - Percent, 20 - ElapsedPercent, 21 - None, 22 - Material

workFormat

-1 - Invalid, -2 - None , 0 - Seconds, 1 - Minutes, 2 - Hours, 3 - Days, 4 - Weeks, 5 - Months, 6 - Quarters, 7 - Years, 8 - Decades, 9 - Material

filterType

0 – All, Overdue – 1, NewlyAssigned – 2, Completed – 3, Incomplete - 4

projUids

List of projects selected for the resource constraint filter.

roleUids

List of roles selected for the resource constraint filter.

UseDate

If true, the Filter By Date checkbox is checked on the Manage Delegations page.

UseResource

If true, the Filter By Users checkbox is checked on the Manage Delegations page.

UseWeek

If true, the Only show delegates covering this week option is checked.

UseSelfDelegates

If true, the Only show delegates acting on my behalf checkbox is checked.

UseNamedDelegate

If true, the Delegate name checkbox is checked.

UseActingFor

If true, the Delegate name who is acting for option is checked.

UseDateRange

If true, the Date range checkbox is checked.

DelegateUid

Unique identifier that represents the currently filtered delegate.

ActingForUid

Unique identifier of the user that the delegation is on behalf of.

DelegateName

Name of the delegate.

ActingForName

Name of delegatee.

FilterVisible

If true, the filter options will display.

GridTimeScaleUnits

0- Hours, 1 – Days, 2- Full Time Equivalent

DateRangeFrom

Start date of data displayed in the view.

DateRangeTo

End date of data displayed in the view.

DateRangeUnits

Units used for date range display on grid. Values are: 0- seconds, 1- minutes, 2- hours, 3- days, 4- weeks, 5 – months, 6- quarters, 7 - years

UserViewSettings for Project Server 2010

Note: This section include information about UserViewSettings data in Project Server 2010. For information about Project Server 2016, Project Server 2013, or Project Online, see the previous section (UserViewSettings).

UserViewSettings contains data about custom view settings that the user created. Objects can have the following properties:

Property

Description

PropertyName

Name of the property.

PropertyValue

Value of the property.

The custom view objects include the following:

  • WebControlSettings: These are user settings for web controls in different pages. These web controls include the following:

    Name

    Web Control

    teambuilderhometab

    Team Builder

    teambuilderjsgridcontrol

    Team Builder

    effectiverightsgrid

    Effective Rights

    eptjsgridcontrol

    Enterprise Project Types

    projectcenterjsgridcontrol

    Project Center

    projectdrilldownjsgridcontrol

    Schedule Page

    resourceassignmentsjsgridcontrol

    Resource Assignments

    resourcecenterjsgridcontrol

    Resource Center

    resourcerequestsjsgridcontrol

    Resource Requests

    reviewtsdetailpartjsgridcontrol

    Review Timesheet

    selecttasksfortlgrid

    Select tasks for Timeline

    statusapprovalshistorypage

    Status Approval History

    approvalcenterjsgridcontrol

    Approvals

    statusapprovalspreviewjsgridcontrol

    Status Approvals Review

    mytasksjsgridcontrol

    My Tasks

    teamtasksjsgridcontrol

    Team Assignments

    timesheetpartjsgridcontrol

    Timesheets

    In the export data for Project Server 2010, WebControlSettings data will display the name of the web control after the actual property for the control. For example, the following is a Date property for the MyTasksJSGridControl, which has a value of 1.

     	{
     	        "PropertyName":  "DateMyTasksJSGridControl",
     	        "PropertyValue":  "1"
     	    },
    
  • WebControlResourcePlanEngagementSettings: : These are user settings for web controls in the resource plan engagement pages. If the PropertyName contains ResPlanGrid or ProjectEngagementsGrid, then the GUID in the PropertyName is the Project Unique Identifier (PROJ_UID). You can retrieve the corresponding project name from the MSP_PROJECTS table in the Project Server 2010 Published database.

  • ViewSettings: These are user settings in different views across the product. If the PropertyName looks like it contains just one GUID, then that GUID is the View Identifier (WVIEW_UID) from the MSP_WEB_VIEW_REPORTS table in the Project Server 2010 Published database, and the corresponding view name is stored in the WVIEW_NAME.

    The actual property name will display before the GUID value.

    In the following example, the View unique identifier is 000010fc-7b06-45a9-9bd2-1cbfc2f64ce4 and the property name is DividerPosition.

     	{
     	        "PropertyName":  "DividerPosition000010fc-7b06-45a9-9bd2-1cbfc2f64ce4",
     	        "PropertyValue":  "0"
     	    },
    
  • LastPDPViewed: This provides information about the last Project Detail Page that was viewed for a particular project. The unique identifier of the corresponding project (PROJ_UID) is displayed after the string PDPPages_LastViewed_PDP_For. Also, the project name (PROJ_NAME) can be obtained from the MSP_PROJECTS table in the Project Server 2010 Published database. In the following example, the project has a unique identifier of 051f3a1e-02f5-4e45-bea7-30bfbf8df67f, and the last viewed Project Detail Page has unique identifier 1e26f08d-2757-46d9-b726-16cae3614c56. You could find the project name by checking the MSP_PROJECTS table for the PROJ_NAME associated with 051f3a1e-02f5-4e45-bea7-30bfbf8df67f.

     	{
     	        "PropertyName":  "PDPPages_LastViewed_PDP_For_051f3a1e-02f5-4e45-bea7-30bfbf8df67f",
     	        "PropertyValue":  "1e26f08d-2757-46d9-b726-16cae3614c56"
     	    },
    
  • OptimizerPlannerPlannerReqPages: This provides settings the user customized on the Optimizer, Planner and Planner Request pages. If the PropertyName contains {Optimizer}, {Planner} or {PlannerReq}, two unique identifiers will follow it. The first is the unique identifier of the view, and the second is the unique identifier for the analysis. You can find the corresponding view name (WVIEW_NAME) in the MSP_WEB_VIEW_REPORTS table from the view id (WVIEW_UID) in the Project Server 2010 Published database. The corresponding analysis name (ANALYSIS_NAME) can be obtained from the MSP_ANALYSIS table from the view ID(ANALYSIS_UID) column in the Project Server 2010 Published database.

  • PlannerDefPlannerResPlannerAvailPages: This provides settings the user customized on the Planner Deficit, Planner Resource, Planner Availability pages. If the PropertyName contains {PlannerDef}, {PlannerRes} or {PlannerAvail}, then the GUID that follows it is the unique identifier of the analysis. The corresponding analysis name (ANALYSIS_NAME) can be obtained from the MSP_ANALYSIS table from the view ID (ANALYSIS_UID) in the Project Server 2010 Published database.

PropertyName and PropertyValue properties

You may see the following properties for the above objects for the PropertyName and corresponding PropertyValue properties:

Property

Description

ViewUid

Unique identifier of the view

JSGridWidth

Width of the displayed grid (value in pixels).

SelectedResourceIds

Unique identifiers of resources selected last on the grid.

SelectedResources

Unique identifiers of resources selected last on the grid.

TimeStampUID

A sequential guid that updates every time the view is initialized.

Duration

Selected value of duration for display on the grid. Values are:

-1 -Invalid, -2 -The duration is an estimate, 1 -Seconds, 2 -Elapsed seconds, 3 -Minutes, 4 -Elapsed minutes, 5 -Hours, 6 -Elapsed Hours, 7 -Days, 8 -Elapsed days, 9 -Weeks, 10 -Elapsed Weeks, 11 -Months, 12 -Elapsed Months, 13 -Quarters, 14 -Elapsed Quarters, 15 -Years, 16 -Elapsed Years, 17 -Decades, 18 -Elapsed Decades, 19 -Percent, 20 -Elapsed Percent, 21 -No Units, 22 -Material Usage

Date

The date format used. Values are:

1 – ShortDate, 2 – ShortTime, 3 – ShortDateTime, 4 – LongDate, 5 – LongDateTime, 6 – WeekDayMonth, 7 – MonthDay, 8 – YearMonth, 9 – Sortable, 10 – SmartShortDateTime, 10 – GeneralLongDateTime

ProjectTeamJsGridFields

Contains key value pairs of the fields on the grid.

ExpandSubProjects

If true, subprojects are expanded in the UI.

GanttZoomLevel

Level to which Gantt is zoomed in for display. Goes from most zoomed in to most zoomed out: 0 - Minute, 1 – Hour longdate, 2 - Hour shortdate, 3 – Day with the shortest day name, 4 – Day with the day Year Month listed, 5 – Day with the day year month listed, 6 – Month, 7 - Month, 8 - Quarter, 9 – Half year

PredefinedFilter

Value of current filtering. Values are: 0 – All, 1 – Overdue, 2 – Newly Assigned, 3- Completed, 4 – Incomplete, 5 - Custom

DefaultLayout

Default layout of the page. Values are: 0- None, 1- Gantt, 2- Timephased

ZoomLevel

Zoom level from most zoomed in to most zoomed out : 0- Minute, 1 – Hour longdate, 2- Hour shortdate, 3 – Day with the shortest day name, 4 – Day with the day Year Month listed, 5 – Day with the day year month listed, 6 – Month, 7 - Month, 8 - Quarter, 9 – Half year

DividerPosition

Position of JsGrid splitter in pixels.

GroupBy0

Field to group by.

GroupBy1

Field to group by.

GroupBy2

Field to group by.

SortBy

Field to sort by.

SortByOrder

0 – Ascending, 1 - Descending

ViewOutlineLevel

If value is -1, expand all, except for subprojects. If value is any other number, set that outline level expanded.

FilterBy

Column to filter by.

SelectedFilterId

Field selected to filter.

JSGridFields

Contains key-value pairs describing the settings used to display the Grid in the user interface.

ShowTimeWithDates

If true, time is displayed with dates. If false, they are not.

PrincipalColumnWidth

Width of principal column in pixels.

CategoryColumnWidth

Width of category column in pixels.

IsSidebarHidden

Set to true if sidebar is hidden, false if not.

IsViewBubbleChart

If true, cost constraint analysis chart is displayed. If false, the grid is displayed.

IsViewSBAChart

If true, Strategic Business Alignment Chart is displayed. If false, Efficient Frontier chart is displayed.

IsHighlightDeficit

If true, the Highlight Deficit option is checked. If false, it is not.

ProjUid

Unique identifier of project.

IncludeProposedBookings

True to include proposed bookings in the data displayed on grid, false otherwise.

WorkUnits

Determine work units for the grid. Values are: 0- Hours, 1 – Days, 2- Full Time Equivalent

TimeScale

Determines time scale for the grid. Values are: 3 – Days, 4- Weeks, 5- Months, 6- Quarters, 7 - Years

SelectedViewType

Determines the view type. Values are: 0 – AssignmentsByResource, 1 – AssignmentsByProject, 2- Availability, 3 – Work, 4 - HeatMapCapacityEngagement

DateEarliestSerialized

Represents start date of the view on Capacity Planning page.

DateLatestSerialized

Represents the end date of the view on Capacity Planning page.

UpperThreshold

Value of upper threshold on Capacity Planning page.

LowerThreshold

Value of lower threshold on Capacity Planning page.

FromDate

Start date of the view in the grid.

ToDate

End date of the view in grid.

IncludeProposed

If true, Include Proposed booking is checked. If false, it is not.

TabExpanded

If true, the filter tab is expanded on the Timesheet History page.

DateFilterChecked

If true, the date filter is checked on the Timesheet page.

ResourceFilterChecked

If true, the Resource Filter option is checked on the Timesheet page.

StartDate

Date when view starts.

FinishDate

Date when view ends.

FilterMode

Determines which timesheets are displayed. Values are: 1 – Show unsubmitted timesheets, 2- Show approved timesheets, 3- Show all timesheets

CustomFilterSelected

If true, a custom filter is selected.

SelectedResource

Numeric identifier of the resource selected last on the grid.

SelectedFiscalPeriod

Index of the fiscal period selected from the Fiscal Period dropdown menu.

ShowTimeWithDate

If true, time is displayed with dates.

ShowInsertedProjects

If true, inserted projects will display.

ShowRollups

If true, rollups will display.

ShowGanttChart

If true, Gantt chart will display.

ShowProjectSummaryTask

If true, project summary task will display on grid.

ViewSelection

Whether the view displays InProgressAndFailedJobsInThePastWeek/AllInProgressAndFailedJobs/SuccessfulJobsInThePastWeek/AllSuccessfulJobs/AllJobsInThePastWeek/AllJobs TimePhasedPane..

TimePhasedPane

If true, the Timephased pane will display.

IncludeSummaryTasks

If true, summary tasks will display.

ShowOvertimeWork

If true, overtime work will display.

ShowScheduledWork

If true, scheduled work will display.

ShowSelectedList

If true, selected resources list will display.

Timephased

If true, the Timephased grid will be visible.

Proposed

If true, the proposed values will display.

Planned

If true, planned work will display.

Overtime

If true, overtime work will display.

NonBillable

If true, non-billable work will display.

CommentOnSubmit

If true, comment dialog will display on submit of timesheet.

ShowTotals

If true, total work will display.

TimephasedStart

ECMA Date representation of the start date of timephased data.

TimephasedEnd

ECMA Date representation of the end date of timephased data.

showPlanned

If true, planned work will display.

showOvt

If true, overtime work will display.

showNonBill

If true, non-billable work will display.

dateFormat

The format of date values: 1 - ShortDate, 2 - ShortTime, 3 - ShortDateTime, 4 -LongDate, 5 - LongDateTime, 6 - WeekdayDayMonth, 7 - MonthDay, 8 - YearMonth, 9 - Sortable, 10 - SmartShortDateTime, 11 - General LongDateTime

durationFormat

-1 - Invalid, -2 - SwitchToEstimatedDuration , 1 - Seconds, 2 - ElapsedSeconds, 3 - Minutes, 4 - ElapsedMinutes, 5 - Hours, 6 - ElapsedHours, 7 - Days, 8 - ElapsedDays, 9 - Weeks, 10 - ElapsedWeeks, 11 - Months, 12 - ElapsedMonths, 13 - Quarters, 14 - ElapsedQuarters, 15 - Years, 16 - ElapsedYears, 17 - Decades, 18 - ElapsedDecades, 19 - Percent, 20 - ElapsedPercent, 21 - None, 22 - Material

workFormat

-1 - Invalid, -2 - None , 0 - Seconds, 1 - Minutes, 2 - Hours, 3 - Days, 4 - Weeks, 5 - Months, 6 - Quarters, 7 - Years, 8 - Decades, 9 - Material

filterType

0 – All, Overdue – 1, NewlyAssigned – 2, Completed – 3, Incomplete - 4

projUids

List of projects selected for the resource constraint filter.

roleUids

List of roles selected for the resource constraint filter.

UseDate

If true, the Filter By Date checkbox is checked on the Manage Delegations page.

UseResource

If true, the Filter By Users checkbox is checked on the Manage Delegations page.

UseWeek

If true, the Only show delegates covering this week option is checked.

UseSelfDelegates

If true, the Only show delegates acting on my behalf checkbox is checked.

UseNamedDelegate

If true, the Delegate name checkbox is checked.

UseActingFor

If true, the Delegate name who is acting for option is checked.

UseDateRange

If true, the Date range checkbox is checked.

DelegateUid

Unique identifier that represents the currently filtered delegate.

ActingForUid

Unique identifier of the user that the delegation is on behalf of.

DelegateName

Name of the delegate.

ActingForName

Name of delegatee.

FilterVisible

If true, the filter options will display.

GridTimeScaleUnits

0- Hours, 1 – Days, 2- Full Time Equivalent

DateRangeFrom

Start date of data displayed in the view.

DateRangeTo

End date of data displayed in the view.

DateRangeUnits

Units used for date range display on grid. Values are: 0- seconds, 1- minutes, 2- hours, 3- days, 4- weeks, 5 – months, 6- quarters, 7 - years

Workflow

This file contains data about Project workflows in which the user was an owner. For each WorkflowInstances object, you may see the following objects:

Object

Description

SiteID

Unique identifier for the PWA site in which the workflow is used.

ProjectID

Unique identifier of the project utilizing the workflow.

ProjectName

Name of the project utilizing the workflow.

WorkflowInstanceId

Unique identifier of the workflow instance.

WorkflowError

Instance failed with this error string.

WorkflowErrorResponseCode

Instance failed with this error code.

WorkflowCreatedDate

Date the workflow instance for the project was created.

EnterpriseProjectTypeUid

Unique identifier for the enterprise project type using the workflow.

EnterpriseProjectTypeName

Name the enterprise project type using the workflow.

WorkflowStatus

Status of the workflow.

For each WorkflowStatus object, you may see the following properties:

Property

Description

WorkflowInstanceId

Unique identifier for the workflow instance.

PhaseId

Unique identifier for the workflow phase.

PhaseName

Name of the workflow phase.

PhaseDescription

Description of the workflow phase.

StageId

Unique identifier for the workflow stage.

StageName

Name of the workflow stage.

StageDescription

Description of the workflow stage.

StageInformation

Actual stage information that was updated through the workflow.

StageOrder

The order of a stage in a workflow.

StageStatus

The status of a workflow stage.

StageStateDescription

The description of the state of a workflow stage.

StageEntryDate

The date and time that a workflow stage begins.

StageLastSubmitted

Date when project was last submitted.

StageCompletionDate  

Date the stage was completed.

LastModifiedDate

Time/Date the workflow instance was last modified.

WorkspaceItems

WorkspaceItems described data about SharePoint items that are used in Project Server and Project Online, such as Issues, Risks, and deliverables. This can include collections of:

  • Issues

  • Risks

  • Deliverable

  • ListItemAssociations

There can be a collection of Issues objects that have the following properties:

Property

Description

ProjectId

Unique identifier for the project.

ProjectName

Name of the project.

IssueUniqueId

Unique identifier for the issue.

IssueId

The ID of the issue.

Title

The title or name of the issue.

AssignedToResource

WSS item assigned to field.

AssignedToUserClaimsAccount

WSS item assigned to claims field.

NumberOfAttachments

The number of attachments for the issue.

DueDate

Date the issue is due to complete.

Category

The category of the issue.

Status

The status of the issue.

Priority

The priority of the issue.

Owner

Name of the issue owner.

OwnerUserClaimsAccount

Claims account of the owner.

Discussion

The text field for the issue discussion.

Resolution

The resolution of the issue.

IsFolder

True if the issue is a folder in the SharePoint list.

ItemRelativeUrlPath

The relative URL of the issue.

CreatedByResource

The resource that created the issue.

CreatedByUserClaimsAccount

Claims account of the user that created the issue.

CreatedDate

The date and time the issue was created.

ModifiedByResource

The user who last modified the issue.

ModifiedByUserClaimsAccount

Claims account of the user that last modified the issue.

ModifiedDate

The date and time that the issue was last updated.

There can be a collection of Risk objects that have the following properties:

Property

Description

ProjectId

Unique identifier for the project with the risk.

ProjectName

Name of the project with the risk.

RiskUniqueId

The unique identifier of the risk.

RiskId

The ID of a risk.

Title

The title or name of a risk.

AssignedToResource

WSS item assigned to field.

AssignedToUserClaimsAccount

WSS item assigned to claims field.

NumberOfAttachments

The number of attachments for a risk.

DueDate

Date the risk is due.

Probability

The percent probability that a risk will happen.

Impact

The magnitude of the impact if a risk happens.

Exposure

The overall threat of a risk, calculated by multiplying the risk probability by the impact.

Cost

The total projected cost for a risk.

CostExposure

The overall threat of risk, calculated by multiplying the cost by the risk probability.

Category

The risk category.

Status

The status of a risk.

Owner

Name of the risk owner.

R.OwnerUserClaimsAccount

Claims account of the risk owner.

Description

The text field for a risk description.

MitigationPlan

A plan for handling problems that are related to risk factors.

ContingencyPlan

The contingency plan for a risk.

TriggerTask

The condition that triggers the contingency plan (for example, date, exposure over threshold, tasks not completed, or other user-assigned values).

TriggerDescription

The description of the trigger that causes a risk.

NumberOfAttachments

The number of attachments for the risk.

IsFolder

True if the risk is a folder in the SharePoint list.

ItemRelativeUrlPath

The relative URL of the risk.

CreatedByResource

The resource that created a risk.

CreatedByUserClaimsAccount

Claims account of the user that created the risk.

CreatedDate

The date and time when a risk was created.

ModifiedByResource

The user who modified a risk.

ModifiedByUserClaimsAccount

Claims account of the user that last modified the risk.

ModifiedDate

The date and time when a risk was modified.

There can be a collection of Deliverables objects that have the following properties:

Property

Description

ProjectId

Unique identifier for the project for the deliverable.

ProjectName

Name of the project for the deliverable.

DeliverableUniqueId

Unique identifier for the deliverable.

DeliverableId

The ID of the deliverable.

Title

The title of the deliverable.

Description

Description of the deliverable.

StartDate

The start date and time of the deliverable.

FinishDate

The finish date of the deliverable.

IsFolder

True if the deliverable is a folder in the SharePoint list.

ItemRelativeUrlPath

The relative URL of the deliverable.

CreatedByResource

The resource that created the deliverable.

CreatedByUserClaimsAccount

The  Claims account of the user who created the deliverable

CreatedDate

The date and time that the deliverable was created.

ModifiedByResource

The resource that last changed the deliverable.

ModifiedByUserClaimsAccount

The Claims account of the user who last modified the deliverable.

ModifiedDate

The date and time that the deliverable was modified.

There can be a collection of ListItemAssociations objects that have the following properties:

Property

Description

ProjectId

Unique identifier for the project.

ProjectName

Name of the project.

ListItemId

Unique identifier for the list item.

ListItemName

Name of the list item.

RelatedProjectId

Unique identifier for the related project.

RelatedProjectName

Name of the related project.

RelatedItemId

Name of the item that is related to the list item

RelatedItemTitle

Title  of the item that is related to the list item

RelationshipTypeId

Identifier of the relationship type

RelationshipDescription

Description of the relationship between list item and related item.

Project-specific user data from the reporting data

The export method defined in Export user data from Project Online will also create eight files for each project in which the user was a part from the Reporting schema.

Similarly, the queries for project-specific reporting data defined in Export user data from Project Server will provide you similar output.

This data includes:

Name

Description

Reporting_AssignmentBaselineTimephased

Assignment Baseline Timephased data for the project from the reporting schema.

Reporting_AssignmentTimephased

Assignment Timephased data for the project from the reporting schema.

Reporting_ProjectBaseline

Project Baseline data for the project from the reporting schema.

Reporting_Tasks

Project tasks data for the project from the reporting schema.

Reporting_Assignments.

Assignment resources data for the project from the reporting schema.

Reporting_Resources

Resources data for the project from the reporting schema.

Reporting_TaskBaselineTimephased

Task baseline timephased data for the project from the reporting schema.

Reporting_TaskTimephased

Task timephased data for the project from the reporting schema.

When you are exporting from Project Online, your will receive the information in json file format. The name for each file will be prefixed with the project name and project ID for the specific project. For example, if a project has the project name ofProject1 and a project ID of fffa21a1-baac-e711-9ee6-00166dac9e0b, the first file in the table above will be named Project1_fffa21a1-baac-e711-9ee6-00166dac9e0b_draft.xml.

Reporting_AssignmentBaselineTimephased

Reporting_AssignmentBaselineTimephased contains the properties that define the reporting data for assignment baseline timephased data in the ProjectData service. It has the following properties:

Object

Description

SiteId

Unique identifier for the PWA site.

BaselineNumber

An integer number that identifies a baseline in a project.

AssignmentUID

Unique identifier of the assignment.

TimeByDay

A primary key that identifies a day along a timeline. The granularity is in days only.

ProjectUID

The GUID of the project that is associated with the assignment baseline timephased data.

TaskUID

The GUID of the task that is associated with the assignment baseline timephased data.

AssignmentBaselineCost

The planned cost of the assignment.

AssignmentBaselineWork

The total planned person-hours scheduled for an assignment.

AssignmentBaselineMaterialWork

The planned number of units of supplies or other consumable items that are to be used to complete an assignment.

AssignmentBaselineBudgetCost

The planned cost of an assignment.

AssignmentBaselineBudgetWork

The planned total amount of time that is needed to complete an assignment.

AssignmentBaselineBudgetMaterialWork

The planned number of units of the supplies or other consumable items that are to be used to complete an assignment.

AssignmentBaselineModifiedDate

Date and time the assignment baseline was last modified.

FiscalPeriodUID

Unique identifier for the fiscal period.

FiscalPeriodName

Name of the fiscal period.

ResourceId

Unique identifier for the resource.

TaskName

Name of the task.

ProjectName

Name of the project.

Reporting_AssignmentTimephased

Reporting_AssignmentTimephased contains the properties that define the reporting data for assignment timephased data in the ProjectData service. It has the following properties:

Object

Description

SiteId

Unique identifier for the PWA site.

AssignmentUID

Unique identifier for the assignment.

TimeByDay

A primary key that identifies a day along a timeline. The granularity is in days only.

ProjectUID

Unique identifier for the project for the assignment timephased data.

TaskUID

Unique identifier for the task for the assignment timephased data.

FiscalPeriodUID

Unique identifier for the fiscal period.

FiscalPeriodName

Name of the fiscal period.

ResourceId

Unique identifier for the resource.

TaskName

Name of the task.

ProjectName

Name of the project.

AssignmentRegularCost

The total cost for regular, nonovertime assignment work that has already been performed, in addition to remaining nonovertime work.

AssignmentRegularWork

The total amount of non-overtime work scheduled to be performed by a resource assigned to a task.

AssignmentRemainingCost

The costs associated with completing all remaining scheduled work by any resources on a specific task.

AssignmentRemainingOvertimeCost

The remaining scheduled overtime expense for an assignment.

AssignmentRemainingOvertimeWork

The amount of overtime work that remains on an assignment.

AssignmentRemainingRegularCost

The expense that will be incurred by completing the remaining regular, nonovertime work for an assignment.

AssignmentRemainingRegularWork

The amount of time, such as person-hours or days, that is still required to complete the regular, nonovertime work for an assignment.

AssignmentRemainingWork

The amount of time required by a resource assigned to a task to complete an assignment.

AssignmentCombinedWork

The work for the assignment, from both the project plan and the resource plan.

AssignmentActualRegularCost

The cost of the nonovertime work that has already been performed on an assignment.

AssignmentActualRegularWork

The actual amount of regular, nonovertime work that has already been performed on an assignment.

AssignmentCost

The total cost for an assignment, based on costs already incurred, in addition to costs that are planned for the remaining work.

AssignmentOvertimeCost

The total overtime cost for an assignment, including costs for overtime work that has already been performed, in addition to remaining overtime costs.

AssignmentActualCost

The costs incurred for work that has already been performed on an assignment, along with any other associated costs.

AssignmentActualOvertimeCost

The costs incurred for overtime work that has already been performed on an assignment.

AssignmentWork

The total amount of time, such as person-hours or days, that is scheduled for an assignment.

AssignmentOvertimeWork

The total overtime work for an assignment, including overtime work that has already been performed, in addition to remaining overtime work.

AssignmentActualWork

The amount of work that has already been performed on an assignment.

AssignmentActualOvertimeWork

The actual amount of overtime work that has already been performed on an assignment.

AssignmentMaterialWork

The total work time scheduled for a material resource.

AssignmentMaterialActualWork

The actual amount of work that has already been performed with the use of a material resource, usually expressed as a percentage of the scheduled amount of material resource work.

AssignmentBudgetCost

The total projected cost of an assignment.

AssignmentBudgetWork

The total projected amount of work that is planned for an assignment.

AssignmentBudgetMaterialWork

The total projected amount of use on the assignment of material resources.

AssignmentResourcePlanWork

The total time that is scheduled for an assignment in the resource plan.

TaskIsActive

True if the task for the assignment timephased data is active.

AssignmentModifiedDate

Date and time the assignment was last updated.

Reporting_ProjectBaseline

Reporting_ProjectBaseline contains the properties that define the reporting data for project baseline data in the ProjectData service. It has the following properties:

Object

Description

SiteId

Unique identifier for the PWA site.

BaselineNumber

A number that identifies a project baseline.

ProjectUID

Unique identifier for the project.

TaskUID

Unique identifier for the task.

TaskBaselineCost

The total planned cost for the task.

TaskBaselineFixedCost

A set task cost that is projected in the baseline and that remains constant regardless of the task duration or the work performed by a resource.

TaskBaselineWork

The total hours that are scheduled in the baseline projection for a task.

TaskBaselineBudgetCost

The cost of the budgeted amount of work as projected in the baseline.

TaskBaselineBudgetWork

The budgeted amount of work as projected in the baseline.

TaskBaselineStartDate

The projected task start date and time.

TaskBaselineFinishDate

The projected completion date of a task.

TaskBaselineDeliverableStartDate

The published deliverable start date and time for a task.

TaskBaselineDeliverableFinishDate

The published deliverable finish date and time for a task as projected in the baseline.

TaskBaselineDuration

The amount of time estimated to complete a task.

TaskBaselineStartDateString

A string that contains the projected task start date and time.

TaskBaselineFinishDateString

A string that contains the projected task finish date and time.

TaskBaselineDurationString

A string that contains the projected task duration.

TaskBaselineModifiedDate

The date and time the task was last updated.

Reporting_Tasks

Reporting_ProjectTasks contains the properties that define the reporting data for project tasks data in the ProjectData service. It has the following properties:

Property

Description

TaskUID

The unique identifier of the task.

TaskParentUID

The unique identifier of the parent task.

ProjectUID

The unique identifier of the project to which the task belongs.

FixedCostAssignmentUID

The PWA instance site ID.

TaskName

The unique identifier of the task.

TaskOutlineLevel

The outline level of the task.

TaskOutlineNumber

The outline number of the task.

TaskIndex

Number of the task in the local project.

TaskIsProjectSummary

Whether the task is a project summary task.

TaskIsOverallocated

Gets a value that indicates whether the task is overallocated.

TaskIsMilestone

Whether the task is a milestone.

TaskIsCritical

Gets a value that indicates whether the timing for the task is critical or whether there can be any slack in the timing.

TaskIsSummary

Whether the task is a summary task.

TaskStatusManagerUID

The unique identifier of the task status manager.

TaskFixedCost

The fixed cost of the task.

TaskActualFixedCost

The actual fixed cost of the task.

TaskCost

The projected or scheduled cost of the task.

TaskOvertimeCost

The sum of the actual and remaining overtime cost of the task.

TaskActualCost

The actual cost of the task.

TaskActualOvertimeCost

The actual overtime cost of the task.

TaskWork

The amount of scheduled work for the task.

TaskOvertimeWork

The amount of overtime work scheduled for the task.

TaskActualWork

The actual work for the task.

TaskActualOvertimeWork

The actual overtime work for the task.

TaskDurationVariance

The difference between the baseline duration of the task and the total duration, or current estimated duration, of the task.

TaskStartVariance

The variance of the task start date from the baseline start date as minutes x 1000.

TaskFinishVariance

The variance of the task finish date from the baseline finish date as minutes x 1000.

TaskTotalSlack

The amount of total slack.

TaskFreeSlack

The amount of free slack.

TaskDuration

The planned duration of the task.

TaskActualDuration

The actual duration of the task.

TaskStartDate

The scheduled start date of the task.

TaskFinishDate

The scheduled finish date of the task.

TaskDeliverableStartDate

The published deliverable start date and time for a task.

TaskDeliverableFinishDate

The published deliverable finish date and time for a task.

TaskActualStartDate

The date the task was started.

TaskActualFinishDate

The date the task was completed.

TaskPercentCompleted

The percentage of the task duration completed.

TaskPercentWorkCompleted

The percentage of the task work completed.

TaskPhysicalPercentCompleted

The percentage complete value entered by the Project Manager. This can be used as an alternative for calculating the budgeted cost of work performed (BCWP).

TaskACWP

The actual cost of work performed on the task to date.

TaskBCWP

The budgeted cost of work performed on the task to date.

TaskBCWS

The budgeted cost of work scheduled for the task.

TaskLevelingDelay

The delay caused by leveling the task.

TaskPriority

The priority of the task from 0 to 1000.

TaskSPI

Shows the ratio of the budgeted cost of work performed to the budgeted cost of work scheduled (BCWP/BCWS).

TaskTCPI

Ratio of the work remaining to be done to funds remaining to be spent, as of the task status date (to complete performance index).

TaskVAC

Variance at completion.

TaskDeadline

The target date and time for when a task should be completed.

TaskDurationIsEstimated

Whether the baseline duration of the task was estimated.

TaskEAC

Task estimate at completion is the expected total cost of a task based on performance up to the status date.

TaskIsEffortDriven

Whether the task is effort-driven.

TaskIsExternal

Whether the task is external.

TaskIsRecurring

Whether the task is a recurring task.

TaskCostVariance

Gets the difference in cost terms between the current progress and the baseline planned progress for a resource on the task.

TaskCV

Earned value cost variance - show the difference between how much it should have cost and how much it has actually cost to achieve the current level of completion up to the status date.

TaskCPI

Show the ratio of budgeted (or baseline) costs of work performed to actual costs of work performed, up to the project status date.

TaskEarlyFinish

The early finish date of the task.

TaskEarlyStart

The early start date of the task.

TaskLateFinish

The late finish date of the task.

TaskLateStart

The late start date of the task.

TaskSV

The cost difference between the current progress and the baseline plan of a task.

TaskWorkVariance

The variance of task work from the baseline task work as minutes x 1000.

TaskIgnoresResourceCalendar

Whether the task ignores the resource calendar.

TaskClientUniqueId

Unique ID of the task as shown in Project Professional.

TaskIsMarked

True if task is marked for identification or further action.

TaskWBS

The work breakdown structure (WBS) code of the task.

TaskCreatedDate

The date that the task was created.

TaskModifiedDate

The date that the task was last updated.

TaskBudgetCost

Used to compare budgeted costs with the planned or actual costs.

TaskBudgetWork

The scheduled work for a task.

TaskResourcePlanWork

Time scheduled on a task for all resouces in the resource plan. This field is used to avoid double-counting if the scheduled work is from a resource plan.

TaskHyperLinkFriendlyName

Shows the title or explanatory text for a hyperlink associated with a task.

TaskHyperLinkAddress

A hyperlink that is associated with a task.

TaskHyperLinkSubAddress

The subaddress of a task hyperlink.

TaskStartDateString

The string value for a task start date and time.

TaskFinishDateString

The string value of the task finish date and time.

TaskDurationString

The string value for the duration of a task.

TaskIsManuallyScheduled

The unique identifier of the project to which the task belongs.

TaskIsActive

If the task is currently active.

CustomFields

Custom fields used in the task.

If the task contains a CustomField object, it will have the following properties:

Property

Description

CustomFieldId

Unique identifier for the custom field.

CustomFieldName

Name of the resource.

TaskId

Unique identifier for the task in which the customer field is used.

CustomFieldValue

Values for the custom field.

Reporting_Assignments

Reporting_Assignments contains the properties that define the reporting data for assignments in the ProjectData service. It has the following properties:

Object

Description

AssignmentUID

Unique identifier for the assignment.

ProjectUID

Unique identifier for the project for the assignment.

ResourceUID

Unique identifier for the resource for the assignment.

TaskUID

Unique identifier for the task for the assignment.

ResourceOwnerUID

Unique identifier for the resource owner.

AssignmentCost

The total cost for an assignment, based on costs already incurred, in addition to costs that are planned for the remaining work.

AssignmentOvertimeCost

The total overtime cost for an assignment, including costs for overtime work that has already been performed, in addition to remaining overtime costs.

AssignmentActualCost

The costs incurred for work that has already been performed on an assignment, along with any other associated costs.

AssignmentActualOvertimeCost

The costs incurred for overtime work that has already been performed on an assignment.

AssignmentWork

The total amount of time, such as person-hours or days, that is scheduled for an assignment.

AssignmentOvertimeWork

The total overtime work for an assignment, including overtime work that has already been performed, in addition to remaining overtime work.

AssignmentActualWork

The amount of work that has already been performed on an assignment.

AssignmentActualOvertimeWork

The actual amount of overtime work that has already been performed on an assignment.

AssignmentMaterialWork

The total work time scheduled for a material resource.

AssignmentMaterialActualWork

The actual amount of work that has already been performed with the use of a material resource, usually expressed as a percentage of the scheduled amount of material resource work.

AssignmentPercentWorkCompleted

Percentage of work that has been completed.

AssignmentStartDate

Date a resource is scheduled to begin an assignment.

AssignmentFinishDate

Date a resource is scheduled to complete assignment.

AssignmentActualStartDate

Date a resource is begins an assignment.

AssignmentActualFinishDate

Date a resource is completes an assignment.

AssignmentDelay

Amount of time a resource is to wait before starting to work on an assignment.

AssignmentStartVariance

Variance at the start of the assignment.

AssignmentFinishVariance

Variance at the assignment finish.

AssignmentACWP

Actual cost of work performed for the assignment.

AssignmentBCWP

Budgeted cost of work performed for the assignment (earned value).

AssignmentBCWS

Budgeted cost of work scheduled for the assignment (planned value).

AssignmentBookingID

Assignment booking GUID.

AssignmentBookingName

Assignment booking name (committed or proposed).

AssignmentType

Type of assignment. NormalAssignment=0, WorkOnlyAssignment=1, FixedCostAssignment=2, FixedCostWorkOnlyAssignment=3, EmptyAssignment=4, FixedCostGeneratedAssignment=100 (generated during RDS transfer), ResourcePlanAssignment=101.

TypeName

Name of the assignment type.

AssignmentResourceType

The type of resource that is associated with an assignment. See Type enumeration.

R.TypeName

IsPublic

True if the item was published, so a team member can see it.

AssignmentIsPublished

True if assignment is published.

AssignmentCostVariance

Difference between baseline cost and total cost.

AssignmentWorkVariance

Difference between baseline work and currently scheduled work.

AssignmentCV

Earned value cost variance.

AssignmentSV

Earned value schedule variance.

AssignmentVAC

Variance at completion.

AssignmentIsOverallocated

True if any assigned resources are overallocated.

AssignmentPeakUnits

Maximum number of units that a resource is assignmed for a task.

AssignmentCreatedDate

Date and time the assignment was created.

AssignmentModifiedDate

Date and time the assignment was last updated.

AssignmentBudgetCost

The total projected cost of an assignment.

AssignmentBudgetWork

The total projected amount of work that is planned for an assignment.

AssignmentBudgetMaterialWork

The total projected amount of use on the assignment of material resources.

AssignmentResourcePlanWork

The total time that is scheduled for an assignment in the resource plan.

TaskIsActive

True if the task for the assignment timephased data is active.

TimesheetClassUID

GUID of the timesheet class.

If the task contains a CustomField object, it will have the following properties:

Property

Description

CustomFieldId

Unique identifier for the custom field.

CustomFieldName

Name of the resource.

PrimaryCustomFieldId

The ID of the primary custom field (either a Task or a Resource type) that this custom field is a child of.

PrimaryCustomFieldName

The name of the primary custom field (either a Task or a Resource type) that this custom field is a child of.

AssignmentRolldown

Does the value of this assignment rolls down from the primary custom field. If it does,the value is the same os the value of the corresponding primary custom field unless ovverriden in the assignment custom field

AssignmentId

The assignment id that this custom field belong to.

CustomFieldValue

Values for the custom field.

Reporting_Resources

Reporting_Resources contains the properties that define the reporting data for resources in the ProjectData service. It has the following properties:

Property

Description

ResourceUID

Unique identifier for the resource.

ResourceName

Display name of the resource.

ResourceStandardRate

The standard rate of pay for a resource.

ResourceOvertimeRate

The rate of overtime pay for a resource.

ResourceStatusUID

GUID of the resource status.

ResourceStatusName

Localized name of the resource status. Status includes Unassigned Resource, Local Resource, Unknown Resource, and Enterprise Resource. Most resources on a project have the Enterprise Active status value.

ResourceCode

Contains any code, abbreviation, or number you want to enter as part of a resource's information.

ResourceCostPerUse

The cost that accrues each time a work resource is used.

ResourceEmailAddress

The email address of a resource.

ResourceInitials

Initials of the resource.

ResourceMaterialLabel

The Material Label field contains the unit of measurement you enter for a material resource, for example, tons, boxes, or cubic yards. This label is then used in conjunction with the material resource's assignment units, for example, eight tons or 22 boxes.

ResourceType

The type of a resource (for example, Enterprise, Local, Project Server, Material, or Generic). See ResourceType Enumerations for values.

TypeName

Name of the resource type.

ResourceGroup

The Group field contains the name of the group that a resource belongs to.

ResourceMaxUnits

The maximum capacity (percentage or units) that a resource is available to accomplish tasks during the current time period.

ResourceBookingType

The resource booking type: proposed or committed.

ResourceTimesheetManagerUID

Timesheet manager for the given resource.

ResourceEarliestAvailableFrom

The earliest date that a resource is available for work on a particular task.

ResourceLatestAvailableTo

The last date that a resource is available.

ResourceCanLevel

True if resource leveling can be done.

ResourceHyperlink

The URL that is specified for a resource in the Edit User page of Project Web Access.

ResourceHyperlinkHref

The text that is displayed for a resource hyperlink, as specified in the Edit User page of Project Web Access.

ResourceNTAccount

The Windows account name for a resource.

ResourceIsActive

Specifies the project version that was active when the resource was created. This field is for internal use by the Project cache.

ResourceIsGeneric

True if the resource is generic.

ResourceIsTeam

True if a resource is a team resource.

ResourceBaseCalendar

The base calendar for a resource.

ResourceWorkgroup

A number value that represents a team collaboration method for a resource.

ResourceClientUniqueId

Unique ID of the resource from a local project when opened in Project Professional.

ResourceCostCenter

A user-defined code for resource cost accounting.

ResourceCreatedRevisionCounter

Specifies the project version that was active when the resource was created. This field is for internal use by the Project cache.

ResourceModifiedRevisionCounter

Count of how many times resource was modified.

ResourceCreatedDate

The date and time that a resource was created in the project.

ResourceModifiedDate

The date that information about a resource was last modified.

ResourceRequiresEngagement

True if the resource can only be requested through an engagement request.

LCID

Resource's Language Code ID.

UserClaimsAccount

Login name for the user.

Reporting_TaskBaselineTimephased

Reporting_TaskBaselineTimephased contains the properties that define the reporting data for task baseline timephased data in the ProjectData service. It has the following properties:

Object

Description

SiteId

Unique identifier for the PWA site.

BaselineNumber

A number that identifies a project baseline.

ProjectUID

Unique identifier for the project.

TaskUID

Unique identifier for the task.

TimeByDay

A primary key that identifies the day along a timeline. The granularity is in days only.

TaskBaselineCost

The total planned cost for a task. The baseline cost is also known as budget at completion (BAC) for earned value.

TaskBaselineFixedCost

A set task cost that is projected in the baseline and that remains constant regardless of the task duration or the work performed by a resource.

TaskBaselineWork

The total planned hours that are scheduled for a task in the baseline projection.

TaskBaselineBudgetCost

The cost of the planned, budgeted amount of work on a task.

TaskBaselineBudgetWork

The planned, budgeted amount of work on a task.

TaskBaselineModifiedDate

The date and time the task was last updated.

FiscalPeriodUID

Unique identifier for the fiscal period.

FiscalPeriodName

Name of the fiscal period.

TaskName

Name of the task.

ProjectName

Name of the project.

Reporting_TaskTimephased

Reporting_TaskTimephased contains the properties that define the reporting data for task timephased data in the ProjectData service. It has the following properties:

Property

Description

SiteId

Unique identifier for the PWA site.

TaskUID

Unique identifier for the task.

TimeByDay

A primary key that identifies a day along a timeline. The granularity is in days only.

T.FiscalPeriodUID

The identifier of the fiscal period.

FiscalPeriodName

Name of the fiscal period.

ProjectUID

Unique identifier for the project.

TaskIsActive

True if the task is active.

TaskIsProjectSummary

True if the task is a project summary task.

TaskCost

The total scheduled or projected cost for a task.

TaskActualCost

The costs incurred for work that is already performed by all resources on a task, along with any other recorded costs.

TaskWork

The total time that is scheduled for a task for all assigned resources.

TaskOvertimeWork

The amount of overtime work that is scheduled to be performed by all resources that are assigned to a task.

TaskActualWork

The actual work that is already performed by resources on a task, usually expressed as percent complete.

TaskBudgetCost

The scheduled costs for a task.

TaskBudgetWork

The scheduled work for a task.

TaskResourcePlanWork

The total time that is scheduled for the task in the resource plan.

TaskModifiedDate

Date and time the task was last modified.

TaskName

Name of the task.

ProjectName

Name of the project.

Project XML files

The method defined in Export user data from Project Online will give you two project-specific files for the each user project, but saved to .xml format. You get two .xml files for each project:

  • <ProjectName>_<ProjectID>_draft.xml: The project file from the Draft schema saved in .XML format.

  • <ProjectName>_<ProjectID>_published.xml: The project file from the Published schema saved in .XML format.

See the Project XML Data Interchange Schema Reference to understand the Project XML data contained in these files.

Project-specific Metadata files

The method defined in Export user data from Project Online will also provide you three project-specific files that give metadata about each individual project. You receive one from each of the following schemas:

Project metadata file from the Reporting schema

The Project metedata file for a project will have the following properties:

Property

Description

ProjectUID

The unique identifier for the project.

ProjectName

Name of the project.

ProjectAuthorName

The name of the author of the project.

ProjectOwnerResourceUID

Resource GUID of the project owner.

ProjectManagerName

Name of the project manager.

ProjectType

The enumerated value that represents the type of a project.

ProjectStartDate

The project start date and time.

ProjectFinishDate

The scheduled finish date and time of a project.

ProjectStatusDate

The status date and time of a project.

ProjectWorkspaceInternalHRef

The URL of the project site.

ProjectWbsIsStale

True if the work breakdown structure (task outline hierarchy) is not up to date.

ProjectEarnedValueIsStale

True if earned value fields are out of date.

ProjectRollupsAreStale

True if the summary task data is out of date.

ProjectHierarchyNotSynchronized

The master - subproject hierarchy is not synchronized.

ProjectCalculationsAreStale

True if project schedule calculations are not up to date.

ProjectGhostTaskAreStale

True if ghost tasks are out of date. Ghost tasks are placeholders for cross-project links.

ProjectCurrency

The project currency character code.

ProjectCategoryName

The name of a project category.

ProjectCompanyName

The name of the company for a project.

ProjectKeywords

The keywords for a project.

ProjectSubject

The subject of a project.

ProjectTitle

Name of the project.

ProjectVisibilityMode

Is this created from SharePoint task list.

ResourcePlanUtilizationType

Value that represents the utilization type of a resource plan.

ResourcePlanUtilizationDate

The start date and time for use of the resource plan.

ProjectDescription

Description of the project.

EnterpriseProjectTypeName

The name of an enterprise project type.

ProjectCreatedDate

The date that a project was created.

ProjectModifiedDate

The date and time that a project was last modified.

ProjectCalendarDuration

The total span of active working time for all tasks in a project, based on the project calendar that is specified in the Project Information dialog box.

ProjectIdentifier

Human readable identifier for the project. This identifier is configured in the EPT.

ProjectLastPublishedDate

The date of last publish

The project can have a collection of CustomFields objects, with the following properties:

Property

Description

CustomFieldValueUID

Unique identifier for the custom field value.

CustomFieldTypeUID

Unique identifier for the custom field type.

CustomFieldName

Name of the custom field.

ResourceUID

Unique identifier for the resource.

CFValue

Custom field value.

Project metadata file from the Draft schema

The Project metedata file for a project in the Draft schema will have the following properties:

Property

Description

ProjectUID

The unique identifier for the project.

ProjectName

Name of the project.

ProjectAuthorName

The name of the author of the project.

ProjectActualCost

The costs incurred for work that has already been performed on a project.

ProjectCategoryName

The name of a project category.

ProjectCompanyName

The name of the company for a project.

ProjectCritcalSlackLimit

The number of days past its end date that a task can go before Project marks that task as a critical task.

ProjectCurrencyDigits

The number of decimal digits in currency values.

ProjectCurrencyPosition

The placement of the currency symbol in relation to the currency value.

ProjectCurrencySymbol

The project currency symbol.

ProjectCurrencyCode

The currency code of the project, as defined in ISO 4217.

ProjectIsNewTasksEffortDriven

Specifies whether new tasks are effort driven.

ProjectCurrentDate

The current date for the project.

ProjectDefaultFinishTime

The default finish time for all new tasks.

ProjectDefaultFixedCostAccrual

A value that indicates which default fixed cost accrual method to use on new tasks.

ProjectMinutesPerDay

The default number of minutes per day.

ProjectMinutesPerWeek

The default number of minutes per week.

ProjectDefaultOvertimeRate

Default overtime rate for local resources.

ProjectDefaultStandardRate

Default standard rate for local resources.

ProjectDefaultStartTime

The default start time for all new tasks.

ProjectDefaultTaskType

The default type for all tasks in the project.

ProjectDurationFormat

The default format for work duration.

ProjectFinishDate

The scheduled finish date and time of a project.

ProjectTasksHonorConstraints

Indicates whether Project schedules tasks according to their constraint date.

ProjectKeywords

The keywords for a project.

ProjectLastSavedDate

The date the project was last saved.

ProjectManagerName

The name of a project manager.

ProjectMultipleCriticalPaths

Indicates whether Project calculates and displays a critical path for each independent network of tasks within a project.

ProjectPoolAttachedTo

The name of the project that shares resources with this project.

ProjectCreatedDate

The date that a project was created.

ProjectIsResourcePool

Indicates if the project is being used as resource pool.

ProjectScheduledFromStart

Indicates whether a project is scheduled from Start Date or Finish Date.

ProjectSplitTasksInProgress

Indicated whether to Allow rescheding of remaining duration and work when a task slips or reports progress ahead of schedule.

ProjectSpreadActualCostsToStatusDate

Indicates whether actual costs are spread to the status date.

ProjectSpreadPercentCompleteToStatus

Indicates whether percent complete is spread to the status date.

ProjectStartDate

The project start date and time.

ProjectStatusDate

The status date and time of a project.

ProjectSubject

The subject of a project.

ProjectTitle

The title of a project.

ProjectCalculateActualCosts

Indicates whether Project should automatically calculate actual costs.

ProjectWorkEntryFormat

The default format for all work durations in the project.

ProjectCalculatesSubTasksAsSummary

Indicates whether Project calculates sub-tasks as summary tasks.

ProjectDaysPerMonth

The default number of working days per month.

ProjectDefaultEstimatedDuration

A value that indicates whether new tasks have estimated durations.

ProjecthowEstimatedDurations

A value that indicates whether a question mark is displayed after an estimated duration for a task.

ProjectExpandTimephased

Indicates whether Project saves timephased data in a readable or binary format when saved to a database.

ProjectExternalEdited

Indicates whether the project was edited externally.

ProjectReadCount

Indicates the number of users who have one or more tables open as read-only.

ProjectType

The enumerated value that represents the type of a project.

ProjectCheckedOutBy

Name of the user who checked out the project.

ProjectCheckOutDate

The project checked out date.

ProjectPath

The project path.

ProjectActualsSyncProtectedActuals

A value that indicates whether the project actuals are synchronized with the protected actuals.

ProjectIsAdministrative

Indicates whether the project is an administrative project.

ProjectTimestamp

The timestamp on the project.

ProjectDescription

Description of the project.

ProjectLocalPath

The project local path.

ProjectWebPath

The project web path.

ProjectOwnerUID

The GUID of a project owner.

ProjectDataSourceNameID

The identifier of the project data source name.

ProjectDelegateAllowed

Indicates if project delegate is allowed.

ProjectIsNonWorking

Indicates if project is non working.

ProjectScope

The project scope.

ProjectIsConsolidatedProject

Indicates if it's a consolidated project.

ProjectResourceCanDecline

Indicates if resource can decline.

ProjectTrackingMode

The default tracking method for all assignments in the project.

ProjectLastPublishedDate

The date of last project publish.

LegacyProjectType

The legacy project type.

ProjectOptionDefaultStartTime

Default start time of a working day.

ProjectOptionDefaultFinishTime

Default end time of a working day.

ProjectSiteName

The name of the project site.

ProjectSiteServerUID

The server ID of the project site..

IssueListName

The name of the project issue list.

RiskListName

The name of the project risk list.

TotalDocumentCount

Count of documents for the project.

ProjectActiveIssueCount

Count of active issues for the project.

ProjectActiveRiskCount

Count of active risks for the project.

ProjectAdminRoleId

The identifier for the project admin role.

ProjectManagerRoleId

The identifier for the project manager role.

ProjectTeamMemberRoleId

The identifier for the project team member role.

ProjectReaderRoleId

The identifier for the project reader role.

ProjectProposalWorkflowInstanceId

The identifier of the project workflow instance.

ProjectIsAdminProjectLegacy

Indicates whether the project is an administrative project.

ProjectCalendarId

The ID for the calendar used by the project.

ProjectClientVersionNumber

The client version for the project.

ProjectVersion

The version of the project.

ProjectProgramUID

The identifier for the project program.

ProjectSessionUID

The identifier for the project session.

ProjectSessionDescription

The project session descriptor.

ProjectIsDeleted

Indicates whether the project is deleted.

ProjectBaselineCalendarId

The identifier of the project baseline calendar.

ProjectWBSPrefix

The work breakdown structure prefix.

ProjectNewTasksStartOnCurrentDate

A value that indicates whether new tasks start on current date.

ProjectIsNewTasksManual

A value that indicates whether new tasks are manually scheduled.

ProjectSummaryTaskId

The task Id of the project summary task.

ProjectModifiedDate

The date and time that a project was last modified.

SharepointIdeaListWebId

The Ideas List SharePoint Web ID.

SharepointIdeaListId

The Ideas List SharePoint List ID.

SharepointIdeaItemId

The Ideas List SharePoint List Item ID.

ProjectVisibilityMode

Specifies whether the project site was created from SharePoint task list.

ProjectIsProjectSiteRemoved

Specifies whether the project site was removed.

ProjectUtilizationType

Value that represents the utilization type of a project.

ProjectUtilizationDate

The start date and time for use of the project.

ProjectIdentifier

Human readable identifier for the project. This identifier is configured in the EPT.

Project metadata file from the Published schema

The Project metedata file for a project in the Published schema will have the following properties:

Property

Description

ProjectUID

The unique identifier for the project.

ProjectName

Name of the project.

ProjectAuthorName

The name of the author of the project.

ProjectActualCost

The costs incurred for work that has already been performed on a project.

ProjectCategoryName

The name of a project category.

ProjectCompanyName

The name of the company for a project.

ProjectCritcalSlackLimit

The number of days past its end date that a task can go before Project marks that task as a critical task.

ProjectCurrencyDigits

The number of decimal digits in currency values.

ProjectCurrencyPosition

The placement of the currency symbol in relation to the currency value.

ProjectCurrencySymbol

The project currency symbol.

ProjectCurrencyCode

The currency code of the project, as defined in ISO 4217.

ProjectIsNewTasksEffortDriven

Specifies whether new tasks are effort driven.

ProjectCurrentDate

The current date for the project.

ProjectDefaultFinishTime

The default finish time for all new tasks.

ProjectDefaultFixedCostAccrual

A value that indicates which default fixed cost accrual method to use on new tasks.

ProjectMinutesPerDay

The default number of minutes per day.

ProjectMinutesPerWeek

The default number of minutes per week.

ProjectDefaultOvertimeRate

Default overtime rate for local resources.

ProjectDefaultStandardRate

Default standard rate for local resources.

ProjectDefaultStartTime

The default start time for all new tasks.

ProjectDefaultTaskType

The default type for all tasks in the project.

ProjectDurationFormat

The default format for work duration.

ProjectFinishDate

The scheduled finish date and time of a project.

ProjectTasksHonorConstraints

Indicates whether Project schedules tasks according to their constraint date.

ProjectKeywords

The keywords for a project.

ProjectLastSavedDate

The date the project was last saved.

ProjectManagerName

The name of a project manager.

ProjectMultipleCriticalPaths

Indicates whether Project calculates and displays a critical path for each independent network of tasks within a project.

ProjectPoolAttachedTo

The name of the project that shares resources with this project.

ProjectCreatedDate

The date that a project was created.

ProjectIsResourcePool

Indicates if the project is being used as resource pool.

ProjectScheduledFromStart

Indicates whether a project is scheduled from Start Date or Finish Date.

ProjectSplitTasksInProgress

Indicated whether to Allow rescheding of remaining duration and work when a task slips or reports progress ahead of schedule.

ProjectSpreadActualCostsToStatusDate

Indicates whether actual costs are spread to the status date.

ProjectSpreadPercentCompleteToStatus

Indicates whether percent complete is spread to the status date.

ProjectStartDate

The project start date and time.

ProjectStatusDate

The status date and time of a project.

ProjectSubject

The subject of a project.

ProjectTitle

The title of a project.

ProjectCalculateActualCosts

Indicates whether Project should automatically calculate actual costs.

ProjectWorkEntryFormat

The default format for all work durations in the project.

ProjectCalculatesSubTasksAsSummary

Indicates whether Project calculates sub-tasks as summary tasks.

ProjectDaysPerMonth

The default number of working days per month.

ProjectDefaultEstimatedDuration

A value that indicates whether new tasks have estimated durations.

ProjecthowEstimatedDurations

A value that indicates whether a question mark is displayed after an estimated duration for a task.

ProjectExpandTimephased

Indicates whether Project saves timephased data in a readable or binary format when saved to a database.

ProjectExternalEdited

Indicates whether the project was edited externally.

ProjectReadCount

Indicates the number of users who have one or more tables open as read-only.

ProjectType

The enumerated value that represents the type of a project.

ProjectCheckedOutBy

Name of the user who checked out the project.

ProjectCheckOutDate

The project checked out date.

ProjectPath

The project path.

ProjectActualsSyncProtectedActuals

A value that indicates whether the project actuals are synchronized with the protected actuals.

ProjectIsAdministrative

Indicates whether the project is an administrative project.

ProjectTimestamp

The timestamp on the project.

ProjectDescription

Description of the project.

ProjectLocalPath

The project local path.

ProjectWebPath

The project web path.

ProjectOwnerUID

The GUID of a project owner.

ProjectDataSourceNameID

The identifier of the project data source name.

ProjectDelegateAllowed

Indicates if project delegate is allowed.

ProjectIsNonWorking

Indicates if project is non working.

ProjectScope

The project scope.

ProjectIsConsolidatedProject

Indicates if it's a consolidated project.

ProjectResourceCanDecline

Indicates if resource can decline.

ProjectTrackingMode

The default tracking method for all assignments in the project.

ProjectLastPublishedDate

The date of last project publish.

LegacyProjectType

The legacy project type.

ProjectOptionDefaultStartTime

Default start time of a working day.

ProjectOptionDefaultFinishTime

Default end time of a working day.

ProjectSiteName

The name of the project site.

ProjectSiteServerUID

The server ID of the project site..

IssueListName

The name of the project issue list.

RiskListName

The name of the project risk list.

TotalDocumentCount

Count of documents for the project.

ProjectActiveIssueCount

Count of active issues for the project.

ProjectActiveRiskCount

Count of active risks for the project.

ProjectAdminRoleId

The identifier for the project admin role.

ProjectManagerRoleId

The identifier for the project manager role.

ProjectTeamMemberRoleId

The identifier for the project team member role.

ProjectReaderRoleId

The identifier for the project reader role.

ProjectProposalWorkflowInstanceId

The identifier of the project workflow instance.

ProjectIsAdminProjectLegacy

Indicates whether the project is an administrative project.

ProjectCalendarId

The ID for the calendar used by the project.

ProjectClientVersionNumber

The client version for the project.

ProjectVersion

The version of the project.

ProjectProgramUID

The identifier for the project program.

ProjectSessionUID

The identifier for the project session.

ProjectSessionDescription

The project session descriptor.

ProjectIsDeleted

Indicates whether the project is deleted.

ProjectBaselineCalendarId

The identifier of the project baseline calendar.

ProjectWBSPrefix

The project work breakdown prefix.

ProjectNewTasksStartOnCurrentDate

A value that indicates whether new tasks start on current date.

ProjectIsNewTasksManual

A value that indicates whether new tasks are manually scheduled.

ProjectSummaryTaskId

The task Id of the project summary task.

ProjectModifiedDate

The date and time that a project was last modified.

SharepointIdeaListWebId

The Ideas List SharePoint Web ID.

SharepointIdeaListId

The Ideas List SharePoint List ID.

SharepointIdeaItemId

The Ideas List SharePoint List Item ID.

ProjectVisibilityMode

Specifies whether the project site was created from SharePoint task list.

ProjectIsProjectSiteRemoved

Specifies whether the project site was removed.

ProjectUtilizationType

Value that represents the utilization type of a resource plan.

ProjectUtilizationDate

The start date and time for use of the project.

ProjectIdentifier

Human readable identifier for the project. This identifier is configured in the EPT.

ProjectPublishedReportingTimephasedMode

The sync mode for timephased data in reporting.

ProjectPublishedReportingTimephasedFirstDayOfWeek

The first day of the week for timephased reporting.

ProjectPublishedReportingTimephasedFirstWeekOfYear

The first week of the year for timephased reporting.

ProjectFiscalPeriodMaxModDate

The fiscal period max modified date.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×