Table: dbo.Deduction_Item
Client payroll item properties applicable only to a deduction payroll item.
Columns
Name | Type | Constraints | Description
client_payroll_item_KEY | int (4) | NOT NULL | Primary key.
is_w2_kansas_retirement_system | bit (1) | NOT NULL | Flags a deduction as a contribution to the Kansas retirement system for public employees. Used for Kansas W-2 processing.
is_w2_maryland_state_pick_up | bit (1) | NOT NULL | Flags a deduction as a contribution to the Maryland state retirement system. Used for Maryland W-2 processing.
is_health_insurance_deduction | bit (1) | NOT NULL | Flag to indicate if this deduction item is used for health insurance
is_dependant_health_insurance_deduction | bit (1) | NOT NULL | Flag to indicate if this deduction item is used for dependant health insurance

Primary key
Name | Columns | Description
PK_Deduction_Item$client_payroll_item_KEY | client_payroll_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Deduction_Item__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |