Skip to main content
System StatusContact Support
VersionOne Community

Dim.StrategicThemeLevel

This feature is available in Enterprise and Ultimate editions.

All Strategic Themes in VersionOne have an attribute called Level. This is a single select list used to indicate the orgazational level for the Strategic Theme  (i.e. Portfolio, Program, etc). This table contains Type 1 data for the Strategic Theme Level values defined in your VersionOne instance.

Table Description

Column Name Description DataType
StrategicThemeLevelKey Data Mart unique identifier for this value int
StrategicThemeLevel​Oid VersionOne unique identifier for this value int
StrategicThemeLevel​Name Name nvarchar
StrategicThemeLevelOrder The order this value appears in the VersionOne dropdown list int
StrategicThemeLevelAssetState State of the list value (Active or Closed) varchar
StrategicThemeLevelCreateDateUTC UTC Date the value was created datetime
StrategicThemeLevelLastModifiedDateUTC UTC Date the value was last modified datetime
StrategicThemeLevelCreatedByKey Data Mart identifier of the Member that created this value int
StrategicThemeLevelLastModifiedByKey Data Mart identifier of the Member that last modified this value int
StrategicThemeLevelCreateDateKey Foreign Key to Dim.Date for the Create Date int
StrategicThemeLevelLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
StrategicThemeLevelCreateDateKey Foreign Key to Dim.Date for the Create Date int
StrategicThemeLevelLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?