Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
Microsoft Project Adapter Views
| Name | Description |
| AssignmentBaselines | Retrieve assignment baselines. |
| AssignmentBaselineTimephasedDataSet | Retrieve assignment baseline timephased dataset. |
| Assignments | Retrieve assignments. |
| AssignmentTimephasedDataSet | Retrieve assignment timephased dataset. |
| BusinessDriverDepartments | Retrieve business driver departments. |
| BusinessDrivers | Retrieve business drivers. |
| CostConstraintScenarios | Retrieve cost constraint scenarios. |
| CostScenarioProjects | Retrieve cost scenario projects. |
| Deliverables | Retrieve deliverables. |
| Engagements | Retrieve engagements. |
| EngagementsComments | Retrieve engagements comments. |
| EngagementsTimephasedDataSet | Retrieve engagements timephased dataset. |
| FiscalPeriods | Retrieve fiscal periods. |
| Issues | Retrieve issues. |
| IssueTaskAssociations | Retrieve issue-task associations. |
| PortfolioAnalyses | Retrieve portfolio analyses. |
| PortfolioAnalysisProjects | Retrieve portfolio analysis projects. |
| PrioritizationDriverRelations | Retrieve prioritization driver relations. |
| PrioritizationDrivers | Retrieve prioritization drivers. |
| Prioritizations | Retrieve prioritizations. |
| ProjectBaselines | Retrieve project baselines. |
| Projects | Retrieve projects. |
| ProjectWorkflowStageDataSet | Retrieve project workflow stage dataset. |
| ResourceConstraintScenarios | Retrieve resource constraint scenarios. |
| ResourceDemandTimephasedDataSet | Retrieve resource demand timephased dataset. |
| Resources | Retrieve resources. |
| ResourceScenarioProjects | Retrieve resource scenario projects. |
| ResourceTimephasedDataSet | Retrieve resource timephased dataset. |
| Risks | Retrieve risks. |
| RiskTaskAssociations | Retrieve risk task associations. |
| TaskBaselines | Retrieve task baselines. |
| TaskBaselineTimephasedDataSet | Retrieve task baseline timephased dataset. |
| Tasks | Retrieve tasks. |
| TaskTimephasedDataSet | Retrieve task timephased dataset. |
| TimeSet | Retrieve timeset. |
| TimesheetClasses | Retrieve timesheet classes. |
| TimesheetLineActualDataSet | Retrieve timesheet line actual dataset. |
| TimesheetLines | Retrieve timesheet lines. |
| TimesheetPeriods | Retrieve timesheet periods. |
| Timesheets | Retrieve timesheets. |