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 |