Dataflow/source of project.Subprojects Portlet

Products

• Clarity PPM On Premise

Issue/Introduction

Request you to help to know where the data is flowing in to project.Subprojects portlet, especially into the schedule column on this portlet.  

Environment

Release : 15.8.1

Component : CA PPM STUDIO

Resolution

As per SQL Trace setup while navigating to Project properties->Subproject page it was identified below is the SQL which determines Schedule column logic

(CASE WHEN B.FINISH_DATE IS NULL THEN NULL WHEN  TRUNC(B.FINISH_DATE-0.0001) < TRUNC(I.SCHEDULE_FINISH-0.0001)  THEN 1 ELSE 0 END) as BEHIND_SCHED

I stands for INV_INVESTMENTS table

B stands for PRJ_BASELINE_DETAILS table

So this basically tells us whether a project is on schedule or not, so either Green or Red if behind.