Skip to main content
System StatusContact Support
VersionOne Community

Dim.Iteration

This feature is available in Enterprise and Ultimate editions.

Iterations represent the basic planning period of an agile project. Depending on your methodology this planning period may be called a Sprint. This table contains Type 1 data for Iterations defined in your VersionOne instance.

Table Description

Column Name Description Datatype
IterationKey Datamert unique identifier for the iteration int
IterationOid VersionOne identifier for the iteration int
IterationName Iteration Name nvarchar
IterationFullName Full name of Iteration nvarchar
IterationBeginDate Iteration Begin Date datetime
IterationEndDate

Iteration 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 Iteration Details page, subtract 1 from this date.
datetime
IterationTargetEstimate Target estimate for the iteration real
IterationOwnerName Name of the person owning the iteration nvarchar
IterationOwnerShortName Short name of the person owning the iteration nvarchar
IterationOwnerUsername Username of the person owning the iteration nvarchar
IterationScheduleName Name of Schedule that owns this Iteration nvarchar
IterationAssetState Asset State for the ineration varchar
IterationScheduleKey Foreign Key to Schedule that owns this Iteration int
IterationBeginDateKey Foreign Key to Iteration Begin Date int
IterationEndDateKey Foreign Key to Iteration End Date int
IterationOwnerMemberKey Foreign Key for Iteration Owner int
IterationCreatedByName Full Name of the Member who created this Iteration nvarchar
IterationLastModifiedByName Full Name of the Member who last modified this Iteration nvarchar
IterationCreateDateUTC UTC Date this iteration was created datetime
IterationLastModifiedDateUTC UTC Date iteration was last modified datetime
IterationCreatedByKey Foreign Key the the Member who created this Iteration int
IterationLastModifiedByKey Foreign Key the the Member who last modified this Iteration int
IterationCreateDateKey Foreign Key to Dim.Date for the Create Date int
IterationLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?