Table: dbo.Employer_Contribution_Item
table containing Insurepay, XactPay employer contribution type information .
Columns
Name | Type | Constraints | Description
client_payroll_item_KEY | int (4) | NOT NULL | Primary key and Foreign key for this table.The associated Client_Payroll_Item primary key.
insurepay_employer_contribution_type_KEY | int (4) |  | Foreign key for this table. The associated Insurepay_Employer_Contribution_Type primary key.
xactpay_employer_contribution_type_KEY | int (4) |  | Foreign key for this table. The associated XactPay_Employer_Contribution_Type primary key.

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

Foreign keys
Name | Columns | Referenced table | Description
FK_Employer_Contribution_Item__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |
FK_Employer_Contribution_Item__Insurepay_Employer_Contribution_Type__insurepay_employer_contribution_type_KEY | insurepay_employer_contribution_type_KEY | Insurepay_Employer_Contribution_Type (insurepay_employer_contribution_type_KEY) |
FK_Employer_Contribution_Item__XactPay_Employer_Contribution_Type__xactpay_employer_contribution_type_KEY | xactpay_employer_contribution_type_KEY | XactPay_Employer_Contribution_Type (xactpay_employer_contribution_type_KEY) |