Skip to main content
System StatusContact Support
VersionOne Community

Dim.Issue

This feature is available in Enterprise and Ultimate editions.

VersionOne Issues are used to highlight those items that require project-wide visibility. This table contains Type 1 data for Issues defined in your VersionOne instance.

Table Description

Column Name Description Datatype
IssueKey Datamart unique identifier for this Issue int
IssueOid VersionOne identifier for this Issue int
IssueName Issue Name nvarchar
IssueDisplayed Issue identifier visible in VersionOne grid varchar
IssueTargetDate Value of the Target Date attribute on this Issue datetime
IssueTargetDateKey Foreign Key to the Date dimension for the Target Date value int
IssueProjectKey Foreign Key to the Project that owns this Issue int
IssueProjectName Name of the Project that owns this Issue nvarchar
IssueTeamKey Foreign Key to the Team assigned to this Issue int
IssueTeamName Name of the Team assigned to this Issue nvarchar
IssueOwnerKey Foreign Key to the Member that owns this Issue int
IssueOwnerName Name of the Member that owns this Issue nvarchar
IssueIdentifiedBy Value of the Identified By attribute on this Issue nvarchar
IssueReference Value of the Reference attribute on this Issue nvarchar
IssueTypeName Value of the Type attribute on this Issue nvarchar
IssuePriorityName Value of the Priority attribute on this Issue nvarchar
IssueSourceName Value of the Source attribute on this Issue nvarchar
IssueResolutionName Value of the Resolution attribute on this Issue nvarchar
IssueClosedDateUTC The UTC date and time this Primary Workitem was Closed / Archived datetime
IssueClosedDateKey Foreign Key to Dim.Date for the Closed Date int
IssueClosedByID Foreign Key the the Dim.Member that closed this Issue int
IssueClosedByName The name of the Member that closed this Issue nvarchar
IssueAssetState Asset State for this Issue varchar
IssueCreatedByName Full Name of the Member who created this Issue nvarchar
IssueLastModifiedByName Full Name of the Member who last modified this Issue nvarchar
IssueCreateDateUTC UTC Date this Issue was created datetime
IssueLastModifiedDateUTC UTC Date this Issue was last modified datetime
IssueCreatedByKey Foreign Key the the Member who created this Issue int
IssueLastModifiedByKey Foreign Key the the Member who last modified this Issue int
IssueCreateDateKey Foreign Key to Dim.Date for the Create Date int
IssueLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?