| 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 | ||