| 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 | |