Table: dbo.Print_W3_Selection
This table is used by tax processing code to drive 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_w3_selection_KEY | int (4) | NOT NULL | Primary key for this table. The print engine uses this to uniquely identify each W3/Summary during a print run.
print_w2_KEY | int (4) | NOT NULL | Foreign key into the Print_W2 table.
client_KEY | int (4) | NOT NULL | Foreign key to the client whose employee is having a W3/Summary form printed for them.
control_number | int (4) | NOT NULL | A unique number for each W3/Summary 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 Summary 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 Summary 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 Summary 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 Summary 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 Summary 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 Summary 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 Summary 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 Summary has nothing to print in this area. This column not used for W3 form printing.
box_14_1_description | nvarchar (50) | NOT NULL | The description for the box 14, item 1 on the Summary.
box_14_2_description | nvarchar (50) | NOT NULL | The description for the box 14, item 2 on the Summary.
box_14_3_description | nvarchar (50) | NOT NULL | The description for the box 14, item 3 on the Summary.
contact_KEY | int (4) |  | The contact to use on the W-3.
other_ein | nvarchar (22) | NOT NULL | The other ein to use for the client.
preparation_date | smalldatetime (4) |  | The preparation date to display on the form. If null, then display nothing on the form.
signature__contact_KEY | int (4) |  | The key for the staff member who will be signing the W-3.
nj_fli_provider_id_number | nvarchar (30) | NOT NULL | The NJ FLI Provider Id for the Summary.
barcode | nvarchar (2200) | NOT NULL | The barcode data for this W-3 form.
box_14_4_description | nvarchar (50) | NOT NULL | The description for the box 14, item 4 on the Summary.
box_14_5_description | nvarchar (50) | NOT NULL | The description for the box 14, item 5 on the Summary.
box_14_6_description | nvarchar (50) | NOT NULL | The description for the box 14, item 6 on the Summary.

Primary key
Name | Columns | Description
PK_Print_W3_Selection | print_w3_selection_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Print_W3_Selection__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Print_W3_Selection__Contact__contact_KEY | contact_KEY | Contact (contact_KEY) |
FK_Print_W3_Selection__Contact__signature__contact_KEY | signature__contact_KEY | Contact (contact_KEY) |
FK_Print_W3_Selection__Print_W2__print_w2_KEY | print_w2_KEY | Print_W2 (print_w2_KEY) |
FK_Print_W3_Selection__Tax_Jurisdiction__local_1__tax_jurisdiction_KEY | local_1__tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |
FK_Print_W3_Selection__Tax_Jurisdiction__local_2__tax_jurisdiction_KEY | local_2__tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |
FK_Print_W3_Selection__Tax_Jurisdiction__state_1__tax_jurisdiction_KEY | state_1__tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |
FK_Print_W3_Selection__Tax_Jurisdiction__state_2__tax_jurisdiction_KEY | state_2__tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |
FK_Print_W3_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_W3_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_W3_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_W3_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) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Print_W2_Selection__Print_W3_Selection__print_w3_selection_KEY | print_w3_selection_KEY | Print_W2_Selection |