Skip to main content
System StatusContact Support
VersionOne Community

Dim.GoalType

This feature is available in Enterprise and Ultimate editions.

This is a single select list of the values available in the Goal Type dropdown. This table contains Type 1 data for the goal type values you have configured in your VersionOne instance.

Table Description

Column Name Description DataType
Goal​TypeKey Datamart unique identifier for this value int
Goal​TypeOid VersionOne unique identifier for this value int
Goal​TypeName Name varchar
Goal​TypeOrder The order this value appears in the VersionOne dropdown list int
Goal​TypeAssetState State of the list value (Active or Closed) varchar
Goal​TypeCreateDateUTC UTC Date the value was created datetime
GoalTypeLastModifiedDateUTC UTC Date the value was last modified datetime
GoalTypeCreatedByKey Data Mart identifier of the Member  that created this value int
GoalTypeLastModifiedByKey Data Mart identifier of the Member  that last modified this value int
GoalTypeCreateDateKey Foreign Key to Dim.Date for the Create Date int
GoalTypeLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?