Table: dbo.Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override
Track employee reconciliation form overrides from the employee detail view grid
Columns
NameTypeConstraintsDescription
employee_reconciliation_tax_form_tax_jurisdiction_override_KEYint (4)NOT NULLUnique key for this employe/state combination
employee_KEYint (4)NOT NULLEmployee Key
tax_jurisdiction_KEYint (4)NOT NULLTax jurisdiction key
include_employeebit (1)State override for Y/N - include this employee on the employee detail listing for this state
social_security_numbernvarchar (22)State override for Social Security Number
first_namenvarchar (60)State override for the employee's first name.
middle_namenvarchar (60)State override for the employee's middle name.
last_namenvarchar (60)State override for the employee's last name.
suffixnvarchar (10)State override for the employee's suffix.
address_1nvarchar (80)State override for the employee's address line 1.
address_2nvarchar (80)State override for the employee's address line 2.
citynvarchar (60)State override for the employee's city.
state_abbreviationnvarchar (4)State override for the employee's state.
postal_codenvarchar (100)State override for the employee's postal code.
fl_out_of_state_abbreviationnvarchar (4)State override for out of state abbreviation
industry_codenvarchar (12)State override for industry code
is_active_employee_first_monthbit (1)State override for is active employee first month of processing quarter
is_active_employee_second_monthbit (1)State override for is active employee second month of processing quarter
is_active_employee_third_monthbit (1)State override for is active employee in third month of processing quarter
is_female_employee_first_monthbit (1)State override for is female employee in the first month of the processing quarter
is_female_employee_second_monthbit (1)State override for is female employee in second month of processing quarter
is_female_employee_third_monthbit (1)State override for is female employee in third month of processing quarter
is_employee_seasonalbit (1)State override for is employee seasonal
is_officerbit (1)State override for is employee an officer
has_health_carebit (1)Override for does this employee have health care.
is_employee_exempt_from_this_state_sutabit (1)State override for is employee exempt from this state's suta
ak_geographic_codenvarchar (4)State override for Alaska geographic code. Valid string value are "00" thru "99"
ak_occupational_titlenvarchar (100)State override for occupational title
mi_is_employee_family_of_ownerbit (1)State override for is status (Michigan is only one that uses this)
mo_is_probationarybit (1)State override for is probationary
nm_is_employee_exempt_from_New_Mexico_Worker_Fund1bit (1)State override for is employee exempt from NM worker comp fund
hire_datesmalldatetime (4)State override for hire date
inactive_datesmalldatetime (4)State override for inactive date
mo_probationary_begin_datesmalldatetime (4)State override for probationary begin date
mo_probationary_end_datesmalldatetime (4)
payroll_item_calculation_type_KEYint (4)State override for Pay Type: Valid values are 1 or 2 Salary or Hourly
gender_type_KEYint (4)State override for male or female
worker_compensation_class_code_KEYint (4)State override for worker compensation code
wy_employee_coverage_type__employee_other_state_setting_type_KEYint (4)State override for Wyoming coverage type: 15 = B, 16 = U and 17 = W
ste_county_KEYint (4)State override for the county (FIPS code)
ca_wage_plan_code__employee_other_state_setting_type_KEYint (4)State override for California wage plan code. Valid values are 1 - 7
ca_exemption_code__employee_other_state_setting_type_KEYint (4)State override for California exemption code. Valid values are 8, 9 or 10
nj_plan_type__employee_other_state_setting_type_KEYint (4)State override for New Jersey plan type. Valid values are 11 or 12
wages_subjectdecimal (9, 2)State override for SUTA subject wages
wages_taxabledecimal (9, 2)State override for SUTA taxable wages
federal_tax_withholding_in_filing_perioddecimal (9, 2)State override for FIT in filing period
outside_filing_period_state_tax_withhelddecimal (9, 2)State override for YTD state withholding
period_unitsdecimal (9, 2)State override for period units
quarter_taxable_hoursdecimal (9, 2)State override for quarter taxable hours
quarter_worker_compensation_wages_this_statedecimal (9, 2)State override for quarter worker compensation wages this state
fl_out_of_state_gross_wagesdecimal (9, 2)State override for out of state gross wages
hourly_ratedecimal (9, 2)State override for hourly rate
quarter_reported_tipsdecimal (9, 2)State override for quarter reported tips
wages_excessdecimal (9, 2)State override for SUTA excess wages
rhode_island_hours_paiddecimal (9, 2)The hours paid for a RI employee
rhode_island_weeks_paiddecimal (9, 2)The weeks paid for a RI employee
work_location_KEYint (4)Reference to work location that signifies that the override SUI amounts are being broken down by work location.
is_householdbit (1)State override for is employee household.
reporting_unitnvarchar (20)A string used in tax processing for the state to identify a particular work location
sdi_wages_subjectdecimal (9, 2)State override for SDI subject wages. A null value indicates that there is no override for this field.
zero_hours_code_KEYtinyint (1)The zero hours code key.
la_hourly_ratedecimal (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_sutabit (1)MO employee reports unemployment to multiple states
outside_filing_period_wages_subjectdecimal (5, 2)subject wages outside of the filing period
soc_codenvarchar (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_titlenvarchar (40)Job Title - title value from the contact table for employee.
countynvarchar (50)County - if employee primary location is WV then stores the county value from Contact_Address otherwise blank.
out_of_state_taxable_wagesdecimal (9, 2)State override for out of state taxable wages
Primary key
NameColumnsDescription
PK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Overrideemployee_reconciliation_tax_form_tax_jurisdiction_override_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override$employee_KEY$tax_jurisdiction_KEY$work_location_KEYemployee_KEY, tax_jurisdiction_KEY, work_location_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee_Other_State_Setting_Type__ca_exemption_code__employee_otca_exemption_code__employee_other_state_setting_type_KEYEmployee_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_otca_wage_plan_code__employee_other_state_setting_type_KEYEmployee_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_snj_plan_type__employee_other_state_setting_type_KEYEmployee_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__empwy_employee_coverage_type__employee_other_state_setting_type_KEYEmployee_Other_State_Setting_Type (employee_other_state_setting_type_KEY)
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Gender_Type__gender_type_KEYgender_type_KEYGender_Type (gender_type_KEY)
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Payroll_Item_Calculation_Type__payroll_item_calculation_type_KEYpayroll_item_calculation_type_KEYPayroll_Item_Calculation_Type (payroll_item_calculation_type_KEY)
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Ste_County__ste_county_KEYste_county_KEYSte_County (ste_county_KEY)
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Work_Location__work_location_KEYwork_location_KEYWork_Location (work_location_KEY)
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Worker_Compensation_Class_Code__worker_compensation_class_code_KEworker_compensation_class_code_KEYWorker_Compensation_Class_Code (worker_compensation_class_code_KEY)
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Zero_Hours_Code__zero_hours_code_KEYzero_hours_code_KEYZero_Hours_Code (zero_hours_code_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount__Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Ovemployee_reconciliation_tax_form_tax_jurisdiction_override_KEYEmployee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount

Schema diagram