Skip to main content
System StatusContact Support
VersionOne Community

Dim.Project

This feature is available in Enterprise and Ultimate editions.

VersionOne projects are a collection workitems and the constructs used to organize this work (releases, sprints, themes, etc). This table contains Type 1 data for VersionOne Project information.

Table Description

Column Name Description Datatype
ProjectKey Datamart unique identifier for the project. int
ProjectOid VersionOne identifier for this project. int
ProjectName Project Name nvarchar
ProjectBeginDate Project begin date datetime
ProjectBeginDateKey Foreign Key to the Date dimension for the Begin Date int
ProjectEndDate

Project end date

This value is intended to be inclusive of the end date entered, therefore the value in this field is one more than the value presented on the VersionOne details page.

  • To filter on this value, use less than, not less than or equal to.
  • To view the data that is displayed on the Project Details page, subtract 1 from this date.
datetime
ProjectEndDateKey Foreign Key to the Date dimension for the End Date int
ProjectOwnerMemberKey Foreign Key to the Project Owner int
ProjectTestSuiteKey Foreign Key to the test suite assigned to this project int
ProjectScheduleKey Foreign Key to the Schedule assigned to this project int
ProjectOwnerName Full Name of the member who owns the project nvarchar
ProjectOwnerShortName Short Name of the member who owns the project nvarchar
ProejctOwnerUserName Username of the member that owns the project nvarchar
ProjectScheduleName Name of the schedule assigned to this project nvarchar
ProjectIterationLength Iteration Length for the project varchar
ProjectIterationGap Iteration Gap for the project varchar
ProjectStatus Status of the project nvarchar
ProjecctPlanningLevel Planning level of the projecct nvarchar
ProjectParentKey Foreign Key to the parent of this project int
ProjectAssetState AssetState of the project varchar
ProjectPath Fully qualified path to this project in the tree. Useful when sorting projects in a list. nvarchar
ProjectParentName Name of the parent project for this project nvarchar
ProjectCreatedByName Full Name of the Member who created this Project nvarchar
ProjectLastModifiedByName Full Name of the Member who last modified this Project nvarchar
ProjectClosedDateUTC The UTC date and time this Project was Closed / Archived datetime
ProjectmClosedDateKey Foreign Key to Dim.Date for the Closed Date int
ProjectClosedByID Foreign Key the the Dim.Member that closed this Project int
ProjectClosedByName The name of the Member that closed this Project nvarchar
ProjectCreateDateUTC UTC Date the project was created. datetime
ProjectLastModifiedDateUTC UTC Date the project was last modified. datetime
ProjectCreatedByKey Foreign Key the the Member who created this Project int
ProjectLastModifiedByKey Foreign Key the the Member who last modified this Project int
ProjectCreateDateKey Foreign Key to Dim.Date for the Create Date int
ProjectLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?