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
NameTypeConstraintsDescription
employee_taxable_wage_adjustment_tax_selection_KEYint (4)NOT NULLPrimary key for this table.
client_tax_item_KEYint (4)NOT NULLForeign key to Client_Tax_Item (1..1 relationship).
employee_taxable_wage_adjustment_KEYint (4)NOT NULLForeign Key to parent table Employee_Taxable_Wage_Adjustment (1..M relationship).
Primary key
NameColumnsDescription
PK_Employee_Taxable_Wage_Adjustment_Tax_Selectionemployee_taxable_wage_adjustment_tax_selection_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Taxable_Wage_Adjustment_Tax_Selection$client_tax_item_KEY$employee_taxable_wage_adjustment_KEYclient_tax_item_KEY, employee_taxable_wage_adjustment_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Taxable_Wage_Adjustment_Tax_Selection__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYClient_Tax_Item (client_tax_item_KEY)
FK_Employee_Taxable_Wage_Adjustment_Tax_Selection__Employee_Taxable_Wage_Adjustment__employee_taxable_wage_adjustment_KEYemployee_taxable_wage_adjustment_KEYEmployee_Taxable_Wage_Adjustment (employee_taxable_wage_adjustment_KEY)

Schema diagram