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_utc | datetime | NOT NULL | |
create_date_utc | 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. |
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 |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
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_Accruable_Benefit__Benefit__benefit_KEY | benefit_KEY | Accruable_Benefit | |
FK_Staff_Benefit__Benefit__benefit_KEY | benefit_KEY | Staff_Benefit | on delete cascade; |
FK_Schedule_Item__Benefit__benefit_KEY | benefit_KEY | Schedule_Item |