Table: dbo.Employee_Taxable_Wage_Adjustment
This table will hold an employee's adjustments to ytd gross taxable wages and ytd taxable wages.
Columns
NameTypeConstraintsDescription
employee_taxable_wage_adjustment_KEYint (4)NOT NULLPrimary key for this table.
gross_taxable_wage_amountdecimal (9, 2)NOT NULLAdjustment amount to gross taxable wages.
taxable_wage_amountdecimal (9, 2)NOT NULLAdjustment amount to subject taxable wages.
adjustment_datedatetime (8, 3)NOT NULLDate the adjustment becomes effective.
notenvarchar (200)NOT NULLAny notes or details that pertain to the adjustment.
employee_KEYint (4)NOT NULLForeign key to parent table Employee (1..M relationship).
Primary key
NameColumnsDescription
PK_Employee_Taxable_Wage_Adjustmentemployee_taxable_wage_adjustment_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Taxable_Wage_Adjustment__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee_Taxable_Wage_Adjustment_Tax_Selection__Employee_Taxable_Wage_Adjustment__employee_taxable_wage_adjustment_KEYemployee_taxable_wage_adjustment_KEYEmployee_Taxable_Wage_Adjustment_Tax_Selection

Schema diagram