Dim.Issue
Issues are used to highlight those items that require project-wide visibility. This table contains Type 1 data for Issues defined in your 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 grid | varchar |
| IssueTargetDate | Value of the Target Date attribute on this Issue | datetime |
| IssueTargetDateKey | Foreign Key to the Date dimension for the Target Date | 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 | UTC date and time this Issue was Closed/Archived | datetime |
| IssueClosedDateKey | Foreign Key to Dim.Date for the Closed Date | int |
| IssueClosedByID | Foreign Key to the Dim.Member that closed this Issue | int |
| IssueClosedByName | 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 to the Member who created this Issue | int |
| IssueLastModifiedByKey | Foreign Key to 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 |