Skip to main content
System StatusContact Support
VersionOne Community

Dim.DefectType

This feature is available in Enterprise and Ultimate editions.

Defects in VersionOne have an attribute called Type. This is a single select list used to indicate what type of Defect is being reported (Code, Documentation, etc). This table contains Type 1 data for the defect type values defined in your VersionOne 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 dropdown list int
DefectTypeAssetState State of this list value (Active or Closed) varchar
DefectTypeCreateDateUTC Value create date UTC datetime
DefectTypeLastModifiedDateUTC Value modified date 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
  • Was this article helpful?