Track employee reconciliation form overrides from the employee detail view grid |
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 (50) | | 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 |