Dim.Theme
This feature is available in Enterprise and Ultimate editions.
VersionOne Themes are used to group similar stories. Themes are also known as Feature Groups or Use Cases depending on your methodology. This table contains Type 1 data for themes defined in your VersionOne instance.
Table Description
| Column Name | Description | DataType |
| ThemeKey | Datamart identifier for this Theme | int |
| ThemeOid | VersionOne identifier for this Theme | int |
| ThemeName | Name | nvarchar |
| ThemeDisplayId | Theme identifier visible in VersionOne grids | varchar |
| ThemeProjectKey | Foreign Key to the Project where the Theme is defined | int |
| ThemeProjectName | Name of project where theme is defined | nvarchar |
| ThemeCustomerName | Customer value for this Theme | nvarchar |
| ThemeReference | Reference value for this Theme | nvarchar |
| ThemeBuild | Build value for this Theme | nvarchar |
| ThemeEstimate | Estimate value for this Theme | real |
| ThemeParentKey | Foreign Key to the Theme's parent | int |
| ThemeType | Theme Type field value | nvarchar |
| ThemeStatus | Theme Status field value | nvarchar |
| ThemeArea | Theme Area field value | nvarchar |
| ThemePriority | Theme Priority field value | nvarchar |
| ThemeComplexity | Theme Complexity field value | nvarchar |
| ThemeSource | Theme Source field value | nvarchar |
| ThemeAssetState | AssetState for this Theme | varcahr |
| ThemePath | Fully qualified path to the theme. useful when sorting a list | nvarchar |
| ThemeParentDisplayId | Display Id for the Theme Parent | varchar |
| ThemeParentName | Name of the Theme parent | nvarchar |
| ThemeCreatedByName | Full Name of the Member who created this Theme | nvarchar |
| ThemeLastModifiedByName | Full Name of the Member who last modified this Theme | nvarchar |
| ThemeClosedDateUTC | The UTC date and time this Theme was Closed / Archived | datetime |
| ThemeClosedDateKey | Foreign Key to Dim.Date for the Closed Date | int |
| ThemeClosedByID | Foreign Key the the Dim.Member that closed this Theme | int |
| ThemeClosedByName | The name of the Member that closed this Theme | nvarchar |
| ThemeCreateDateUTC | UTC Date the Theme was created | datetime |
| ThemeLastModifiedDateUTC | UTC Date the Theme was last modified | datetime |
| ThemeCreatedByKey | Foreign Key to the Member who created this Theme | int |
| ThemeLastModifiedByKey | Foreign Key to the Member who last modified this Theme | int |
| ThemeCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| ThemeLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |