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
Name | Type | Constraints | Description
print_w2_selection_KEY | int (4) | NOT NULL | Primary key for this table. The print engine uses this to uniquely identify each W2 or W3 during a print run.
client_KEY | int (4) | NOT NULL | Foreign key to the client whose employee is having a W2/W3 form printed for them.
employee_KEY | int (4) | NOT NULL | Foreign 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_number | int (4) | NOT NULL | A unique number for each W2/W3 per client within a given print run.
box_12_a__w2_compensation_code_type_KEY | int (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_KEY | int (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_KEY | int (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_KEY | int (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_KEY | int (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_KEY | int (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_KEY | int (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_KEY | int (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_employee | bit (1) | NOT NULL | If 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_KEY | int (4) | NOT NULL | The foreign key into the Print_W2 table.
box_14_1_description | nvarchar (50) | NOT NULL | The description for the box 14, item 1 on the W-2.
box_14_2_description | nvarchar (50) | NOT NULL | The description for the box 14, item 2 on the W-2.
box_14_3_description | nvarchar (50) | NOT NULL | The description for the box 14, item 3 on the W-2.
nj_di_provider_id_number | nvarchar (30) | NOT NULL | The NJ DI Provider ID Number to use for the W-2.
print_w3_selection_KEY | int (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_KEY | int (4) | NOT NULL | Foreign 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_number | nvarchar (30) | NOT NULL | The NJ FLI Provider Id for the W-2.
barcode | nvarchar (2200) | NOT NULL | The barcode data for this W-2 form.
federal_wages | decimal (9, 2) | NOT NULL | The W-2's federal wage amount
federal_tax | decimal (9, 2) | NOT NULL | The W-2's federal tax amount
social_security_wages | decimal (9, 2) | NOT NULL | The W-2's social security wage amount
social_security_tax | decimal (9, 2) | NOT NULL | The W-2's social security tax amount
medicare_wages | decimal (9, 2) | NOT NULL | The W-2's medicare wage amount
medicare_tax | decimal (9, 2) | NOT NULL | The W-2's medicare tax amount
social_security_tips | decimal (9, 2) | NOT NULL | The W-2's social security tips amount
allocated_tips | decimal (9, 2) | NOT NULL | The W-2's alloated tips amount
advanced_eic_payment | decimal (9, 2) | NOT NULL | The W-2's advanced EIC amount
dependent_care_benefits | decimal (9, 2) | NOT NULL | The W-2's dependent care benefit amount
nonqualified_plan_amount | decimal (9, 2) | NOT NULL | The W-2's nonqualified plan amount
box_12a_amount | decimal (9, 2) | NOT NULL | The W-2's Box 12a amount
box_12b_amount | decimal (9, 2) | NOT NULL | The W-2's Box 12b amount
box_12c_amount | decimal (9, 2) | NOT NULL | The W-2's Box 12c amount
box_12d_amount | decimal (9, 2) | NOT NULL | The W-2's Box 12d amount
is_statutory_employee | bit (1) | NOT NULL | Whether or not this employee is a statutory employee
has_retirement_plan | bit (1) | NOT NULL | Whether or not this employee has a retirment plan
has_third_party_sick_pay | bit (1) | NOT NULL | Whether or not this employee has any third party sick pay
third_party_sick_pay_amount | decimal (9, 2) | NOT NULL | The third party sick pay amount displayed on the W-3
box_14_1_amount | decimal (9, 2) | NOT NULL | The W-2's Box 14 Line 1 amount
box_14_2_amount | decimal (9, 2) | NOT NULL | The W-2's Box 14 Line 2 amount
box_14_3_amount | decimal (9, 2) | NOT NULL | The W-2's Box 14 Line 3 amount
state_1_id | nvarchar (50) | NOT NULL | The W-2's state 1 employer id
state_2_id | nvarchar (50) | NOT NULL | The W-2's state 2 employer id
state_1_wages | decimal (9, 2) | NOT NULL | The W-2's state 1 wage amount
state_2_wages | decimal (9, 2) | NOT NULL | The W-2's state 2 wage amount
state_1_tax | decimal (9, 2) | NOT NULL | The W-2's state 1 tax amount
state_2_tax | decimal (9, 2) | NOT NULL | The W-2's state 2 tax amount
new_jersey_family_leave_amount | decimal (9, 2) | NOT NULL | The W-2's NJ FLI amount
local_1_wages | decimal (9, 2) | NOT NULL | The W-2's local 1 wage amount
local_2_wages | decimal (9, 2) | NOT NULL | The W-2's local 2 wage amount
local_1_tax | decimal (9, 2) | NOT NULL | The W-2's local 1 tax amount
local_2_tax | decimal (9, 2) | NOT NULL | The W-2's local 2 tax amount
locality_1_name | nvarchar (160) | NOT NULL | The W-2's locality 1 name
locality_2_name | nvarchar (160) | NOT NULL | The W-2's locality 2 name
original_federal_wages | decimal (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_tax | decimal (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_wages | decimal (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_tax | decimal (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_wages | decimal (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_tax | decimal (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_tips | decimal (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_tips | decimal (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_payment | decimal (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_benefits | decimal (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_amount | decimal (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_amount | decimal (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_amount | decimal (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_amount | decimal (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_amount | decimal (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_employee | bit (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_plan | bit (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_pay | bit (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_amount | decimal (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_amount | decimal (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_amount | decimal (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_amount | decimal (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_id | nvarchar (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_id | nvarchar (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_wages | decimal (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_wages | decimal (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_tax | decimal (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_tax | decimal (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_amount | decimal (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_wages | decimal (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_wages | decimal (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_tax | decimal (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_tax | decimal (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_name | nvarchar (160) |  | The original W-2 locality 1 name if this is being corrected. Otherwise, null if this is not being corrected.
original_locality_2_name | nvarchar (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_number | nvarchar (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_number | nvarchar (30) |  | The original W-2 NJ FLI id number if this field is being corrected, null if field is not corrected.
box_14_4_description | nvarchar (50) | NOT NULL | The description for the box 14, item 4 on the W-2.
box_14_5_description | nvarchar (50) | NOT NULL | The description for the box 14, item 5 on the W-2.
box_14_6_description | nvarchar (50) | NOT NULL | The description for the box 14, item 6 on the W-2.
box_14_4_amount | decimal (9, 2) | NOT NULL | The W-2's Box 14 Line 4 amount
box_14_5_amount | decimal (9, 2) | NOT NULL | The W-2's Box 14 Line 5 amount
box_14_6_amount | decimal (9, 2) | NOT NULL | The W-2's Box 14 Line 6 amount
original_box_14_4_amount | decimal (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_amount | decimal (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_amount | decimal (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
Name | Columns | Description
PK_Print_W2_Selection | print_w2_selection_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Print_W2_Selection__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Print_W2_Selection__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Print_W2_Selection__Print_W2__print_w2_KEY | print_w2_KEY | Print_W2 (print_w2_KEY) |
FK_Print_W2_Selection__Print_W3_Selection__print_w3_selection_KEY | print_w3_selection_KEY | Print_W3_Selection (print_w3_selection_KEY) |
FK_Print_W2_Selection__Tax_Jurisdiction__local_1__tax_jurisdiction_KEY | local_1__tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |
FK_Print_W2_Selection__Tax_Jurisdiction__local_2__tax_jurisdiction_KEY | local_2__tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |
FK_Print_W2_Selection__Tax_Jurisdiction__state_1__tax_jurisdiction_KEY | state_1__tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |
FK_Print_W2_Selection__Tax_Jurisdiction__state_2__tax_jurisdiction_KEY | state_2__tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |
FK_Print_W2_Selection__W2_Compensation_Code_Type__box_12_a__w2_compensation_code_type_KEY | box_12_a__w2_compensation_code_type_KEY | W2_Compensation_Code_Type (w2_compensation_code_type_KEY) |
FK_Print_W2_Selection__W2_Compensation_Code_Type__box_12_b__w2_compensation_code_type_KEY | box_12_b__w2_compensation_code_type_KEY | W2_Compensation_Code_Type (w2_compensation_code_type_KEY) |
FK_Print_W2_Selection__W2_Compensation_Code_Type__box_12_c__w2_compensation_code_type_KEY | box_12_c__w2_compensation_code_type_KEY | W2_Compensation_Code_Type (w2_compensation_code_type_KEY) |
FK_Print_W2_Selection__W2_Compensation_Code_Type__box_12_d__w2_compensation_code_type_KEY | box_12_d__w2_compensation_code_type_KEY | W2_Compensation_Code_Type (w2_compensation_code_type_KEY) |
FK_Print_W2_Selection__W2_Special_Correction_Type__w2_special_correction_type_KEY | w2_special_correction_type_KEY | W2_Special_Correction_Type (w2_special_correction_type_KEY) |