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_Filing__W2_Override_Type__w2_override_type_KEYw2_override_type_KEYClient_W2_FilingFOREIGN KEY constraint of w2_override_type_KEY for the Client_W2_Filing table
FK_Employee_W2_Filing__W2_Override_Type__w2_override_type_KEYw2_override_type_KEYEmployee_W2_FilingFOREIGN KEY constraint of w2_override_type_KEY for the Employee_W2_Filing table which ensures valid w2 override type

Schema diagram