Dim.IssueCategory
Issue assets in have an attribute called Category (Issue Type in the UI). This is a single select list used to indicate what category of Issue is being reported (Impediment). This table contains Type 1 data for the Issue Category values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| IssueCategoryKey | Data Mart identifier for this data | int |
| IssueCategoryOid | VersionOne identifier for this data | int |
| IssueCategoryName | Name | nvarchar |
| IssueCategoryOrder | The order this value appears in the VersionOne drop-down list | int |
| IssueCategoryAssetState | State of the list value (Active or Closed) | varchar |
| IssueCategoryCreateDateUTC | Date and time this value was created | datetime |
| IssueCategoryLastModifiedDateUTC | Date and time this value was last modified | datetime |
| IssueCategoryCreatedByKey | Data Mart identifier of the Member who created this value | int |
| IssueCategoryLastModifiedByKey | Data Mart identifier of the Member who last modified this value | int |