What is different between IS_TEMPLATE column in INV_PROJECTS and DWH_INV_INVESTMENTS table and ODF_TEMPLATE column in INV_INVESTMENTS table?
Clarity Release : 16.1.2
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
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.