Table: History_Of_Schedule_Item_Series
Columns
Name | Type | Constraints | Description
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
revise__changeset_KEY | int | NOT NULL |
history_action_KEY | tinyint (3) | NOT NULL |
schedule_item_series_KEY | int | NOT NULL |
update__staff_KEY | int | NOT NULL |
recurrence_method_KEY | int | NOT NULL |
recurrence_rule | nvarchar (-1) | NOT NULL |
generation_date_based_on_fiscal_year_end | bit | NOT NULL |
generation_date_must_occur_on_weekdays | bit | NOT NULL |
recurrence_expiration_method_KEY | int | NOT NULL |
expiration_occurrences | int | NOT NULL |
expiration_date_utc | smalldatetime |  |
recurrence_generation_method_KEY | int | NOT NULL |
generation_month | int | NOT NULL |
generation_day | int | NOT NULL |
generate_descriptions_from_project | bit | NOT NULL |
generate_engagement_from_project | bit | NOT NULL |
generate_groupings_from_project | bit | NOT NULL |
generate_assigned_from_project | bit | NOT NULL |
generate_notes_from_project | bit | NOT NULL |
generate_links_from_project | bit | NOT NULL |
generate_custom_values_from_project | bit | NOT NULL |
generate_tasks_from_project | bit | NOT NULL |
budget_generation_KEY | int | NOT NULL |
generate_budgeted_hours_factor | decimal (6, 4) | NOT NULL |
generate_budgeted_amount_factor | decimal (6, 4) | NOT NULL |
target_start_month | int | NOT NULL |
target_start_day | int | NOT NULL |
start__target_date_method_KEY | int | NOT NULL |
target_complete_month | int | NOT NULL |
target_complete_day | int | NOT NULL |
complete__target_date_method_KEY | int | NOT NULL |
generate_calendar_entries_from_project | bit | NOT NULL |
generate_descriptions_from_task | bit | NOT NULL |
generate_assigned_from_task | bit | NOT NULL |
generate_calendar_entries_from_task | bit | NOT NULL |
generate_notes_from_task | bit | NOT NULL |
generate_links_from_task | bit | NOT NULL |
generate_custom_values_from_task | bit | NOT NULL |

Primary key
Name | Columns | Description
PK_History_Of_Schedule_Item_Series$schedule_item_series_KEY$revise__changeset_KEY$create__changeset_KEY$update__changeset_KEY$hi | schedule_item_series_KEY, revise__changeset_KEY, create__changeset_KEY, update__changeset_KEY, history_action_KEY | CLUSTERED