Table: Staff_Benefit_Entry
Columns
NameTypeConstraintsDescription
staff_benefit_entry_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
staff_benefit_KEYintNOT NULLKey to a staff benefit.
sheet_datesmalldatetimeNOT NULLThe sheet date that this entry corresponds to.
entry_datesmalldatetimeNOT NULLThe date that this entry corresponds to.
benefit_entry_type_KEYintNOT NULLKey to a staff benefit entry type.
commentsnvarchar (-1)NOT NULLComments about this entry.
hours_entereddecimal (9, 2)NOT NULLThe number of hours entered included in this entry.
hoursdecimal (9, 2)NOT NULLThe number of hours included in this entry.
Primary key
NameColumnsDescription
PK_Staff_Benefit_Entry$staff_benefit_entry_KEYstaff_benefit_entry_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Staff_Benefit_Entry$benefit_entry_type_KEYbenefit_entry_type_KEYIndex supports foreign key FK_Staff_Benefit_Entry__Benefit_Entry_Type__benefit_entry_type_KEY
IX_Staff_Benefit_Entry$staff_benefit_KEYstaff_benefit_KEYIndex supports foreign key FK_Staff_Benefit_Entry__Staff_Benefit__staff_benefit_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Benefit_Entry__Staff_Benefit__staff_benefit_KEYstaff_benefit_KEYStaff_Benefit

Schema diagram