Dim.DefectType
Defects in Agility have an attribute called Type. This is a single select list used to indicate what type of Defect is being reported (Code, Documentation). This table contains Type 1 data for the defect type values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| DefectTypeKey | Data Mart unique identifier for this value | int |
| DefectTypeOid | VersionOne unique identifier for this value | int |
| DefectTypeName | Name | varchar |
| DefectTypeOrder | The order this value appears in the VersionOne drop-down list | int |
| DefectTypeAssetState | State of this list value (Active or Closed) | varchar |
| DefectTypeCreateDateUTC | Value create date in UTC | datetime |
| DefectTypeLastModifiedDateUTC | Value modified date in UTC | datetime |
| DefectTypeCreatedByKey | Data Mart identifier of the Dim.Member that created this value | int |
| DefectTypeLastModifiedByKey | Data Mart identifier of the Dim.Member that last modified this value | int |
| DefectTypeCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| DefectTypeLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |