| The table used to store Client W-2 overrides. |
| 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. |
| 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. |
| client_w2_filing_KEY | int (4) | NOT NULL | client w2 filing KEY |