Table: dbo.Insurepay_Client_Class_Code
Table containing InsurePay client specific class code.
Columns
NameTypeConstraintsDescription
insurepay_client_class_code_KEYint (4)NOT NULLPrimary key for this table.
client_KEYint (4)NOT NULLclient id for this class code.
worker_compensation_class_code_detail_KEYint (4)NOT NULLinsurepay worker_compensation_class code detail key for this client.
Primary key
NameColumnsDescription
PK_Insurepay_Client_Class_Codeinsurepay_client_class_code_KEY
Unique constraints
NameColumnsDescription
UK_Insurepay_Client_Class_Code$client_KEY$worker_compensation_class_code_detail_KEYclient_KEY, worker_compensation_class_code_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Insurepay_Client_Class_Code__Insurepay_Client__client_KEYclient_KEYInsurepay_Client (client_KEY)
FK_Insurepay_Client_Class_Code__Worker_Compensation_Class_Code_Detail__worker_compensation_class_code_detail_KEYworker_compensation_class_code_detail_KEYWorker_Compensation_Class_Code_Detail (worker_compensation_class_code_detail_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Insurepay_Client_Class_Code_N_Client_Benefit__Insurepay_Client_Class_Code__insurepay_client_class_code_KEYinsurepay_client_class_code_KEYInsurepay_Client_Class_Code_N_Client_Benefit
FK_Insurepay_Client_Class_Code_N_Client_Payroll_Item__Insurepay_Client_Class_Code__insurepay_client_class_code_KEYinsurepay_client_class_code_KEYInsurepay_Client_Class_Code_N_Client_Payroll_Item
FK_Insurepay_Client_Class_Code_N_Employee_Payroll_Item__Insurepay_Client_Class_Code__insurepay_client_class_code_KEYinsurepay_client_class_code_KEYInsurepay_Client_Class_Code_N_Employee_Payroll_Item

Schema diagram