Table: dbo.Deduction_Item
Client payroll item properties applicable only to a deduction payroll item.
Columns
NameTypeConstraintsDescription
client_payroll_item_KEYint (4)NOT NULLPrimary key.
is_w2_kansas_retirement_systembit (1)NOT NULLFlags a deduction as a contribution to the Kansas retirement system for public employees. Used for Kansas W-2 processing.
is_w2_maryland_state_pick_upbit (1)NOT NULLFlags a deduction as a contribution to the Maryland state retirement system. Used for Maryland W-2 processing.
is_health_insurance_deductionbit (1)NOT NULLFlag to indicate if this deduction item is used for health insurance
is_dependant_health_insurance_deductionbit (1)NOT NULLFlag to indicate if this deduction item is used for dependant health insurance
Primary key
NameColumnsDescription
PK_Deduction_Item$client_payroll_item_KEYclient_payroll_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Deduction_Item__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)

Schema diagram