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) |