For all IDs in inv_investments, there are no corresponding records in prj_baseline_details and prj_baselines tables

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We would like to understand how the data is made available in the below tables. And why there are some investments (in inv_investments table) for which there are no corresponding records in these tables.

prj_baseline_details
prj_baselines

Environment

Version: 15.8

Resolution

These two are tables related with the Baselines. If an investment does not hold any baselines then no data would be available against either prj_baselines or prj_baseline_details table for that investment.

We can check if there are any baselines against a project by navigating to Home -> Project -> {Specific Project} -> Properties -> Baseline subpage. A sample screenshot is below.