Skip to main content
System StatusContact Support
VersionOne Community

Dim.ProjectStatus

This feature is available in Enterprise and Ultimate editions.

This is a single select list of the values available in the Project Status dropdown. This table contains Type 1 data for the project status values you have configured in your VersionOne instance.

Table Description

Column Name Description DataType
ProjectStatusKey Data Mart identifier for this data int
ProjectStatusOid VersionOne identifier for this data int
ProjectStatusName Name varchar
ProjectStatusOrder The order this value appears in the VersionOne dropdown list int
ProjectStatusAssetState   State of this value (Active or Closed) varchar
ProjectStatusCreateDateUTC Date and time this value was created datetime
ProjectStatusLastModifiedDateUTC Date and time this value was last modified datetime
ProjectStatusCreatedByKey  Data Mart identifier of the  Dim.Member that created this value int
ProjectStatusLastModifiedByKey Data Mart identifier of the  Dim.Member that last modified this value   int
ProjectStatusCreateDateKey Foreign Key to Dim.Date for the Create Date int
ProjectStatusLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?