Dim.GoalPriority
This is a single select list of the values available in the Goal Priority drop-down. This table contains Type 1 data for the goal priority values you have configured in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| GoalPriorityKey | Datamart unique identifier for this value | int |
| GoalPriorityOid | VersionOne unique identifier for this value | int |
| GoalPriorityName | Name | nvarchar |
| GoalPriorityOrder | The order this value appears in the drop-down list | int |
| GoalPriorityAssetState | State of the list value (Active or Closed) | varchar |
| GoalPriorityCreateDateUTC | UTC Date the value was created | datetime |
| GoalPriorityLastModifiedDateUTC | UTC Date the value was last modified | datetime |
| GoalPriorityCreatedByKey | Data Mart identifier of the Member that created this value | int |
| GoalPriorityLastModifiedByKey | Data Mart identifier of the Member that last modified this value | int |
| GoalPriorityCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| GoalPriorityLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |