Table: dbo.Employee_Tax_Form_Locality_Amount_Override
Track employee reconciliation form local overrides from the employee detail view grid
Columns
NameTypeConstraintsDescription
employee_tax_form_locality_amount_override_KEYint (4)NOT NULLUnique key for this employee/locality/locality amount type combination
employee_KEYint (4)NOT NULLEmployee Key
ste_location_codenvarchar (60)NOT NULLEmployee Key
employee_tax_form_locality_amount_type_KEYint (4)NOT NULLUnique key for this employee/locality combination
override_valuedecimal (9, 2)NOT NULLUnique key for this employee/locality combination
Primary key
NameColumnsDescription
PK_Employee_Tax_Form_Locality_Amount_Overrideemployee_tax_form_locality_amount_override_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Tax_Form_Locality_Amount_Override$employee_KEY$ste_location_code$employee_tax_form_locality_amount_type_KEYemployee_KEY, ste_location_code, employee_tax_form_locality_amount_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Tax_Form_Locality_Amount_Override__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Employee_Tax_Form_Locality_Amount_Override__Employee_Tax_Form_Locality_Amount_Type__employee_tax_form_locality_amount_type_KEemployee_tax_form_locality_amount_type_KEYEmployee_Tax_Form_Locality_Amount_Type (employee_tax_form_locality_amount_type_KEY)

Schema diagram