| 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 | |