Table: Schedule_Item_Budget_Remaining_Entry
This table stores the user adjustments to the remaining hours value for Projects/Tasks
Columns
Name | Type | Constraints | Description
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
schedule_item_budget_remaining_entry_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
update__staff_KEY | int | NOT NULL | Key of Staff who last modified this row.
entry_date | smalldatetime | NOT NULL | The date that this row was entered.
schedule_item_KEY | int | NOT NULL | Schedule item key to which this entry belongs.
hours | decimal (9, 2) | NOT NULL | The number of hours this entry is adjusting the remaining hours value.
comments | nvarchar (-1) | NOT NULL | User entered comments.

Primary key
Name | Columns | Description
PK_Schedule_Item_Budget_Remaining_Entry$schedule_item_budget_remaining_entry_KEY | schedule_item_budget_remaining_entry_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Schedule_Item_Budget_Remaining_Entry$schedule_item_KEY | schedule_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Schedule_Item_Budget_Remaining_Entry__Schedule_Item__schedule_item_KEY | schedule_item_KEY | Schedule_Item |