Table: dbo.W2_Override_Type
Type table for W-2 override type.
Columns
NameTypeConstraintsDescription
w2_override_type_KEYint (4)NOT NULLPrimary Key
descriptionnvarchar (30)NOT NULLW-2 override type description.
Primary key
NameColumnsDescription
PK_W2_Override_Typew2_override_type_KEY
Unique constraints
NameColumnsDescription
UK_W2_Override_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_W2_Override__W2_Override_Type__w2_override_type_KEYw2_override_type_KEYClient_W2_Override
FK_Client_W2_State_Override__W2_Override_Type__w2_override_type_KEYw2_override_type_KEYClient_W2_State_Override
FK_Employee_W2_Tax_Jurisdiction_Override__W2_Override_Type__w2_override_type_KEYw2_override_type_KEYEmployee_W2_Tax_Jurisdiction_Override
FK_Employee_W2_Box_12_Override__W2_Override_Type__w2_override_type_KEYw2_override_type_KEYEmployee_W2_Box_12_Override
FK_Employee_W2_Box_14_Override__W2_Override_Type__w2_override_type_KEYw2_override_type_KEYEmployee_W2_Box_14_Override
FK_Employee_W2_Override__W2_Override_Type__w2_override_type_KEYw2_override_type_KEYEmployee_W2_Override

Schema diagram