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 |