How does the column 'PICKLIST_DEF_ID' get populated

Products

• Clarity PPM On Premise

Issue/Introduction

How does the column 'PICKLIST_DEF_ID' get populated in ODF_ITEM_POSITIONS table?

Environment

Release : 15.9.2

Component : CLARITY DATA WAREHOUSE

Resolution

In the 'ODF_ITEM_POSITIONS' table, values in the column 'PICKLIST_DEF_ID' column are populated when from the Modern UX - Project -> Task - Board page, a new value is selected in the 'Columns' dropdown within 'Board Options'

When a new picklist is also created in the 'Board Options', a new entry is populated in the 'PICKLIST_DEF_ID' column of the ODF_ITEM_POSITIONS' table.