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 |