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