Table: dbo.W2_Employee_Sort_Type
Table used to store the ways to sort employees on W-2s.
Columns
NameTypeConstraintsDescription
w2_employee_sort_type_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (100)NOT NULLDescription of the sort type.
Primary key
NameColumnsDescription
PK_W2_Employee_Sort_Typew2_employee_sort_type_KEY
Unique constraints
NameColumnsDescription
UK_W2_Employee_Sort_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_1095_User_Preference__w2_employee_sort_type_KEYw2_employee_sort_type_KEYForm_1095_User_Preference
FK_W2_1099_User_Preference__W2_Employee_Sort_Type__w2_employee_sort_type_KEYw2_employee_sort_type_KEYW2_1099_User_Preference

Schema diagram