Dim.Schedule
Schedules are used in 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 instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| ScheduleKey | Datamart identifier for this data | int |
| ScheduleOid | 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 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 |