Table: dbo.Employee_Tax_Form_Locality_Amount_Override
Track employee reconciliation form local overrides from the employee detail view grid
Columns
Name | Type | Constraints | Description
employee_tax_form_locality_amount_override_KEY | int (4) | NOT NULL | Unique key for this employee/locality/locality amount type combination
employee_KEY | int (4) | NOT NULL | Employee Key
ste_location_code | nvarchar (60) | NOT NULL | Employee Key
employee_tax_form_locality_amount_type_KEY | int (4) | NOT NULL | Unique key for this employee/locality combination
override_value | decimal (9, 2) | NOT NULL | Unique key for this employee/locality combination

Primary key
Name | Columns | Description
PK_Employee_Tax_Form_Locality_Amount_Override | employee_tax_form_locality_amount_override_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_Tax_Form_Locality_Amount_Override$employee_KEY$ste_location_code$employee_tax_form_locality_amount_type_KEY | employee_KEY, ste_location_code, employee_tax_form_locality_amount_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Tax_Form_Locality_Amount_Override__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Employee_Tax_Form_Locality_Amount_Override__Employee_Tax_Form_Locality_Amount_Type__employee_tax_form_locality_amount_type_KE | employee_tax_form_locality_amount_type_KEY | Employee_Tax_Form_Locality_Amount_Type (employee_tax_form_locality_amount_type_KEY) |