Table: dbo.Pay_Item_Exclusion_Detail
Table used to store selected payroll items exclusions.
Columns
NameTypeConstraintsDescription
pay_item_exclusion_detail_KEYint (4)NOT NULLPrimary key.
client_payroll_item_KEYint (4)NOT NULLForeign key to the client payroll item.
excluded__client_payroll_item_KEYint (4)NOT NULLKey corresponding to the excluded payroll item.
exclude_regularbit (1)NOT NULLIndicates that the client payroll item should exclude regular wages from this pay item.
exclude_OTbit (1)NOT NULLIndicates that the client payroll item should exclude overtime wages from this pay item.
exclude_DTbit (1)NOT NULLIndicates that the client payroll item should exclude doubletime wages from this pay item.
exclude_accruable_benefitsbit (1)NOT NULLIndicates that the client payroll item should exclude accruable benefit wages from this pay item.
Primary key
NameColumnsDescription
PK_Pay_Item_Exclusion_Detailpay_item_exclusion_detail_KEY
Unique constraints
NameColumnsDescription
UK_Pay_Item_Exclusion_Detail$client_payroll_item_KEY$excluded__client_payroll_item_KEYclient_payroll_item_KEY, excluded__client_payroll_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Pay_Item_Exclusion_Detail__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_Pay_Item_Exclusion_Detail__Client_Payroll_Item__excluded__client_payroll_item_KEYexcluded__client_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)

Schema diagram