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

Primary key
Name | Columns | Description
PK_Client_W2_Override$client_w2_filing_KEY | client_w2_filing_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_W2_Override__Client_W2_Filing__client_w2_filing_KEY | client_w2_filing_KEY | Client_W2_Filing (client_w2_filing_KEY) | FOREIGN KEY constraint of client_w2_filing_KEY for the Client_W2_Override table
FK_Client_W2_Override__Employer_Type__employer_type_KEY | employer_type_KEY | Employer_Type (employer_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) |