Skip to main content
System StatusContact Support
VersionOne Community

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
  • Was this article helpful?