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: A list of projects that the user was a part of in the Project Web App (PWA) site.

• Feature-specific data: Feature in the PWA site in which the user might have data.

• Project-specific user data from the reporting data: Detailed data about a user's project in the PWA site.

• Project-specific Metadata files: Project metadata about a user's project in the PWA site.

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

• Project metadata file from the Draft schema

• Project metadata file from the Published schema

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.