Table: dbo.Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override
Track employee reconciliation form overrides from the employee detail view grid
Columns
Name | Type | Constraints | Description
employee_reconciliation_tax_form_tax_jurisdiction_override_KEY | int (4) | NOT NULL | Unique key for this employe/state combination
employee_KEY | int (4) | NOT NULL | Employee Key
tax_jurisdiction_KEY | int (4) | NOT NULL | Tax jurisdiction key
include_employee | bit (1) |  | State override for Y/N - include this employee on the employee detail listing for this state
social_security_number | nvarchar (22) |  | State override for Social Security Number
first_name | nvarchar (60) |  | State override for the employee's first name.
middle_name | nvarchar (60) |  | State override for the employee's middle name.
last_name | nvarchar (60) |  | State override for the employee's last name.
suffix | nvarchar (10) |  | State override for the employee's suffix.
address_1 | nvarchar (80) |  | State override for the employee's address line 1.
address_2 | nvarchar (80) |  | State override for the employee's address line 2.
city | nvarchar (60) |  | State override for the employee's city.
state_abbreviation | nvarchar (4) |  | State override for the employee's state.
postal_code | nvarchar (100) |  | State override for the employee's postal code.
fl_out_of_state_abbreviation | nvarchar (4) |  | State override for out of state abbreviation
industry_code | nvarchar (12) |  | State override for industry code
is_active_employee_first_month | bit (1) |  | State override for is active employee first month of processing quarter
is_active_employee_second_month | bit (1) |  | State override for is active employee second month of processing quarter
is_active_employee_third_month | bit (1) |  | State override for is active employee in third month of processing quarter
is_female_employee_first_month | bit (1) |  | State override for is female employee in the first month of the processing quarter
is_female_employee_second_month | bit (1) |  | State override for is female employee in second month of processing quarter
is_female_employee_third_month | bit (1) |  | State override for is female employee in third month of processing quarter
is_employee_seasonal | bit (1) |  | State override for is employee seasonal
is_officer | bit (1) |  | State override for is employee an officer
has_health_care | bit (1) |  | Override for does this employee have health care.
is_employee_exempt_from_this_state_suta | bit (1) |  | State override for is employee exempt from this state's suta
ak_geographic_code | nvarchar (4) |  | State override for Alaska geographic code. Valid string value are "00" thru "99"
ak_occupational_title | nvarchar (100) |  | State override for occupational title
mi_is_employee_family_of_owner | bit (1) |  | State override for is status (Michigan is only one that uses this)
mo_is_probationary | bit (1) |  | State override for is probationary
nm_is_employee_exempt_from_New_Mexico_Worker_Fund1 | bit (1) |  | State override for is employee exempt from NM worker comp fund
hire_date | smalldatetime (4) |  | State override for hire date
inactive_date | smalldatetime (4) |  | State override for inactive date
mo_probationary_begin_date | smalldatetime (4) |  | State override for probationary begin date
mo_probationary_end_date | smalldatetime (4) |  |
payroll_item_calculation_type_KEY | int (4) |  | State override for Pay Type: Valid values are 1 or 2 Salary or Hourly
gender_type_KEY | int (4) |  | State override for male or female
worker_compensation_class_code_KEY | int (4) |  | State override for worker compensation code
wy_employee_coverage_type__employee_other_state_setting_type_KEY | int (4) |  | State override for Wyoming coverage type: 15 = B, 16 = U and 17 = W
ste_county_KEY | int (4) |  | State override for the county (FIPS code)
ca_wage_plan_code__employee_other_state_setting_type_KEY | int (4) |  | State override for California wage plan code. Valid values are 1 - 7
ca_exemption_code__employee_other_state_setting_type_KEY | int (4) |  | State override for California exemption code. Valid values are 8, 9 or 10
nj_plan_type__employee_other_state_setting_type_KEY | int (4) |  | State override for New Jersey plan type. Valid values are 11 or 12
wages_subject | decimal (9, 2) |  | State override for SUTA subject wages
wages_taxable | decimal (9, 2) |  | State override for SUTA taxable wages
federal_tax_withholding_in_filing_period | decimal (9, 2) |  | State override for FIT in filing period
outside_filing_period_state_tax_withheld | decimal (9, 2) |  | State override for YTD state withholding
period_units | decimal (9, 2) |  | State override for period units
quarter_taxable_hours | decimal (9, 2) |  | State override for quarter taxable hours
quarter_worker_compensation_wages_this_state | decimal (9, 2) |  | State override for quarter worker compensation wages this state
fl_out_of_state_gross_wages | decimal (9, 2) |  | State override for out of state gross wages
hourly_rate | decimal (9, 2) |  | State override for hourly rate
quarter_reported_tips | decimal (9, 2) |  | State override for quarter reported tips
wages_excess | decimal (9, 2) |  | State override for SUTA excess wages
rhode_island_hours_paid | decimal (9, 2) |  | The hours paid for a RI employee
rhode_island_weeks_paid | decimal (9, 2) |  | The weeks paid for a RI employee
work_location_KEY | int (4) |  | Reference to work location that signifies that the override SUI amounts are being broken down by work location.
is_household | bit (1) |  | State override for is employee household.
reporting_unit | nvarchar (20) |  | A string used in tax processing for the state to identify a particular work location
sdi_wages_subject | decimal (9, 2) |  | State override for SDI subject wages. A null value indicates that there is no override for this field.
zero_hours_code_KEY | tinyint (1) |  | The zero hours code key.
la_hourly_rate | decimal (5, 4) |  | The nominal hourly rate for any payroll item type, used by Louisiana. A null means there is no override. As per the LA LWC ES-4BC instructions, the max value this can take is 999.9999, and the scale and precision are set appropriately.
mo_out_of_state_suta | bit (1) |  | MO employee reports unemployment to multiple states
outside_filing_period_wages_subject | decimal (5, 2) |  | subject wages outside of the filing period
soc_code | nvarchar (12) |  | SOC Code - To override SOC Code for Indiana and Washington state, NULL means no override and the empty string means overridden to be blank
job_title | nvarchar (40) |  | Job Title - title value from the contact table for employee.
county | nvarchar (70) |  | County - if employee primary location is WV then stores the county value from Contact_Address otherwise blank.
out_of_state_taxable_wages | decimal (9, 2) |  | State override for out of state taxable wages

Primary key
Name | Columns | Description
PK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override | employee_reconciliation_tax_form_tax_jurisdiction_override_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override$employee_KEY$tax_jurisdiction_KEY$work_location_KEY | employee_KEY, tax_jurisdiction_KEY, work_location_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee_Other_State_Setting_Type__ca_exemption_code__employee_ot | ca_exemption_code__employee_other_state_setting_type_KEY | Employee_Other_State_Setting_Type (employee_other_state_setting_type_KEY) |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee_Other_State_Setting_Type__ca_wage_plan_code__employee_ot | ca_wage_plan_code__employee_other_state_setting_type_KEY | Employee_Other_State_Setting_Type (employee_other_state_setting_type_KEY) |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee_Other_State_Setting_Type__nj_plan_type__employee_other_s | nj_plan_type__employee_other_state_setting_type_KEY | Employee_Other_State_Setting_Type (employee_other_state_setting_type_KEY) |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee_Other_State_Setting_Type__wy_employee_coverage_type__emp | wy_employee_coverage_type__employee_other_state_setting_type_KEY | Employee_Other_State_Setting_Type (employee_other_state_setting_type_KEY) |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Gender_Type__gender_type_KEY | gender_type_KEY | Gender_Type (gender_type_KEY) |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Payroll_Item_Calculation_Type__payroll_item_calculation_type_KEY | payroll_item_calculation_type_KEY | Payroll_Item_Calculation_Type (payroll_item_calculation_type_KEY) |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Ste_County__ste_county_KEY | ste_county_KEY | Ste_County (ste_county_KEY) |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Work_Location__work_location_KEY | work_location_KEY | Work_Location (work_location_KEY) |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Worker_Compensation_Class_Code__worker_compensation_class_code_KE | worker_compensation_class_code_KEY | Worker_Compensation_Class_Code (worker_compensation_class_code_KEY) |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Zero_Hours_Code__zero_hours_code_KEY | zero_hours_code_KEY | Zero_Hours_Code (zero_hours_code_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount__Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Ov | employee_reconciliation_tax_form_tax_jurisdiction_override_KEY | Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount |