Table: dbo.Benefit_Accrual_Exclusion_Detail
Table used to store selected accruable benefit exclusions.
Columns
Name | Type | Constraints | Description
benefit_accrual_exclusion_detail_KEY | int (4) | NOT NULL | Primary key.
client_payroll_item_KEY | int (4) | NOT NULL | Foreign key to the client payroll item.
client_benefit_KEY | int (4) | NOT NULL | Foreign key to the client benefit item.

Primary key
Name | Columns | Description
PK_Benefit_Accrual_Exclusion_Detail | benefit_accrual_exclusion_detail_KEY |
Unique constraints
Name | Columns | Description
UK_Benefit_Accrual_Exclusion_Detail$client_payroll_item_KEY$client_benefit_KEY | client_payroll_item_KEY, client_benefit_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Benefit_Accrual_Exclusion_Detail__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Client_Benefit (client_benefit_KEY) |
FK_Benefit_Accrual_Exclusion_Detail__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |