Table: Schedule_Item_Series
Schedule Item Series
Columns
Name | Type | Constraints | Description
schedule_item_series_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Assigned primary key for this table.
update__staff_KEY | int | NOT NULL | Key of Staff who last modified this row.
recurrence_method_KEY | int | NOT NULL | Indicates whether this recurrs and where to get the recurrence information from.
recurrence_rule | nvarchar (-1) | NOT NULL | Text of the iCalendar recurrence rules and exteneded properties that make up the date recurrence.
generation_date_based_on_fiscal_year_end | bit | NOT NULL | When the value is 1 the generation date is adjusted for the Client's fiscal year end.
generation_date_must_occur_on_weekdays | bit | NOT NULL | When the value is 1 the generation date is adjusted so that it does not fall on a weekend.
recurrence_expiration_method_KEY | int | NOT NULL |
expiration_occurrences | int | NOT NULL | Indicates the ending number of occurrences or 0 if none.
expiration_date_utc | smalldatetime |  | Indicates the ending date of this series or null if none.
recurrence_generation_method_KEY | int | NOT NULL | Indicates how this schedule item will be generated.
generation_month | int | NOT NULL | Number of months before the next date to generate the project.
generation_day | int | NOT NULL | Number of days before the next date to generate the project.
generate_descriptions_from_project | bit | NOT NULL | When set to 1 will indicate that next project generation should use the descriptions from the project instead of the template.
generate_engagement_from_project | bit | NOT NULL | When set to 1 will indicate that next project generation should use the engagement from the project instead of the template.
generate_groupings_from_project | bit | NOT NULL | When set to 1 will indicate that next project generation should use the groupings from the project instead of the template.
generate_assigned_from_project | bit | NOT NULL | When set to 1 will indicate that next project generation should use the assigned from the project instead of the template.
generate_notes_from_project | bit | NOT NULL | When set to 1 will indicate that next project generation should use the notes from the project instead of the template.
generate_links_from_project | bit | NOT NULL | When set to 1 will indicate that next project generation should use the links from the project instead of the template.
generate_custom_values_from_project | bit | NOT NULL | When set to 1 will indicate that next project generation should copy custom val
generate_tasks_from_project | bit | NOT NULL | When set to 1 will indicate that next project generation should use the tasks from the project instead of the template.
budget_generation_KEY | int | NOT NULL | Key to a Budget Generation that indicates the source of the budget information.
generate_budgeted_hours_factor | decimal (6, 4) | NOT NULL | Factor to be used to adjust the hours when generating from the project.
generate_budgeted_amount_factor | decimal (6, 4) | NOT NULL | Factor to be used to adjust the amount when generating from the project.
target_start_month | int | NOT NULL | Number of months relative to start__target_date_method_KEY to use as the target start date.
target_start_day | int | NOT NULL | Number of days relative to start__target_date_method_KEY to use as the target start date.
start__target_date_method_KEY | int | NOT NULL | The method used to calculate the target start date.
target_complete_month | int | NOT NULL | Number of months relative to complete__target_date_method_KEY to use as the target complete date.
target_complete_day | int | NOT NULL | Number of days relative to complete__target_date_method_KEY to use as the target complete date.
complete__target_date_method_KEY | int | NOT NULL | The method used to calculate the target complete date.
generate_calendar_entries_from_project | bit | NOT NULL | When set to 1 will indicate that next project generation should copy the calendar entries from the prior project.
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
generate_descriptions_from_task | bit | NOT NULL | When set to 1 will indicate that next project generation should use the descriptions from the task instead of the template.
generate_assigned_from_task | bit | NOT NULL | When set to 1 will indicate that next project generation should use the assigned from the task instead of the template.
generate_calendar_entries_from_task | bit | NOT NULL | When set to 1 will indicate that next project generation should copy the calendar entries from the prior task.
generate_notes_from_task | bit | NOT NULL | When set to 1 will indicate that next project generation should use the notes from the task instead of the template.
generate_links_from_task | bit | NOT NULL | When set to 1 will indicate that next project generation should use the links from the task instead of the template.
generate_custom_values_from_task | bit | NOT NULL | When set to 1 will indicate that next project generation should copy custom val

Primary key
Name | Columns | Description
PK_Schedule_Item_Series$schedule_item_series_KEY | schedule_item_series_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Schedule_Item_Series$budget_generation_KEY | budget_generation_KEY | Index supports foreign key FK_Schedule_Item_Series__Budget_Generation__budget_generation_KEY
IX_Schedule_Item_Series$complete__target_date_method_KEY | complete__target_date_method_KEY | Index supports foreign key FK_Schedule_Item_Series__Target_Date_Method__complete__target_date_method_KEY
IX_Schedule_Item_Series$recurrence_expiration_method_KEY | recurrence_expiration_method_KEY | Index supports foreign key FK_Schedule_Item_Series__Recurrence_Expiration_Method__recurrence_expiration_method_KEY
IX_Schedule_Item_Series$recurrence_generation_method_KEY | recurrence_generation_method_KEY | Index supports foreign key FK_Schedule_Item_Series__Recurrence_Generation_Method__recurrence_generation_method_KEY
IX_Schedule_Item_Series$recurrence_method_KEY | recurrence_method_KEY | Index supports foreign key FK_Schedule_Item_Series__Recurrence_Method__recurrence_method_KEY
IX_Schedule_Item_Series$start__target_date_method_KEY | start__target_date_method_KEY | Index supports foreign key FK_Schedule_Item_Series__Target_Date_Method__start__target_date_method_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Schedule_Item_Series__Recurrence_Expiration_Method__recurrence_expiration_method_KEY | recurrence_expiration_method_KEY | Recurrence_Expiration_Method |
FK_Schedule_Item_Series__Recurrence_Generation_Method__recurrence_generation_method_KEY | recurrence_generation_method_KEY | Recurrence_Generation_Method |
FK_Schedule_Item_Series__Recurrence_Method__recurrence_method_KEY | recurrence_method_KEY | Recurrence_Method |
FK_Schedule_Item_Series__Target_Date_Method__complete__target_date_method_KEY | complete__target_date_method_KEY | Target_Date_Method |
FK_Schedule_Item_Series__Target_Date_Method__start__target_date_method_KEY | start__target_date_method_KEY | Target_Date_Method |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Schedule_Item_Generation_Date__Schedule_Item_Series__schedule_item_series_KEY | schedule_item_series_KEY | Schedule_Item_Generation_Date |
FK_Project_Template__Schedule_Item_Series__schedule_item_series_KEY | schedule_item_series_KEY | Project_Template |
FK_Schedule_Item__Schedule_Item_Series__schedule_item_series_KEY | schedule_item_series_KEY | Schedule_Item |
FK_Schedule_Item_Last_In_Series__Schedule_Item_Series__schedule_item_series_KEY | schedule_item_series_KEY | Schedule_Item_Last_In_Series | on delete cascade;