Table: dbo.Employer_Jurisdiction_Payroll_Tax_Information
Columns
Name | Type | Constraints | Description
employer_jurisdiction_payroll_tax_information_KEY | int (4) | NOT NULL | Unique primary key of Employer_Jurisdiction_Payroll_Tax_Information
tax_jurisdiction_KEY | int (4) | NOT NULL | Foreign key to an entry in the Tax_Jurisdiction table
fractions_of_cents_threshold | float (8) | NOT NULL | Numeric value that is used for a threshold in which the amount under the threshold is used as an adjustment on the Fed 941.
overpayment_handling_option_KEY | int (4) | NOT NULL | Foreign key to an entry in the Overpayment_Handling_Option table that defines how tax return overpayment should be used.
supplemental_information_xml | nvarchar (-1) |  | Field for storage of serialized non-standard jurisdiction data in xml format.
third_party_designee_signer__contact_KEY | int (4) |  | Foreign key to an entry in the contact table that is used to designate a contact signer for third party signer designee demographic information sections.
taxpayer_signer__contact_KEY | int (4) |  | Foreign key to an entry in the contact table that is used to designate a contact signer for taxpayer signature demographic information sections.
preparer_signer__contact_KEY | int (4) |  | Foreign key to an entry in the contact table that is used to designate a contact signer for preparer signature demographic information sections.
payment__contact_KEY | int (4) |  | Foreign key to contact table for payment. Contact that the government will contact if there is something wrong with the payment file.
w2_signature__contact_KEY | int (4) |  | Foreign key for w2 signature to contact table. Contact of person who signs w2.
w2_contact__contact_KEY | int (4) |  | Foreign key for w2 contact to contact table. Contact that the government will contact if there is something wrong with the w2.
signature_1099__contact_KEY | int (4) |  | Foreign key for signature 1099 to contact table. This is the person who signs the 1099.
contact_1099__contact_KEY | int (4) |  | Foreign key for contact 1099 to contact table. Contact that the government will contact if there is somewthing wrong with the 1099.
is_reporting_agent | bit (1) | NOT NULL | True if the reporting agent checkbox is marked in the client setup on the payroll taxes tab in the 94X additional information.
taxpayer_signature__report_image_KEY | int (4) |  | Report image key for the tax form signature bit map image.
form1095c_signature__contact_KEY | int (4) |  | The signer of the Federal 1095-C form.
form1095c_contact__contact_KEY | int (4) |  | The contact person for the Federal 1095-C form.
checkbook_KEY | int (4) |  | Foreign key to Checkbook table to indicate the bank account used for Direct Deposit refunds.

Primary key
Name | Columns | Description
PK_Employer_Jurisdiction_Payroll_Tax_Information | employer_jurisdiction_payroll_tax_information_KEY |
Unique constraints
Name | Columns | Description
UK_Employer_Jurisdiction_Payroll_Tax_Information$tax_jurisdiction_KEY | tax_jurisdiction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__form1095c_signature__contact_KEY | form1095c_signature__contact_KEY | Contact (contact_KEY) |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__form1095c_contact__contact_KEY | form1095c_contact__contact_KEY | Contact (contact_KEY) |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__contact_1099__contact_KEY | contact_1099__contact_KEY | Contact (contact_KEY) |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__payment__contact_KEY | payment__contact_KEY | Contact (contact_KEY) |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__preparer_signer__contact_KEY | preparer_signer__contact_KEY | Contact (contact_KEY) |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__signature_1099__contact_KEY | signature_1099__contact_KEY | Contact (contact_KEY) |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__taxpayer_signer__contact_KEY | taxpayer_signer__contact_KEY | Contact (contact_KEY) |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__third_party_designee_signer__contact_KEY | third_party_designee_signer__contact_KEY | Contact (contact_KEY) |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__w2_contact__contact_KEY | w2_contact__contact_KEY | Contact (contact_KEY) |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__w2_signature__contact_KEY | w2_signature__contact_KEY | Contact (contact_KEY) |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Overpayment_Handling_Option__overpayment_handling_option_KEY | overpayment_handling_option_KEY | Overpayment_Handling_Option (overpayment_handling_option_KEY) |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Report_Image__taxpayer_signature__report_image_KEY | taxpayer_signature__report_image_KEY | Report_Image (report_image_KEY) |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |
FK_Employer_Jurisdiction_Payroll_Tax_Information__checkbook_KEY__Checkbook | checkbook_KEY | Checkbook (checkbook_KEY) |