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 |