Identify Master Project and Subproject

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

How to recognize which is a master project and which is a subproject.

Resolution

There is INV_FLAT_HIERARCHIES table that includes PARENT_ID and CHILD_ID columns.
PARENT_ID means Master Project ID.
CHILD_ID means Subproject ID.

Here is a sample query to get the pares of Master and Subproject. (Project and Program)

(Sample Query)
SELECT A.PARENT_ID MASTER_PROJECT_ID, 
               B.NAME MASTER_PROJECT_NAME, 
               A.CHILD_ID SUB_PROJECT_ID, 
               C.NAME SUB_PROJECT_NAME
FROM    INV_FLAT_HIERARCHIES A,
               INV_INVESTMENTS B,
               INV_INVESTMENTS C
WHERE A.PARENT_ID =B.ID
      AND A.CHILD_ID=C.ID
      AND A.PARENT_ID != A.CHILD_ID

 

Additional Information

See also: Query to determine if project is a master project or sub project