Export (0) Print
Expand All
Expand Minimize

Schema: ReportingData (ProjectData service)

Office 2013

Last modified: June 23, 2014

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.

<Schema Namespace="ReportingData" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" 
    xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" 
    xmlns="http://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.

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.

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.

Show:
© 2014 Microsoft