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 |