Table: History_Of_Schedule_Item
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
revise__changeset_KEYintNOT NULL
history_action_KEYtinyint (3)NOT NULL
schedule_item_KEYintNOT NULL
update__staff_KEYintNOT NULL
schedule_item_type_KEYintNOT NULL
staff_assignment_method_KEYintNOT NULL
priority_KEYintNOT NULL
is_all_day_eventbitNOT NULL
target_start_date_utcdatetime
budgeted_hoursdecimal (9, 2)NOT NULL
descriptionnvarchar (250)NOT NULL
schedule_item_notenvarchar (-1)NOT NULL
target_complete_date_exclusive_utcdatetime
current_due_date_exclusive_utcdatetimeNOT NULL
posted_actual_hoursdecimal (17, 2)NOT NULL
posted_actual_amountdecimal (17, 2)NOT NULL
remaining_hours_adjustmentdecimal (9, 2)NOT NULL
remaining_hours_adjustment_countintNOT NULL
staff_qualifications__filter_KEYint
target_start__time_zone_KEYsmallint (5)
target_complete__time_zone_KEYsmallint (5)
live_actual_hoursdecimal (17, 2)NOT NULL
live_actual_amountdecimal (17, 2)NOT NULL
schedule_item_series_KEYint
activity_KEYint
client_KEYint
engagement_KEYint
tracking_description_KEYint
reminder_date_utcdatetime
benefit_KEYint
scheduled_benefit_status_KEYint
approved__staff_KEYint
approved_datesmalldatetime
scheduled_phone_call_status_KEYint
with__contact_KEYint
of__contact_KEYint
is_openbitNOT NULL
education_sponsor_KEYint
education_delivery_format_KEYint
locationnvarchar (250)NOT NULL
instructornvarchar (250)NOT NULL
costdecimal (9, 2)NOT NULL
Primary key
NameColumnsDescription
PK_History_Of_Schedule_Item$schedule_item_KEY$revise__changeset_KEY$create__changeset_KEY$update__changeset_KEY$history_action_Kschedule_item_KEY, revise__changeset_KEY, create__changeset_KEY, update__changeset_KEY, history_action_KEYCLUSTERED

Schema diagram