Table: Schedule_Item_Budget_Remaining_Entry
This table stores the user adjustments to the remaining hours value for Projects/Tasks
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
schedule_item_budget_remaining_entry_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
update__staff_KEYintNOT NULLKey of Staff who last modified this row.
entry_datesmalldatetimeNOT NULLThe date that this row was entered.
schedule_item_KEYintNOT NULLSchedule item key to which this entry belongs.
hoursdecimal (9, 2)NOT NULLThe number of hours this entry is adjusting the remaining hours value.
commentsnvarchar (-1)NOT NULLUser entered comments.
Primary key
NameColumnsDescription
PK_Schedule_Item_Budget_Remaining_Entry$schedule_item_budget_remaining_entry_KEYschedule_item_budget_remaining_entry_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Schedule_Item_Budget_Remaining_Entry$schedule_item_KEYschedule_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Schedule_Item_Budget_Remaining_Entry__Schedule_Item__schedule_item_KEYschedule_item_KEYSchedule_Item

Schema diagram