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 |