Table: dbo.Print_W2_Selection
This table is used by tax processing code to drive W2 and W3 form printing. It determines each form's control number as well as which box 12 codes, which states, and which localities ton include on a form.
Columns
NameTypeConstraintsDescription
print_w2_selection_KEYint (4)NOT NULLPrimary key for this table. The print engine uses this to uniquely identify each W2 or W3 during a print run.
client_KEYint (4)NOT NULLForeign key to the client whose employee is having a W2/W3 form printed for them.
employee_KEYint (4)NOT NULLForeign key to the employee for whom the W2 form is being printed. This key is required for W2 forms. For W3 forms, this key is null since client totals are being calculated across all employees.
control_numberint (4)NOT NULLA unique number for each W2/W3 per client within a given print run.
box_12_a__w2_compensation_code_type_KEYint (4)Foreign key to the W2 compensation code whose information (code, amount) will print in the (a) slot of box 12. If null, then this W2 has nothing to print in this area. This column not used for W3 form printing.
box_12_b__w2_compensation_code_type_KEYint (4)Foreign key to the W2 compensation code whose information (code, amount) will print in the (b) slot of box 12. If null, then this W2 has nothing to print in this area. This column not used for W3 form printing.
box_12_c__w2_compensation_code_type_KEYint (4)Foreign key to the W2 compensation code whose information (code, amount) will print in the (c) slot of box 12. If null, then this W2 has nothing to print in this area. This column not used for W3 form printing.
box_12_d__w2_compensation_code_type_KEYint (4)Foreign key to the W2 compensation code whose information (code, amount) will print in the (d) slot of box 12. If null, then this W2 has nothing to print in this area. This column not used for W3 form printing.
state_1__tax_jurisdiction_KEYint (4)Foreign key to a state tax jurisdiction whose information (state ID number, state wages, state income tax) will print on the first line of box 15 thru 17. If null, then this W2 has nothing to print in this area. This column not used for W3 form printing.
state_2__tax_jurisdiction_KEYint (4)Foreign key to a state tax jurisdiction whose information (state ID number, state wages, state income tax) will print on the second line of box 15 thru 17. If null, then this W2 has nothing to print in this area. This column not used for W3 form printing.
local_1__tax_jurisdiction_KEYint (4)Foreign key to a locality tax jurisdiction whose information (local wages, local income tax, locality name) will print on the first line of box 18 thru 20. If null, then this W2 has nothing to print in this area. This column not used for W3 form printing.
local_2__tax_jurisdiction_KEYint (4)Foreign key to a locality tax jurisdiction whose information (local wages, local income tax, locality name) will print on the second line of box 18 thru 20. If null, then this W2 has nothing to print in this area. This column not used for W3 form printing.
is_second_or_more_form_for_employeebit (1)NOT NULLIf this is the first form being printed for the employee, then this value should be set to false (0). If this is the second or more W2 printed for this employee, then it should be set to true (1). If true, W2 form printing will only include the client and employee information and any box 12, state, and/or locality information indicated. This is not used for W3 form printing.
print_w2_KEYint (4)NOT NULLThe foreign key into the Print_W2 table.
box_14_1_descriptionnvarchar (50)NOT NULLThe description for the box 14, item 1 on the W-2.
box_14_2_descriptionnvarchar (50)NOT NULLThe description for the box 14, item 2 on the W-2.
box_14_3_descriptionnvarchar (50)NOT NULLThe description for the box 14, item 3 on the W-2.
nj_di_provider_id_numbernvarchar (30)NOT NULLThe NJ DI Provider ID Number to use for the W-2.
print_w3_selection_KEYint (4)A key into the Print_W3_Selection table to link employee selections with a W-3 or Summary print job
w2_special_correction_type_KEYint (4)NOT NULLForeign key to the W2_Special_Correction_Type table that indicates if a special correction is being made for the W-2s and what kind of special correction is being made.
nj_fli_provider_id_numbernvarchar (30)NOT NULLThe NJ FLI Provider Id for the W-2.
barcodenvarchar (2200)NOT NULLThe barcode data for this W-2 form.
federal_wagesdecimal (9, 2)NOT NULLThe W-2's federal wage amount
federal_taxdecimal (9, 2)NOT NULLThe W-2's federal tax amount
social_security_wagesdecimal (9, 2)NOT NULLThe W-2's social security wage amount
social_security_taxdecimal (9, 2)NOT NULLThe W-2's social security tax amount
medicare_wagesdecimal (9, 2)NOT NULLThe W-2's medicare wage amount
medicare_taxdecimal (9, 2)NOT NULLThe W-2's medicare tax amount
social_security_tipsdecimal (9, 2)NOT NULLThe W-2's social security tips amount
allocated_tipsdecimal (9, 2)NOT NULLThe W-2's alloated tips amount
advanced_eic_paymentdecimal (9, 2)NOT NULLThe W-2's advanced EIC amount
dependent_care_benefitsdecimal (9, 2)NOT NULLThe W-2's dependent care benefit amount
nonqualified_plan_amountdecimal (9, 2)NOT NULLThe W-2's nonqualified plan amount
box_12a_amountdecimal (9, 2)NOT NULLThe W-2's Box 12a amount
box_12b_amountdecimal (9, 2)NOT NULLThe W-2's Box 12b amount
box_12c_amountdecimal (9, 2)NOT NULLThe W-2's Box 12c amount
box_12d_amountdecimal (9, 2)NOT NULLThe W-2's Box 12d amount
is_statutory_employeebit (1)NOT NULLWhether or not this employee is a statutory employee
has_retirement_planbit (1)NOT NULLWhether or not this employee has a retirment plan
has_third_party_sick_paybit (1)NOT NULLWhether or not this employee has any third party sick pay
third_party_sick_pay_amountdecimal (9, 2)NOT NULLThe third party sick pay amount displayed on the W-3
box_14_1_amountdecimal (9, 2)NOT NULLThe W-2's Box 14 Line 1 amount
box_14_2_amountdecimal (9, 2)NOT NULLThe W-2's Box 14 Line 2 amount
box_14_3_amountdecimal (9, 2)NOT NULLThe W-2's Box 14 Line 3 amount
state_1_idnvarchar (50)NOT NULLThe W-2's state 1 employer id
state_2_idnvarchar (50)NOT NULLThe W-2's state 2 employer id
state_1_wagesdecimal (9, 2)NOT NULLThe W-2's state 1 wage amount
state_2_wagesdecimal (9, 2)NOT NULLThe W-2's state 2 wage amount
state_1_taxdecimal (9, 2)NOT NULLThe W-2's state 1 tax amount
state_2_taxdecimal (9, 2)NOT NULLThe W-2's state 2 tax amount
new_jersey_family_leave_amountdecimal (9, 2)NOT NULLThe W-2's NJ FLI amount
local_1_wagesdecimal (9, 2)NOT NULLThe W-2's local 1 wage amount
local_2_wagesdecimal (9, 2)NOT NULLThe W-2's local 2 wage amount
local_1_taxdecimal (9, 2)NOT NULLThe W-2's local 1 tax amount
local_2_taxdecimal (9, 2)NOT NULLThe W-2's local 2 tax amount
locality_1_namenvarchar (160)NOT NULLThe W-2's locality 1 name
locality_2_namenvarchar (160)NOT NULLThe W-2's locality 2 name
original_federal_wagesdecimal (9, 2)The original W-2 federal amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_federal_taxdecimal (9, 2)The original W-2 federal tax amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_social_security_wagesdecimal (9, 2)The original W-2 social security wage amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_social_security_taxdecimal (9, 2)The original W-2 social security tax amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_medicare_wagesdecimal (9, 2)The original W-2 medicare wage amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_medicare_taxdecimal (9, 2)The original W-2 medicare tax amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_social_security_tipsdecimal (9, 2)The original W-2 social securtiy tip amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_allocated_tipsdecimal (9, 2)The original W-2 allocated tip amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_advanced_eic_paymentdecimal (9, 2)The original W-2 advanced EIC amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_dependent_care_benefitsdecimal (9, 2)The original W-2 dependent care benefit amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_nonqualified_plan_amountdecimal (9, 2)The original W-2 nonqualified plan amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_box_12a_amountdecimal (9, 2)The original W-2 Box 12a amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_box_12b_amountdecimal (9, 2)The original W-2 Box 12b amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_box_12c_amountdecimal (9, 2)The original W-2 Box 12c amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_box_12d_amountdecimal (9, 2)The original W-2 Box 12d amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_is_statutory_employeebit (1)This represents whether or not the employee was originally marked as a statutory employee if this is being corrected. Otherwise, null if this is not being corrected.
original_has_retirement_planbit (1)This represents whether or not the employee was originally marked as having a retirement plan if this is being corrected. Otherwise, null if this is not being corrected.
original_has_third_party_sick_paybit (1)This represents whether or not the employee was originally marked as having a third party sick pay if this is being corrected. Otherwise, null if this is not being corrected.
original_third_party_sick_pay_amountdecimal (9, 2)The original W-2 third party sick pay amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_box_14_1_amountdecimal (9, 2)The original W-2 Box 14 line 1 amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_box_14_2_amountdecimal (9, 2)The original W-2 Box 14 line 2 amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_box_14_3_amountdecimal (9, 2)The original W-2 Box 14 line 3 amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_state_1_idnvarchar (50)The original W-2 state 1 employer id if this is being corrected. Otherwise, null if this is not being corrected.
original_state_2_idnvarchar (50)The original W-2 state 2 employer id if this amount is being corrected. Otherwise, null if this is not being corrected.
original_state_1_wagesdecimal (9, 2)The original W-2 state 1 wage amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_state_2_wagesdecimal (9, 2)The original W-2 state 2 wage amount amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_state_1_taxdecimal (9, 2)The original W-2 state 1 tax amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_state_2_taxdecimal (9, 2)The original W-2 state 2 tax amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_new_jersey_family_leave_amountdecimal (9, 2)The original W-2 NJ FLI amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_local_1_wagesdecimal (9, 2)The original W-2 local 1 wage amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_local_2_wagesdecimal (9, 2)The original W-2 local 2 wage amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_local_1_taxdecimal (9, 2)The original W-2 local 1 tax amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_local_2_taxdecimal (9, 2)The original W-2 local 2 tax amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_locality_1_namenvarchar (160)The original W-2 locality 1 name if this is being corrected. Otherwise, null if this is not being corrected.
original_locality_2_namenvarchar (160)The original W-2 locality 2 name if this is being corrected. Otherwise, null if this is not being corrected.
original_nj_di_provider_id_numbernvarchar (30)The original W-2 NJ DI id number if this field is being corrected, null if field is not corrected.
original_nj_fli_provider_id_numbernvarchar (30)The original W-2 NJ FLI id number if this field is being corrected, null if field is not corrected.
box_14_4_descriptionnvarchar (50)NOT NULLThe description for the box 14, item 4 on the W-2.
box_14_5_descriptionnvarchar (50)NOT NULLThe description for the box 14, item 5 on the W-2.
box_14_6_descriptionnvarchar (50)NOT NULLThe description for the box 14, item 6 on the W-2.
box_14_4_amountdecimal (9, 2)NOT NULLThe W-2's Box 14 Line 4 amount
box_14_5_amountdecimal (9, 2)NOT NULLThe W-2's Box 14 Line 5 amount
box_14_6_amountdecimal (9, 2)NOT NULLThe W-2's Box 14 Line 6 amount
original_box_14_4_amountdecimal (9, 2)The original W-2 Box 14 line 4 amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_box_14_5_amountdecimal (9, 2)The original W-2 Box 14 line 5 amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
original_box_14_6_amountdecimal (9, 2)The original W-2 Box 14 line 6 amount if this amount is being corrected. Otherwise, null if this amount is not being corrected.
Primary key
NameColumnsDescription
PK_Print_W2_Selectionprint_w2_selection_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_W2_Selection__Client__client_KEYclient_KEYClient (client_KEY)
FK_Print_W2_Selection__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Print_W2_Selection__Print_W2__print_w2_KEYprint_w2_KEYPrint_W2 (print_w2_KEY)
FK_Print_W2_Selection__Print_W3_Selection__print_w3_selection_KEYprint_w3_selection_KEYPrint_W3_Selection (print_w3_selection_KEY)
FK_Print_W2_Selection__Tax_Jurisdiction__local_1__tax_jurisdiction_KEYlocal_1__tax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)
FK_Print_W2_Selection__Tax_Jurisdiction__local_2__tax_jurisdiction_KEYlocal_2__tax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)
FK_Print_W2_Selection__Tax_Jurisdiction__state_1__tax_jurisdiction_KEYstate_1__tax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)
FK_Print_W2_Selection__Tax_Jurisdiction__state_2__tax_jurisdiction_KEYstate_2__tax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)
FK_Print_W2_Selection__W2_Compensation_Code_Type__box_12_a__w2_compensation_code_type_KEYbox_12_a__w2_compensation_code_type_KEYW2_Compensation_Code_Type (w2_compensation_code_type_KEY)
FK_Print_W2_Selection__W2_Compensation_Code_Type__box_12_b__w2_compensation_code_type_KEYbox_12_b__w2_compensation_code_type_KEYW2_Compensation_Code_Type (w2_compensation_code_type_KEY)
FK_Print_W2_Selection__W2_Compensation_Code_Type__box_12_c__w2_compensation_code_type_KEYbox_12_c__w2_compensation_code_type_KEYW2_Compensation_Code_Type (w2_compensation_code_type_KEY)
FK_Print_W2_Selection__W2_Compensation_Code_Type__box_12_d__w2_compensation_code_type_KEYbox_12_d__w2_compensation_code_type_KEYW2_Compensation_Code_Type (w2_compensation_code_type_KEY)
FK_Print_W2_Selection__W2_Special_Correction_Type__w2_special_correction_type_KEYw2_special_correction_type_KEYW2_Special_Correction_Type (w2_special_correction_type_KEY)

Schema diagram