The table used to store Client W-2 overrides. |
client_KEY | int (4) | NOT NULL | Primary key and foreign key into the Client table. |
client_id | nvarchar (22) | | Override for the Client's id. |
client_ein | nvarchar (22) | | Override for the Client's EIN. |
final_return | bit (1) | | Override for whether this is a final return or not. |
payroll_name | nvarchar (100) | | Override for the Client's payroll name. |
address_1 | nvarchar (80) | | Override for the Client's address line 1. |
address_2 | nvarchar (80) | | Override for the Client's address line 2. |
city | nvarchar (60) | | Override for the Client's city. |
state_abbreviation | nvarchar (4) | | Override for the Client's state. |
postal_code | nvarchar (20) | | Override for the Client's postal code. |
employer_type_KEY | int (4) | | Override for the Client's employer type. |
other_ein | nvarchar (22) | | Override for the Client's other EIN. |
establishment_number | nvarchar (8) | | Override for the Client's establishment number. |
box_14_sick_pay | decimal (9, 2) | | Override for the Client's total Box 14 sick pay. |
nj_disability_insurance_provider_number | nvarchar (18) | | Override for the Client's NJ disability insurance provider number. |
contact_name | nvarchar (100) | | Override for the Client's contact name. |
contact_email | nvarchar (80) | | Override for the Client's contact email. |
contact_phone | nvarchar (50) | | Override for the Client's contact phone number. |
contact_fax | nvarchar (50) | | Override for the Client's contact fax number. |
title | nvarchar (40) | | Override for the Client's tax form signer's title. |
signature_date | smalldatetime (4) | | Override for the date the return was signed. |
client_w2_override_KEY | int (4) | NOT NULL | The primary key. |
w2_override_type_KEY | int (4) | NOT NULL | The foreign key into the W2_Override_Type table. |
explain_decrease | nvarchar (100) | | The explanation of changes being made to the original W-2 if the changes result in a decrease of an amount from what was previously reported on the W-2. This is only used for the W-2c. |
adjusted_on_irs_tax_return | bit (1) | | Identifies whether the changes being made on the W-2c were previously corrected on the IRS tax return. This is only used for the W-2c. |
date_of_adjustment | smalldatetime (4) | | Used to specify the date to which the changes to the IRS tax form were made. This is only used for the W-2c. |
nj_fli_provider_id_number | nvarchar (30) | | The override for the NJ FLI Provider Id for the W-2, or null if there is no override. |
w3_kind_of_employer_KEY | int (4) | | The kind of employer that needs to be displayed on the W-3 for this client. This will be null if no override exists. |