The table used to store the overrides for an Employee's state information. |
employee_w2_tax_jurisdiction_override_KEY | int (4) | NOT NULL | Primary key. |
employee_KEY | int (4) | NOT NULL | Foreign key into the employee table. |
tax_jurisdiction_KEY | int (4) | NOT NULL | Foreign key into the tax jurisdiction table. |
wages | decimal (9, 2) | | Override for the employee's state wages. |
tax | decimal (9, 2) | | Override for the employee's state taxes |
w2_override_type_KEY | int (4) | NOT NULL | The foreign key into the W2_Override_Type table. |
is_nonstandard | bit (1) | NOT NULL | Boolean value representing whether this override corresponds to a nonstandard tax jurisdiction. CA SDI is treated as a local, but uses the state tax jurisdiction key. NJ FLI is treated as a state, but behaves differently from other states. |