Skip to main content
System StatusContact Support
VersionOne Community

Dim.StrategicTheme

This feature is available in Enterprise and Ultimate editions.

VersionOne Strategic Theme are used to reflect top-tier strategic planning activities at the company and/or organizational level. This table contains Type 1 data for Strategic Themes defined in your VersionOne instance.

Table Description

Column Name Description Datatype
StrategicThemeKey Data Mart unique identifier for this Strategic Theme int
StrategicThemeOid VersionOne unique identifier for this Strategic Theme int
StrategicThemeName Name nvarchar
StrategicThemeDisplayId VersionOne identifier seen in the grids varchar
StrategicThemeProjectKey Foreign key into Dim.Project for the project containing this Strategic Theme int
StrategicThemeProjectName Name of the project containing this Strategic Theme nvarchar
StrategicThemeLevel Strategic Theme Level Attribute Value nvarchar
StrategicThemeAssetState Indicate the Strategic Theme State (Open/Closed) varchar
StrategicThemeCreatedByName Full Name of the member who created this Strategic Theme nvarchar
StrategicThemeLastModifiedByName Full Name of the member who last modified this Strategic Theme nvarchar
StrategicThemeCreateDateUTC Create date for Strategic Theme UTC datetime
StrategicThemeLastModifiedDateUTC Modify date for Strategic Theme UTC datetime
StrategicThemeCreateByKey Foreign Key the the Dim.Member that created this Strategic Theme int
StrategicThemeLastModifiedByKey Foreign Key the the Dim.Member that last modified this Strategic Theme int
StrategicThemeCreateDateKey Foreign Key to Dim.Date for the Create Date int
StrategicThemeLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
StrategicThemeCreateDateKey Foreign Key to Dim.Date for the Create Date int
StrategicThemeLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?