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 |