Table: dbo.Payroll_Item_Worker_Compensation_Exemption_Detail
Columns
NameTypeConstraintsDescription
payroll_item_worker_compensation_exemption_detail_KEYint (4)NOT NULLunique key
payroll_item_worker_compensation_exemption_KEYint (4)NOT NULLclient payroll item exemption record this relates to
ste_state_code_KEYnvarchar (4)NOT NULLState that this payroll item is exempt from for worker compensation calculations
Primary key
NameColumnsDescription
PK_Payroll_Item_Worker_Compensation_Exemption_Detailpayroll_item_worker_compensation_exemption_detail_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Item_Worker_Compensation_Exemption_Detail$payroll_item_worker_compensation_exemption_KEY$ste_state_code_KEYpayroll_item_worker_compensation_exemption_KEY, ste_state_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Item_Worker_Compensation_Exemption_Detail__Payroll_Item_Worker_Compensation_Exemption__payroll_item_worker_compensatipayroll_item_worker_compensation_exemption_KEYPayroll_Item_Worker_Compensation_Exemption (payroll_item_worker_compensation_exemption_KEY)
FK_Payroll_Item_Worker_Compensation_Exemption_Detail__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)

Schema diagram