Table: dbo.Insurepay_Client_Class_Code
Table containing InsurePay client specific class code.
Columns
Name | Type | Constraints | Description
insurepay_client_class_code_KEY | int (4) | NOT NULL | Primary key for this table.
client_KEY | int (4) | NOT NULL | client id for this class code.
worker_compensation_class_code_detail_KEY | int (4) | NOT NULL | insurepay worker_compensation_class code detail key for this client.

Primary key
Name | Columns | Description
PK_Insurepay_Client_Class_Code | insurepay_client_class_code_KEY |
Unique constraints
Name | Columns | Description
UK_Insurepay_Client_Class_Code$client_KEY$worker_compensation_class_code_detail_KEY | client_KEY, worker_compensation_class_code_detail_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Insurepay_Client_Class_Code__Insurepay_Client__client_KEY | client_KEY | Insurepay_Client (client_KEY) |
FK_Insurepay_Client_Class_Code__Worker_Compensation_Class_Code_Detail__worker_compensation_class_code_detail_KEY | worker_compensation_class_code_detail_KEY | Worker_Compensation_Class_Code_Detail (worker_compensation_class_code_detail_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Insurepay_Client_Class_Code_N_Client_Benefit__Insurepay_Client_Class_Code__insurepay_client_class_code_KEY | insurepay_client_class_code_KEY | Insurepay_Client_Class_Code_N_Client_Benefit |
FK_Insurepay_Client_Class_Code_N_Client_Payroll_Item__Insurepay_Client_Class_Code__insurepay_client_class_code_KEY | insurepay_client_class_code_KEY | Insurepay_Client_Class_Code_N_Client_Payroll_Item |
FK_Insurepay_Client_Class_Code_N_Employee_Payroll_Item__Insurepay_Client_Class_Code__insurepay_client_class_code_KEY | insurepay_client_class_code_KEY | Insurepay_Client_Class_Code_N_Employee_Payroll_Item |