Table: Schedule_Item_Series
Schedule Item Series
Columns
NameTypeConstraintsDescription
schedule_item_series_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Assigned primary key for this table.
update__staff_KEYintNOT NULLKey of Staff who last modified this row.
recurrence_method_KEYintNOT NULLIndicates whether this recurrs and where to get the recurrence information from.
recurrence_rulenvarchar (-1)NOT NULLText of the iCalendar recurrence rules and exteneded properties that make up the date recurrence.
generation_date_based_on_fiscal_year_endbitNOT NULLWhen the value is 1 the generation date is adjusted for the Client's fiscal year end.
generation_date_must_occur_on_weekdaysbitNOT NULLWhen the value is 1 the generation date is adjusted so that it does not fall on a weekend.
recurrence_expiration_method_KEYintNOT NULL
expiration_occurrencesintNOT NULLIndicates the ending number of occurrences or 0 if none.
expiration_date_utcsmalldatetimeIndicates the ending date of this series or null if none.
recurrence_generation_method_KEYintNOT NULLIndicates how this schedule item will be generated.
generation_monthintNOT NULLNumber of months before the next date to generate the project.
generation_dayintNOT NULLNumber of days before the next date to generate the project.
generate_descriptions_from_projectbitNOT NULLWhen set to 1 will indicate that next project generation should use the descriptions from the project instead of the template.
generate_engagement_from_projectbitNOT NULLWhen set to 1 will indicate that next project generation should use the engagement from the project instead of the template.
generate_groupings_from_projectbitNOT NULLWhen set to 1 will indicate that next project generation should use the groupings from the project instead of the template.
generate_assigned_from_projectbitNOT NULLWhen set to 1 will indicate that next project generation should use the assigned from the project instead of the template.
generate_notes_from_projectbitNOT NULLWhen set to 1 will indicate that next project generation should use the notes from the project instead of the template.
generate_links_from_projectbitNOT NULLWhen set to 1 will indicate that next project generation should use the links from the project instead of the template.
generate_custom_values_from_projectbitNOT NULLWhen set to 1 will indicate that next project generation should copy custom val
generate_tasks_from_projectbitNOT NULLWhen set to 1 will indicate that next project generation should use the tasks from the project instead of the template.
budget_generation_KEYintNOT NULLKey to a Budget Generation that indicates the source of the budget information.
generate_budgeted_hours_factordecimal (6, 4)NOT NULLFactor to be used to adjust the hours when generating from the project.
generate_budgeted_amount_factordecimal (6, 4)NOT NULLFactor to be used to adjust the amount when generating from the project.
target_start_monthintNOT NULLNumber of months relative to start__target_date_method_KEY to use as the target start date.
target_start_dayintNOT NULLNumber of days relative to start__target_date_method_KEY to use as the target start date.
start__target_date_method_KEYintNOT NULLThe method used to calculate the target start date.
target_complete_monthintNOT NULLNumber of months relative to complete__target_date_method_KEY to use as the target complete date.
target_complete_dayintNOT NULLNumber of days relative to complete__target_date_method_KEY to use as the target complete date.
complete__target_date_method_KEYintNOT NULLThe method used to calculate the target complete date.
generate_calendar_entries_from_projectbitNOT NULLWhen set to 1 will indicate that next project generation should copy the calendar entries from the prior project.
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
generate_descriptions_from_taskbitNOT NULLWhen set to 1 will indicate that next project generation should use the descriptions from the task instead of the template.
generate_assigned_from_taskbitNOT NULLWhen set to 1 will indicate that next project generation should use the assigned from the task instead of the template.
generate_calendar_entries_from_taskbitNOT NULLWhen set to 1 will indicate that next project generation should copy the calendar entries from the prior task.
generate_notes_from_taskbitNOT NULLWhen set to 1 will indicate that next project generation should use the notes from the task instead of the template.
generate_links_from_taskbitNOT NULLWhen set to 1 will indicate that next project generation should use the links from the task instead of the template.
generate_custom_values_from_taskbitNOT NULLWhen set to 1 will indicate that next project generation should copy custom val
Primary key
NameColumnsDescription
PK_Schedule_Item_Series$schedule_item_series_KEYschedule_item_series_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Schedule_Item_Series$budget_generation_KEYbudget_generation_KEYIndex supports foreign key FK_Schedule_Item_Series__Budget_Generation__budget_generation_KEY
IX_Schedule_Item_Series$complete__target_date_method_KEYcomplete__target_date_method_KEYIndex supports foreign key FK_Schedule_Item_Series__Target_Date_Method__complete__target_date_method_KEY
IX_Schedule_Item_Series$recurrence_expiration_method_KEYrecurrence_expiration_method_KEYIndex supports foreign key FK_Schedule_Item_Series__Recurrence_Expiration_Method__recurrence_expiration_method_KEY
IX_Schedule_Item_Series$recurrence_generation_method_KEYrecurrence_generation_method_KEYIndex supports foreign key FK_Schedule_Item_Series__Recurrence_Generation_Method__recurrence_generation_method_KEY
IX_Schedule_Item_Series$recurrence_method_KEYrecurrence_method_KEYIndex supports foreign key FK_Schedule_Item_Series__Recurrence_Method__recurrence_method_KEY
IX_Schedule_Item_Series$start__target_date_method_KEYstart__target_date_method_KEYIndex supports foreign key FK_Schedule_Item_Series__Target_Date_Method__start__target_date_method_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Schedule_Item_Series__Recurrence_Expiration_Method__recurrence_expiration_method_KEYrecurrence_expiration_method_KEYRecurrence_Expiration_Method
FK_Schedule_Item_Series__Recurrence_Generation_Method__recurrence_generation_method_KEYrecurrence_generation_method_KEYRecurrence_Generation_Method
FK_Schedule_Item_Series__Recurrence_Method__recurrence_method_KEYrecurrence_method_KEYRecurrence_Method
FK_Schedule_Item_Series__Target_Date_Method__complete__target_date_method_KEYcomplete__target_date_method_KEYTarget_Date_Method
FK_Schedule_Item_Series__Target_Date_Method__start__target_date_method_KEYstart__target_date_method_KEYTarget_Date_Method
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Schedule_Item_Generation_Date__Schedule_Item_Series__schedule_item_series_KEYschedule_item_series_KEYSchedule_Item_Generation_Date
FK_Project_Template__Schedule_Item_Series__schedule_item_series_KEYschedule_item_series_KEYProject_Template
FK_Schedule_Item__Schedule_Item_Series__schedule_item_series_KEYschedule_item_series_KEYSchedule_Item
FK_Schedule_Item_Last_In_Series__Schedule_Item_Series__schedule_item_series_KEYschedule_item_series_KEYSchedule_Item_Last_In_Serieson delete cascade;

Schema diagram