Table: dbo.Client_W2_Override
The table used to store Client W-2 overrides.
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLPrimary key and foreign key into the Client table.
client_idnvarchar (22)Override for the Client's id.
client_einnvarchar (22)Override for the Client's EIN.
final_returnbit (1)Override for whether this is a final return or not.
payroll_namenvarchar (100)Override for the Client's payroll name.
address_1nvarchar (80)Override for the Client's address line 1.
address_2nvarchar (80)Override for the Client's address line 2.
citynvarchar (60)Override for the Client's city.
state_abbreviationnvarchar (4)Override for the Client's state.
postal_codenvarchar (20)Override for the Client's postal code.
employer_type_KEYint (4)Override for the Client's employer type.
other_einnvarchar (22)Override for the Client's other EIN.
establishment_numbernvarchar (8)Override for the Client's establishment number.
box_14_sick_paydecimal (9, 2)Override for the Client's total Box 14 sick pay.
nj_disability_insurance_provider_numbernvarchar (18)Override for the Client's NJ disability insurance provider number.
contact_namenvarchar (100)Override for the Client's contact name.
contact_emailnvarchar (80)Override for the Client's contact email.
contact_phonenvarchar (50)Override for the Client's contact phone number.
contact_faxnvarchar (50)Override for the Client's contact fax number.
titlenvarchar (40)Override for the Client's tax form signer's title.
signature_datesmalldatetime (4)Override for the date the return was signed.
client_w2_override_KEYint (4)NOT NULLThe primary key.
w2_override_type_KEYint (4)NOT NULLThe foreign key into the W2_Override_Type table.
explain_decreasenvarchar (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_returnbit (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_adjustmentsmalldatetime (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_numbernvarchar (30)The override for the NJ FLI Provider Id for the W-2, or null if there is no override.
w3_kind_of_employer_KEYint (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
NameColumnsDescription
PK_Client_W2_Overrideclient_w2_override_KEY
Unique constraints
NameColumnsDescription
UK_Client_W2_Override$client_KEY$w2_override_type_KEYclient_KEY, w2_override_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_W2_Override__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_W2_Override__Employer_Type__employer_type_KEYemployer_type_KEYEmployer_Type (employer_type_KEY)
FK_Client_W2_Override__W2_Override_Type__w2_override_type_KEYw2_override_type_KEYW2_Override_Type (w2_override_type_KEY)
FK_Client_W2_Override__W3_Kind_Of_Employer__w3_kind_of_employer_KEYw3_kind_of_employer_KEYW3_Kind_Of_Employer (w3_kind_of_employer_KEY)

Schema diagram