Table: dbo.Employer_Jurisdiction_Payroll_Tax_Information
Columns
NameTypeConstraintsDescription
employer_jurisdiction_payroll_tax_information_KEYint (4)NOT NULLUnique primary key of Employer_Jurisdiction_Payroll_Tax_Information
tax_jurisdiction_KEYint (4)NOT NULLForeign key to an entry in the Tax_Jurisdiction table
fractions_of_cents_thresholdfloat (8)NOT NULLNumeric 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_KEYint (4)NOT NULLForeign key to an entry in the Overpayment_Handling_Option table that defines how tax return overpayment should be used.
supplemental_information_xmlnvarchar (-1)Field for storage of serialized non-standard jurisdiction data in xml format.
third_party_designee_signer__contact_KEYint (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_KEYint (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_KEYint (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_KEYint (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_KEYint (4)Foreign key for w2 signature to contact table. Contact of person who signs w2.
w2_contact__contact_KEYint (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_KEYint (4)Foreign key for signature 1099 to contact table. This is the person who signs the 1099.
contact_1099__contact_KEYint (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_agentbit (1)NOT NULLTrue 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_KEYint (4)Report image key for the tax form signature bit map image.
form1095c_signature__contact_KEYint (4)The signer of the Federal 1095-C form.
form1095c_contact__contact_KEYint (4)The contact person for the Federal 1095-C form.
Primary key
NameColumnsDescription
PK_Employer_Jurisdiction_Payroll_Tax_Informationemployer_jurisdiction_payroll_tax_information_KEY
Unique constraints
NameColumnsDescription
UK_Employer_Jurisdiction_Payroll_Tax_Information$tax_jurisdiction_KEYtax_jurisdiction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__form1095c_signature__contact_KEYform1095c_signature__contact_KEYContact (contact_KEY)
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__form1095c_contact__contact_KEYform1095c_contact__contact_KEYContact (contact_KEY)
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__contact_1099__contact_KEYcontact_1099__contact_KEYContact (contact_KEY)
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__payment__contact_KEYpayment__contact_KEYContact (contact_KEY)
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__preparer_signer__contact_KEYpreparer_signer__contact_KEYContact (contact_KEY)
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__signature_1099__contact_KEYsignature_1099__contact_KEYContact (contact_KEY)
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__taxpayer_signer__contact_KEYtaxpayer_signer__contact_KEYContact (contact_KEY)
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__third_party_designee_signer__contact_KEYthird_party_designee_signer__contact_KEYContact (contact_KEY)
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__w2_contact__contact_KEYw2_contact__contact_KEYContact (contact_KEY)
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__w2_signature__contact_KEYw2_signature__contact_KEYContact (contact_KEY)
FK_Employer_Jurisdiction_Payroll_Tax_Information__Overpayment_Handling_Option__overpayment_handling_option_KEYoverpayment_handling_option_KEYOverpayment_Handling_Option (overpayment_handling_option_KEY)
FK_Employer_Jurisdiction_Payroll_Tax_Information__Report_Image__taxpayer_signature__report_image_KEYtaxpayer_signature__report_image_KEYReport_Image (report_image_KEY)
FK_Employer_Jurisdiction_Payroll_Tax_Information__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)

Schema diagram