Dim.ThemeArea
This is a single select list of the values available in the Theme Area dropdown. This table contains Type 1 data for the theme area values you have configured in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| ThemeAreaKey | Datamart identifier for this data | int |
| ThemeAreaOid | Identifier for this data | int |
| ThemeAreaName | Name | varchar |
| ThemeAreaOrder | The order this value appears in the dropdown list | int |
| ThemeAreaAssetState | State of this value (Active or Closed) | varchar |
| ThemeAreaCreateDateUTC | Date and time this value was created | datetime |
| ThemeAreaLastModifiedDateUTC | Date and time this value was last modified | datetime |
| ThemeAreaCreatedByKey | Data Mart identifier of the Dim.Member that created this value | int |
| ThemeAreaLastModifiedByKey | Data Mart identifier of the Dim.Member that last modified this value | int |
| ThemeAreaCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| ThemeAreaLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |