Table: dbo.Client_1099_Tax_Form_Selection
This table stores selections by client, 1099 Type, and tax form collation (as a proxy for federal/state copies of 1099s) as to the filing method, the do-not-file selection, and the filing threshold.
Columns
NameTypeConstraintsDescription
client_1099_tax_form_selection_KEYint (4)NOT NULLPrimary key for this table
client_KEYint (4)NOT NULLKey of client to which this data belongs
w2_1099_type_KEYint (4)NOT NULLType of 1099 to which this selection applies
tax_form_KEYint (4)NOT NULLKey of Tax Form Collation that is being described. Note that individual tax forms do not actually have keys!All tax_form_KEY values everywhere in the system actually indicate a Tax Form Collation!This is necessary because the Federal 1099-NEC and the Wisconsin 1099-NEC,for example, will have the same w2_1099_type_KEY but distinct tax_form_KEY values.
tax_form_filing_method_KEYint (4)NOT NULLThe selected filing method
do_not_filebit (1)NOT NULLContains the "Do Not File" Selection: 1 = do not file, 0 = go ahead and file
threshold_amountint (4)NOT NULLSpecifies the minimum dollar value for which the form will be processed
Primary key
NameColumnsDescription
PK_Client_1099_Tax_Form_Selectionclient_1099_tax_form_selection_KEY
Unique constraints
NameColumnsDescription
UK_Client_1099_Tax_Form_Selection$client_KEY$tax_form_KEYclient_KEY, tax_form_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_1099_Tax_Form_Selection__Client_Payroll_Information__client_KEYclient_KEYClient_Payroll_Information (client_KEY)FOREIGN KEY constraint of client_KEY for the Client_1099_Tax_Form_Selection table.
FK_Client_1099_Tax_Form_Selection__W2_1099_Type__w2_1099_type_KEYw2_1099_type_KEYW2_1099_Type (w2_1099_type_KEY)FOREIGN KEY constraint of w2_1099_type_KEY for the Client_1099_Tax_Form_Selection table.
FK_Client_1099_Tax_Form_Selection__Tax_Form__tax_form_KEYtax_form_KEYTax_Form (tax_form_KEY)FOREIGN KEY constraint of tax_form_KEY for the Tax_Form_Filing table.
FK_Client_1099_Tax_Form_Selection__Tax_Form_Filing_Method__tax_form_filing_method_KEYtax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)FOREIGN KEY constraint of tax_form_filing_method_KEY for the Tax_Form_Filing table.

Schema diagram