Dim.IssueResolution
Issue assets in Agility have an attribute called Resolution. This is a single select list used to indicate the how the issue was resolved (No Action). This table contains Type 1 data for the Issue Resolution values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| IssueResolutionKey | Data Mart identifier for this data | int |
| IssueResolutionOid | Identifier for this data | int |
| IssueResolutionName | Name | nvarchar |
| IssueResolutionOrder | The order this value appears in the drop-down list | int |
| IssueResolutionAssetState | State of the list value (Active or Closed) | varchar |
| IssueResolutionCreateDateUTC | Date and time this value was created | datetime |
| IssueResolutionLastModifiedDateUTC | Date and time this value was last modified | datetime |
| IssueResolutionCreatedByKey | Data Mart identifier of the Member who created this value | int |
| IssueResolutionLastModifiedByKey | Data Mart identifier of the Member who last modified this value | int |
| IssueResolutionCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| IssueResolutionLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |