Request you to help to know where the data is flowing in to project.Subprojects portlet, especially into the schedule column on this portlet.
Release : 15.8.1
Component : CA PPM STUDIO
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.