Dim.WorkitemSource
All Workitems in have an attribute called Source. This is a single select list used to indicate the Workitems Source (Customer, Sales, Product Management). This table contains Type 1 data for the Workitem Source values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| WorkitemSourceKey | Data Mart unique identifier for this value | int |
| WorkitemSourceOid | Identifier for this value | int |
| WorkitemSourceName | Name | nvarchar |
| WorkitemSourceOrder | The order this value appears in the dropdown list | nvarchar |
| WorkitemSourceAssetState | State of the list value | int |
| WorkitemSourceCreateDateUTC | UTC Date the value was created | datetime |
| WorkitemSourceLastModifiedDateUTC | UTC Date the value was last modified | datetime |
| WorkitemSourceCreatedByKey | Data Mart identifier of the Member that created this value | int |
| WorkitemSourceLastModifiedByKey | Data Mart identifier of the Member that last modified this value | int |
| WorkitemSourceCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| WorkitemSourceLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |