Table: History_Of_Schedule_Item
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_KEY | int | NOT NULL |
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
create_date | datetime | NOT NULL |
schedule_item_type_KEY | int | NOT NULL |
staff_assignment_method_KEY | int | NOT NULL |
priority_KEY | int | NOT NULL |
is_all_day_event | bit | NOT NULL |
target_start_date_utc | datetime |  |
budgeted_hours | decimal (9, 2) | NOT NULL |
description | nvarchar (30) | NOT NULL |
schedule_item_note | nvarchar (-1) | NOT NULL |
target_complete_date_exclusive_utc | datetime |  |
current_due_date_exclusive_utc | datetime | NOT NULL |
posted_actual_hours | decimal (17, 2) | NOT NULL |
posted_actual_amount | decimal (17, 2) | NOT NULL |
remaining_hours_adjustment | decimal (9, 2) | NOT NULL |
remaining_hours_adjustment_count | int | NOT NULL |
staff_qualifications__filter_KEY | int |  |
target_start__time_zone_KEY | smallint (5) |  |
target_complete__time_zone_KEY | smallint (5) |  |
live_actual_hours | decimal (17, 2) | NOT NULL |
live_actual_amount | decimal (17, 2) | NOT NULL |
schedule_item_series_KEY | int |  |
activity_KEY | int |  |
client_KEY | int |  |
engagement_KEY | int |  |
tracking_description_KEY | int |  |
reminder_date_utc | datetime |  |
benefit_KEY | int |  |
scheduled_benefit_status_KEY | int |  |
approved__staff_KEY | int |  |
approved_date | smalldatetime |  |
scheduled_phone_call_status_KEY | int |  |
with__contact_KEY | int |  |
of__contact_KEY | int |  |
is_open | bit | NOT NULL |

Primary key
Name | Columns | Description
PK_History_Of_Schedule_Item$schedule_item_KEY$revise__changeset_KEY$create__changeset_KEY$update__changeset_KEY$history_action_K | schedule_item_KEY, revise__changeset_KEY, create__changeset_KEY, update__changeset_KEY, history_action_KEY | CLUSTERED