Table: dbo.Client_W2_Override
The table used to store Client W-2 overrides.
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Client_W2_Override | client_w2_override_KEY |
Unique constraints
Name | Columns | Description
UK_Client_W2_Override$client_KEY$w2_override_type_KEY | client_KEY, w2_override_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_W2_Override__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_W2_Override__Employer_Type__employer_type_KEY | employer_type_KEY | Employer_Type (employer_type_KEY) |
FK_Client_W2_Override__W2_Override_Type__w2_override_type_KEY | w2_override_type_KEY | W2_Override_Type (w2_override_type_KEY) |
FK_Client_W2_Override__W3_Kind_Of_Employer__w3_kind_of_employer_KEY | w3_kind_of_employer_KEY | W3_Kind_Of_Employer (w3_kind_of_employer_KEY) |