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