Table: Benefit
Columns
NameTypeConstraintsDescription
benefit_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table, same value as activity_KEY.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
benefit_type_KEYintNOT NULLKey to a Benefit Type.
activebitNOT NULLWhether this benefit is active.
recurrence_rulenvarchar (-1)NOT NULLText of the iCalendar recurrence rules and exteneded properties that make up the benefit recurrence.
use_maximum_carryoverbitNOT NULLDetermines whether the maximum carryover amount is enforced.
maximum_carryoverdecimal (9, 2)NOT NULLThe maximum amount allowed to carryover annually.
Primary key
NameColumnsDescription
PK_Benefit$benefit_KEYbenefit_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Benefit$benefit_type_KEYbenefit_type_KEYIndex supports foreign key FK_Benefit__Benefit_Type__benefit_type_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Accruable_Benefit_Allowance_By_Month__Benefit__benefit_KEYbenefit_KEYAccruable_Benefit_Allowance_By_Monthon delete cascade;
FK_Accruable_Benefit_Allowance_By_Staff_Level__Benefit__benefit_KEYbenefit_KEYAccruable_Benefit_Allowance_By_Staff_Levelon delete cascade;
FK_Benefit_Factor__Benefit__benefit_KEYbenefit_KEYBenefit_Factoron delete cascade;
FK_Accruable_Benefit__Benefit__benefit_KEYbenefit_KEYAccruable_Benefit
FK_Staff_Benefit__Benefit__benefit_KEYbenefit_KEYStaff_Benefiton delete cascade;
FK_Schedule_Item__Benefit__benefit_KEYbenefit_KEYSchedule_Item

Schema diagram