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 |