How to identify project template used in the project creation?

Article Id: 20130
Status: Published
Updated On: 14-02-2018 07:51
Legacy Id: TEC600149
Products:
CLARITY PPM FOR ITG , CA Project & Portfolio Management , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , STARTER PACK-CLARITY PPM
Issue/Introduction:

Issue:

Is there a way to identify a template used in the creation of projects?

Environment:

Applies to all supported PAS environments. 

Resolution:

  1. Create a Project Template (make a note of the internal ID from the URL)
  2. Once created, create new project from template created in step #1 (make a note of the internal ID from the URL)
  3. Check the following database table: ODF_OBJECT_COPY_FLAT

    SELECT * FROM ODF_OBJECT_COPY_FLAT
  4. Main Columns from this result provide the following information:

    OBJECT_ID = Corresponds at internal ID of the new project created
    SRC_OBJECT_ID = Corresponds at internal ID of the Template used

Note: The unique exception that occurs is when project created through project template is marked as new template and then this new project template is used, for this case in the previous table 2 records will be added. This is by product design.

Environment:

Release: ESPCLA99000-13.2-Clarity-Extended Support Plus
Component: