IS_TEMPLATE and ODF_TEMPLATE

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

What is different between IS_TEMPLATE column in INV_PROJECTS and DWH_INV_INVESTMENTS table and ODF_TEMPLATE column in INV_INVESTMENTS table?

Environment

Clarity Release : 16.1.2

Resolution

IS_TEMPLATE (INV_PROJECTS)

IS_TEMPLATE is template flag which is used in classic ppm for determining if a project is a template. This column indicates if the project is marked as a template or not. Templates are used to create new projects and are restricted from some project functionality.

IS_TEMPLATE is included for Datawarehouse 

ODF_TEMPLATE (INV_INVESTMENTS)

Whereas ODF_TEMPLATES is the attribute introduced for investment object and would be the primary flag to determine the template status of the object instances in the modern UI. 

This column indicates if the investment is marked as a template or not. Templates are used to create new investments and are restricted from some investment functionality. Used in the modern UI and introduced from 16.0. There is also ODF_TEMPLATE_ID, i.e. the When an investment is created from a template this field is populated with the template's internal id.

ODF_TEMPLATE is yet to be included for Datawarehouse.