Table: Benefit
Columns
Name | Type | Constraints | Description
benefit_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table, same value as activity_KEY.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
create_date | datetime | NOT NULL |
benefit_type_KEY | int | NOT NULL | Key to a Benefit Type.
active | bit | NOT NULL | Whether this benefit is active.
recurrence_rule | nvarchar (-1) | NOT NULL | Text of the iCalendar recurrence rules and exteneded properties that make up the benefit recurrence.
recurrence_rule_text | nvarchar (250) | NOT NULL | Text in plain English of the recurrence rules that make up the benefit recurrence.
use_maximum_carryover | bit | NOT NULL | Determines whether the maximum carryover amount is enforced.
maximum_carryover | decimal (9, 2) | NOT NULL | The maximum amount allowed to carryover annually.

Primary key
Name | Columns | Description
PK_Benefit$benefit_KEY | benefit_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Benefit$benefit_type_KEY | benefit_type_KEY | Index supports foreign key FK_Benefit__Benefit_Type__benefit_type_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Benefit__Benefit_Type__benefit_type_KEY | benefit_type_KEY | Benefit_Type |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Accruable_Benefit__Benefit__benefit_KEY | benefit_KEY | Accruable_Benefit |
FK_Accruable_Benefit_Allowance_By_Month__Benefit__benefit_KEY | benefit_KEY | Accruable_Benefit_Allowance_By_Month | on delete cascade;
FK_Accruable_Benefit_Allowance_By_Staff_Level__Benefit__benefit_KEY | benefit_KEY | Accruable_Benefit_Allowance_By_Staff_Level | on delete cascade;
FK_Benefit_Factor__Benefit__benefit_KEY | benefit_KEY | Benefit_Factor | on delete cascade;
FK_Staff_Benefit__Benefit__benefit_KEY | benefit_KEY | Staff_Benefit | on delete cascade;
FK_Schedule_Item__Benefit__benefit_KEY | benefit_KEY | Schedule_Item |