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 |
|---|---|
Represents reporting data for an assignment. |
|
Represents reporting data for an assignment baseline. |
|
Represents reporting data for assignment baseline timephased data. |
|
Represents reporting data for assignment timephased data. |
|
Represents reporting data for a business driver. |
|
Represents reporting data for a business driver department. |
|
Represents reporting data for a cost constraint scenario. |
|
Represents reporting data for a cost scenario project. |
|
Represents reporting data for a deliverable. |
|
Represents reporting data for an issue. |
|
Represents reporting data for an issue task association. |
|
Represents reporting data for a portfolio analysis. |
|
Represents reporting data for a portfolio analysis project. |
|
Represents reporting data for a prioritization. |
|
Represents reporting data for a prioritization driver. |
|
Represents reporting data for a prioritization driver relation. |
|
Represents reporting data for a project. |
|
Represents reporting data for a project baseline. |
|
Represents reporting data for project workflow stage data. |
|
Represents reporting data for a resource. |
|
Represents reporting data for a resource constraint scenario. |
|
Represents reporting data for a resource scenario project. |
|
Represents reporting data for resource timephased data. |
|
Represents reporting data for a risk. |
|
Represents reporting data for a risk task association. |
|
Represents reporting data for a task. |
|
Represents reporting data for a task baseline. |
|
Represents reporting data for task baseline timephased data. |
|
Represents reporting data for task timephased data. |
|
Represents reporting data for a time period. |
|
Represents reporting data for a timesheet. |
|
Represents reporting data for a timesheet class. |
|
Represents reporting data for a timesheet line. |
|
Represents reporting data for timesheet actual data. |
|
Represents reporting data for a timesheet period. |
Association elements
The ReportingData namespace contains the following Association elements.
Association element |
Description |
|---|---|
Relates assignments to a resource and relates a resource to its assignments. |
|
Relates assignments to the task that contains them and relates a task to its assignments. |
|
Relates an assignment with its baseline. |
|
AssignmentBaseline_AssignmentBaselineTimephasedDataSet_AssignmentBaselineTimephasedData_Baseline |
Relates an assignment baseline with its assignment baseline timephased dataset. |
Relates assignment baselines to a task and relates a task to its assignment baselines. |
|
Relates timephased data in an assignment baseline to an assignment. |
|
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. |
Relates assignment timephased data to a project. |
|
Relates assignment timephased data to a task. |
|
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. |
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. |
Relates cost constraint scenarios to a resource. |
|
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. |
Relates cost scenarios projects to a portfolio analysis. |
|
Relates cost scenario projects to a project. |
|
Relates the deliverable to its dependent tasks. |
|
Relates the deliverable to its parent projects. |
|
Relates deliverables to parent tasks. |
|
Relates issues to related risks and risks to related issues. |
|
Relates issues to subissues. |
|
Issue_Tasks_Task_Issues |
Relates an issue to tasks and relates a task to issues. |
Relates an issue task association to an issue. |
|
Relates an issue task association to a project. |
|
Relates an issue task association to a related project. |
|
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. |
Relates portfolio analyses to the creating resource. |
|
Relates portfolio analysis to the resource that did modifications. |
|
Relates portfolio analyses to a prioritization. |
|
PortfolioAnalysis_ResourceConstraintScenarios_ResourceConstraintScenario_Analysis |
Relates portfolio analyses to resource constraint scenarios. |
Relates portfolio analysis projects to a project. |
|
Relates prioritizations to a resource. |
|
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. |
Relates prioritization drivers to a business driver. |
|
Relates project prioritizations in a portfolio analysis to the first business driver. |
|
Relates project prioritizations in a portfolio analysis to the second business driver. |
|
Relates a project to the assignment baselines that it contains and relates assignment baselines to a project. |
|
Relates a project to the assignments that it contains and relates assignments to a project. |
|
Relates a project to the deliverables that it contains and relates deliverables to projects. |
|
Relates project to dependencies and relates deliverables to dependent projects. |
|
Relates a project to the issues that it contains and relates a collection of issues to its project. |
|
Relates a project to the risks that it contains and relates a risk to its project. |
|
Relates a project to workflow stage information and relates workflow stage data to a project. |
|
Relates a project to the tasks that it contains and relates a task to its project. |
|
Relates project baselines to a project. |
|
Relates portfolio analysis resource constraint scenarios to a resource. |
|
Relates portfolio analysis resource constraint scenarios to a resource. |
|
Relates a resource constraint scenario to resource scenario projects and relates resource scenario projects to a resource constraint scenario. |
|
Relates resource scenario projects to an analysis. |
|
Relates resource scenario projects to a cost constraint scenario. |
|
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. |
Relates risks to subrisks. |
|
Relates a risk to tasks and relates a task to risks. |
|
Relates a risk task association to a project. |
|
Relates risk task association to a related project. |
|
Relates a risk task association to a risk. |
|
Relates a risk task association to a task. |
|
Relates task baselines to a project. |
|
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. |
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. |
Relates task timephased data to its project. |
|
Relates a task timephased data to a task and relates a task to timephased information. |
|
Relates a timesheet period to its timesheet. |
|
Relates a timesheet line to actual data and relates timesheet line actual data to a timesheet line. |
|
Relates an approver resource to its timesheet line. |
|
Relates timesheet lines to a timesheet and relates a timesheet to timesheet lines. |
|
Relates a timesheet line to a timesheet class. |
|
Relates timesheet line actual data to a resource. |
|
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