Table: dbo.Print_W2
This table is used by tax processing code to drive W2 and W3 form printing. It determines which user is printing and what year they are printing for.
Columns
Name | Type | Constraints | Description
print_w2_KEY | int (4) | NOT NULL | Primary key for this table.
user_session_guid | uniqueidentifier (16) | NOT NULL | The user session for the person printing the forms. We note user session (as opposed to user) because the application allows a user to log in more than once. In turn, this permits a user to print from more than one session at the same time.
beginning_date | smalldatetime (4) | NOT NULL | The beginning date for bank transactions to be filtered on.
ending_date | smalldatetime (4) | NOT NULL | The ending date for bank transactions to be filtered on.
w2_form_corrected_type_KEY | int (4) | NOT NULL | Foreign key to the W2_Form_Corrected_Type table that indicates what type of W-2 is being corrected, or will be none if processing regular W-2s.

Primary key
Name | Columns | Description
PK_Print_W2 | print_w2_KEY |
Unique constraints
Name | Columns | Description
UK_Print_W2$user_session_guid | user_session_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Print_W2__User_Session__user_session_guid | user_session_guid | User_Session (user_session_guid) |
FK_Print_W2__W2_Form_Corrected_Type__w2_form_corrected_type_KEY | w2_form_corrected_type_KEY | W2_Form_Corrected_Type (w2_form_corrected_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Print_W3_Selection__Print_W2__print_w2_KEY | print_w2_KEY | Print_W3_Selection |
FK_Print_W2_Selection__Print_W2__print_w2_KEY | print_w2_KEY | Print_W2_Selection |