Dim.Iteration

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 instance.

Table Description

Column Name	Description	DataType
IterationKey	Data Mart unique identifier for the iteration	int
IterationOid	Identifier for the iteration	int
IterationName	Iteration Name	nvarchar
IterationFullName	Full name of the Iteration	nvarchar
IterationBeginDate	Iteration Begin Date	datetime
IterationEndDate	Iteration End Date (inclusive of the entered 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 the Schedule that owns this Iteration	nvarchar
IterationAssetState	Asset State for the iteration	varchar
IterationScheduleKey	Foreign Key to the Schedule owning this Iteration	int
IterationBeginDateKey	Foreign Key to the Iteration Begin Date	int
IterationEndDateKey	Foreign Key to the Iteration End Date	int
IterationOwnerMemberKey	Foreign Key for the 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 this Iteration was last modified	datetime
IterationCreatedByKey	Foreign Key to the Member who created this Iteration	int
IterationLastModifiedByKey	Foreign Key to 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