Table: dbo.Employee_Taxable_Wage_Adjustment
This table will hold an employee's adjustments to ytd gross taxable wages and ytd taxable wages.
Columns
Name | Type | Constraints | Description
employee_taxable_wage_adjustment_KEY | int (4) | NOT NULL | Primary key for this table.
gross_taxable_wage_amount | decimal (9, 2) | NOT NULL | Adjustment amount to gross taxable wages.
taxable_wage_amount | decimal (9, 2) | NOT NULL | Adjustment amount to subject taxable wages.
adjustment_date | datetime (8, 3) | NOT NULL | Date the adjustment becomes effective.
note | nvarchar (200) | NOT NULL | Any notes or details that pertain to the adjustment.
employee_KEY | int (4) | NOT NULL | Foreign key to parent table Employee (1..M relationship).

Primary key
Name | Columns | Description
PK_Employee_Taxable_Wage_Adjustment | employee_taxable_wage_adjustment_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Taxable_Wage_Adjustment__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Employee_Taxable_Wage_Adjustment_Tax_Selection__Employee_Taxable_Wage_Adjustment__employee_taxable_wage_adjustment_KEY | employee_taxable_wage_adjustment_KEY | Employee_Taxable_Wage_Adjustment_Tax_Selection |