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:

  • 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.
TaskStatus_AssignmentsHistory
Statusing assignments history data.
TaskStatus_AssignmentsSaved
Statusing assignments save data.
TaskStatus_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.
TaskTimephasedDataset
Timephased reporting data for tasks (Applies to only Project Server Subscription Edition).
TaskBaselineTimephasedDataset
Timephased reporting data for tasks baselines (Applies to only Project Server Subscription Edition).
AssignmentTimephasedDataset
Timephased reporting data for assignments (Applies to only Project Server Subscription Edition).
AssignmentBaselineTimephasedDataset
Timephased reporting data for assignments baselines (Applies to only Project Server Subscription Edition).

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.
DriverName
The name of a 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.
SubmitterResourceName
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
Proposed contour which is not flat.
CommittedCustomContour
Committed contour which is not flat.

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.
PlanningHorizonStartDate
The beginning of the date and time range that is considered in a portfolio analysis.
PlanningHorizonEndDate
The end of the date and time range that is considered in a portfolio analysis.
RoleCustomFieldId
The GUID of the custom field that is used to define a role.
RoleCustomFieldName
TThe name of the custom field that is used to define a role.

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.
ResourceRequiresEngagement
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.
ProjectName
The name of the project.
ResourceID
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.
AssignmentActualStartDate
The date and time that the assignment actually began.
AssignmentActualFinishDate
The date and time when an assignment was actually completed.
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.
ResourcePlanCreationDate
Date and time the resource plan was created.
ResourcePlanModDate
Date and time the resource plan was last updated.
ResourcePlanStartDate
Date and time the resource plan began.
ResourcePlanFinishDate
Date and time the resource plan ended.
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.

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
Field1Name
Fields used for comparisons in approval rules.
Field2Name
Fields used for comparisons in approval rules.
AssignmentLastDelegationId
The last delegation performed on this assignment.
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, a ParentPermissionData 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, a PermissionData 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 WeekDetails 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.
TaskStartOffset
Offset for the task start
TaskReservedData
Used to temporarily store calculated values.
TaskSummaryProgressDate
Internal user only.

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 actual overtime cost of the assignment.
AssignmentOvertimeCost1
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.
AssignmentIsConfirmed1
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.
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.
AssignmentActualOvertimeCost
The costs incurred for overtime work that has already been performed on an 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.
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.
ReserverData
Internal user only.
AssignmentIsConfirmed
Indicates whether this resource has accepted or rejected the task assignment.
HistoryNotes
Archives user comments about an assignment.
AssignmentDelegationPending
True if delete for assignment is pending to be applied.
WNWRK_UID
Internal use only.
WNWORK_ENTRY_UID
Internal use only.
AssignmentOvertimeCost
The total overtime cost for an assignment, including costs for overtime work that has already been performed, in addition to remaining overtime costs.
AssignmentCV
Earned value cost variance.
ProjectSummaryAssignmentID
Unique identifier of the project summary assignment.

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
Indicates whether this resource has accepted or rejected the task assignment.
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.
AssignmentDelegationPending
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
The sum of the actual and remaining overtime cost of the assignment.
AssignmentOvertimeCost
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 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 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".

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.
CustomFieldValue
Value properties for 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
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.

TaskTimephasedDataset

TaskTimephasedDataset contains the properties that define the reporting data for task timephased data in the reporting schema. It has the following properties:

Property Description
TaskUID
Unique identifier for the task.
TimeByDay
A primary key that identifies a day along a timeline. The granularity is in days only.
FiscalPeriodUID
The identifier 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.

TaskBaselineTimephasedDataset

TaskBaselineTimephasedDataset contains the properties that define the reporting data for task baseline timephased data in the reporting schema. It has the following properties:

Property Description
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.
TaskName
Name of the task.
ProjectName
Name of the project.

AssignmentTimephasedDataset

AssignmentTimephasedDataset contains the properties that define the reporting data for assignment timephased data in the reporting schema. It has the following properties:

Property Description
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.
ResourceUID
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.

AssignmentBaselineTimephasedDataset

AssignmentBaselineTimephasedDataset contains the properties that define the reporting data for assignment baseline timephased data in the reporting schema. It has the following properties:

Property Description
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.
ResourceUID
Unique identifier for the resource.
TaskName
Name of the task.
ProjectName
Name of the project.

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 of Project1 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
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.
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
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.
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
BaselineNumber
A number that identifies a project baseline.
AssignmentUid
Unique identifier of the assignment.
AssignmentType
Type of the assignment. NormalAssignment=0, WorkOnlyAssignment=1, FixedCostAssignment=2, FixedCostWorkOnlyAssignment=3, EmptyAssignment=4, FixedCostGeneratedAssignment=100 (generated during RDS transfer), ResourcePlanAssignment=101.
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.
AssignmentBaselineStartDate
The planned start date of the assignment.
AssignmentBaselineFinishDate
The planned finish date of the assignment.
AssignmentBaselineModifiedDate
The planned finish date of the assignment.
AssignmentBaselineModifiedDate
Date and time the assignment baseline was last modified.
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.
ResourceRequiresEngagements
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
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.
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
TaskID
Unique identifier for the task.
TimeByDay
A primary key that identifies a day along a timeline. The granularity is in days only.
FiscalPeriodUID
The identifier 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 metadata 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 metadata 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.
ProjectShowEstimatedDurations
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 metadata 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.
ProjectShowEstimatedDurations
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.