Where is the Work Plan Template ID stored in DB when add work plan from template

Hi,

The work plan template is not added in the project settings for work plans. The Project Manager or PMO office will add the work plan template depending on the type of project, "Create work plan from a template ..."

The customer want a report that indicate any project where the work plan was not added from a template.

I checked DB table pm_work_plans and kdrv_projects_v. The work_plan_template_id for table pm_work_plans returns null. The template_flag and project_template_id for table kdrv_projects_v return N and null for the two columns.

How can I determine if a Template was used to create the work plan for a project?

Your assistance in this matter is higly appreciated.

Regards,

Alfred Puth

iOCO: Senior PPM Consultant

  • Verified Answer

    +1  

    Hi Alfred,

    After a quick check the only thing I could find is that PM_WORK_PLANS.IS_COPY_FLAG will be set to "y" for work plans created from a Template (or from copying another work plan).

    Column work_plan_template_id will only contain a value if the work plan itself is a template. 

    I haven't found any column indicating whether a work plan was created from a specific template.

  • 0 in reply to   

    Thanks Etienne, 

    I will use the PM_WORK_PLANS.IS_COPY_FLAG, that should help the customer to monitor when a Template ot Copy from another Project was used.

    I tested and Importing from MPP or creating a blank work plan, return PM_WORK_PLANS.IS_COPY_FLAG ="N"

    Thanks again for your assistance.

    Regards,

    Alfred Puth

    iOCO: Senior PPM Consultant

  • Verified Answer

    +1 in reply to   

    Hi Etienne,

    The Work Plan Template Name is in the Project Audit Trail and can be extracted with the following Select Statement:

    SELECT
       iae.message
    FROM
       itg_audit_events iae
    WHERE
          iae.event_type_code = 9
       AND iae.container0_id = 12345
    ORDER BY
       iae.event_date DESC

    container0_id should be equal to the Project ID.

    Regards,

    Alfred Puth

    iOCO: Senior PPM Consultant