Skip to main content
System StatusContact Support
VersionOne Community

Dim.Schedule

This feature is available in Enterprise and Ultimate editions.

Schedules are used in VersionOne for creating Iterations. They define the iteration length and the number of days between end of one iteration and the beginning of another. Projects in VersionOne are related to only one Schedule; however a single schedule can be related to multiple projects. This table contains Type 1 data for schedules defined in your VersionOne instance.

Table Description

Column Name Description DataType
ScheduleKey Datamart identifier for this data int
ScheduleOid VersionOne identifier for this data int
ScheduleName Name nvarchar
ScheduleIterationLength Length of iterations created based on this schedule varchar
ScheduleIterationGap Number of days between the end of one iteration and the beginning of another for iterations created based on this schedule varchar
ScheduleCreatedByName Full Name of the Member who created this Schedule nvarchar
ScheduleLastModifiedByName Full Name of the Member who last modified this Schedule nvarchar
ScheduleCreateDateUTC Date and time this value was created datetime
ScheduleLastModifiedDateUTC Date and time this value was last modified datetime
ScheduleCreatedByKey Foreign Key to the Member who created this Schedule int
ScheduleLastModifiedByKey Foreign Key to the Member who last modified this Schedule int
ScheduleCreateDateKey Foreign Key to Dim.Date for the Create Date int
ScheduleLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?