| 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 | |||
| Name | Type | Constraints | Description |
| client_1099_tax_form_selection_KEY | int (4) | NOT NULL | Primary key for this table |
| client_KEY | int (4) | NOT NULL | Key of client to which this data belongs |
| w2_1099_type_KEY | int (4) | NOT NULL | Type of 1099 to which this selection applies |
| tax_form_KEY | int (4) | NOT NULL | Key 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_KEY | int (4) | NOT NULL | The selected filing method |
| do_not_file | bit (1) | NOT NULL | Contains the "Do Not File" Selection: 1 = do not file, 0 = go ahead and file |
| threshold_amount | int (4) | NOT NULL | Specifies the minimum dollar value for which the form will be processed |
| Primary key | |||
| Name | Columns | Description | |
| PK_Client_1099_Tax_Form_Selection | client_1099_tax_form_selection_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Client_1099_Tax_Form_Selection$client_KEY$tax_form_KEY | client_KEY, tax_form_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Client_1099_Tax_Form_Selection__Client_Payroll_Information__client_KEY | client_KEY | Client_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_KEY | w2_1099_type_KEY | W2_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_KEY | tax_form_KEY | Tax_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_KEY | tax_form_filing_method_KEY | Tax_Form_Filing_Method (tax_form_filing_method_KEY) | FOREIGN KEY constraint of tax_form_filing_method_KEY for the Tax_Form_Filing table. |