In previous discussions with AMD and in MUG, we have decided to move from using project types (added in the project summary view) to focusing on component work types. In order to incorporate this data into the project summary view and the project list, we need to add a column to the project_list_view database view that gives a summary of all component work types across all components associated with a project.
This column has similarities to the funding_source_name and funding_program_names columns calculated in the funding_sources_lookup CTE in the project_list_view.
In Scope
Add a column called component_work_types to the project_list_view which is:
A de-duplicated and comma-separated list of all component work types on all components associated with a project
NULL if there are no component work types
Does not include work types of related project components
In previous discussions with AMD and in MUG, we have decided to move from using project types (added in the project summary view) to focusing on component work types. In order to incorporate this data into the project summary view and the project list, we need to add a column to the
project_list_viewdatabase view that gives a summary of all component work types across all components associated with a project.This column has similarities to the
funding_source_nameandfunding_program_namescolumns calculated in thefunding_sources_lookupCTE in theproject_list_view.In Scope
component_work_typesto theproject_list_viewwhich is:NULLif there are no component work types