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
NameTypeConstraintsDescription
print_w3_selection_KEYint (4)NOT NULLPrimary key for this table. The print engine uses this to uniquely identify each W3/Summary during a print run.
print_w2_KEYint (4)NOT NULLForeign key into the Print_W2 table.
client_KEYint (4)NOT NULLForeign key to the client whose employee is having a W3/Summary form printed for them.
control_numberint (4)NOT NULLA unique number for each W3/Summary 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 Summary 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 Summary 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 Summary 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 Summary 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 Summary 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 Summary 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 Summary 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 Summary has nothing to print in this area. This column not used for W3 form printing.
box_14_1_descriptionnvarchar (50)NOT NULLThe description for the box 14, item 1 on the Summary.
box_14_2_descriptionnvarchar (50)NOT NULLThe description for the box 14, item 2 on the Summary.
box_14_3_descriptionnvarchar (50)NOT NULLThe description for the box 14, item 3 on the Summary.
contact_KEYint (4)The contact to use on the W-3.
other_einnvarchar (22)NOT NULLThe other ein to use for the client.
preparation_datesmalldatetime (4)The preparation date to display on the form. If null, then display nothing on the form.
signature__contact_KEYint (4)The key for the staff member who will be signing the W-3.
nj_fli_provider_id_numbernvarchar (30)NOT NULLThe NJ FLI Provider Id for the Summary.
barcodenvarchar (2200)NOT NULLThe barcode data for this W-3 form.
box_14_4_descriptionnvarchar (50)NOT NULLThe description for the box 14, item 4 on the Summary.
box_14_5_descriptionnvarchar (50)NOT NULLThe description for the box 14, item 5 on the Summary.
box_14_6_descriptionnvarchar (50)NOT NULLThe description for the box 14, item 6 on the Summary.
Primary key
NameColumnsDescription
PK_Print_W3_Selectionprint_w3_selection_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_W3_Selection__Client__client_KEYclient_KEYClient (client_KEY)
FK_Print_W3_Selection__Contact__contact_KEYcontact_KEYContact (contact_KEY)
FK_Print_W3_Selection__Contact__signature__contact_KEYsignature__contact_KEYContact (contact_KEY)
FK_Print_W3_Selection__Print_W2__print_w2_KEYprint_w2_KEYPrint_W2 (print_w2_KEY)
FK_Print_W3_Selection__Tax_Jurisdiction__local_1__tax_jurisdiction_KEYlocal_1__tax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)
FK_Print_W3_Selection__Tax_Jurisdiction__local_2__tax_jurisdiction_KEYlocal_2__tax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)
FK_Print_W3_Selection__Tax_Jurisdiction__state_1__tax_jurisdiction_KEYstate_1__tax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)
FK_Print_W3_Selection__Tax_Jurisdiction__state_2__tax_jurisdiction_KEYstate_2__tax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)
FK_Print_W3_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_W3_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_W3_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_W3_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)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Print_W2_Selection__Print_W3_Selection__print_w3_selection_KEYprint_w3_selection_KEYPrint_W2_Selection

Schema diagram