Dim.IssueStatus
This is a single select list of the values available in the Issue Status drop-down. This table contains Type 1 data for the issue status values you have configured in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| IssueStatusKey | Data Mart identifier for this data | int |
| IssueStatusOid | VersionOne identifier for this data | int |
| IssueStatusName | Name | nvarchar |
| IssueStatusOrder | The order this value appears in the drop-down list | int |
| IssueStatusAssetState | State of the list value (Active or Closed) | varchar |
| IssueStatusCreateDateUTC | Date and time this value was created | datetime |
| IssueStatusLastModifiedDateUTC | Date and time this value was last modified | datetime |
| IssueStatusCreatedByKey | Data Mart identifier of the Member who created this value | int |
| IssueStatusLastModifiedByKey | Data Mart identifier of the Member who last modified this value | int |
| IssueStatusCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| IssueStatusLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |