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 |