Table: dbo.Benefit_Accrual_Exclusion_Detail
Table used to store selected accruable benefit exclusions.
Columns
NameTypeConstraintsDescription
benefit_accrual_exclusion_detail_KEYint (4)NOT NULLPrimary key.
client_payroll_item_KEYint (4)NOT NULLForeign key to the client payroll item.
client_benefit_KEYint (4)NOT NULLForeign key to the client benefit item.
Primary key
NameColumnsDescription
PK_Benefit_Accrual_Exclusion_Detailbenefit_accrual_exclusion_detail_KEY
Unique constraints
NameColumnsDescription
UK_Benefit_Accrual_Exclusion_Detail$client_payroll_item_KEY$client_benefit_KEYclient_payroll_item_KEY, client_benefit_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Benefit_Accrual_Exclusion_Detail__Client_Benefit__client_benefit_KEYclient_benefit_KEYClient_Benefit (client_benefit_KEY)
FK_Benefit_Accrual_Exclusion_Detail__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)

Schema diagram