Table: dbo.Employee_Multi_State_Income_Tax_Calculation_Method
This is a type table of options for how an employee's multi-state income tax will be calculated. Each record maps to an available option in the Symmetry calculation engine to configure it to calculate as desired.
Columns
NameTypeConstraintsDescription
employee_multi_state_income_tax_calculation_method_KEYint (4)NOT NULLPrimary key for the Employee_State_Income_Tax_Withholding_Override_Type table.
descriptionnvarchar (80)NOT NULLText description of the calculation method record.
Primary key
NameColumnsDescription
PK_Employee_Multi_State_Income_Tax_Calculation_Methodemployee_multi_state_income_tax_calculation_method_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Multi_State_Income_Tax_Calculation_Method$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee__Employee_Multi_State_Income_Tax_Calculation_Method__employee_multi_state_income_tax_calculation_method_KEYemployee_multi_state_income_tax_calculation_method_KEYEmployee
FK_Payroll_Bank_Transaction__Employee_Multi_State_Income_Tax_Calculation_Method__employee_multi_state_income_tax_calculation_metemployee_multi_state_income_tax_calculation_method_KEYPayroll_Bank_Transaction

Schema diagram