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
NameTypeConstraintsDescription
print_w2_KEYint (4)NOT NULLPrimary key for this table.
user_session_guiduniqueidentifier (16)NOT NULLThe 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_datesmalldatetime (4)NOT NULLThe beginning date for bank transactions to be filtered on.
ending_datesmalldatetime (4)NOT NULLThe ending date for bank transactions to be filtered on.
w2_form_corrected_type_KEYint (4)NOT NULLForeign 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
NameColumnsDescription
PK_Print_W2print_w2_KEY
Unique constraints
NameColumnsDescription
UK_Print_W2$user_session_guiduser_session_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_W2__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)
FK_Print_W2__W2_Form_Corrected_Type__w2_form_corrected_type_KEYw2_form_corrected_type_KEYW2_Form_Corrected_Type (w2_form_corrected_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Print_W3_Selection__Print_W2__print_w2_KEYprint_w2_KEYPrint_W3_Selection
FK_Print_W2_Selection__Print_W2__print_w2_KEYprint_w2_KEYPrint_W2_Selection

Schema diagram