Schema: ReportingData (ProjectData service)

In this article
Definition
Parent element
Child elements

Specifies the ReportingData namespace, which defines entity types and associations used to query the ProjectData OData service for reporting data.

Definition

<Schema Namespace="ReportingData" xmlns:d="https://schemas.microsoft.com/ado/2007/08/dataservices" 
    xmlns:m="https://schemas.microsoft.com/ado/2007/08/dataservices/metadata" 
    xmlns="https://schemas.microsoft.com/ado/2007/05/edm">

The XML namespace attributes (xmlns) specify the namespaces for services and metadata in the OData specification, and for the Entity Data Model (EDM) of an OData service. You can browse the ReportingData EDM by using the <pwa_url>/_api/projectdata/$metadata endpoint.

Parent element

None

Child elements

EntityType elements
Association elements

EntityType elements

The ReportingData namespace contains the following EntityType elements.

EntityType element	Description
Assignment	Represents reporting data for an assignment.
AssignmentBaseline	Represents reporting data for an assignment baseline.
AssignmentBaselineTimephasedData	Represents reporting data for assignment baseline timephased data.
AssignmentTimephasedData	Represents reporting data for assignment timephased data.
BusinessDriver	Represents reporting data for a business driver.
BusinessDriverDepartment	Represents reporting data for a business driver department.
CostConstraintScenario	Represents reporting data for a cost constraint scenario.
CostScenarioProject	Represents reporting data for a cost scenario project.
Deliverable	Represents reporting data for a deliverable.
Issue	Represents reporting data for an issue.
IssueTaskAssociation	Represents reporting data for an issue task association.
PortfolioAnalysis	Represents reporting data for a portfolio analysis.
PortfolioAnalysisProject	Represents reporting data for a portfolio analysis project.
Prioritization	Represents reporting data for a prioritization.
PrioritizationDriver	Represents reporting data for a prioritization driver.
PrioritizationDriverRelation	Represents reporting data for a prioritization driver relation.
Project	Represents reporting data for a project.
ProjectBaseline	Represents reporting data for a project baseline.
ProjectWorkflowStageData	Represents reporting data for project workflow stage data.
Resource	Represents reporting data for a resource.
ResourceConstraintScenario	Represents reporting data for a resource constraint scenario.
ResourceScenarioProject	Represents reporting data for a resource scenario project.
ResourceTimephasedData	Represents reporting data for resource timephased data.
Risk	Represents reporting data for a risk.
RiskTaskAssociation	Represents reporting data for a risk task association.
Task	Represents reporting data for a task.
TaskBaseline	Represents reporting data for a task baseline.
TaskBaselineTimephasedData	Represents reporting data for task baseline timephased data.
TaskTimephasedData	Represents reporting data for task timephased data.
Time	Represents reporting data for a time period.
Timesheet	Represents reporting data for a timesheet.
TimesheetClass	Represents reporting data for a timesheet class.
TimesheetLine	Represents reporting data for a timesheet line.
TimesheetLineActualData	Represents reporting data for timesheet actual data.
TimesheetPeriod	Represents reporting data for a timesheet period.

Association elements

The ReportingData namespace contains the following Association elements.

Association element	Description
Assignment_Resource_Resource_Assignments	Relates assignments to a resource and relates a resource to its assignments.
Assignment_Task_Task_Assignments	Relates assignments to the task that contains them and relates a task to its assignments.
AssignmentBaseline_Assignment_Assignment_Baseline	Relates an assignment with its baseline.
AssignmentBaseline_AssignmentBaselineTimephasedDataSet_AssignmentBaselineTimephasedData_Baseline	Relates an assignment baseline with its assignment baseline timephased dataset.
AssignmentBaseline_Task_Task_AssignmentsBaselines	Relates assignment baselines to a task and relates a task to its assignment baselines.
AssignmentBaselineTimephasedData_Assignment	Relates timephased data in an assignment baseline to an assignment.
AssignmentBaselineTimephasedData_Project	Relates timephased data in an assignment baseline to a project.
AssignmentBaselineTimephasedData_Tasks_Task_AssignmentsBaselineTimephasedData	Relates timephased data for assignment baselines to a task and relates a task to timephased data for assignment baselines.
AssignmentTimephasedData_Assignment_Assignment_TimephasedData	Relates assignment timephased data to its assignment and relates an assignment to its timephased data.
AssignmentTimephasedData_Project	Relates assignment timephased data to a project.
AssignmentTimephasedData_Task	Relates assignment timephased data to a task.
BusinessDriver_CreatedByResource	Relates business drivers to a resource.
BusinessDriver_Departments_BusinessDriverDepartment_BusinessDriver	Relates a business driver to departments that it contains and relates business driver departments to a business driver.
BusinessDriver_ModifiedByResource	Relates business drivers to a resource.
CostConstraintScenario_CostScenarioProjects_CostScenarioProject_CostConstraintScenario	Relates a cost constraint scenario to cost scenario projects and relates cost scenario projects to a cost constraint scenario.
CostConstraintScenario_CreatedByResource	Relates cost constraint scenarios to a resource.
CostConstraintScenario_ModifiedByResource	Relates cost constraint scenarios to a resource.
CostConstraintScenario_ResourceConstraintScenarios_ResourceConstraintScenario_CostConstraintScenario	Relates a cost constraint scenario to the resource constraint scenarios that it contains and relates resource constraint scenarios to a cost constraint scenario.
CostScenarioProject_Analysis	Relates cost scenarios projects to a portfolio analysis.
CostScenarioProject_Project	Relates cost scenario projects to a project.
Deliverable_DependentTasks	Relates the deliverable to its dependent tasks.
Deliverable_ParentProjects	Relates the deliverable to its parent projects.
Deliverable_ParentTasks	Relates deliverables to parent tasks.
Issue_RelatedRisks_Risk_RelatedIssues	Relates issues to related risks and risks to related issues.
Issue_SubIssues	Relates issues to subissues.
Issue_Tasks_Task_Issues	Relates an issue to tasks and relates a task to issues.
IssueTaskAssociation_Issue	Relates an issue task association to an issue.
IssueTaskAssociation_Project	Relates an issue task association to a project.
IssueTaskAssociation_RelatedProject	Relates an issue task association to a related project.
IssueTaskAssociation_Task	Relates an issue task association to a task.
PortfolioAnalysis_AnalysisProjects_PortfolioAnalysisProject_Analysis	Relates a portfolio analysis to the analysis projects that it contains and relates portfolio analysis projects to an analysis.
PortfolioAnalysis_CostConstraintScenarios_CostConstraintScenario_Analysis	Relates a portfolio analysis to the cost constraint scenarios that it contains and relates a collection of cost constraint scenarios to its portfolio analysis.
PortfolioAnalysis_CreatedByResource	Relates portfolio analyses to the creating resource.
PortfolioAnalysis_ModifiedByResource	Relates portfolio analysis to the resource that did modifications.
PortfolioAnalysis_Prioritization	Relates portfolio analyses to a prioritization.
PortfolioAnalysis_ResourceConstraintScenarios_ResourceConstraintScenario_Analysis	Relates portfolio analyses to resource constraint scenarios.
PortfolioAnalysisProject_Project	Relates portfolio analysis projects to a project.
Prioritization_CreatedByResource	Relates prioritizations to a resource.
Prioritization_ModifiedByResource	Relates portfolio analysis prioritizations to the resource that modified prioritizations.
Prioritization_PrioritizationDriverRelations_PrioritizationDriverRelation_Prioritization	Relates a prioritization to prioritization driver relations and relates prioritization driver relations to a prioritization.
Prioritization_PrioritizationDrivers_PrioritizationDriver_Prioritization	Relates a prioritization to the prioritization drivers that it contains and relates a collection of prioritization drivers to its prioritization.
PrioritizationDriver_BusinessDriver	Relates prioritization drivers to a business driver.
PrioritizationDriverRelation_BusinessDriver1	Relates project prioritizations in a portfolio analysis to the first business driver.
PrioritizationDriverRelation_BusinessDriver2	Relates project prioritizations in a portfolio analysis to the second business driver.
Project_AssignmentBaselines_AssignmentBaseline_Project	Relates a project to the assignment baselines that it contains and relates assignment baselines to a project.
Project_Assignments_Assignment_Project	Relates a project to the assignments that it contains and relates assignments to a project.
Project_Deliverables_Deliverable_Project	Relates a project to the deliverables that it contains and relates deliverables to projects.
Project_Dependencies_Deliverable_DependentProjects	Relates project to dependencies and relates deliverables to dependent projects.
Project_Issues_Issue_Project	Relates a project to the issues that it contains and relates a collection of issues to its project.
Project_Risks_Risk_Project	Relates a project to the risks that it contains and relates a risk to its project.
Project_StagesInfo_ProjectWorkflowStageData_Project	Relates a project to workflow stage information and relates workflow stage data to a project.
Project_Tasks_Task_Project	Relates a project to the tasks that it contains and relates a task to its project.
ProjectBaseline_Project	Relates project baselines to a project.
ResourceConstraintScenario_CreatedByResource	Relates portfolio analysis resource constraint scenarios to a resource.
ResourceConstraintScenario_ModifiedByResource	Relates portfolio analysis resource constraint scenarios to a resource.
ResourceConstraintScenario_ResourceScenarioProjects_ResourceScenarioProject_ResourceConstraintScenario	Relates a resource constraint scenario to resource scenario projects and relates resource scenario projects to a resource constraint scenario.
ResourceScenarioProject_Analysis	Relates resource scenario projects to an analysis.
ResourceScenarioProject_CostConstraintScenario	Relates resource scenario projects to a cost constraint scenario.
ResourceScenarioProject_Project	Relates a resource scenario project to its project.
ResourceTimephasedData_Resource_Resource_TimephasedInfoDataSet	Relates resource timephased data to a resource and relates a resource to timephased information.
Risk_SubRisks	Relates risks to subrisks.
Risk_Tasks_Task_Risks	Relates a risk to tasks and relates a task to risks.
RiskTaskAssociation_Project	Relates a risk task association to a project.
RiskTaskAssociation_RelatedProject	Relates risk task association to a related project.
RiskTaskAssociation_Risk	Relates a risk task association to a risk.
RiskTaskAssociation_Task	Relates a risk task association to a task.
TaskBaseline_Project	Relates task baselines to a project.
TaskBaseline_Task_Task_Baselines	Relates a task to task baselines and relates task baselines to a task.
TaskBaseline_TaskBaselineTimephasedDataSet_TaskBaselineTimephasedData_TaskBaselines	Relates a task baseline to task baseline timephased data and relates task baseline timephased data to task baselines.
TaskBaselineTimephasedData_Project	Relates a project to the task baseline timephased data that it contains.
TaskBaselineTimephasedData_Task_Task_BaselinesTimephasedDataSet	Relates task baseline timephased data to a task and relates a task to a baseline timephased dataset.
TaskTimephasedData_Project	Relates task timephased data to its project.
TaskTimephasedData_Task_Task_TimephasedInfo	Relates a task timephased data to a task and relates a task to timephased information.
Timesheet_Periods	Relates a timesheet period to its timesheet.
TimesheetLine_Actuals_TimesheetLineActualData_TimesheetLine	Relates a timesheet line to actual data and relates timesheet line actual data to a timesheet line.
TimesheetLine_ApproverResource	Relates an approver resource to its timesheet line.
TimesheetLine_Timesheet_Timesheet_Lines	Relates timesheet lines to a timesheet and relates a timesheet to timesheet lines.
TimesheetLine_TimesheetClass	Relates a timesheet line to a timesheet class.
TimesheetLineActualData_LastChangedByResource	Relates timesheet line actual data to a resource.
TimesheetLineActualData_Time	Relates timesheet line actual data to a time entity.

Remarks

OData queries of the Reporting tables can be used with Project Server online or on-premises. The OData schema for the ProjectData service contains two namespaces that are specified by Schema elements. The ReportingData namespace is used for queries of data for entities such as Project, Resource, and Task, and for entity associations such as project risks and resource assignments.

The ProjectData service uses the Microsoft.Office.Project.Server namespace for queries of the reporting tables that return entity sets such as Projects and Tasks, and association sets such as Ref_Projects_Tasks_Tasks, which is the primary key that internally relates a Projects_Tasks association with the Tasks entity set.

See also

Reference

Schema element: Microsoft.Office.Project.Server

Concepts

Querying OData feeds for Project 2013 reporting data