The table used to store the overrides for an Employee's W-2 information. |
employee_KEY | int (4) | NOT NULL | Primary key and foreign key into the Employee table. |
include_employee | bit (1) | | Override for whether or not the employee should be included. |
social_security_number | nvarchar (22) | | Override for the employee's social security number. |
last_name | nvarchar (60) | | Override for the employee's last name. |
suffix | nvarchar (10) | | Override for the employee's suffix. |
first_name | nvarchar (60) | | Override for the employee's first name. |
middle_name | nvarchar (60) | | Override for the employee's middle name. |
address_1 | nvarchar (80) | | Override for the employee's address line 1. |
address_2 | nvarchar (80) | | Override for the employee's address line 2. |
city | nvarchar (60) | | Override for the employee's city. |
state_abbreviation | nvarchar (4) | | Override for the employee's state. |
postal_code | nvarchar (100) | | Override for the employee's postal code. |
federal_wages | decimal (9, 2) | | Override for the employee's federal wages. |
federal_tax | decimal (9, 2) | | Override for the employee's federal tax. |
social_security_wages | decimal (9, 2) | | Override for the employee's social security wages. |
social_security_tax | decimal (9, 2) | | Override for the employee's social security tax. |
medicare_wages | decimal (9, 2) | | Override for the employee's medicare wages. |
medicare_tax | decimal (9, 2) | | Override for the employee's medicare tax. |
social_security_tips | decimal (9, 2) | | Override for the employee's social security tips. |
allocated_tips | decimal (9, 2) | | Override for the employee's allocated tips. |
earned_income_credit | decimal (9, 2) | | Override for the employee's earned income credit. |
dependent_care | decimal (9, 2) | | Override for the employee's dependent care. |
nonqualifying_457 | decimal (9, 2) | | Override for the employee's nonqualifying 457. |
nonqualifying_other | decimal (9, 2) | | Override for the employee's nonqualifying other. |
statutory | bit (1) | | Override for the employee's statutory checkbox. |
retirement | bit (1) | | Override for the employee's retirement checkbox. |
sick_pay | bit (1) | | Override for the employee's sick pay checkbox. |
employee_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. |