Table: dbo.Employee_W2_Override
The table used to store the overrides for an Employee's W-2 information.
Columns
NameTypeConstraintsDescription
employee_KEYint (4)NOT NULLPrimary key and foreign key into the Employee table.
include_employeebit (1)Override for whether or not the employee should be included.
social_security_numbernvarchar (22)Override for the employee's social security number.
last_namenvarchar (60)Override for the employee's last name.
suffixnvarchar (10)Override for the employee's suffix.
first_namenvarchar (60)Override for the employee's first name.
middle_namenvarchar (60)Override for the employee's middle name.
address_1nvarchar (80)Override for the employee's address line 1.
address_2nvarchar (80)Override for the employee's address line 2.
citynvarchar (60)Override for the employee's city.
state_abbreviationnvarchar (4)Override for the employee's state.
postal_codenvarchar (100)Override for the employee's postal code.
federal_wagesdecimal (9, 2)Override for the employee's federal wages.
federal_taxdecimal (9, 2)Override for the employee's federal tax.
social_security_wagesdecimal (9, 2)Override for the employee's social security wages.
social_security_taxdecimal (9, 2)Override for the employee's social security tax.
medicare_wagesdecimal (9, 2)Override for the employee's medicare wages.
medicare_taxdecimal (9, 2)Override for the employee's medicare tax.
social_security_tipsdecimal (9, 2)Override for the employee's social security tips.
allocated_tipsdecimal (9, 2)Override for the employee's allocated tips.
earned_income_creditdecimal (9, 2)Override for the employee's earned income credit.
dependent_caredecimal (9, 2)Override for the employee's dependent care.
nonqualifying_457decimal (9, 2)Override for the employee's nonqualifying 457.
nonqualifying_otherdecimal (9, 2)Override for the employee's nonqualifying other.
statutorybit (1)Override for the employee's statutory checkbox.
retirementbit (1)Override for the employee's retirement checkbox.
sick_paybit (1)Override for the employee's sick pay checkbox.
employee_w2_override_KEYint (4)NOT NULLThe primary key.
w2_override_type_KEYint (4)NOT NULLThe foreign key into the W2_Override_Type table.
Primary key
NameColumnsDescription
PK_Employee_W2_Overrideemployee_w2_override_KEY
Unique constraints
NameColumnsDescription
UK_Employee_W2_Override$employee_KEY$w2_override_type_KEYemployee_KEY, w2_override_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_W2_Override__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Employee_W2_Override__W2_Override_Type__w2_override_type_KEYw2_override_type_KEYW2_Override_Type (w2_override_type_KEY)

Schema diagram