Dim.DefectResolution
Defect assets in Agility have an attribute called Resolution. This is a single select list used to indicate how the Defect was resolved (Fixed, As Designed, etc). This table contains Type 1 data for the Defect Resolution values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| DefectResolutionKey | Data Mart unique identifier for this value | int |
| DefectResolutionOid | VersionOne unique identifier for this value | int |
| DefectResolutionName | Name | varchar |
| DefectResolutionOrder | The order this value appears in the VersionOne drop-down list | int |
| DefectResolutionAssetState | State of the list value (Active or Closed) | varchar |
| DefectResolutionCreateDateUTC | Value create date in UTC | datetime |
| DefectResolutionLastModifiedDateUTC | Value modified date in UTC | datetime |
| DefectResolutionCreatedByKey | Data Mart identifier of the Dim.Member that created this value | int |
| DefectResolutionLastModifiedByKey | Data Mart identifier of the Dim.Member that last modified this value | int |
| DefectResolutionCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| DefectResolutionLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |