Table: dbo.Employee_Taxable_Wage_Adjustment_Tax_Selection
This table holds the tax item (federal/state/local) selection that the user wants the adjustments applied to.
Columns
Name | Type | Constraints | Description
employee_taxable_wage_adjustment_tax_selection_KEY | int (4) | NOT NULL | Primary key for this table.
client_tax_item_KEY | int (4) | NOT NULL | Foreign key to Client_Tax_Item (1..1 relationship).
employee_taxable_wage_adjustment_KEY | int (4) | NOT NULL | Foreign Key to parent table Employee_Taxable_Wage_Adjustment (1..M relationship).

Primary key
Name | Columns | Description
PK_Employee_Taxable_Wage_Adjustment_Tax_Selection | employee_taxable_wage_adjustment_tax_selection_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_Taxable_Wage_Adjustment_Tax_Selection$client_tax_item_KEY$employee_taxable_wage_adjustment_KEY | client_tax_item_KEY, employee_taxable_wage_adjustment_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Taxable_Wage_Adjustment_Tax_Selection__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Client_Tax_Item (client_tax_item_KEY) |
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 (employee_taxable_wage_adjustment_KEY) |