Table: Staff_Benefit_Entry
Columns
Name | Type | Constraints | Description
staff_benefit_entry_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
create_date | datetime | NOT NULL |
staff_benefit_KEY | int | NOT NULL | Key to a staff benefit.
sheet_date | smalldatetime | NOT NULL | The sheet date that this entry corresponds to.
entry_date | smalldatetime | NOT NULL | The date that this entry corresponds to.
benefit_entry_type_KEY | int | NOT NULL | Key to a staff benefit entry type.
comments | nvarchar (-1) | NOT NULL | Comments about this entry.
hours_entered | decimal (9, 2) | NOT NULL | The number of hours entered included in this entry.
hours | decimal (9, 2) | NOT NULL | The number of hours included in this entry.

Primary key
Name | Columns | Description
PK_Staff_Benefit_Entry$staff_benefit_entry_KEY | staff_benefit_entry_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Staff_Benefit_Entry$benefit_entry_type_KEY | benefit_entry_type_KEY | Index supports foreign key FK_Staff_Benefit_Entry__Benefit_Entry_Type__benefit_entry_type_KEY
IX_Staff_Benefit_Entry$staff_benefit_KEY | staff_benefit_KEY | Index supports foreign key FK_Staff_Benefit_Entry__Staff_Benefit__staff_benefit_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Staff_Benefit_Entry__Benefit_Entry_Type__benefit_entry_type_KEY | benefit_entry_type_KEY | Benefit_Entry_Type |
FK_Staff_Benefit_Entry__Staff_Benefit__staff_benefit_KEY | staff_benefit_KEY | Staff_Benefit |