Skip to main content
System StatusContact Support
VersionOne Community

Dim.DefectResolution

This feature is available in Enterprise and Ultimate editions.

Defect assets in VersionOne 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 VersionOne 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 dropdown list int
DefectResolutionAssetState State of the list value (Active or Closed) varchar
DefectResolutionCreateDateUTC Value create date UTC datetime
DefectResolutionLastModifiedDateUTC Value modified date 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
  • Was this article helpful?