Table: dbo.W2_Employee_Sort_Type
Table used to store the ways to sort employees on W-2s.
Columns
Name | Type | Constraints | Description
w2_employee_sort_type_KEY | int (4) | NOT NULL | Primary key for this table.
description | nvarchar (100) | NOT NULL | Description of the sort type.

Primary key
Name | Columns | Description
PK_W2_Employee_Sort_Type | w2_employee_sort_type_KEY |
Unique constraints
Name | Columns | Description
UK_W2_Employee_Sort_Type$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Form_1095_User_Preference__w2_employee_sort_type_KEY | w2_employee_sort_type_KEY | Form_1095_User_Preference |
FK_W2_1099_User_Preference__W2_Employee_Sort_Type__w2_employee_sort_type_KEY | w2_employee_sort_type_KEY | W2_1099_User_Preference |