Iterations
List Iterations
Columns
| Name | Type | References | Description |
| ParentReference | String | Parent reference. Only available if IncludeReferenceColumn=true. | |
| IterationSK [KEY] | String | Iteration surrogate key. | |
| AnalyticsUpdatedDate | Datetime | Watermark that indicates the last time the Analytics data was updated. | |
| Depth | Integer | Level of the iteration path based on its depth from the root level. | |
| EndDate | Datetime | End date defined for the iteration path. | |
| IsEnded | Boolean | Indication that the iteration path end date is in the past when set to True. | |
| IterationId | String | Unique identifier assigned to an iteration path at creation. | |
| IterationLevel1 | String | Node level 1. Node levels of an iteration path are up to 14 nested levels. Iteration Level 1 always corresponds to the root node and the project name. | |
| IterationLevel10 | String | Node level 10. Node levels of an iteration path are up to 14 nested levels. Iteration Level 1 always corresponds to the root node and the project name. | |
| IterationLevel11 | String | Node level 11. Node levels of an iteration path are up to 14 nested levels. Iteration Level 1 always corresponds to the root node and the project name. | |
| IterationLevel12 | String | Node level 12. Node levels of an iteration path are up to 14 nested levels. Iteration Level 1 always corresponds to the root node and the project name. | |
| IterationLevel13 | String | Node level 13. Node levels of an iteration path are up to 14 nested levels. Iteration Level 1 always corresponds to the root node and the project name. | |
| IterationLevel14 | String | Node level 14. Node levels of an iteration path are up to 14 nested levels. Iteration Level 1 always corresponds to the root node and the project name. | |
| IterationLevel2 | String | Node level 2. Node levels of an iteration path are up to 14 nested levels. Iteration Level 1 always corresponds to the root node and the project name. | |
| IterationLevel3 | String | Node level 3. Node levels of an iteration path are up to 14 nested levels. Iteration Level 1 always corresponds to the root node and the project name. | |
| IterationLevel4 | String | Node level 4. Node levels of an iteration path are up to 14 nested levels. Iteration Level 1 always corresponds to the root node and the project name. | |
| IterationLevel5 | String | Node level 5. Node levels of an iteration path are up to 14 nested levels. Iteration Level 1 always corresponds to the root node and the project name. | |
| IterationLevel6 | String | Node level 6. Node levels of an iteration path are up to 14 nested levels. Iteration Level 1 always corresponds to the root node and the project name. | |
| IterationLevel7 | String | Node level 7. Node levels of an iteration path are up to 14 nested levels. Iteration Level 1 always corresponds to the root node and the project name. | |
| IterationLevel8 | String | Node level 8. Node levels of an iteration path are up to 14 nested levels. Iteration Level 1 always corresponds to the root node and the project name. | |
| IterationLevel9 | String | Node level 9. Node levels of an iteration path are up to 14 nested levels. Iteration Level 1 always corresponds to the root node and the project name. | |
| IterationName | String | Name defined for an iteration path at creation. | |
| IterationPath | String | Full iteration path starting with the root node. The iteration must be a valid node in the project hierarchy. | |
| Number | Integer | Integer value assigned to an iteration path node at creation. | |
| ProjectSK | String | Project surrogate key. | |
| StartDate | Datetime | Start date defined for the iteration path. |